Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: DBI mysql router mysqlrouter cluster

by Anonymous Monk
on Jul 01, 2022 at 13:57 UTC ( [id://11145216]=note: print w/replies, xml ) Need Help??


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!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11145216]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2024-04-18 13:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found