MySQL Router REST API

[@fahdbahoo1]

i have Innodb cluster with 3 MySQL servers and 2 Routers , how to make 2 Routers highly available ? i can do it with KeepaliveD software , is it a good approach in Production environment? if there is a better approach then please guide , thanks

[@lefred]

In fact, MySQL Router has been developed as an extension of the connector. Usually it's installed on the application server itself. It's not uncommon to see thousands of routers in a production environment. Now if you want to have dedicated servers for your routers, you will indeed need to manage the high availability of it. Check - lefred.be/content/mysql-router-ha-with-keepalived/ - lefred.be/content/mysql-router-ha-with-pacemaker/

[@fahdbahoo1]

@@lefred if its installed on application server then how is HA achieved?

[@lefred]

@@fahdbahoo1 if your Application Server dies... there is no need for Router... If you have 4 application servers... each with a local Router and each application server connected to their own router... if an application server dies... the other are not impacted and you have HA

[@fahdbahoo1]

​@@lefred but we have microservices, each microservice making its own DB connection

[@fahdbahoo1]

​@@lefred here is the application architecture drive.google.com/file/d/1TrLhDcgetMxrfO9KE23C1lwTYA1Q1mDw/view?usp=drivesdk

[@naheliegend5222]

Can I inject the SQL queries or read the results from the DB before passed to the App like in mysql proxy? If yes, how?

[@lefred]

Hi, this is not possible, MySQL Router works on the transport level (layer 4), ProxySQL/MySQL proxy work on application level (layer 7)

[@naheliegend5222]

@@lefred Thank you! Do you prefer ProxySQL over the old mysql proxy for injection?

[@lefred]

@@naheliegend5222 yes, old MySQL Proxy is not maintained anymore