MySQL Forums
Forum List  »  General

Distributed tables or something like that
Posted by: Ilya Veretenkin
Date: October 06, 2004 12:33AM


I have the following environment. Several clients, that connect to MySQL server have lots of INSERT queries in _one_ table (it's something like logging). But MySQL server can't insert rows at the speed I want it to. I tried to use INSERT DELAYED, but it didn't solve the problem. I have an idea to install several MySQL servers on several hosts, make a table with the same structure on all of the hosts and to write a server that stands between clients and mysql servers. This server will process INSERT queries by readdressing them to each of mysql servers in turn. So each of MySQL servers would store horizontally separated part of my table. The questions follow:
1. Will this proposed system of "load balancing" work?
2. Are there any written tools acting similar to proposed by me?

Options: ReplyQuote

Written By
Distributed tables or something like that
October 06, 2004 12:33AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.