row-based or query-based MySQL log-bins?
der.hans
PLUGd at LuftHans.com
Mon Jul 26 12:33:09 MST 2010
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
More information about the PLUG-discuss
mailing list