Master/Slave Configuration

[Jason]

We are getting a lot of inquires about the master/slave configuration that is available in the v3.0 package.

This feature is for advanced users only
If you don't know what master/slave means, then you probably shouldn't be using it. It requires a special server configuration in order to use it. You can read more about MySQL replication and how to use it at https://www.toptal.com/mysql/mysql-mast ... n-tutorial

That being said, it is worth the time to set up. The benefits of using MySQL replication are huge. On large sites, you will see a significant improvement in SQL performance.

Please comment if you have any questions.

[convexchange]

What is the number of concurrent users you have seen in order to start using replicas?

[Jason]

What is the number of concurrent users you have seen in order to start using replicas?

There is no specific number, it depends on a lot of different things.

[arrusr1]

i got around 500 concurrent users and i definitely need master/slave as my super overpowered server cant hold them and makes sql slow

[Jason]

i got around 500 concurrent users and i definitely need master/slave as my super overpowered server cant hold them and makes sql slow

You don’t necessarily need master/slave. It will help for sure, though. We have sites running thousands of users without issue. The server software optimization is key.