Web Blog of Greg Mathews

OK its been about 10 days since my last post so lets try and bring you up to date.

I found that the Yzoo database replication was getting out of sync. I had set up 4 databases all replicating with each other in rotation, ie dbase1 -> dbase2, dbase2->dbase3, dbase3->dbase4 and dbase4->dbase1 then all the scripts would use the database with the lowest server load. In theory it should work, in practice it worked poorly. It appeared the replication itself on such a large database with hundreds of updates every minute was in itself causing a high server load.

I decided to reorganise (again), now dbase1 and dbase2 replicated with each other, and also dbase2 replicated its data to dbase3. I then modified the scripts so all lookups where done on dbase3 only, and any updates where then done on either dbase1 or dbase2 whichever had the lowest load. dbase4 is now used for two other sites listed below.

This appears to have had a dramatic effect, BUT during the process I wiped out the database in my mistake.

Read the rest of this entry »