Read the original article at Accidental DBA’s Guide to MySQL Management
So you’ve been tasked with managing the MySQL databases in your environment, but you’re not sure where to start. Here’s the quick & dirty guide. Oh yeah, and for those who love our stuff, take a look to your right. See that subscribe button? Grab our newsletter!
The “yum” tool is your friend. If you’re using debian, you’ll use apt-get but it’s very similar. You can do a “yum list” to see what packages are available. We prefer to use the Percona distribution of MySQL. It’s fully compatible with stock MySQL distribution, but usually a bit ahead in terms of tweak and fixes. Also if …[Read more]