2

I want to setup a simple master-slave MySQL replication. I also want to balance the load between the 2 servers. Can I use MySQL Router 2.1 for that purpose? As I read the official documentation, it seems that MySQL Router now only works with InnoDB cluster. I don't have a need for InnoDB cluster. I just want to load balance 2 servers. Is the Router a good way to go, or should I look elsewhere?

Improve this question
2
  • Keep in mind that all writes are handled on both servers. Do you have a lot of reads? And you need to move some of the reads to the Master?
    – Rick James
    Commented Apr 30, 2018 at 4:37
  • You can use proxysql for this.
    – MD Nasirul Islam
    Commented Oct 30, 2023 at 5:39

1 Answer 1

Reset to default
0

Yes! You can have a router for basic Master-Slave Replication. But use the routing strategy as "first-available".

Though this works, you should be aware that your slave will be in read-write mode (if you allowed it to be) and all write operations performed on slave should be manually synced with master.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.