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?
  • Comment on Re: DBI mysql router mysqlrouter cluster

Replies are listed 'Best First'.
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!