OraFAQ Forum: MySQL » MySQL text book

Home » Open Source » MySQL » MySQL text book ( Ver 14.14 Distrib 5.6.32, for Linux (x86_64) )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MySQL text book [message #658857]

Wed, 28 December 2016 09:55

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

The Oracle OVM Manager no longer uses an Oracle database for its repository, MySQL is the only supported option. So I'm going to have to learn a bit of MySQL admin. Just what I've always wanted to do Sad

Can anyone recommend a book? This is the version installed with OVM 3.4.2,

Code: [Select all] [Show/ hide]

[oracle@ovmmanager1 ~]$ mysql -V
mysql  Ver 14.14 Distrib 5.6.32, for Linux (x86_64) using  EditLine wrapper
[oracle@ovmmanager1 ~]$

Report message to a moderator

Re: MySQL text book [message #658862 is a reply to message #658857]

Wed, 28 December 2016 12:29

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

I recommend MySQL (Developer's Library) by Paul DuBois. This is a classic book for the Oracle MySQL. The last part of the book is about administration.

I guess most (much more than me as I switched two years ago Wink

) stuff you know already, with Oracle background it's simple to learn MariaDB/MySQL, but quite difficult to learn distributed data store (NoSQL) like MongoDB. Good luck and have a lot of fun with modern and new database systems.

After the Paul DuBois I recommend Mastering MariaDB (also to broaden your horizon with MariaDB)- ISBN-13: 978-1783981540

Report message to a moderator

Re: MySQL text book [message #658870 is a reply to message #658862]

Thu, 29 December 2016 02:07

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

THank you, I'll look at those. Overall, I am disappointed: I can't find one book on MySQL DB admin. A typical book has a dozen chapters teaching SQL, and then one or two on admin. In the Oracle world, it is usually assumed that you know SQL backwards before looking at admin work. Possiblys administering MySQL is sufficiently trivial that it really doesn't require any significant learning. I hope so! The OVM install includes MySQL, creates the database, and sets up some sort of backup routine. THe database won't be very big or very active, so perhaps that is enough.

Report message to a moderator

Re: MySQL text book [message #658897 is a reply to message #658870]

Thu, 29 December 2016 12:36

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

John Watson wrote on Thu, 29 December 2016 02:07

In the Oracle world, it is usually assumed that you know SQL backwards before looking at admin work. Possiblys administering MySQL is sufficiently trivial that it really doesn't require any significant learning. I hope so!

That's true. MySQL/MariaDB is typical deployed in Cloud (DBaaS). The MySQL admin doesn't necessary knows all deep SQL stuff, this is the developers job. The MySQL DBA offers less service to customer, than the Oracle DBA.

The only thing the MySQL DBA has more skills is Linux, Automation and Open Source (modern system administration). In Oracle world that would do other department or team.

Yes MySQL is simpler and less powerful than Oracle ($$$).

[Updated on: Thu, 29 December 2016 12:39]

Report message to a moderator

Previous Topic:	select statement as per the columns label
Next Topic:	Connecting to MSSQL server via php-pdo?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 00:37:21 CDT 2025