2008年7月18日

Low-cost database load balancing solutions

MySQL Proxy is a simple program that sits between your client and MySQL server(s) that can monitor, analyze or transform their communication. Its flexibility allows for unlimited uses; common ones include: load balancing; failover; query analysis; query filtering and modification; and many more.

Sequoia is a transparent middleware solution offering clustering, load balancing and failover services for any database. The database is distributed and replicated over multiple nodes and Sequoia balances the queries between them. Sequoia handles node and network failures transparently. It also provides support for hot recovery, online maintenance operations and online upgrades.

MMM (MySQL Master-Master Replication Manager) is set of flexible scripts to perform monitoring/failover and management of MySQL Master-Master replication cluster configurations. Current version of this software is stable, but authors would appreciate any comments, suggestions, bug reports about this version to make it even better.

Maatkit (formerly MySQL Toolkit) contains essential command-line tools for MySQL, such as table checksums, a query profiler, and a visual EXPLAIN tool. It provides missing features such as checking whether slaves have the same data as the master.

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux.

沒有留言:

張貼留言

lyhcode by lyhcode
歡迎轉載,請務必註明出處!