Routine maintenance of mysql DB's

Hi, Im a MSSQL DBA/Developer who uses MySQL for my personal projects. With MSSQL, there are several routine tasks I do just to keep the databases running smoothly (defrag of indices etc, integrity checks etc)

On MySQL I use innodb, and my database is now growing to a non trivial size (130GB). What routines should I be running regularly ?

Any other you can suggest please?


Please check this link for information

Hi, thanks for the advice, but I dont have any issues with backups

Im mainly interested in any maintenance tasks I should run, maybe tables and indices get fragmented, and should be defragged occasionally