I have replicated my db (mysql) and have hit roadblocks with both mysql-proxy and with acts_as_readonlyable .
Firstly, is there something else I should be using?
What would be the advantages of mysql-proxy over in-rails solutions? One is that it keeps the rails config and code simpler, puts the db redirection (kinda) where it should be, at the (kinda) db layer of the architecture.
Has anyone used both? That person would have great authority…
With mysql-proxy, I’m getting no reads on the readonly slave, only message I’m getting is “no handler for COM_CONNECT” grr
With acts_as_readonlyable, I’m getting: “No db config entry defined for read_only”
Here’s my config/database.yml (some names changed to protect the innocent):