Re: mysqld on drawable.gnome.org

[Owen Taylor <otaylor redhat com>]

On Fri, 2009-07-31 at 15:43 -0700, Max Kanat-Alexander wrote:
> Owen Taylor wrote:
> > I've gone ahead and set up MySQL on drawable.gnome.org. 
> 
> 	It's probably too late, and I'm not sure it matters, but high-end MySQL 
> installations apparently frequently get some benefit from running on XFS 
> instead of ext3.

Not too late, but XFS is definitely on the wrong side of the
what-I'm-comfortable with vs. what-might-be-fast tradeoff. And I have a
lot more faith that ext3 gets solid testing in the RHEL kernels.

> >     mysqldump
> >     gzip'ed mysqldump is suprisingly reasonable for snapshotting
> 
> 	mysqldump is what Mozilla does.

It certainly is the straightforward option. We can try that, and if we
start having problems (say, the mysqldump read locks start causing
updates to fail for an hour), consider alternatives.

- Owen