On mer, 2003-01-22 at 02:35, buraq wrote:
just read about Wikipedia and the Wiktionary this morning in www.heise.de for the first time and I'm impressed ! Good work.
Wilkommen aus Wikipedia!
getting on-topic again, I could not find any information on setting up mirrors (the How to become a Wikipedia hacker page is a bit incomplete :) Is there any best-practice way to do it, which avoids transferring SQL Dumps of the whole database every day ?
Do MySQL or PostgreSQL have +working+ replication, transmitting just the changes/additions, has anybody ever used them to replicate Wikipedia ?
MySQL replication _supposedly_ works... I'm considering setting it up on our own server so that slow read-only operations (like the SQL dumps) can be done on the local mirror without the main database locking and grinding to a complete halt for forty minutes. I haven't yet looked into the setup details in earnest though.
Allowing remote servers to sync that way should be possible. Can we leave out certain tables? Eg, the user table, which contains sensitive information -- password hashes and e-mail addresses -- that we'd rather not have zipping about the net willy-nilly.
-- brion vibber (brion @ pobox.com)