The general principle of mysqldump and the influence of DDL operation in the backup process of mysqldump

The general principle of mysqldump and the influence of DDL operation in the backup process of mysqldumpThe general principle of mysqldumpThe first caseThe second case The general principle of mysqldump and the influence of DDL operation in the backup process of mysqldump MySQL Version: 5.7.18 Isolation level: REPEATABLE-READ If th ...

Posted by kuri7548 on Mon, 17 Jun 2019 16:55:48 -0700

I-team Blog Full Text Retrieval of Elasticsearch Actual

I have always felt the shortcomings of the blog, but recently I found it difficult to find a blog I wrote before when it grew up. As a back-end developer, the owner felt he had enough clothes and clothes to eat, so he had the full-text search function of the blog, Elasticsearch, and thanks to a server sponsored by Phigo. Selection of Full Text ...

Posted by love_php on Sat, 11 May 2019 07:21:54 -0700

How to realize automatic backup and regular backup of mysql database under linux

1. View disk space: Since it is a regular backup, we should choose a disk space with sufficient space to avoid the consequences of backup failure and data loss caused by insufficient space! __________ Storing on the current disk is the simplest, but it is the least recommended; servers have multiple hard disks, it is best to store backups o ...

Posted by misteraven on Thu, 18 Apr 2019 12:39:32 -0700

Linux mysql backup every day

This paper mainly introduces mysqldump and cron command of Linux to realize database backup every day. Mysqldump is often used for logical backup of MySQL database, and cron is the planned task of linux, which is to perform the planned work at the agreed time. 1. Creating shell scripts #!/bin/bash #The database backup path needs to be creat ...

Posted by weiwei on Tue, 16 Apr 2019 12:06:32 -0700

MySQL Master-Slave Replication Practice-Log Point-Based Replication

MySQL Master-Slave Replication Practice-Log Point-Based Replication Log-point-based replication Establishment of special duplicate accounts on master and slave Libraries MariaDB [employees]> create user 'repl'@'172.%' identified by '123456'; Note that passwords in production must be in accordance with the relevant specifications to ...

Posted by ee12csvt on Thu, 11 Apr 2019 11:21:31 -0700

Common script records in mysql

-- select * from information_schema.processlist show processlist; -- View the user link show full processlist; kill id; /** View state Connections, the number of connections attempted to connect to (whether successful or not) MySQL servers. Max_used_connections, the maximum number of connections that have been used concurrently sin ...

Posted by powaz on Mon, 08 Apr 2019 13:30:31 -0700

Solution to connect Mysql prompt Can't connect to local MySQL server through socket

mysql, mysqldump, mysqldump, php connection mysql service often prompts the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) There are generally two reasons for this problem: 1. The mysql service is not functioning properly: Since mysql's socket file is created when m ...

Posted by chrille112 on Tue, 18 Dec 2018 01:30:04 -0800