关于MySQL主从配置 [英] Regarding Mysql Master-slave configuration

问题描述

我正在开发一个社交网络.对于数据库负载平衡，我想使用 Mysql中的主从复制.

I am developing one social-networking. For DB Load Balancing, i want to use Master-slave Replication in Mysql.

在开始复制之前，我想知道类似的东西

Before start working on Replication, i want to know something like

1)我们如何设置该复制

1) How can we setup that replication

2)优势是什么?主从复制的缺点

2) what is the advantage & Dis-advantages of Master-slave Replication

3)当我们使用选择"查询时，是，我们需要(手动)向主服务器或从服务器发送请求

3) when we are using "select" queries, Is that , we need to send request to Master or Slave (manually)

或主控自动发送给从属...我想知道这一点.

or Master automatically sent to slave...i want to know about this.

4)我们可以安装Master&吗?从属一个系统(即CPU)?可以暗示吗?

4) can we install Master & Slaves in one system(i.e. CPU)? is it suggestable?

预先感谢

推荐答案

对于 Mysql主从复制安装程序，
请访问此处 http://ranjithonrails.wordpress.com/2012/07/21/mysql-master-slave-replication/

For Mysql Master-Slave Replication Setup,
Visit here http://ranjithonrails.wordpress.com/2012/07/21/mysql-master-slave-replication/

这篇关于关于MySQL主从配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！