Lars Thalmann

MySQL Fabric is an open-source solution released by the MySQL Engineering team at Oracle. It makes management of MySQL server farms easy and available for both applications with small and large number of servers.

In order to provide resilience to server failures, MySQL Fabric organizes the servers in groups and deploys high-availability solutions within each group. The concept is independent of the implementation, which can be done using traditional asynchronous primary backup approach, MySQL Cluster or solutions with shared or replicated storage. In the first version, availability is implemented using the asynchronous primary backup approach.

As the enterprise grows, so does the data and the number of requests for the data. A single server will not be able to handle the increased demands on size and load of the database. A common technique for scaling is to shard the database thereby reducing the write load and data size for each server. MySQL Fabric is integrated with the connectors and provides an enhanced API for working with massively sharded databases.

In this presentation, you will get an introduction to MySQL Fabric and how it support high-availability and sharding as well as how to write and manage applications taking advantage of the latest features of MySQL Fabric.

The new MySQL 5.6 server is the most capable MySQL server ever developed. There are optimizer improvements, higher transactional throughput and lower latency for complex queries, NoSQL API with memcache, partitioning improvements, performance schema, and a range of replication features.

In this talk we present the top new features and go into more depth on replication, in terms of performance, scalability, high availability and agility – whether deployed on premise or in the cloud.

MySQL 5.6 leverages DevOps methodologies, providing a compelling feature set coupled with a comprehensive array of tooling. Together they reduce administrative overhead, providing flexibility to support rapidly evolving business requirements.