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
---------------------------------------------------
PLUG-discuss mailing list - [email protected]
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
