gfy database desync (NOT downtime)

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • mike503
    Confirmed User
    • May 2002
    • 2243
    #1

    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.
    Tags: None
    • toddler
      Confirmed User
      • Jun 2002
      • 1911
      #2
      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/

        Comment

        • boneprone
          Hall Of Fame
          • Jan 2001
          • 34415
          #3
          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.

            Comment

            • Rictor
              Old Timer
              • Jan 2001
              • 12208
              #4
              Speak English, nerds.

                Comment

                • mike503
                  Confirmed User
                  • May 2002
                  • 2243
                  #5
                  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.
                  php/mysql guru. hosting, coding, all that jazz.

                    Comment

                    • boneprone
                      Hall Of Fame
                      • Jan 2001
                      • 34415
                      #6
                      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.

                      Industry Hall Of Fame Legend Mike Jones
                      Bow to the Power - Still BP4L
                      http://gfyawards.com/hall-of-fame
                      Learn about it kids.

                        Comment

                        • mike503
                          Confirmed User
                          • May 2002
                          • 2243
                          #7
                          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
                          php/mysql guru. hosting, coding, all that jazz.

                            Comment

                            • mike503
                              Confirmed User
                              • May 2002
                              • 2243
                              #8
                              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.
                              php/mysql guru. hosting, coding, all that jazz.

                                Comment

                                • liquidmoe
                                  Confirmed User
                                  • Mar 2002
                                  • 4994
                                  #9
                                  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!

                                    Comment

                                    • boneprone
                                      Hall Of Fame
                                      • Jan 2001
                                      • 34415
                                      #10
                                      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.

                                        Comment

                                        • mike503
                                          Confirmed User
                                          • May 2002
                                          • 2243
                                          #11
                                          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
                                          php/mysql guru. hosting, coding, all that jazz.

                                            Comment

                                            • boneprone
                                              Hall Of Fame
                                              • Jan 2001
                                              • 34415
                                              #12
                                              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.

                                                Comment

                                                • mike503
                                                  Confirmed User
                                                  • May 2002
                                                  • 2243
                                                  #13
                                                  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.
                                                  php/mysql guru. hosting, coding, all that jazz.

                                                    Comment

                                                    • mike503
                                                      Confirmed User
                                                      • May 2002
                                                      • 2243
                                                      #14
                                                      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
                                                      php/mysql guru. hosting, coding, all that jazz.

                                                        Comment

                                                        • liquidmoe
                                                          Confirmed User
                                                          • Mar 2002
                                                          • 4994
                                                          #15
                                                          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!

                                                            Comment

                                                            • mike503
                                                              Confirmed User
                                                              • May 2002
                                                              • 2243
                                                              #16
                                                              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.
                                                              php/mysql guru. hosting, coding, all that jazz.

                                                                Comment

                                                                Previous template Next
                                                                Working...