Shulou(Shulou.com)06/03 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.