Jump to content

Load balancing database server and read/write operations


Anay

Recommended Posts

Today, the replication phase of the main server and database has finally finished!


I use:

-NGINX reverse proxy server together with Proxysql.
-Nginx distributes requests to two main servers based on sticky ip_hash sessions, and Proxysql processes database requests.
-Mysql replication based on GTID master slave. At the same time, all SELECT requests are processed by the slave, and the rest of the requests are processed by the master.
-The Sphinx is configured and connected.
A question for practitioners, did I take everything into account in this configuration?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
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.

×
×
  • Create New...