About MySQL 5.7 enabling bin log master-slave replication
Master-slave replication: generally used for real-time backup.
The next steps are as follows: master master database configuration synchronization, slave database configuration synchronization, master lock table / backup, slave data recovery, slave synchronization enabled, master unlocking, and completion.
##################### mysql5.7 bin-lo ...
Posted by croix on Tue, 31 Dec 2019 18:38:36 +0100
JAVA calls the console to implement MYSQL incremental backup and recovery (mysqlbinlog)
Knowledge background
Background reference website: https://www.cnblogs.com/luoyx/p/5896419.html (I'll copy it below if I have time)
Open MySQL binlog
Barbara
Full backup and recovery in dump mode
Barbara
Incremental backup and recovery using binlog
Barbara
JAVA implementation
Realize f ...
Posted by Omri16 on Fri, 25 Oct 2019 18:42:46 +0200
Restore MySQL data to data before the table was deleted by mistake
1. Demonstration environment description:
System CentOS Linux release 7.2.1511 (Core) X_86 64-bit minimal installationThe mysql version is the official binary version 5.7.22-22. mysql is a binary installation. Open two mysql instances on a single machine, open the timer event_scheduler=ON for the mysql instances, and open Gtid for both mysql i ...
Posted by sgs on Sat, 17 Aug 2019 06:14:56 +0200
[MYSQL] MHA Building Process
Environmental Introduction
IP
role
172.16.20.105
master
172.16.20.106
slave1(manage)
172.16.20.107
slave2
Install mysql
Download the mha installation package
https://code.google.com/archive/p/mysql-master-ha/downloads?page=1
mha installation
## Install dependency packages (all nodes ...
Posted by imawake on Tue, 30 Jul 2019 21:05:48 +0200
Some characteristics of mariadb (<=10.4)
Recently, I read MariaDB's official website to introduce MariaDB's functions and characteristics, and outlined a few places that I feel it necessary to understand:
Supporting column-level compression
CREATE TABLE `cmp2` (
`id` bigint(20) NOT NULL,
`name` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`));
https://mariadb.com/kb/en/library/storag ...
Posted by Crystal Dragon on Sat, 11 May 2019 22:26:21 +0200