How to configure database master-slave replication on Linux-Linux Operation and Maintenance-php.cn

Home

Operation and Maintenance

Linux Operation and Maintenance

How to configure database master-slave replication on Linux

PHPz

Jul 07, 2023 am 09:45 AM

linuxmaster-slave replicationdatabase

How to configure database master-slave replication on Linux

In Linux systems, configuring database master-slave replication is a common task. Master-slave replication can provide data redundancy backup, load balancing and high availability. This article will introduce the steps of configuring database master-slave replication on Linux and provide corresponding code examples.

Step 1: Install database software
First, we need to install the corresponding database software on the master server and slave server. This article takes the MySQL database as an example. The installation process is as follows:

Execute the following commands on the master server and slave server to install the MySQL database:
```
sudo apt update
sudo apt install mysql-server
```

Step 2: Configure the main server
Next, we need to perform a series of configurations on the main server:

Edit the MySQL configuration file/etc/mysql/mysql. conf.d/mysqld.cnf, uncomment the following lines (delete the # before the line):

#bind-address            = 127.0.0.1
#log_bin                  = /var/log/mysql/mysql-bin.log
#binlog_do_db            = mydatabase

Restart the MySQL server:
```
sudo service mysql restart
```
Log in to the MySQL server and execute the following SQL command:
```
mysql -u root -p
```
Execute in the MySQL interactive interface:
```
CREATE USER 'replication'@'%' IDENTIFIED BY 'password';
GRANT REPLICATION SLAVE ON *.* TO 'replication'@'%';
FLUSH PRIVILEGES;
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;
```
Note down the File and The value of the Position field will be used on the slave server.
Unlock form:
```
UNLOCK TABLES;
```

Step 3: Configure the slave server
Next, perform a series of configurations on the slave server:

Edit the MySQL configuration file/etc/mysql/mysql.conf.d/mysqld.cnf and uncomment the following lines:
```
#bind-address            = 127.0.0.1
```
Restart the MySQL server:
```
sudo service mysql restart
```
Log in to the MySQL server and execute the following SQL command: (Replace <master-ip></master-ip> with that of the master server IP address, <master-file></master-file> and <master-position></master-position> are replaced with the File and Position## recorded in the previous step. #The value of the field.)
```
mysql -u root -p
```
Execute in the MySQL interactive interface:
```
CHANGE MASTER TO MASTER_HOST='<master-ip>', MASTER_USER='replication', MASTER_PASSWORD='password', MASTER_LOG_FILE='<master-file>', MASTER_LOG_POS=<master-position>;
START SLAVE;
```
Check the status of the slave server:
```
SHOW SLAVE STATUSG
```
Ensure
The values of the Slave_IO_Running and Slave_SQL_Running fields are both Yes, indicating that master-slave replication has been successfully configured.

So far, we have completed the process of configuring database master-slave replication on Linux.

Summary

This article introduces the steps to configure database master-slave replication under Linux system, and provides corresponding code examples. Through master-slave replication, we can obtain the benefits of data redundancy backup, load balancing and high availability. When configuring master-slave replication, you need to pay attention to the software installation and configuration of the master server and slave servers, and correctly set the connections and permissions of the master and slave servers. I hope this article will help you configure database master-slave replication on your Linux system.

The above is the detailed content of How to configure database master-slave replication on Linux. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Linux's Essential Components: Explained for BeginnersApr 17, 2025 am 12:08 AM

The core components of Linux include the kernel, file system, shell and common tools. 1. The kernel manages hardware resources and provides basic services. 2. The file system organizes and stores data. 3. Shell is the interface for users to interact with the system. 4. Common tools help complete daily tasks.

Linux: A Look at Its Fundamental StructureApr 16, 2025 am 12:01 AM

The basic structure of Linux includes the kernel, file system, and shell. 1) Kernel management hardware resources and use uname-r to view the version. 2) The EXT4 file system supports large files and logs and is created using mkfs.ext4. 3) Shell provides command line interaction such as Bash, and lists files using ls-l.

Linux Operations: System Administration and MaintenanceApr 15, 2025 am 12:10 AM

The key steps in Linux system management and maintenance include: 1) Master the basic knowledge, such as file system structure and user management; 2) Carry out system monitoring and resource management, use top, htop and other tools; 3) Use system logs to troubleshoot, use journalctl and other tools; 4) Write automated scripts and task scheduling, use cron tools; 5) implement security management and protection, configure firewalls through iptables; 6) Carry out performance optimization and best practices, adjust kernel parameters and develop good habits.

Understanding Linux's Maintenance Mode: The EssentialsApr 14, 2025 am 12:04 AM

Linux maintenance mode is entered by adding init=/bin/bash or single parameters at startup. 1. Enter maintenance mode: Edit the GRUB menu and add startup parameters. 2. Remount the file system to read and write mode: mount-oremount,rw/. 3. Repair the file system: Use the fsck command, such as fsck/dev/sda1. 4. Back up the data and operate with caution to avoid data loss.

How Debian improves Hadoop data processing speedApr 13, 2025 am 11:54 AM

This article discusses how to improve Hadoop data processing efficiency on Debian systems. Optimization strategies cover hardware upgrades, operating system parameter adjustments, Hadoop configuration modifications, and the use of efficient algorithms and tools. 1. Hardware resource strengthening ensures that all nodes have consistent hardware configurations, especially paying attention to CPU, memory and network equipment performance. Choosing high-performance hardware components is essential to improve overall processing speed. 2. Operating system tunes file descriptors and network connections: Modify the /etc/security/limits.conf file to increase the upper limit of file descriptors and network connections allowed to be opened at the same time by the system. JVM parameter adjustment: Adjust in hadoop-env.sh file

How to learn Debian syslogApr 13, 2025 am 11:51 AM

This guide will guide you to learn how to use Syslog in Debian systems. Syslog is a key service in Linux systems for logging system and application log messages. It helps administrators monitor and analyze system activity to quickly identify and resolve problems. 1. Basic knowledge of Syslog The core functions of Syslog include: centrally collecting and managing log messages; supporting multiple log output formats and target locations (such as files or networks); providing real-time log viewing and filtering functions. 2. Install and configure Syslog (using Rsyslog) The Debian system uses Rsyslog by default. You can install it with the following command: sudoaptupdatesud

How to choose Hadoop version in DebianApr 13, 2025 am 11:48 AM

When choosing a Hadoop version suitable for Debian system, the following key factors need to be considered: 1. Stability and long-term support: For users who pursue stability and security, it is recommended to choose a Debian stable version, such as Debian11 (Bullseye). This version has been fully tested and has a support cycle of up to five years, which can ensure the stable operation of the system. 2. Package update speed: If you need to use the latest Hadoop features and features, you can consider Debian's unstable version (Sid). However, it should be noted that unstable versions may have compatibility issues and stability risks. 3. Community support and resources: Debian has huge community support, which can provide rich documentation and

TigerVNC share file method on DebianApr 13, 2025 am 11:45 AM

This article describes how to use TigerVNC to share files on Debian systems. You need to install the TigerVNC server first and then configure it. 1. Install the TigerVNC server and open the terminal. Update the software package list: sudoaptupdate to install TigerVNC server: sudoaptinstalltigervnc-standalone-servertigervnc-common 2. Configure TigerVNC server to set VNC server password: vncpasswd Start VNC server: vncserver:1-localhostno

See all articles