1.1 modify host name
# Add corresponding host
1.2 turn off the firewall and modify selinux
# Turn off firewall
systemctl stop firewalldsystemctl disable firewalld # Turn off self start
# Modify selinux
Posted on Mon, 25 May 2020 11:21:27 -0400 by eliezer
Note: The content of the article originated from the Internet and was based on our own experiments; however, the address of the reference article was not recorded at that time. If you find any infringement problems, please leave a message.
~Special Reminder: If concurrency is high, this may affect performance and should be fully evaluated bef ...
Posted on Thu, 07 May 2020 16:15:58 -0400 by sparshdharam
The reason for the error is that the master database service is restarted abnormally, which causes the slave database replication to report 1032 errors
In other cases, the slave does not limit the read-only permission. When the development or operation and maintenance personnel mistakenly delete the data on the slave database, which results in ...
Posted on Wed, 06 May 2020 10:09:24 -0400 by maxpup979
Links to the original text: segmentfault.com/a/1190000020116271
In our daily work, there will always be some erroneous deletion of database tables and data caused by hand shaking, wrong writing conditions, wrong table names, wrong con ...
Posted on Fri, 06 Sep 2019 01:25:52 -0400 by spiceydog
This article is the fifth in a series of articles on database optimization: "Database optimization - backup and recovery"
See more articles
Database optimization: http://blog.csdn.net/leyounger/article/details/70157087
Backup and Recovery
1. Backup/Recovery Strategy
For a DBA, it is very important to customi ...
Posted on Fri, 28 Jun 2019 16:11:31 -0400 by Sera
Abstract: By creating a new slave library by backing up the file and running the binlog to the specified gtid location, the data can be restored to the specified time point.
First, the introduction of gtid characteristics:
GTID(global transaction identifier) is MySQL 5.6 The new feature, which can uniquely identify a transaction, consists ...
Posted on Sat, 15 Jun 2019 21:22:44 -0400 by froggie81
For reprint, please indicate the source: http://blog.csdn.net/l1028386804/article/details/60326337
I. Use scenarios
MySQL database is fully automated at 0:00 a.m. per day
At 9 a.m. one day, Zhang San accidentally drop ped a database.
We need full data files and incremental binlog files for data recovery
2. Main Ideas and Principles
Find o ...
Posted on Wed, 10 Apr 2019 22:30:31 -0400 by ignace
MySQL binlog The log file records all the modification operations of the database tables. This article briefly collates MySQL binlog related knowledge, and how to use binlog to restore or flash back database data.
Bilog in STATEMENT format
To open binlog, you need to pass in when you start MySQL-- log-bin Parameters. Or you can set log_bin to o ...
Posted on Sun, 03 Feb 2019 14:00:17 -0500 by Michdd