本文用到的Mysql版本是5.0.18 数据库复制技术说明：(本文后面有具体操作示例)MySQL features support for one-way, asynchronous replication, in which one serv......
本文用到的Mysql版本是5.0.18
数据库复制技术说明：(本文后面有具体操作示例)
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. 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.
Replication offers benefits for robustness, speed, and system administration:
1/29 1 2 3 4 5 6 下一页 尾页 |
