Re: MySQL DBA learning

[Sree R]

Thanks Rick, That helps. I will start with the resources which you've provided.

Rick James Wrote:
-------------------------------------------------------
> mysql.com has much of what you want, including
> tutorials. Once you have been through the
> tutorials, the "reference" manual is the next
> step.
>
> There are numerous blogs online that tackle narrow
> subtopics.
>
> There are books -- MySQL Administrator's Guide;
> High Performance MySQL (multiple, different,
> editions); etc. Be sure to buy something
> published in the last 10 years, else you may get
> only MyISAM info, without InnoDB info. (The
> InnoDB 'ENGINE' is strongly preferred today.)
>
> Within the last 10 years, there have been lots of
> 'little' features added. Hence, a book from, say,
> 2008 will tell you virtually everything needed for
> building a database today. What it leaves out may
> not be necessary for a given application.
>
> Community Edition has most of what Enterprise has.
> (I am not versed in the detailed license
> questions you ask.)
>
> percona.com has many of the (free) tools you are
> looking for.
>
> If you want to experiment with replication, note
> that there are multiple flavors:
> * Traditional Master-Slave (arbitrary DAG tree)
> * Dual Master (2 masters slaved to each other;
> good for faster failover; bad for writing to
> both)
> * Galera (add it on by yourself, or install it
> built-in via PXC, MariaDB-10)
> * Fabric -- Oracle's new HA + Sharding platform
>
> The set of forums here is a good place for asking
> questions at all levels. (Sorry, my ego is
> leaking out.)