MHA cluster of MySQL highly available articles

1 preparations 1.1 modify host name vim /etc/hosts # Add corresponding host 192.168.28.128 mha1 192.168.28.131 mha2 192.168.28.132 mha3 1.2 turn off the firewall and modify selinux # Turn off firewall systemctl stop firewalldsystemctl  disable firewalld # Turn off self start # Modify selinux vim /etc/sysconfig/selinux SELINUX=disable ...

Posted on Mon, 25 May 2020 11:21:27 -0400 by eliezer

Logging user login information using init_connect parameter

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

Solve 1032 error report of online master-slave replication

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

Delete databases without running away: Explain MySQL data recovery in detail

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

Database optimization - backup and recovery

abstract 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

MySQL Data Recovery Based on gtid and xtrabackup

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

MySQL: A Case of Incremental Data Recovery in Database

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 notes

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