MySql数据库点对点复制

双向的点对点数据复制(bidirectional peer-to-peer replication)是一个应用程序达到high-availability的一个重要途径。MySql在5.0提供了replication的功能。在其reference里是这样介绍的：

MySQL features support for one-way, asynchronous replication, in which one server acts as the master, while one or more other servers act as slaves. This is in contrast to the synchronous replication which is a characteristic of MySQL Cluster (see Chapter 15, MySQL Cluster).

In single-master replication, the master server writes updates to its binary log files and maintains an index of those files to keep track of log rotation. The binary log files serve as a record of updates to be sent to any slave servers. When a slave connects to its master, it informs the master of the position up to which the slave read the logs at its last successful update. The slave receives any updates that have taken place since that time, and then blocks and waits for the master to notify it of new updates.

A slave server can itself serve as a master if you want to set up chained replication servers.

在我的blog里我给出了一个实现方案，大家有其他好的方案么？

评论

2 楼 hijack 2006-10-12  

to bluemeteor .
是的，呵呵，主要想验证一下自己的想法。

接下去去试验一下clustering, 那个应该有LB地考虑。

1 楼 bluemeteor 2006-10-12  

没有试过双向的，楼主这个方案的负载能力如何？

其实以你的应用需求，做成单向的M/S结构就可以了