Forum Stats

  • 3,838,654 Users
  • 2,262,389 Discussions
  • 7,900,724 Comments

Discussions

MySQL 负载均衡+读写分离

3514109
3514109 Member Posts: 3
edited Aug 8, 2017 10:21PM in MySQL Community Space

我们公司购买了企业版,现在有一主一从两台数据库服务器,想要实现负载均衡+读写分离要怎么做?如果要一主多从的话又要怎么做?

Answers

  • Dave Stokes-MySQL Community Team-Oracle
    Dave Stokes-MySQL Community Team-Oracle MySQL Community Manager TexasMember Posts: 374 Employee
    edited Aug 8, 2017 1:47PM

    There are too many options to give you a 'one size fits all answer'.  If you want to split reads/writes then you will probably need at least 2-3 read only servers.  You can then load balance the reads with many different options.  Look at ProxySQL as a popular option

    Dave Stokes

    MySQL Community Manager

  • 3514109
    3514109 Member Posts: 3
    edited Aug 8, 2017 10:21PM

    Currently there are only two database servers to implement the cluster (master slave, read and write separation, high availability), which is better. And it may be added from the server in the future, so the plan is more from or more master from the future, can have a better effect