in reply to DBI mysql router mysqlrouter cluster
As far as I understand the documentation, MySQL Router is entirely transparent and speaks the same MySQL protocol as the database itself. It should be possible to just switch the address and the port. What have you tried? What didn't work? What happened instead?
Re^2: DBI mysql router mysqlrouter cluster
by RedJeep (Sexton) on Jul 02, 2022 at 17:00 UTC
|
Yes. It looks like you are correct and I was over-complicating things. It seems that a single replication model of write to primary server, replicate to secondary server and query from secondary server will do what I need.
Thanks! | [reply] |
|