you might also try using some sort of VPN solution; depending on distance, setting up pptp might not be a bad idea anyways. The overhead can hit 5% or even 10%, but the added security and error correction makes it well worth it, especially over a potentially buggy connection such as yours.
I've personal experience with using a pair of Netopia R910 routers; they're bloody cheap and approaching wire speeds on their ports, which is no small feat when you consider they're less than $150 a pop. If they're in the same room, however...just get a decent pair of 10/100 cards and make a nice crossover cable. Please. It's the right thing to do. hth Dan ----- Original Message ----- From: "Alexander Newald" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 6:36 PM Subject: unstable mysql connection > Hello, > > I've an application client that stores it's data in a mysql server. Client > and server (Both linux) are on diffrent hosts, I can't change the > application but I have root access on both server and client. > > The problem: Sometimes the lan connection has paket drops (about 1%) and the > connection to the mysql server is lost. Unfortunately the client starts his > work from the beginning. > > How can I add some sort of "proxy" between the client and the server on the > client host that accept the mysql query from the client like a mysql server, > forwards this query to the real mysql server as often as needed to get the > answer over the bad lan connection and than returns the result of the > clients query to the client like a normal mysql server would do? > > Anyway, if someone knows a complete diffrent solution that works without > changing the client application (and of course the buggy lan) I will be > happy! > > Thanks, > > Alexander Newald > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]