MySQL Knowledge point Summary continuous update

Tags: mysql knowledge points Summary

NOTES: Zheng

Start Note time:2014-08-27

Scheduled completion: 2014-09-07

Upload blog time:2014-09-08

-------------------------

Outline:

First, install the MySQL service [completed]

Ii. deploying MySQL Master-slave asynchronous replication [completed]

Iii. deploying MySQL Master and slave semi-synchronous [completed]

Iv. deployment of Primary master replication for MySQL [completed]

V. SSL encryption authentication for MySQL [completed]

Vi. deployment of MySQL high-availability Master Master Architecture [completed]

Vii. deploy MySQL high-availability master/slave architecture [completed]

Viii. online hot backup of MySQL [completed]

1. Innobackupex Online hot backup [completed]

2. Backup policy, full + incremental backup [completed]

Ix. analyzing two data engines for MySQL and testing [completed]

Ten, MySQL optimization

XI. MySQL Replication tool [completed]

12, mysql5.1 and mysql5.6 performance test comparison [completed]

13. mysql Log management

14. Monitor MySQL master-slave synchronization

The following is to be determined ...

Supplemental sections:

Use of mysqldump

Error summary and solution during MySQL work

wailting ...

This article is from the "Zheng" blog, make sure to keep this source http://467754239.blog.51cto.com/4878013/1548094

MySQL Knowledge point Summary continuous update