Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I use SQL Relay to make my existing MySQL app send all insert/update/deletes to a master database and distribute selects over a set of slaves?

April 26, 2017app delete existing insert MySQL Relay send sql

0

Posted

Can I use SQL Relay to make my existing MySQL app send all insert/update/deletes to a master database and distribute selects over a set of slaves?

1 Answer

0

Posted

Probably. As of version 0.38. You’ll need to set up SQL Relay to route queries and use the Drop-in Replacement Library for MySQL to redirect your app to use SQL Relay. See Routing and Filtering Queries with SQL Relay for details on how to set up SQL Relay as a query router. See Using the SQL Relay drop-in replacement library for MySQL for details about how to use the drop-in replacement library.