You could use Mysql replication (master-slave). I have some experience working with replication setups, so I can help you if you want. In the event the master goes down you can use your slave as read-only copy or even do writes on it, but then you'll need to push the changes back to the original master when it comes back up. In the latter case, you could also do master-master replication and not use your master at all (unless the other one goes down). Also, keep in mind this will cause some additional traffic for you and the guy who runs the current database.. (an alternative could be rsyncing backups. I don't know if that will be more or less traffic though. Depends on the volume of write queries (updates/inserts) I guess) Dieter On Sun, 2008-11-02 at 21:52 -0500, Lee Burton wrote:

I am also willing to contribute a AUR/wiki mirror.. not sure how the mysql/db syncing will happen though.

On Mon, Nov 03, 2008 at 03:38:45AM +0100, Geoffroy Carrier wrote:

...

On Mon, Nov 3, 2008 at 03:30, Stythys wrote:

...

Due to our recent downtime, I wanted to open a discussion about the possibility of mirroring the wiki/aur. I'm sure the are many people among the community (including myself) who'd be willing to put forth some hosting. I still have a nice server. I'd be pleased to contribute this way!

-- Geoffroy Carrier

so can we get a dev to comment on this? what do they think about mirroring this stuff On Mon, Nov 3, 2008 at 11:27 AM, Luke S Crawford wrote:

Dieter Plaetinck writes:

...

You could use Mysql replication (master-slave). I have some experience working with replication setups, so I can help you if you want. In the event the master goes down you can use your slave as read-only copy or even do writes on it, but then you'll need to push the changes back to the original master when it comes back up. In the latter case, you could also do master-master replication and not use your master at all (unless the other one goes down).

If everyone is on a fast enough network, I've always liked the master-master MySQL cluster setup, but I don't think I've used it over long-haul links.

I believe that if you do have a MySQL cluster in one location, you can use that as a master for master-slave replication to a terciary.

btw, I can kick in a Xen VPS or two, if you are ok with a 10Mbps cap. I'll have quite a bit of excess ram/cpu after this weekend.