[ILUG] MySQL replication
murtaghn at tcd.ie
Fri Mar 1 14:52:07 GMT 2002
On Friday 01 March 2002 14:44, kevin lyda wrote:
> > http://www.mysql.org/documentation/mysql/bychapter/
> > manual_MySQL_Database_Administration.html#Replication_HOWTO
> wow, interesting. this must be really useful to people admining a
> critical database. wonder how it affects performance?
The logging is an overhead, but you can load balance database reads
across the replicas, thus increasing performance. Unfortunately you only have
one master for writes at the moment.
> i suppose you don't completely avoid a spof, but you'd certainly reduce
> outages with such a setup.
Well, if you write some clever scripts to switch a slave to a master when
the master fails, and bring the master back up as a slave, that might be
More information about the ILUG