本文用到的Mysql版本是5.0.18 数据库复制技术说明：(本文后面有具体操作示例)MySQL features support for one-way, asynchronous replication, in which one serv......
- Robustness is increased with a master/slave setup. In the event of problems with the master, you can switch to the slave as a backup.
- Better response time for clients can be achieved by splitting the load for processing client queries between the master and slave servers. SELECT queries may be sent to the slave to reduce the query processing load of the master. Statements that modify data should still be sent to the master so that the master and slave do not get out of synchrony. This load-balancing strategy is effective if non-updating queries dominate, but that is the normal case.
- Another benefit of using replication is that you can perform database backups using a slave server without disturbing the master. The master continues to process updates while the backup is being made.
2/29 首页 上一页 1 2 3 4 5 6 下一页 尾页 |
