Mysql remote connection doesn't stay connected

Discussion in 'Server Operation' started by TiTex, Mar 9, 2012.

  1. TiTex

    TiTex Member

    Hello to everybody ,
    After searching on the all mighty google for a few hours for a solution i gave up because i don't know what exactly i'm looking for.

    This is my problem ...
    I've got a linux box with mysql server installed (fedora, x86 , 4gb ddr2 ).
    I've got 3 or more remote game servers hosted by some 3rd party.
    On my linux box also have a web-application , that application is using a mysql database table.
    The remote game servers need to read the information in this table all the time and also make updates/changes to it when an event orcurs.

    I don't know why but sometimes ... randomly, the connection between mysql database and game server IP is lost. I've tried searching for a solution but since i don't know what exactly i'm searching for maybe somebody here had a similar problem and can help me out

    this is the mysql configuration file

    Code:
    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    #old_passwords=1
    skip-innodb
    thread_cache_size=4
    key_buffer_size=32M
    query_cache_size=8M
    query_cache_limit=48M
    join_buffer_size=2024K
    table_cache=96
    skip-locking
    connect_timeout=120
    interactive_timeout=58000
    wait_timeout=58000
    
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    
    
    [mysqldump]
    quick
    max_allowed_packet = 16M
    
    [mysql]
    no-auto-rehash
    # Remove the next comment character if you are not familiar with SQL
    #safe-updates
    
    [myisamchk]
    key_buffer_size = 20M
    sort_buffer_size = 20M
    read_buffer = 2M
    write_buffer = 2M
    
    [mysqlhotcopy]
    interactive-timeout
    
    Thank you!
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Are there any MySQL errors in your logs?
     
  3. TiTex

    TiTex Member

    no ... nothing
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Is there something in between your servers that blocks the connection from time to time (firewall, unstable connection, etc.)?
     
  5. TiTex

    TiTex Member

    as far as i know it shouldn't be , i'll send you my firewall script in PM maybe you'll spot something i didn't
     
  6. falko

    falko Super Moderator ISPConfig Developer

    Do you have this problem also if you disable the firewall?
     
  7. TiTex

    TiTex Member

    didn't try but i will and see what's gonna happen
     

Share This Page