MySQL Forums
Forum List  »  Utilities

Re: read write spliting using MySQL Router
Posted by: Geert Vanderkelen
Date: March 29, 2016 03:52AM

Hi Rakesh,

Connection Routing does not automatically split read/write requests.
The idea is that the application is build so that it connects to the correct TCP port for either doing read/write or read-only operations.

The modes 'read-only' and 'read-write' are there to schedule how the servers are accessed: for read-only, it will be round-robin (for slaves); for read-write it will be first-available (for masters).

We are looking into ways of adding these kind of splitting. Focus was on HA and performance with the Connection Routing plugin.

Router has no support for LUA scripts or any other scripting language.


Geert Vanderkelen
Software Developer at Oracle

Options: ReplyQuote

Written By
Re: read write spliting using MySQL Router
March 29, 2016 03:52AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.