Am 26. Jul, 2010 schwätzte der.hans so: moin moin, I got internal feedback saying that our biggest concern is InnoDB and transactions. We've moved most tables of concern to InnoDB. ciao, der.hans > moin moin, > > Which is better, more reliable, etc? > > I think most of our queries are really only updating one row at a time, so > the size of the log-bin probably doesn't change. We do probably have some > transactional stuff. The transactional stuff would be for financials, so > likely the most important stuff :). > > Some of the slaves are in different datacenters than the masters if that > matters. > > Thus far slaves are purely for backup and failover. We should soon also > have slaves for reporting. If I get my way, the reporting slaves will get > updates from the backup/failover slaves. > > ciao, > > der.hans > -- # http://www.LuftHans.com/Classes http://www.TwoGeekTechs.com/ # Director of Engineering, FonWallet Transaction Solutions, Inc. # Hope has two beautiful daughters: Anger and Courage. Anger at the way # things are, and Courage to struggle to create things as they should be. # -- St. Augustine