Tungsten project... proxy, router, SQL load balancer...

By Mathieu CARBONNEAUX

It’s an open source project (GPL) in Java to provide a complete software stack that allows database-level scaling:

  • Master/slave replication clustering,
  • SQL load balancer,
  • SQL router/proxy,
  • **Monitoring… **

Globally revolves around MySQL and PostgreSQL, but there is a paid Oracle version.

Tungsten Replicator:

Implements a database-independent master/slave replication system.

Tungsten Connector

A proxy for MySQL and PostgreSQL clients. The connector converts native protocol queries (MySQL and PostgreSQL protocol) into JDBC queries.

http://scale-out-blog.blogspot.com/2008/05/myosotis-connector-fast-sql-proxy-for.html. Tungsten SQL-Router

It’s a JDBC “wrapper” that serves to provide “transparent failover”, “load-balancing” and “partitioning” in a cluster context to a native JDBC driver.

http://scale-out-blog.blogspot.com/2009/03/implementing-relaxed-consistency.html.

Tungsten Manager

It’s a “Framework”-based system that allows managing cluster resources. “Tungsten Manager” offers the ability to distribute commands and administrative orders to groups of services supporting JMX, as well as system processes.

Tungsten Monitor

“Pluggable” monitoring system that collects and distributes the state of each cluster resource.

http://scale-out-blog.blogspot.com/2009/03/announcing-tungsten-monitor.html.