Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've been tasked with taking over the administration of a MySQL installation (running on Red Hat Linux) that will become fairly critical to our business in the near future.

I was wondering if anyone could recommend some resources in regards to administering MySQL for DBAs already experienced with other relational database (SQL Server and some Oracle in my case). Specifically I'm looking for information around disaster recovery as well as high availability to start with, but I do want to get well rounded with the entire system.

Thanks in advance, Dan

share|improve this question
add comment

2 Answers 2

up vote 3 down vote accepted

A great resource about MySQL is Percona's blogs, you'll find information about pretty every configuration options on it. You must read the official documentation related to High Availablity too: http://dev.mysql.com/doc/mysql-ha-scalability/en/index.html

Another good thing to do is for you to buy the book from O'Reilly named MySQL CookBook, it's very well structured and will introduce you to the way MySQL works.

One thing you should not underestimate is the OS your MySQL instances will run on (*NIX I hope for your sake), if you don't have any experience on it you should begin learning what impact the different filesystems (and their options) can have on MySQL performances before you even try to setup your server.

Don't be afraid, from my experience SQL Server is much more intricate (I'd even said touchy) concerning settings and functionalities than MySQL.

share|improve this answer
    
+1, this answer is my answer too. Percona, especially the MySQL Performance Blog. Then, play with it. Conventional wisdom with InnoDB is to use mysqldump with --single-transaction --all-databases. If you have a big enough system running, Percona has a free hot-dump backup system. –  Jeff Ferland Feb 5 '11 at 1:40
    
@Autocracy - I think the common parlance there is "hot-copy" or "hot-backup" –  danlefree Feb 5 '11 at 6:15
    
@danlefree You are correct. –  Jeff Ferland Feb 5 '11 at 14:27
    
Thanks. I guess RTFM is the best place to start. I also check out the Percona blog and the MySQL CookBook as well. –  SQL3D Feb 7 '11 at 19:21
add comment

If you're a book nerd like me, get Paul DuBois' "MySQL" (Developer's Library). I've found it to be the only MySQL book I've needed on my shelf for a couple years now (sitting next to the several dozen I have on SQL Server).

http://www.amazon.com/gp/product/0672329387?ie=UTF8

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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