Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have recently joined a team in my corp office that has mysql as a part of their work profile. Though the mysql work not often in this team, but when they do it comes in big scale. The main mysql technology part that this team works on is High availability. Please do not mix high availability with clustering. Which was the mistake i understaood when i heard this first time. By high availability i mean db replication, master/slave/relay master, etc setup. I won't be doing any query optimization or any of those closely code related STUFF. But more of database administration stuff like looking for replication failures and fixing it and setting up replication, troubleshoot issues maybe like slow query (rarely). Please suggest me a book that concentrates on this part. I have some experince with mysql query language like creating db & tables, looking at tables schema and db priveldges and grants priveldges and backing up and restoring db with mysqldump and writing small select queries and like for mainly find out where it is going wrong or use it in my report generation script from bash command line. I am mainly a bash scripting and apache httpd and tomcat expert and new to this filed. Although the httpd and tomcat have always maintanined a close relation with mysql and db in general . But where i worked previously had huge db and were maintained by a special dedicated team of experts who work solely on db. And that was in oracle and their size was in tera bytes and had advanced structure like oracle rack and real time replications setup, etc and i wan't expected to touch any parts. I was concerating on the app tier and web tier. So can you guys suggest me a way to quickly learn the important stuff of mysql and know the internals or more subtile part as we move on. A book or a online course or a tutorial site. Ah forgot to mention we are using mysql 5 and 4 in some *nix machines. And these are huge setup with lots of machine in many DC. As i said before my primary filed of expertise is bash scripting and web and app layer stuff. So please guide. I am not familiar with windows though worked on AD (and to some extent on SCCM) related stuff for sometime and i am certified RHCE (current and valid). Thanks. ;)

share|improve this question

closed as not constructive by jcolebrand Jan 13 '12 at 21:16

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

Thank you, kind sir !!! – RolandoMySQLDBA Jul 10 '11 at 4:49
up vote 2 down vote accepted

If you are interested in High Availability and Performance for MySQL, then High Performance MySQL : Optimization, Backups, Replication, and More

enter image description here

is definitely the book for you (Third Edition is out now) !!!

I would still have MySQL 5.0 Certification Study Guide

enter image description here

as well. I used this book as my reference book for 10 months before taking the Certification Exams. In honesty, it has many typos and incorrect facts, all minor in nature.

There is no substitute for Practical Experience. Implement the things leaned from these two books and you will develop the needed confidence to handle,..., no, manhandle MySQL.

If you must use MySQL 4.x, then you will also need MySQL Reference Manual.

enter image description here

share|improve this answer
Thanks RolandMySQLDBA, this was the kind of input i am needing. Thank you very much. – Naai Sekar Jul 10 '11 at 4:34
@Rolando, What are some use cases for still using MySQL 4.x? – Pacerier Apr 9 '15 at 22:00
@RolandoMySQLDBA Do you think High Performance MySQL is still worth reading today? The 3rd edition should be the latest and it was done four years ago (2012). – Francesco Casula 23 hours ago
@FrancescoCasula I still have the book today (3rd edition) and the Cert Book (As for Reference Book I don't know where it is). I am hoping to see books that cover MySQL 5.7 – RolandoMySQLDBA 18 hours ago
@Pacerier To answer your question, if you have really crappy hardware and 1 CPU. In an old post of mine (…), I reference a Percona bog where multiple versions of MySQL were critiqued. It turns out MySQL 4.1 could outperform newer versions in a single threaded environment (essentially crappy hardware with 1 CPU) – RolandoMySQLDBA 18 hours ago

Not the answer you're looking for? Browse other questions tagged or ask your own question.