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!