MySQL Master-Slave type replication is often used to provide application resiliency. In addition, it allows you to distribute the load on the database between several servers (replicas).
Of course, it is Linux of family of CentOS7+
Configuring of replication takes place in several steps. We will use two servers with addresses:
10.90.100.31 and 10.90.100.32
Case 1 - Beginning.
Configuring the Master. If this is 'fresh' installation, on the server that will act as the master, you need to make changes in additional files of configuration in /etc/my.cnf.d:
Settings of character sets for Master/Slave:
Full content of this article are only for private subscribers or clients .
Also you can to get all content and any support for sites or servers after donation or after buying of any types of subscribe.
Only 101% quaility of any information. We are the best!
Get your personal WordPress site and emailbox on MyVoice.link RIGHT NOW!!!
Your site with SSL
You will be able to get possibility video and audio streaming from own device or via site !!!
You will be a part of community of language exchange, dating and much more !!!
Start plan ONLY 12.99$ per month !!!
With basic support of Super Admins !!!
Try it FREE with 1G of storage space for first month !!!