NYCPHP Meetup

[Jerry B. Altzman]

on 5/8/2009 10:17 AM Anthony Wlodarski said the following:
> It can be a PITA sometimes.  The typical usage is the master-slave 
> replication.  Even with this type of replication there can be some data 
> loss too.

MySQL replication is great when it works.
With 5.1 they've introduced row-level replication (as opposed to 
statement-level replication) which can help in many cases (where you're 
using MySQL to do heavy processing, like their internal GIS functions).

MySQL replication can also fail silently in the presence of brief 
network disconnections.

It's not REAL redundancy (like Oracle RAC) but you get what you pay for, 
and having a slave for backup purposes is handy.

> -Anthony

//jbaltz
-- 
jerry b. altzman        jbaltz at altzman.com     www.jbaltz.com
thank you for contributing to the heat death of the universe.