Mysql – Consolidated realtime thesql backup with master/slave setup or binlog

You might look into MySQL Proxy. Features include:

• load balancing
• failover
• query analysis
• query filtering and modification

I haven't run it myself, but it seems to cover what you want.

UPDATE

Apparently the Read/Write splitting is a proof of concept and not for production use

QUESTION #1

I issue or schedule mysqldump on master servers.

ANSWER TO QUESTION #1

DEPENDS ON STORAGE ENGINE

If your database is all InnoDB, you can launch mysqldump to get a live snapshot of the Master, but you can run the great risk of slowing down transactions. (See my old post MySQL quick database transfer between two servers for caveats)

DEPENDS ON DB TRAFFIC

The slowdown of transaction incurred would be due to maintaining snapshots of data to support repeatable reads.

MORAL OF THIS STORY

It is best not to do it on a live server, even if it is possible

QUESTION #2

I allow developers to make changes directly connecting to master servers with the GUI tools(workbench)

ANSWER TO QUESTION #2

You can and will break the transaction issued by the mysqldump --single-transaction. See my old post row locking within ACID transaction innodb to see the commands that will disrupt a consistent backup if executed on the master during a mysqldump

MORAL OF HIS STORY

Use a MySQL Replication Slave and issue mysqldumps without disturbing the Master