MySQL Fabric Server Farm Testing Overview_MySQL

MySQL SystemQA: MySQL Fabric server farm Setup and Testing overview

<font color="#000000" face="times new roman,times,serif"></font><font size="3">MySQL Fabric is an open-source solution released by the MySQL Engineering team at Oracle. </font><font face="times new roman,times,serif"></font><font color="#000000"></font><font size="3">It is an extensible and easy to use system for managing a MySQL deployment for Sharding</font><font color="#000000"></font><font size="3">and High-availability.</font><font color="#000000"></font><font size="3">High availability is generally used to describe the ability of a system to continue operating </font><font color="#000000"></font><font size="3">and provide resources to the application when a failure occurs in one or more of the </font><font color="#000000"></font><font size="3">following categories in a fault domain: hardware, software, or application.</font><font face="times new roman,times,serif"></font><font color="#000000"></font><font size="3"></font><font color="#000000"></font><font size="3">With high availability feature, MySQL fabric manages several servers in different groups</font><font color="#000000"></font><font size="3">using replication topology. At any point of failure it creates servers available to do the regular </font><font face="times new roman,times,serif"></font><font color="#000000"></font><font size="3">activities.</font><img  src="http://img.bitscn.com/upimg/allimg/c140719/1405KQ10I440-1CR.jpg"    style="max-width:90%"  style="max-width:90%" alt="MySQL Fabric Server Farm Testing Overview_MySQL" ><font face="times new roman,times,serif" size="3"></font><font color="#000000">To test similar functionalities, we have designed a setup in JET framework which will handle multiple </font><font face="times new roman,times,serif" size="3"></font><font color="#000000">servers in multiple machines.</font><font size="4"><b><font color="#000000">What we did?</font></b>We have started with a fabric setup class in JET framework, which starts few servers, creates groups</font><font face="times new roman,times,serif" size="3"></font><font color="#000000">and shards. Initially we ran this on a single machine to verify the setup is fine.</font><font face="times new roman,times,serif" size="3"></font><font color="#000000">Later we moved to 2-3 physical machines to create up to 100 servers, 20 groups and 15 shards. We encountered with a failure as the servers can not be started in individual machines. This was because of the limitations of the physical machine i.e we can not start more that 15-20 servers in a 8gb ram machine.We create a server farm using 2 physical machines and 18 Oracle VMs. There we were able to create a MySQL Fabric setup using 230 servers, 40 groups and 35 shards. This setup was done in linux environment. We then used one window 7 machine and multiple MySQL versions to run the setup.</font><font size="4"><b><font color="#000000">What we have tested using this setup?</font></b><u>We have used the setup to run :</u></font>

• Feature testing (fabric CLI features)
• Failover testing ( failing a server/VM and ensure the recovery)
• Concurrent testing (running multiple activities using threads)
• Scalability testing

<font face="times new roman,times,serif" size="3"></font><font size="4"><b><font color="#000000">Future activities:</font></b></font>

• Crash Testing includes crashing of fabric state-store, multiples Vms, Multiple servers.

Randomize testing includes running randomly selected activities in multiple tests.

Blogs about detail of Crash and randomize testing