Alan Knowles wrote:
>
> Emiliano <[EMAIL PROTECTED]> said:
>
> > Then there's the issue of fetching the database. We can use MySQL
> > replication although I've never worked with this; experiences/comments
> > welcome. Other options are dumping the database and either the mirrors
> > pulling it in or the master pushing them out. In order for MySQL
> > replication to work the mirrors may require a MySQL upgrade
> > (3.23.15 minimum) and I'll need to know the hostname for your mirror
> > since the replication mechanism is in all likelyness going to clobber
> > your host entries unless they're in the master database.
>
> for reference :)
>
> mysql replication is tempramental - it needs alot of babysitting in getting it
> to work,
Getting it to work, or to keep it working? The former I can accept, the
latter not.
> - you can tell it to only replicate certain databases (eg. not the
> authentications one).. we did not do this for our expo, but it will probably
> solve the bigger issue below!
> - You cannot send update/insert queries to the slaves (it will destroy the
> replication) - this could be done by modifing the local privaliges for a given
> database so that local users can not write!
It's a matter of how you're using it. The idea was to have the mirrors
be read-only
mirrors of the main server. There are still a few issues unresolved, ie
how to
handle things like annotations.
> - what ever happened to repligard, I thought that was supposed to solve this
> one ???? = it sounded nicer in theory than the mysql replication....
Alas, at the moment it's just that -- theory.
> Dbdumping on small databases may be easier - probably on 1-2 seconds down per
> week at most????
Once a week would be a bit too much lag. Once a day at least, I'd think.
The database
takes about 20 seconds to dump, which includes sanitizing & compressing.
The resulting
file measures 5.5MB. Rsync will probably keep unnecesary traffic to a
minimum. I'm also
still toying with distributing update logs.
Emile
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
