Public SourceMage Discussion List

[Jason Flatt <jason AT flattfamily.com>]

On Monday 19 April 2004 3:10 pm, Andrew wrote:
> In regards to the bugzilla problem (and the fact that some people are
> noticing that its unresponsive) I've heard that its relatively trivial
> to do a mysql dump type backup of the database. I can find out more
> about that (and a recovery) if you need me to. So we could possibly move it
> to a different place.

I tried that method, along with every backup method listed on MySQL's Web 
page 
for database backups.  I also tried to do the backup using phpMyAdmin.  All 
attempts failed.

> Second I thought that perhaps running a distributed or mirrored mysql
> database plus a round-robin dns over several of our machines all running
> bugzilla would make the system more responsive and less prone to failure.
>
> Of course the real problem then is that mysql doesnt really do mirroring
> on the fly. Although theres a new 'mysql cluster' [0] which presumably
> we could use for things like this.
>
> [0] http://www.mysql.com/products/cluster/

That sounds interesting and useful.  I'll look at it in the next couple days.

-- 
Jason Flatt (jason @ flattfamily . com)
Father of five (http://www.flattfamily.com/)
Linux user (http://www.sourcemage.org/)
IRC Nick: Oadae  Channels: #sourcemage, #lvlug  Server: irc.freenode.net

-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GCS/IT d(-) s+:- a>++++ C++$(+++) UL++++ P(+) L+++ E- W++ N+@ o? K? w-- O? 
M-- V PS- PE+ Y+ PGP@ t 5+ X R tv--() b+@ DI+@ D+++ G e h---- r+++ y++++
------END GEEK CODE BLOCK------