row-based or query-based MySQL log-bins?

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: der.hans
Date:  
To: quatsch
Subject: row-based or query-based MySQL log-bins?
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.
#  Nobody grows old merely by living a number of years.
#  We grow old by deserting our ideals.
#  Years may wrinkle the skin, but to give up enthusiasm
#  wrinkles the soul.  -- Samuel Ullman
---------------------------------------------------
PLUG-discuss mailing list - 
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss