Managing Mysql Master/Slave

1,111 views

Skip to first unread message

Maziz Esa

unread,

Jan 4, 2017, 3:17:21 AM1/4/17

to HikariCP

Hi all.

Im aware that hikari cp doesn't support Mysql Replication driver as per https://github.com/brettwooldridge/HikariCP/issues/625#issuecomment-251613688.

Could anyone give some pointer as to how to handle single master / many slaves architecture via hikari cp ? (Limiting read to slaves and write to master)?

An implementation example would be appreciated.

Regards,

Maziz.

Brett Wooldridge

unread,

Jan 4, 2017, 4:46:09 AM1/4/17

to HikariCP

Not to be too critical of MySQL, but nobody running anything resembling a mission critical application takes MySQL's driver-level replication support seriously.

There are many solutions floating around based on ProxySQL, like this one described by the Percona guys in a blog. ProxySQL can also be deployed standalone in simpler environments, and there several good guides available, including this one from severalnines.

All of these solutions allow read/write splitting without any change to your application, unlike the MySQL Connector/J hack of using Connection.setReadOnly() to control splitting.