Re: Possible perlmonks mirrors?

Yeah, sure. MySQL has replication. one-way replication. But if you are going to mirror, you need two-way replication. Which is hard to get it right. Believe me, I've done so, and it took us 3 months to build it, with a $300,000 price tag. (One of the most interesting projects I've ever done). Not that it would even be remotely possible to use the same technique with MySQL.

You could set up a contruct were the database is mirrored, and you use the mirror as a query database, but still use the master to perform updates on. But then you get into a master-slave setup, with an assymmetric relationship. And you'd need synchronic writes to the replicated database - or else you get strange effects (you reply to an article, but then it disappears for a while - until the data has replicated). Synchronized writes are slooooooooooow.

Abigail

Comment on Re: Possible perlmonks mirrors?

Replies are listed 'Best First'.
Re: Re: Possible perlmonks mirrors? by Jaap (Curate) on Feb 13, 2003 at 23:56 UTC
Yes one-way replication indeed. You could then only post to the master. If the slave site cannot find a page you could perhaps redirect to the master?	[reply]
Re: Re: Possible perlmonks mirrors? by mugwumpjism (Hermit) on Feb 14, 2003 at 13:31 UTC
But surely perlmonk's major load in terms of query time is read operations, not updates. $h=$ENV{HOME};my@q=split/\n\n/,`cat $h/.quotes`;$s="$h/." ."signature";$t=`cat $s`;print$t,"\n",$q[rand($#q)],"\n"; [download]	[reply] [d/l]