Jump to content

Community

Xiaodidi8

Master/Slave Configuration

Recommended Posts

Hello,

as our website is kind of big (10.000 current online users) we are looking for a system which can handle a lot of load. So we were wondering if you support a master/slave database replication? 

https://en.wikipedia.org/wiki/Master/slave_(technology)

https://en.wikipedia.org/wiki/Database_replication

 

Thanks,

Rob

Best option would be to run Galera Cluster (open source or paid), depending on your writes, you can put haproxy in front of it to point to the primary DB and fail-over to the second master, or just let it LB between them, and you can scale this beyond 2 nodes.

You can also look at running mysql cluster cge, which is an in-memory clustering system and scales out very large and qps.

Whatever you do, run your DB servers on fast, enterprise SSD/nvme drives.

Share this post


Link to post
Share on other sites

Your content will need to be approved by a moderator

Guest
You are commenting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

  • Recently Browsing   0 members

    No registered users viewing this page.

×