Share the super complete MySQL
Brief introduction of all-around DBA:MySQL (1)
Www.sudo.ren/article/23?...
Installation and basic configuration of Universal DBA:MySQL (2)
Www.sudo.ren/article/24?...
Omnipotent DBA:MySQL Architecture-Model, connection layer, SQL layer detailed explanation (3)
Www.sudo.ren/article/25?...
Universal DBA:MySQL connection, Startup, shutdown and error reporting (4)
Www.sudo.ren/article/26?...
Introduction and use of omnipotent DBA:MySQL configuration file (5)
Www.sudo.ren/article/27?...
Multi-instance configuration of Universal DBA:MySQL (6)
Www.sudo.ren/article/28
Universal DBA:MySQL user Management-user Rights definition (7)
Www.sudo.ren/article/29
Introduction of omnipotent DBA:MySQL interface command, DDL and DML (8)
Www.sudo.ren/article/30
Omnipotent DBA: introduction to Database DQL (9)
Www.sudo.ren/article/31
Omnipotent DBA:MySQL Development Specification (10)
Www.sudo.ren/article/32
Universal DBA: metadata acquisition-information_schema (11)
Www.sudo.ren/article/34
Basic Optimization of all-around DBA:MySQL-Index Management and Design (12)
Www.sudo.ren/article/35
Basic Optimization of all-around DBA:MySQL-explain use (XIII)
Www.sudo.ren/article/36
Introduction and View of all-around DBA:MySQL Storage engine (14)
Www.sudo.ren/article/38
Universal DBA:MySQL- shared tablespaces VS independent tablespaces (15)
Www.sudo.ren/article/39
Versatile DBA:Innodb engine transactions (XVI)
Www.sudo.ren/article/40
Universal DBA:MySQL transaction Log-redo log/undo log (XVII)
Www.sudo.ren/article/42
Introduction to all-purpose DBA:MySQL transaction Lock + isolation level (XVIII)
Www.sudo.ren/article/43
Omnipotent DBA:MySQL Log Management (19)
Www.sudo.ren/article/44
Omnipotent DBA:MySQL Log-Binlog Log Management (20)
Www.sudo.ren/article/45
Omnipotent DBA:MySQL Log-slowlog Log Management (21)
Www.sudo.ren/article/46
Introduction to all-around DBA:MySQL backup and recovery (22)
Www.sudo.ren/article/47
Universal DBA:mysqldump backup parameters (23)
Www.sudo.ren/article/48
All-round DBA:mysqldump+binlog enterprises resume actual combat (24)
Www.sudo.ren/article/49
Introduction of all-around DBA:xtrabackup and full recovery (25)
Www.sudo.ren/article/50
Implementing incremental backup with all-around DBA:xtrabackup (26)
Www.sudo.ren/article/51
The principle mentioned before master-slave replication of omnipotent DBA:MySQL (27)
Www.sudo.ren/article/53
Master-Slave replication Construction of all-round DBA:MySQL (28)
Www.sudo.ren/article/54
Universal DBA:MySQL Master-Slave replication _ failure causes and Solutions (29)
Www.sudo.ren/article/55
Advanced features of master-slave replication of omnipotent DBA:MySQL (30)
Www.sudo.ren/article/56
Introduction to the problems existing in the Master-Slave Environment of all-round DBA:MySQL and the High availability Scheme of Enterprises (31)
Www.sudo.ren/article/57
Introduction to the principle of High availability of all-around DBA:MHA (32)
Www.sudo.ren/article/58
Preparation and Construction of pre-Environment for all-around DBA:MHA (33)
Www.sudo.ren/article/59
Fault Simulation and handover of Universal DBA:MHA configuration (34)
Www.sudo.ren/article/61
Universal DBA:MHA VIP usage and failover process (35)
Www.sudo.ren/article/62
Universal DBA:MHA binlog server configuration use (36)
Www.sudo.ren/article/63
Introduction of omnipotent DBA:Atlas- software and construction of read-write separation (37)
Www.sudo.ren/article/69
Introduction of automatic Meter Distribution function of all-around DBA:Atlas- (38)
Www.sudo.ren/article/70
Omnipotent DBA:MySQL Optimization-detailed explanation of the use of the Optimization tool top (39)
Www.sudo.ren/article/71
Omnipotent DBA:MySQL Optimization-hardware Optimization-system Optimization recommendations (40)
Www.sudo.ren/article/72
Omnipotent DBA:MySQL Optimization-mysqlslap instructions (41)
Www.sudo.ren/article/73
Omnipotent DBA:MySQL Optimization-recommendations for Parameter Optimization (42)
Www.sudo.ren/article/74