asked on

Which is the SMB solution for MySQL Backup and Monitoring

Hi,
I am looking for a unified solution for MySQL backup and server monitoring.

Currently we are using MySQL 5.6 community edition but we have two major issues: Backup/Restore is slow and Monitoring of replication (1 Master / 3 slaves) is difficult.

a) How is Percona MySQL compared to MySQL 5.6 community edition in terms of performance and stability as both are free? Is there any difference between MySSQL Community vs Standard Edition other than support?

b) Which is recommended for monitoring / alerts and backups: MonYog, MySQL Enterprise Monitor, KontrolSoft(Free) especially to manage replication?

Thanks,
Zen

gheist

a) more or less 1:1. mariadb is somewhat distinct as they guarantee data integriti un disk, at price of 1% of performance, and then they optimize some and in some parts it is slightly faster.

b) Lets consider SMB with capital S. One will use same tools as single server - namely MySQL tuning scripts that say how to scale mysql to your load.
Replication can send mails when it fails.

zen shaw

ASKER

I think we have to choose between
a) MySQL Community 5.6 vs Percona 5.6
b) MonYog vs Percona Toolkit vs MySQL Enterprise manager

since MySQL tuning scripts are too much a learning curve for our non-techie managers :)

ASKER CERTIFIED SOLUTION

gheist

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION