Home / server / Questions / 231460
Accepted
SQL3D
Asked: 2011-02-05 16:21:30 +0800 CST

MySQL for SQL Server DBAs

  • 772

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

sql-server mysql

2 Answers

  1. Best Answer

    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.

    • 3

  2. 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

    • 0