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
kinda cool...
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
