gfy database desync (NOT downtime) - GoFuckYourself.com

mike503 · 03-08-2004, 11:24 PM

we've all noticed the downtime and sporadic server outages. i'm not asking about that. i'm wondering if you guys (lensman/adult.com) are relying on mysql replication in the backend for the databases? sometimes i've seen posts come and go, which is a telltale sign of either odd caching (not likely for this) or using replication.

just wondering, i've been relying on it for months and it sucks. i'm about to stop using it soon.

toddler · 03-08-2004, 11:41 PM

What problems are you seeing with it personally? I know many many people who use it just fine. Well, 4.x code base.

What version are you running?

boneprone · 03-09-2004, 12:00 AM

Whhhazzp mike...

We need to do D2 again soon..

Maybe next week

Rictor · 03-09-2004, 12:01 AM

Speak English, nerds.

mike503 · 03-09-2004, 12:03 AM

Quote:

Originally posted by boneprone
Whhhazzp mike...

We need to do D2 again soon..

Maybe next week

i am buddies with asia now dude.

it's pretty tight.

and a couple other chicks there holler at me when i am there.

you got my icq. just let me know. i am down! tues/thurs are best.

boneprone · 03-09-2004, 12:04 AM

Quote:

Originally posted by mike503

i am buddies with asia now dude.

it's pretty tight.

and a couple other chicks there holler at me when i am there.

you got my icq. just let me know. i am down! tues/thurs are best.

Ahh.. Asia is old school..

I used to be tight with her friends. Man, its good to see she is still around.. I love her little sister...

Kinda coked out, but hot.

mike503 · 03-09-2004, 12:04 AM

Quote:

Originally posted by toddler
What problems are you seeing with it personally? I know many many people who use it just fine. Well, 4.x code base.

What version are you running?

4.x - i'm replicating data to 4 slaves and rely on it for real-time access.

looked great on paper, but the hardware/bandwidth can't keep up.

if any slaves get out of sync for any reason either, i have to take down the master db box and allow the slave to sync up (you can do it without taking it down,but it sets the entire master DB to read-only anyway.)

it's crappy.

anyway, i have a beefy fucking dual opteron box coming in for my new database server. so i'm all set

mike503 · 03-09-2004, 12:05 AM

Quote:

Originally posted by boneprone

Ahh.. Asia is old school..

I used to be tight with her friends. Man, its good to see she is still around.. I love her little sister...

Kinda coked out, but hot.

haha yeah. funny shit is she is telling me that she doesn't want her sister hanging out with this other chick i used to go see, because SHE is too much of a cokehead and a "bad influence"

i tell you man, crazy shit.

liquidmoe · 03-09-2004, 12:10 AM

I've played around with mysql replication in the past, but its always been a bit unstable, losing sync at odd times for no real reason.

Whats the \s status show on your 4 servers for queries per sec?

boneprone · 03-09-2004, 12:10 AM

Strippers and coke..

Im tellin ya Dolphin is full of the coke heads..

Asia has seen it all, but her and her era of the crew are all but gone now.

The younger breed seem to have the power there now..

Im still looking for

-Gracie
-Heaven

Asia was friends with em both..

Im wondering where they went. Maybe Asia knows.. Ask her..

Gracie, and Heaven...

Hit me back when ya find out!

mike503 · 03-09-2004, 12:11 AM

Quote:

Originally posted by boneprone

Gracie, and Heaven...

Hit me back when ya find out!

i'll try to remember. i was thinking of going there tomorrow night possibly...

you on icq? hit me up quick, 45226474

boneprone · 03-09-2004, 12:12 AM

btw mike, is the Miss Nude Oregon thing starting again soon?

If so is it at Dolphin again, or has it Ventured out...

The website seems to have some kind of problem..

http://www.missnudeoregon.com

mike503 · 03-09-2004, 12:16 AM

Quote:

Originally posted by liquidmoe
I've played around with mysql replication in the past, but its always been a bit unstable, losing sync at odd times for no real reason.

Whats the \s status show on your 4 servers for queries per sec?

master db box: 284 (it's only a dual p3 800 with a gig of ram and it also does my NFS)

slave: 8 queries per sec

i don't believe it counts replication

the sad thing is, all the replication shit is is just sending the same queries to all the slaves. it's really not "smart" at all. all it does is track where it left off.

the code is designed to hit the master db box for writes and VERY important reads. hit the [local webserver] slaves for reads. as you can see, shit sucks at the moment. not balancing very nicely.

(i've also got a couple clients using my master db box... blahblahblah) - i have a new cluster setup being setup that will address a lot of this.

mike503 · 03-09-2004, 12:17 AM

Quote:

Originally posted by boneprone
btw mike, is the Miss Nude Oregon thing starting again soon?

If so is it at Dolphin again, or has it Ventured out...

The website seems to have some kind of problem..

http://www.missnudeoregon.com

what kind of problem is that?

yeah, the miss nude oregon shit is still going on. they had it last year and some chicks have mentioned it this year...

d2 changed it's entire layout now it's all cramped and they've got 3 different style stages now, the chicks hate it (supposedly only temporary) but they don't know how they can do all the miss nude oregon activities on such small/lame stages.

who knows. heh

liquidmoe · 03-09-2004, 12:20 AM

Are you still planning to replicate when you replace the master server with something else? At this stage I dont trust replication so we just upgrade the hardware until a single server is capable of pushing the entire sql load.

mike503 · 03-09-2004, 12:23 AM

Quote:

Originally posted by liquidmoe
Are you still planning to replicate when you replace the master server with something else? At this stage I dont trust replication so we just upgrade the hardware until a single server is capable of pushing the entire sql load.

nope.

in the new setup the beefy master box will handle all of the sql load.

i will forward cache only a few things to local mysql servers - just to help save unnecessary/redundant/cached-style queries from the master db.

03-08-2004, 11:24 PM	#1
mike503 Confirmed User Industry Role: Join Date: May 2002 Location: oregon. Posts: 2,243	gfy database desync (NOT downtime) we've all noticed the downtime and sporadic server outages. i'm not asking about that. i'm wondering if you guys (lensman/adult.com) are relying on mysql replication in the backend for the databases? sometimes i've seen posts come and go, which is a telltale sign of either odd caching (not likely for this) or using replication. just wondering, i've been relying on it for months and it sucks. i'm about to stop using it soon. __________________ php/mysql guru. hosting, coding, all that jazz.

03-08-2004, 11:41 PM	#2
toddler Confirmed User Join Date: Jun 2002 Location: austin, tx Posts: 1,911	What problems are you seeing with it personally? I know many many people who use it just fine. Well, 4.x code base. What version are you running? __________________ http://www.flickr.com/photos/zoddler/

03-09-2004, 12:00 AM	#3
boneprone Hall Of Fame Industry Role: Join Date: Jan 2001 Location: Portland Oregon USA Posts: 34,415	Whhhazzp mike... We need to do D2 again soon.. Maybe next week __________________ Industry Hall Of Fame Legend Mike Jones Bow to the Power - Still BP4L http://gfyawards.com/hall-of-fame Learn about it kids.

03-09-2004, 12:10 AM	#9
liquidmoe Confirmed User Join Date: Mar 2002 Location: NY Posts: 4,994	I've played around with mysql replication in the past, but its always been a bit unstable, losing sync at odd times for no real reason. Whats the \s status show on your 4 servers for queries per sec? __________________ Take Luck!

03-09-2004, 12:10 AM	#10
boneprone Hall Of Fame Industry Role: Join Date: Jan 2001 Location: Portland Oregon USA Posts: 34,415	Strippers and coke.. Im tellin ya Dolphin is full of the coke heads.. Asia has seen it all, but her and her era of the crew are all but gone now. The younger breed seem to have the power there now.. Im still looking for -Gracie -Heaven Asia was friends with em both.. Im wondering where they went. Maybe Asia knows.. Ask her.. Gracie, and Heaven... Hit me back when ya find out! __________________ Industry Hall Of Fame Legend Mike Jones Bow to the Power - Still BP4L http://gfyawards.com/hall-of-fame Learn about it kids.

03-09-2004, 12:01 AM	#4
Rictor Old Timer Industry Role: Join Date: Jan 2001 Location: Indianapolis Posts: 12,208	Speak English, nerds.

03-09-2004, 12:12 AM	#12
boneprone Hall Of Fame Industry Role: Join Date: Jan 2001 Location: Portland Oregon USA Posts: 34,415	btw mike, is the Miss Nude Oregon thing starting again soon? If so is it at Dolphin again, or has it Ventured out... The website seems to have some kind of problem.. http://www.missnudeoregon.com __________________ Industry Hall Of Fame Legend Mike Jones Bow to the Power - Still BP4L http://gfyawards.com/hall-of-fame Learn about it kids.

03-09-2004, 12:20 AM	#15
liquidmoe Confirmed User Join Date: Mar 2002 Location: NY Posts: 4,994	Are you still planning to replicate when you replace the master server with something else? At this stage I dont trust replication so we just upgrade the hardware until a single server is capable of pushing the entire sql load. __________________ Take Luck!