MySQL database backup can be divided into logical backup and physical backup. The logical backup tools are mysqldump and the physical backup tools are xtrabackup. The two backup methods have their own advantages and disadvantages
Support hot backup and incremental backup, requ ...
1. mysql user management
In daily use, it is necessary to limit the permissions of personnel, so it is necessary to manage users.
##Create users and authorize
Specify login IP
[root@host ~]# mysql -uroot -p
Welcome to the MySQL monitor.
mysql> grant all on *.* to 'user1'@'127.0.0.1' identified by '123456';
#Create user1 us ...
Posted by pucker22 on Wed, 01 Apr 2020 20:18:42 +0200
1, Connect to database
Do not use database management software (such as Navicat, etc.), connect mysql server through dos, and then operate database
General format for connecting to database: mysql -P port number - h mysql host name or ip address - u user name - p
Explanation: (- P upper case P represe ...
Posted by Michael001 on Thu, 05 Mar 2020 07:45:26 +0100
Article brief introduction
When learning relational database, the database in the textbook uses Oracle relational database, while I use MySQL database for other reasons. From the perspective of database type, both are relational databases, and there is not much difference in data access mode. But afte ...
Posted by Stickdragon on Wed, 12 Feb 2020 12:26:31 +0100
A production environment mysql migration operation (I) data archivingA production environment mysql migration operation (2) mysql space release (defragmentation)
The fixed time archive is added above. Now some large table disk space has not been released, resulting in larger and larger database files. N ...
Posted by dmarquard on Thu, 30 Jan 2020 14:49:56 +0100
Last article This article briefly introduces mysqldump's backup and recovery of database. This article introduces another backup tool xtrabackup. In the era of InnoDB transaction engine flooding, xtrabackup can well support hot backup of database, which is very gratifying,
Xtrabackup is available in the epel source, so you can install it dir ...
Posted by dmort on Tue, 10 Dec 2019 03:14:13 +0100
Master slave configuration
server_id = 100 # Server id. the slave database should be larger than the master database, and be unique
gtid_mode = on #Turn on gtid mode
enforce_gtid_consistency = on #Force gtid consistency. ...
Posted by kenyabob on Sun, 01 Dec 2019 08:02:07 +0100
This article is from community users. Thank you for your technology sharing.
Brief Introduction of Jushan Database Architecture
Jushan database, as a distributed database, is a computing and storage separation architecture, which consists of database instance layer and storage engine layer. Storage engine layer is responsible for database core ...
Posted by lachhekumar on Thu, 22 Aug 2019 06:13:36 +0200
1. Using the cmd command line to perform data backup:
Backup command code format:
Mysqldump-h database server IP-P database uses port number-u account-p password database name > save path
mysqldump -h127.0.0.1 -p3306 -uroot -proot zbsqx>D:\MysqlBackup\20190807.sql
Enter the above c ...
Posted by mgason on Wed, 07 Aug 2019 13:29:17 +0200
You should know that the biggest feature of mysql is master-slave replication compared with other databases, but the version before 5.7 only supports one master-slave replication at most. For some statistical classes, it needs to cross-database. This is a troublesome thing. In the past, only database middleware (mycat, etc.) can do this kind of ...
Posted by steelerman99 on Mon, 17 Jun 2019 02:14:29 +0200