I’m looking at options for using multiple databases in a
master-for-writes, slaves-for-reads config. I’ve Googled up multiple
options including ActsAsReadonlyable, MagicMultiConnections,
ActiveDelegate, and native MySQL. I’m looking for any real-world
experience / advice on which of these (or others) are real options.
Some background on my constraints…
- the site is customer-facing and business-critical
- development is done primariliy on WinXP boxes (corp standard) running
local copies of MySQL. production is a clustered environment (except
for a single DB box right now)
- we have a DBA group that controls the production DB environment
- all the ‘normal’ Fortune 500 organization / process stuff
Thanks in advance!