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>
<font face="times new roman,times,serif" size="3"></font><font size="4"><b><font color="#000000">Future activities:</font></b></font>
