What ongoing maintenance is needed for a MySQL environment? I'm an MSSQL DBA, and I'm inheriting a 3-server MySQL 5.6 environment feeding a (currently) low traffic website.  I'm having a hard time finding what kind of regular / preventative maintenance a MySQL env needs.  I've done a fair amount of self-studying, but the guides etc I've run across mainly talk about installation and backups.  My environment is installed, and we have backups going.  Now what?  

So what sort of care and feeding does a MySQL environment need?  Corruption checks?  Index rebuilds?  Aromatherapy?
It just works!

Seriously though, if you got a master with two replicas environment, you probably want to do occasional consistency checks with pt-table-checksum. Replication does not guarantee consistency (and writes can happen on replicas too).

Otherwise:


Verify your backups to make sure you can actually recover (most of our data recovery customers thought they have backups, but they were actually not working).
Query reviews - definitely worth learning how to do that so you can review them proactively.
Do check error logs - any corruption errors will show up there.


There are many other things you can do, but I try to live by the rule: don't fix what ain't broken.

Good luck!