Oracle Blog

JBalint's Blog

Saturday Sep 21, 2013

As Tomas announced in his keynote at MySQL Connect 2013, we are working on a brand new product called MySQL Fabric. Along with this release of MySQL Fabric, we are releasing Connector/J 5.1.26 with Fabric support on labs.mysql.com. This is an alpha-quality release that adds support for scalability features in MySQL Fabric. Sharding and read/write splitting are the initial features supported by Connector/J.

In a setup involving read/write splitting or customized sharding, we generally have to duplicate knowledge of this configuration in the client applications. This is done in connection strings specified in configuration files or directly in code. With MySQL Fabric, we can express our system-wide configuration of database servers in a way that it can be accessed by client applications. In cases where this needs to change (and it always does..), the configurations affecting client applications no longer need to be changed. The connector will access the configuration change through the MySQL Fabric server and automatically route new connections to the appropriate servers.

In addition to the JDBC API, this release includes integration for using Hibernate with MySQL Fabric. Based on Hibernate's built-in multi-tenancy support, you can access your sharded data with little effort.

This is a big step forward for handling large datasets and we encourage you try out the new features! Download MySQL Utilities: Fabric and Connector/J with Fabric support from labs.mysql.com. For more details, refer to the README.1ST file in the Connector/J package.