Dear Friends,
Considering what a backup is done with the method following:
1. One master server replicate to one slave server.
2. The master server handle all manipulations and transactions of
data (all tables are InnoDB type).
3. The slave server is exclusively used for to
"MySQL only supports one master and many slaves. In 4.x, we will add a
voting algorithm to automatically change master if something goes wrong with
the current master. We will also introduce 'agent' processes to help do load
balancing by sending select queries to different slaves. "
i dont want to
