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
Background reference website: https://www.cnblogs.com/luoyx/p/5896419.html (I'll copy it below if I have time)
Open MySQL binlog
Full backup and recovery in dump mode
Incremental backup and recovery using binlog
Realize f ...
Posted by Omri16 on Fri, 25 Oct 2019 18:42:46 +0200
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
Download the mha installation package
## Install dependency packages (all nodes ...
Posted by imawake on Tue, 30 Jul 2019 21:05:48 +0200
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`));
Posted by Crystal Dragon on Sat, 11 May 2019 22:26:21 +0200