load-balanced mysql error: lost connection during query

Discussion in 'HOWTO-Related Questions' started by richmond.sterling, Aug 22, 2006.

  1. richmond.sterling

    richmond.sterling New Member

    Hi,

    First, thanks for the great article you posted on:
    http://www.howtoforge.com/loadbalanced_mysql_cluster_debian

    We've implemented what you've done with some
    difference: we're using Mandriva Linux instead. We
    did not use Debian because the Debian distro we used
    could not detect our SATA drives for some reason.

    The problem we encounter is that we keep encountering
    "Mysql connection lost during query" errors. It would
    occur randomly throughout our webpage. We tried
    different timeout settings for the nodes (thru mysql
    CLI interface) to no avail. (Is not using the Debian
    distro a big issue here?)

    Do you know of any other website that talks about
    resolving this?

    Thanks for any info you can give regarding this,
    Rich
     
  2. falko

    falko Super Moderator Howtoforge Staff

    What's the output of
    Code:
    netstat -tap
    ?
    What's the exact error message? Is there anything in the logs?
     

Share This Page