About MariaDB.10.5.1 master-slave replication

Note: the demo environment of this blog is based on centos7.2 x86? 64 bit, minimized installation system, and MariaDB.10.5.1 binary installation 1, A brief introduction to the parallel replication mode of slave Library Five modes of slave parallel mode:Five official models Description: Controls what transactions are applied in parallel when us ...

Posted on Wed, 26 Feb 2020 00:43:09 -0500 by majik-sheff

k8s practice 16: using job controller to back up Mysql container pod database

job configuration and easy testing Official documents 1. Brief introduction to job job is also a kind of controller. k8s has two types of controllers. One is service controller, such as deployment, teamonset, replicaset, etc. the other is task controller. job and cronjon are task controller Simple parameters of job spec.template format is th ...

Posted on Fri, 20 Dec 2019 07:21:12 -0500 by kb0000

MySQL - full, incremental backup and recovery

The importance of data backup 1. In the production environment, the safety of data is very important, and any loss of data may have serious consequences 2. Causes of data loss Program errorHuman errorComputer failureDisk failureDisaster and theft Classification of database backup From a physical and logical point of view, backup can be divid ...

Posted on Fri, 13 Dec 2019 08:22:55 -0500 by mammy

Conditional testing of shell and batch creation of user script by shell

Article directory Conditional expression and logical expression Document and directory judgment Case: the wordpress Library in the backup database starts in the early morning every day. If the backup is successful, an email notification will be sent Numerical comparison Case: r disk root '/' usage rate, more than 80% alarms S ...

Posted on Thu, 12 Dec 2019 11:10:10 -0500 by jtgraphic

ubuntu mysql master-slave replication

1. The main service starts log bin # vim /etc/mysql/my.cnf .... server-id = 55 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M ... Restart mysql after modifying mysql configuration # service mysql restart Authorize slave permission mysql > grant repli ...

Posted on Wed, 11 Dec 2019 01:13:28 -0500 by CMC

Two methods of database backup

Database backup is necessary. Generally, mysqldump is used for backup. I have written two backup methods for reference. The first is to use mysqldump and exec function to backup the database. The code is as follows: /** * Subject: php-mysql Realize database backup * User: luokakale * Date: 2018/11/9 * Time: 13:31 */ header('Content-Type: ...

Posted on Sun, 08 Dec 2019 13:46:35 -0500 by BPWheeler

Backup and recovery of Mysql database

The importance of data backup In the production environment, the security of data is very important. Any loss of data may have serious consequencesCauses of data lossProgram errorHuman errorComputer failureDisk failuredisaster Classification of database backup Physical backupCopies of physical files (such as data files, log files, etc.) of ...

Posted on Sun, 24 Nov 2019 14:11:10 -0500 by NikLP

Automatic backup of mysql under freebsd

Communication is very important, the channel of communication is very important. When the team needs to cooperate, it is necessary to find ways to inform other members of the team in the most effective way of what it is doing to avoid unnecessary harm. For example, the following has just happened:There is a test system. The historical task is t ...

Posted on Sat, 02 Nov 2019 07:22:17 -0400 by amyhughes

Introduction to common commands of MySQL basic introduction

Next: MySQL database master slave synchronization process mysql command introduction mysql is a database management command adopt mysql --help To view relevant parameters and instructions mysql --help #mysql database management command Usage: mysql [OPTIONS] [database] #Grammatical format --help #View help d ...

Posted on Tue, 15 Oct 2019 15:50:10 -0400 by jblallement

Backup database for introduction to MySQL database

Last time: MySQL database entry multi-instance configuration When it comes to data, we are nervous. There are many types of data, but the total normalization point, data is very important and very important. Therefore, the daily data backup work has become the focus of the operation and maintenance work. Let's first look at the data in the dat ...

Posted on Sun, 13 Oct 2019 22:05:58 -0400 by skeetley