Equivalent of pgpool-II for MySQL
Is t开发者_开发技巧here any tools which is equivalent to pgpool-II (which is for PostgreSQL) for MySQL db?
Of particular importance for me is the feature - Load Balalce
Load Balance
If a database is replicated, executing a SELECT query on any server will return the same result. pgpool-II takes an advantage of the replication feature to reduce the load on each PostgreSQL server by distributing SELECT queries among multiple servers, improving system's overall throughput. At best, performance improves proportionally to the number of PostgreSQL servers. Load balance works best in a situation where there are a lot of users executing many queries at the same time.
精彩评论