| MySQL text book [message #658857] |
Wed, 28 December 2016 09:55  |
John Watson
Messages: 8960
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 
Can anyone recommend a book? This is the version installed with OVM 3.4.2,[oracle@ovmmanager1 ~]$ mysql -V
mysql Ver 14.14 Distrib 5.6.32, for Linux (x86_64) using EditLine wrapper
[oracle@ovmmanager1 ~]$
|
|
|
|
|
|
| Re: MySQL text book [message #658870 is a reply to message #658862] |
Thu, 29 December 2016 02:07  |
John Watson
Messages: 8960
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.
|
|
|
|
| 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:07In 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
) 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.