Date: Wed, 8 Oct 2003 22:16:33 +1000 (EST) From: Peter Ross <Peter.Ross@alumni.tu-berlin.de> To: Sebastien Gioria <gioria@freebsd.org> Cc: freebsd-cluster@freebsd.org Subject: Re: Clustering mysql Message-ID: <20031008214602.T625@guckloch.zuhause> In-Reply-To: <20031008095226.A18491@thorm.gioria.dyndns.org> References: <20031008095226.A18491@thorm.gioria.dyndns.org>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi Sebastien, On Wed, 8 Oct 2003, Sebastien Gioria wrote: > Anybody does have any experience in clustering mysql ? > Software to install, tuning OS ? I used mysql in a master/slave replication configuration. Do you mean that? I had to use Linux so the OS tuning is not what you are looking for (and the circumstances were an invention of .. okay no swear words here .. but would you run NFS server, mysql and postgresql with high load on the same machine? And then Linux with it's problems under high load?) Especially mysql was hell. Occasionally corrupted indexes. When I rebuilt them the master/server pair became out of sync. I had to keep the mysql running so I used a rsync loop to fix it. The last rsync had to be done while the master wasn't writing to disk (I forgot the command only to use the memory for updates, sorry). Then I restarted the replication and let the master dump the updates cached in memory. Maybe it's better with version 4? I hope you get better results Peter
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20031008214602.T625>