10 years ago

MySQL 5.7 Fabric: Sharding & server farm management tool

MySQL Fabric Setup using DRBD and Pacemaker.

MySQL 5.7 Fabric is seen to be MySQL’s answer to the growing threat of NoSQL systems.  That is to make MySQL still competitive when it comes to workloads related to online transaction processing.

What is MySQL 5.7 Fabric?

MySQL 5.7 Fabric is open source and is seen as a high availability solution.  You could also think of it as a management tool that can help you with sharding.  With Fabric, you no longer have to create the sharding yourself as it is built into the MySQL 5.7 release.

Or better yet, think of it as a middleware-based replication platform that helps you manage primary copy clusters.

MySQL 5.7 Fabric is integrated and built-in, and helps you manage and oversee MySQL server farms.  It makes both sharding and high availability possible.

What’s more, MySQL 5.7 Fabric is easy to use and extensible.  You can execute it even when something fails in your MySQL set up.

High Availability

If you want your MySQL servers to be highly available, you would need to make sure that your system is redundant.  Traditionally, redundancy usually means having secondary servers become backups to a primary or master server.  So you are working with a farm, or a collection of servers, and not just one server.

MySQL 5.7 Fabric helps you manage that collection of servers.

What’s more, MySQL 5.7 Fabric makes use of failure detectors that help you see if there are node failures.  The detector can then switch to the most updated slave if the master fails for some reason.  Clients and applications can ask MySQL Fabric for a list of available nodes, and deploy themselves on one of these.

Sharding

Sharding is very useful if you have particularly large databases or if you have very demanding write loads. Sharding allows you to divide these databases into different shards. These shards would then contain portions of data of the entire database and are stored on separate servers.

So what happens with sharding is that you get a more manageable database while also being able to scale write traffic by allowing you to execute several write loads simultaneously.

MySQL Fabric can separate tables into various sharded tables. It also allows you to shard several tables in the same way. This helps when you are optimizing data locality and latency.

Let Four Cornerstone help you with all your MySQL 5.7 Fabric concerns

If you are looking to improve on your MySQL servers, then you simply must give MySQL 5.7 Fabric a whirl.  Four Cornerstone can help you leverage all features and technology that comes with MySQL with its team of Oracle and MySQL experts.  If you have problems implementing sharding and high availability solutions using MySQL 5.7 Fabric, we can help.

You do not have to wait! We can get your MySQL servers up and running at a scale you need to run, operate and manage your business.  On top of that, working with us allows you to take full advantage of MySQL Enterprise, including leveraging the following features:

  • Audit
  • Complete High Availability
  • Enterprise Backup
  • Monitor
  • Scalability
  • Security
  • Workbench

Call Four Cornerstone today and get the best MySQL 5.7 Fabric implementations without further delay!

Photo by MySQL.

Scroll to Top