Here is an outline of this series , The blog on this page is completely original , It cost the author a lot of effort , If reprinted , Be sure to indicate the original link .

If you think the article is good , Please help me " recommend ", Your support , Can inspire and encourage me to write more enthusiastically . Thank you in advance !

 

To make the list of articles more compact , Small font . If it doesn't look good , Please zoom the page 150%

<>

1.MySQL/MariaDB Grammar and foundation

MySQL Basic grammar : and SQL Server On the differences of grammar
<http://www.cnblogs.com/f-ck-need-u/p/7592501.html>
Data type explanation and storage mechanism <http://www.cnblogs.com/f-ck-need-u/p/7729251.html>( essence )
Built in function <http://www.cnblogs.com/f-ck-need-u/p/7740235.html>
variable <http://www.cnblogs.com/f-ck-need-u/p/8695767.html>
DML(1): Data insertion <http://www.cnblogs.com/f-ck-need-u/p/8907617.html>
DML(2): Data update , delete <http://www.cnblogs.com/f-ck-need-u/p/8912026.html>
Usage of windowing function <http://www.cnblogs.com/f-ck-need-u/p/8945248.html>
Stored procedures and functions <http://www.cnblogs.com/f-ck-need-u/p/8710324.html>
cursor <http://www.cnblogs.com/f-ck-need-u/p/8722244.html>
Process control statement <http://www.cnblogs.com/f-ck-need-u/p/8724063.html>
trigger <http://www.cnblogs.com/f-ck-need-u/p/8870446.html>
Table expression (1): Derived table ( To be added ) <>
Table expression (2):CTE( Common table expression ) <http://www.cnblogs.com/f-ck-need-u/p/8875863.html>
Table expression (3): view <http://www.cnblogs.com/f-ck-need-u/p/8870908.html>


miscellaneous

SQL Statement logic execution (MSSQL/MYSQL/MariaDB)
<http://www.cnblogs.com/f-ck-need-u/p/8656828.html>
Analysis from the perspective of relationship model and set SQL Related grammar ( For MSSQL/MYSQL/MariaDB)
<http://www.cnblogs.com/f-ck-need-u/p/8656828.html>
From the perspective of the disorder of set " order "( For MSSQL/MYSQL/MariaDB)
<http://www.cnblogs.com/f-ck-need-u/p/8718662.html>
MyISAM Storage engine read , Write priority <http://www.cnblogs.com/f-ck-need-u/p/8907252.html>
Can't connect to local MySQL server through socket
<https://www.cnblogs.com/f-ck-need-u/p/9098664.html>
You must reset your password using ALTER USER statement before executing this
statement. <https://www.cnblogs.com/f-ck-need-u/p/9221317.html>


More articles to be continued ...

<>

2.MySQL/MariaDB Management

MySQL,MariaDB Installation and multi instance configuration <http://www.cnblogs.com/f-ck-need-u/p/7590376.html>
User and rights management <http://www.cnblogs.com/f-ck-need-u/p/8994220.html>
lock <http://www.cnblogs.com/f-ck-need-u/p/8995475.html>
Transaction and transaction isolation level <http://www.cnblogs.com/f-ck-need-u/p/8997814.html>
journal ( One ) <http://www.cnblogs.com/f-ck-need-u/p/9001061.html>
journal ( Two ): Transaction log (redo log and undo log)
<http://www.cnblogs.com/f-ck-need-u/p/9010872.html>
Backup and recovery ( One ):mysqldump Tool usage details <http://www.cnblogs.com/f-ck-need-u/p/9013458.html>
Backup and recovery ( Two ): Import , Export table data <http://www.cnblogs.com/f-ck-need-u/p/9013643.html>
Backup and recovery ( Three ):xtrabackup Detailed description of usage and principle <http://www.cnblogs.com/f-ck-need-u/p/9018716.html>
MySQL copy ( One ): Replication theory and configuration of traditional replication <https://www.cnblogs.com/f-ck-need-u/p/9155003.html>
MySQL copy ( Two ): be based on GTID copy <https://www.cnblogs.com/f-ck-need-u/p/9164823.html>
MySQL copy ( Three ): Semisynchronous replication <https://www.cnblogs.com/f-ck-need-u/p/9166452.html>


Database performance test :sysbench would rather <https://www.cnblogs.com/f-ck-need-u/p/9279703.html>

show processlist explain <http://www.cnblogs.com/f-ck-need-u/p/7742153.html>

More articles to be continued ...

<>

3.MySQL colony

MySQL Cluster structure description <https://www.cnblogs.com/f-ck-need-u/p/9278900.html>( Must see )
sharding: A library that everyone can read , Sub table , partition <https://www.cnblogs.com/f-ck-need-u/p/9388407.html>


<>

3.1 MySQL High availability : Group replication ,Galera

MySQL Group copy official manual translation .rar( download )
<https://files.cnblogs.com/files/f-ck-need-u/MySQL_GR.rar>

1.MySQL Highly available group replication (1): Introduction to group replication technology <https://www.cnblogs.com/f-ck-need-u/p/9216828.html>
2.MySQL Highly available group replication (2): Configure group replication for a single master model
<https://www.cnblogs.com/f-ck-need-u/p/9203154.html>
3.MySQL Highly available group replication (3): Configure group replication for multi master models
<https://www.cnblogs.com/f-ck-need-u/p/9215013.html>
4.MySQL Highly available group replication (4): A thorough analysis of group replication theory
<https://www.cnblogs.com/f-ck-need-u/p/9225442.html>
5. translate :MySQL Limitations and limitations of group replication <https://www.cnblogs.com/f-ck-need-u/p/9197442.html>
6. translate : monitor MySQL Group replication <https://www.cnblogs.com/f-ck-need-u/p/9204774.html>

 

MGR Article recommendation :https://sq.163yun.com/blog/article/223220453915172864

1.PXC quick get start : build PXC <https://www.cnblogs.com/f-ck-need-u/p/9364877.html>


<>

3.2 MySQL middleware :ProxySQL

Introduction to middleware :MySQL Router realization MySQL Separation of reading and writing
<https://www.cnblogs.com/f-ck-need-u/p/9276639.html>

ProxySQL Chinese Manual ( Translation of official documents ).rar( download )
<https://files.cnblogs.com/files/f-ck-need-u/ProxySQL_cn.rar>

1.ProxySQL(1): Introduction and installation <https://www.cnblogs.com/f-ck-need-u/p/9278818.html>
2.ProxySQL(2): Separation of reading and writing <https://www.cnblogs.com/f-ck-need-u/p/9278839.html>
3.ProxySQL(3):Admin Management interface <https://www.cnblogs.com/f-ck-need-u/p/9281199.html>
4.ProxySQL(4): Multi tier configuration system <https://www.cnblogs.com/f-ck-need-u/p/9280793.html>
5.ProxySQL(5): thread , Thread pool , Connection pool <https://www.cnblogs.com/f-ck-need-u/p/9281909.html>
6.ProxySQL(6): Manage backend nodes <https://www.cnblogs.com/f-ck-need-u/p/9286922.html>
7.ProxySQL(7): Detailed routing rules <https://www.cnblogs.com/f-ck-need-u/p/9300829.html>
8.ProxySQL(8):SQL Rewriting rules for statements <https://www.cnblogs.com/f-ck-need-u/p/9309760.html>
9.ProxySQL(9): Query cache function <https://www.cnblogs.com/f-ck-need-u/p/9314459.html>
10.ProxySQL(10): Methodology of separation of reading and writing <https://www.cnblogs.com/f-ck-need-u/p/9318558.html>
11.ProxySQL(11): Chain rule ( flagIN and flagOUT )
<https://www.cnblogs.com/f-ck-need-u/p/9350631.html>
12.ProxySQL(12): Prohibit multipathing <https://www.cnblogs.com/f-ck-need-u/p/9372447.html>
13.ProxySQL(13):ProxySQL colony <https://www.cnblogs.com/f-ck-need-u/p/9362822.html>
14.ProxySQL(14):ProxySQL+PXC
<https://www.cnblogs.com/f-ck-need-u/p/9372382.html>
15.ProxySQL(15):ProxySQL+ Group replication
<https://www.cnblogs.com/f-ck-need-u/p/9383126.html>
The next one to be written
16.ProxySQL(16):ProxySQL realization sharding
<https://www.cnblogs.com/f-ck-need-u/p/7586194.html>


<>

4. My translation (39)

MySQL Group copy official manual translation <https://files.cnblogs.com/files/f-ck-need-u/MySQL_GR.rar>
ProxySQL Chinese Manual ( Translation of official documents ) <https://github.com/malongshuai/proxysql/wiki>
MariaDB Official manual translation collection <https://www.cnblogs.com/f-ck-need-u/p/10697909.html>

More articles to be continued ...