MySQL Forums :: Utilities :: read write spliting using MySQL Router


Advanced Search

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.

Cheers,
Geert

Geert Vanderkelen
Software Developer at Oracle

Options: ReplyQuote


Subject Views Written By Posted
read write spliting using MySQL Router 2041 RAKESH PABLA 03/24/2016 07:21PM
Re: read write spliting using MySQL Router 814 Rick James 03/28/2016 10:07AM
Re: read write spliting using MySQL Router 963 Geert Vanderkelen 03/29/2016 03:52AM
Re: read write spliting using MySQL Router 822 Rick James 03/30/2016 07:53PM


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.