Programmer Think

brief introduction 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 Backup tools mysqldump xtrabackup advantage 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 Enter password: Welcome to the MySQL monitor. mysql> grant all on *.* to 'user1'@'127.0.0.1' identified by '123456'; #Create user1 us ...

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 ...

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 ...

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 ...

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 ...

Environmental Science mysql-5.7.19 Centos7 master: 192.168.111.64 slave: 192.168.111.66 Master slave configuration master configuration ## GTID 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. ...

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 ...

Backup database 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 ...

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 ...