Hello,
I work as a software engineer/ sysadmin and am currently moving into DBA land. I'm tasked to come up with at least 5-10 best practices for our MySQL database environment running on centos 6.5 in AWS. We currently run two MySQL database servers for our web-based SAAS application in master-master replication, with a disaster recovery database as a slave of one of the masters. We also have this exact setup in our stack for a different piece of the application, so in total 6 database servers.
I'm wondering if anyone has any suggestions for what we should be doing or what we can adopt as best practices for managing and maintaining database environments. If there are any DBAs out there that could share their expertise that would be very much appreciated!
Thank you!
First is done by scripts (couple of them on the web)
Second - just read through.
Third - ask your boss to restore the DBbackup to his desktop... try again until it works...