


Detailed explanation on setting up a master-slave instance for MySQL5.7.18 master-slave replication
This article mainly introduces the detailed tutorial of MySQL5.7.18 master-slave replication setup (one master and one slave). Friends who need it can refer to it. I hope it can help everyone. MySQL uses 3 threads to perform the replication function (one of which is on the master server and the other two on the slave server. Let’s introduce the content of this article in detail.
1. Replication Principle
The master writes updates to binary log files and maintains an index of the files to keep track of the log rotation. These logs record updates sent to the slave. When a slave connects to the master, it notifies the master that the slave is in the log. The location of the last successful update is read. The slave server receives any updates that have occurred since then, and then blocks and waits for the master server to notify of new updates.
MySQL uses 3 threads to perform the replication function (where 1 on the master server and the other two on the slave server. When START SLAVE is issued, the slave server creates an I/O thread to connect to the master server and let it send the statements recorded in its binary log. One thread sends the content in the binary log to the slave server.
This thread reads the content sent by the main server Binlog Dump thread and transfers the data to the Binlog Dump thread on the master server. Copy to the local file in the data directory of the slave server, that is, the relay log. The third thread is the SQL thread, which is created by the slave server to read the relay log and execute the updates contained in the log
. 2. Server preparation
Operating system version: Red Hat Enterprise Linux Server release 6.7 (Santiago)
Master (master) ip: 172.16.115.245 Host name: mysql2 server_id:245
Slave (slave) ip: 172.16.115.247 Host name: mysql3 server_id:247
MySQL5.7.18 is installed on both the master and slave servers
3. Master-slave replication implementation details
1. Set a connection account for the server on the master server and grant REPLICATION SLAVE permission
1 |
|
2. Modify the master configuration file my.cnf
1 2 |
|
These two values must be set. After setting up, restart MySQL
3. Back up the complete data of the master
1 |
|
Description:
--master-data=2 means recording the master at the backup time. Binlog location and Position
--single-transaction means getting a consistent snapshot
-R means backing up stored procedures and functions
--triggres means backup triggers
-A means backup All libraries
4. Check the binlog name and location when backing up the main library
1 2 3 4 5 6 7 |
|
Or go to the database file just backed up: vi all.sql
5. Modify the slave library configuration file my.cnf
1 2 3 4 5 6 7 |
|
read_only=ON (read-only mode)
After setting, restart MySQL.
6. Restore the master backup on the slave server
1 |
|
7. Stop the slave library, configure the master-slave parameters, and open the slave library.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 |
|
8. View master and slave related processes
master Binlog Dump thread:
1 2 3 4 5 6 7 8 9 10 |
|
slave IO/SQL thread:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
|
9. At this point, The master-slave configuration has been completed. You can create databases, tables and other operations on the master server to see if the slave database is synchronized!
Related recommendations:
Mysql master-slave replication setup_MySQL
Analysis of the principle and configuration of MySQL master-slave replication
The above is the detailed content of Detailed explanation on setting up a master-slave instance for MySQL5.7.18 master-slave replication. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











We users should be able to understand the diversity of some functions when using this platform. We know that the lyrics of some songs are very well written. Sometimes we even listen to it several times and feel that the meaning is very profound. So if we want to understand the meaning of it, we want to copy it directly and use it as copywriting. However, if we want to use it, we still need to You just need to learn how to copy lyrics. I believe that everyone is familiar with these operations, but it is indeed a bit difficult to operate on a mobile phone. So in order to give you a better understanding, today the editor is here to help you. A good explanation of some of the above operating experiences. If you also like it, come and take a look with the editor. Don’t miss it.

The shortcut key for copying is "Ctrl+c", and the corresponding paste key is "Ctrl+v"; on the computer, use the mouse to drag and select text, hold down Ctrl, and then click the C key to complete the copy; A shortcut key refers to completing an operation through certain specific keys, key sequences, or key combinations.

How to quickly build a statistical chart system under the Vue framework. In modern web applications, statistical charts are an essential component. As a popular front-end framework, Vue.js provides many convenient tools and components that can help us quickly build a statistical chart system. This article will introduce how to use the Vue framework and some plug-ins to build a simple statistical chart system. First, we need to prepare a Vue.js development environment, including installing Vue scaffolding and some related plug-ins. Execute the following command in the command line

In the PS copy layer shortcut keys, we can know that if you want to copy a layer when using PS, you can use the shortcut key [Ctrl+J] for quick copying. This introduction to the shortcut keys for copying layers can tell you the specific operation method. The following is the detailed content, so take a look. PS copy layer shortcut key answer: [Ctrl+J] Specific method: 1. Open the image in PS and select the layer that needs to be copied. 2. Press [Ctrl+J] on the keyboard at the same time to complete the copy of the layer. Other copying methods: 1. After opening the image, press and hold the layer and move the [New Layer] icon downwards. 2. After moving to the icon, let go. 3. The layer copy is completed.

Players can collect different materials to build buildings when playing in the Mistlock Kingdom. Many players want to know whether to build buildings in the wild. Buildings cannot be built in the wild in the Mistlock Kingdom. They must be within the scope of the altar. . Can buildings be built in the wild in Mistlock Kingdom? Answer: No. 1. Buildings cannot be built in the wild areas of the Mist Lock Kingdom. 2. The building must be built within the scope of the altar. 3. Players can place the Spirit Fire Altar by themselves, but once they leave the range, they will not be able to construct buildings. 4. We can also directly dig a hole in the mountain as our home, so we don’t need to consume building materials. 5. There is a comfort mechanism in the buildings built by players themselves, that is to say, the better the interior, the higher the comfort. 6. High comfort will bring attribute bonuses to players, such as

Vue is a popular JavaScript framework that provides a convenient drag-and-drop function, allowing us to easily copy and move elements. Next, let's take a look at how to copy and move drag-and-drop elements in Vue. 1. Basic implementation of drag-and-drop elements To copy and move drag-and-drop elements in Vue, you first need to implement the basic drag-and-drop function of the element. The specific implementation method is as follows: Add the elements that need to be dragged in the template: <divclass="drag-elem"

How to back up CMS DreamWeaver database files? In the process of using CMS to build a website, it is very important to ensure the security of database files to prevent data loss or damage. Backing up database files is an essential operation. The following will introduce how to back up CMS DreamWeaver database files and attach specific code examples. 1. Use phpMyAdmin for backup. phpMyAdmin is a commonly used database management tool through which you can easily back up the database. The following is using phpMyAdm

On Windows, the shortcut key for copying is Ctrl C; on Apple, the shortcut key for copying is Command C; on Linux, the shortcut key for copying is Ctrl Shift C. Knowing these shortcut keys can improve the user's work efficiency and facilitate text or file copy operations.
