The Future of Performance: Scaling

[Steve Wendt]

On 1/8/2009 5:52 PM, Max Kanat-Alexander wrote:

>> Besides being MySQL specific, the privileges required for running
>> that are probably not what you want your web processes running with.
>> I've thought about trying to do something like this myself
>> (completely unrelated to Bugzilla), and never came up with a good
>> solution.
> 
> 	I think Eclipse has a cron script or something that routinely
> checks the slave replication delay and switches the shadowdb parameters
> over to match the master DB if the replication lag is longer than 30
> seconds or so.

Which means you have to make sure that the cron script runs "frequently 
enough" - it's not very elegant, because it is completely independent of 
actual traffic.  I suppose you could have something from the web side 
trigger it to run, but you'd have to be careful about file permissions 
so you didn't get yourself into trouble...
_______________________________________________
dev-apps-bugzilla mailing list
dev-apps-bugzilla at lists.mozilla.org
https://lists.mozilla.org/listinfo/dev-apps-bugzilla