4. Create a Slave MySQL Server

&lt;p&gt;In Bitrix24 Virtual Appliance, it is possible to quickly deploy a Master-Slave cluster configuration for &lt;a href=&quot;https://www.bitrix24.com/self-hosted/&quot; target=&quot;_blank&quot; /&gt;Bitrix24 On-Premise&lt;/a&gt;. &lt;/p&gt; &lt;p&gt;&lt;img src=&quot;/images/portal_admin/install/vmbitrix/vmbitrix5/manage_pool/cluster_replication_new_en.png&quot; width=&quot;682&quot; height=&quot;411&quot; /&gt;&lt;/p&gt; &lt;p&gt;Key features: &lt;/p&gt; &lt;ul&gt; &lt;li&gt; Flexible SQL load balancing&lt;/li&gt; &lt;li&gt; Easy administration&lt;/li&gt; &lt;li&gt; Fast, cheap and unlimited scalability&lt;/li&gt; &lt;li&gt; Online backup&lt;/li&gt; &lt;li&gt; Web application logic maintenance not required&lt;/li&gt; &lt;/ul&gt; &lt;p&gt;«Master - Slave» model is realized via MySQL tools. Bitrix24 software allows to flexibly balance the load between servers, participating in replication. &lt;/p&gt; &lt;p&gt;&lt;div class=&quot;warning&quot;&gt;&lt;b&gt;Attention!&lt;/b&gt; Prior to start using the &lt;b&gt;memcached&lt;/b&gt; server pool in &lt;b&gt;BitrixVA/BitrixEnv&lt;/b&gt;, it is necessary to pre-install the Bitrix24 On-Premise &lt;a href=&quot;https://www.bitrix24.com/self-hosted/&quot; target=&quot;_blank&quot; /&gt;Bitrix24 On-Premise&lt;/a&gt; or Bitrix Site Manager products with &lt;a href=&quot;http://www.bitrixsoft.com/download/files/manuals/en/webcluster_guide_en.pdf&quot; target=&quot;_blank&quot;&gt;Web Cluster&lt;/a&gt; module. This module is available only in advanced editions of Bitrix24 products. &lt;/div&gt;&lt;/p&gt; &lt;a name=&quot;add_slave&quot;&gt;&lt;/a&gt; &lt;p&gt;To create a slave MySQL server, the following steps are required: &lt;/p&gt; &lt;ul&gt; &lt;li&gt;Select the menu item &lt;span class=&quot;path&quot;&gt;3. Configure MySQL servers &gt; 4. Create slave MySQL server&lt;/span&gt;, enter host name in the pool in which the slave MySQL server will be created (in this example - &lt;b&gt;server2&lt;/b&gt;): &lt;p&gt;&lt;img src=&quot;/images/bitrixvm/vmbitrix7/configure_mysql/vm_mysql_add_slave1.png&quot;&gt;&lt;/p&gt; &lt;/li&gt; &lt;li&gt;Enter passwords for replication and cluster: &lt;p&gt;&lt;img src=&quot;/images/bitrixvm/vmbitrix7/configure_mysql/vm_mysql_add_slave2.png&quot; /&gt;&lt;/p&gt; &lt;p&gt;&lt;div class=&quot;hint&quot;&gt;&lt;b&gt;Note&lt;/b&gt;: Replication and cluster passwords are required to be entered once, then these passwords will not be requested when new servers are added. &lt;/div&gt;&lt;/p&gt; &lt;/li&gt; &lt;li&gt;Wait until the task of adding MySQL server is completed.&lt;/li&gt; &lt;li&gt;Create one more slave MySQL server in the similar manner (&lt;b&gt;server3&lt;/b&gt;). As a result, we will get three MySQL servers: master (&lt;b&gt;server1&lt;/b&gt;) and two slaves (&lt;b&gt;server2&lt;/b&gt; and &lt;b&gt;server3&lt;/b&gt;): &lt;p&gt;&lt;img src=&quot;/images/bitrixvm/vmbitrix7/configure_mysql/vm_mysql_add_slave3.png&quot;&gt;&lt;/p&gt; &lt;/li&gt; &lt;/ul&gt; &lt;p&gt;&lt;div class=&quot;warning&quot;&gt;&lt;b&gt;Attention!&lt;/b&gt; Task execution may take a rather long time (up to 2-3 hours and more) depending on the task complexity, data volume used in such tasks, capacity and server load. You can check the currently executed tasks by using menu item &lt;span class=&quot;path&quot;&gt;5. Background tasks in the pool &gt; 1. View running tasks&lt;/span&gt;. If task completion log files are needed to be reviewed, they are located in the following directory &lt;code&gt;/opt/webdir/temp&lt;/code&gt;.&lt;/div&gt;&lt;/p&gt;

Bitrix Virtual Appliance