next »

[nutballs]

holy smokes.
Seconds_Behind_Master: 89068
thats over a day behind.
It seems to be going down at the rate of 25 seconds per 10 seconds.

so.... at that rate, it will catch up in....

59 hours... hahahah and thats assuming no big database churns in the meantime.

ugh.

[vsloathe]

Uh, did you LOAD DATA FROM MASTER?

Also, did you grant proper permissions between masters and slaves?

Also, MySQL master-master replication is a hacky workaround, you have to setup master->slave both ways, so in essence both machines are a master and a slave. Is that what you did?

[nutballs]

actually i did not do LOAD DATA FROM MASTER since its no longer the "correct" way to do it and not even sure if its supported in my current version of mysql.

I set up my new slave.
Dumped the database, which took half a day.
then imported from the dump, which took over half a day.
and turned on replication and it all started doing its thing, with records copying.

I can see my big ass database updating, growing in size.
It just is REALLY busy, and REALLY big.

And yes its master->slave slave<-master
But thats no longer "hacky" as its now actually the standard way to do 2 servers, and most recommend it in 3 servers even. cluster is for more it seems.

I used this walk through:
http://www.howtoforge.com/mysql5_master_master_replication_debian_etch

[nutballs]

62K seconds behind. woot!
go baby go! 17 hours left. youcandoit.

[perkiset]

How long did you go between mirroring the server and starting the slave? That's a nasty amount of transactions that were not moved... or is it huge blobs that need to move?

[nutballs]

it was about 28 hours from me locking the master tables to dump until finishing the import of the dump into the slave.

That means about 5.8million queried based on my stats if i do the math. LOL
206k/hour
OUCH.

but i assume that only table changing queries affect the replication of course, so...
it looks like about 3.5 million table altering trans.
again. OUCH.

[nutballs]

Woot! live and kicking. So... now to add a chunk of code and viola, ghetto round robin.

Code:

function roundrobinhost()
{
$hosts=array('data1','data2');
return $hosts[array_rand($hosts)];
}

working great