Help needed: Very strange mysql problem!!

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • KidCock
    So Fucking Banned
    • May 2003
    • 788
    #1

    Help needed: Very strange mysql problem!!

    Hi, I am having a very weird problem with one of my database servers.

    Let's take the following setup:

    10 load-balanced servers (I'll call them ServerA)
    1 admin server (ServerB)
    1 database server (DB1)

    Now ServerA has a function to insert a row into a table on DB1 whenever someone hits certain pages (for stats collection). There are probably about 1000 inserts being done per second.

    ServerB has a script that runs every 20 minutes, which does a very quick/simple select from DB1, then loops though the results and does updates/deletes on a different database server.

    Everytime the script on ServerB runs, all attempts to connect to DB1 from ServerA fail. This causes major problems like causing server load on ServerA to rise dramatically.

    I have checked when the script runs, everything on DB1 is normal. Server load, mysql processes, no locks, etc...

    I also have it logging the connection failures with mysql_error but mysql_error turns up blank.

    Can anyone try and help me figure out what's going on here!? Why won't it connect during the period the script runs and why is mysql_error blank?

    Webservers are FreeBSD 4.8-Stable, DB1 is Redhat 7.3 running MySQL-standard 4.0.13

    Thanks!!
    Tags: None
    • m4tt
      So Fucking Banned
      • May 2003
      • 384
      #2
      What is your ICQ? I'll try to help : )

        Comment

        • KidCock
          So Fucking Banned
          • May 2003
          • 788
          #3
          38373031

          thx ;>

            Comment

            • foe
              Confirmed User
              • May 2002
              • 5246
              #4
              Originally posted by KidCock
              Hi, I am having a very weird problem with one of my database servers.

              Let's take the following setup:

              10 load-balanced servers (I'll call them ServerA)
              1 admin server (ServerB)
              1 database server (DB1)

              Now ServerA has a function to insert a row into a table on DB1 whenever someone hits certain pages (for stats collection). There are probably about 1000 inserts being done per second.

              ServerB has a script that runs every 20 minutes, which does a very quick/simple select from DB1, then loops though the results and does updates/deletes on a different database server.

              Everytime the script on ServerB runs, all attempts to connect to DB1 from ServerA fail. This causes major problems like causing server load on ServerA to rise dramatically.

              I have checked when the script runs, everything on DB1 is normal. Server load, mysql processes, no locks, etc...

              I also have it logging the connection failures with mysql_error but mysql_error turns up blank.

              Can anyone try and help me figure out what's going on here!? Why won't it connect during the period the script runs and why is mysql_error blank?

              Webservers are FreeBSD 4.8-Stable, DB1 is Redhat 7.3 running MySQL-standard 4.0.13

              Thanks!!
              use lowpriority

                Comment

                • foe
                  Confirmed User
                  • May 2002
                  • 5246
                  #5
                  icq me if you still cant solve it

                    Comment

                    Previous template Next
                    Working...