Get the App
SLTechnology News&Howtos  ›  Servers  › 

Share the super complete MySQL

Shulou Source: shulou.com Published: 2022-06-03 06:00:53 10月01日 Update

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

Tags: Omnipotent log master-slave management configuration transaction backup fault enterprise principle parameter foundation actual combat suggestion engine data solution environment user space Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno OPPO Reno Linux Shulou Technology MariaDB Huawei