Page 1 of 1

Master/Slave Configuration

PostPosted: 13 May 2020, 16:24
by 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.

Re: Master/Slave Configuration

PostPosted: 14 May 2020, 13:58
by convexchange
What is the number of concurrent users you have seen in order to start using replicas?

Re: Master/Slave Configuration

PostPosted: 18 May 2020, 00:08
by 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.

Re: Master/Slave Configuration

PostPosted: 26 May 2020, 02:55
by 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

Re: Master/Slave Configuration

PostPosted: 26 May 2020, 03:02
by 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.