The industry's most influential MySQL boutique article highlights (300 articles)

MySQL is an associated database management system, and the SQL language is the most commonly used standardized language for accessing databases. The information collected in this document has MySQL database backup and recovery, configuration, solutions, etc., for everyone to read easily.

Blog Special

1 MySQL database backup and recovery http://blog.51cto.com/zt/292

2 Classic SQL Statements Daquan http://blog.51cto.com/zt/206

3 SQL Server Backup and recovery http://blog.51cto.com/zt/258

4 SQL Server 2005 Learning Note http://blog.51cto.com/zt/270

5 SQL SERVR 2008 Spatial Data Application http://blog.51cto.com/zt/188

Recommended posts

1 MySQL5.5 Deployment MHA http://ylw6006.blog.51cto.com/470441/890360

2 MySQL5.5 using bare device storage http://ylw6006.blog.51cto.com/470441/884555

3 MySQL5.5 Configuring Master-slave replication http://ylw6006.blog.51cto.com/470441/888523

4 Automatic monitoring of the master-slave MySQL synchronization shell script http://andrewyu.blog.51cto.com/1604432/666019

5 Do not log in the database to execute MySQL command summary http://oldboy.blog.51cto.com/2561410/632608

6 MySQL5.5 compiled and installed on Linux platform http://ylw6006.blog.51cto.com/470441/883598

7 separate MySQL and storage for dual web load Balancing http://lustlost.blog.51cto.com/2600869/926764

8 MySQL processing mode/Common query/pattern matching http://xiaominghimi.blog.51cto.com/2614927/908928

9 Mytop-mysql Monitoring Tool http://521cto.blog.51cto.com/950229/900339

10 on-line MySQL sync error troubleshooting http://hcymysql.blog.51cto.com/5223301/888007

MySQL database automatic local/offsite dual backup/mysql incremental backup [serial build millions of traffic e-commerce website] http://jimmyli.blog.51cto.com/3190309/888630

Corosync+drbd+pacemaker implementation of the HA cluster of MySQL server-previous http://xjzhujunjie.blog.51cto.com/3582724/886317

COROSYNC+PACEMAKER+DRBD High-availability http://rrliang.blog.51cto.com/4214966/881898 for MySQL

MySQL Master/slave Master/master http://liuping0906.blog.51cto.com/2516248/879877

Win7 Django MySQL installation, problem solving solution http://purplebutterfly.blog.51cto.com/1337285/875910

Details of the master-slave synchronization process in MySQL database (i) http://wanghaipeng1124.blog.51cto.com/2500801/874651

The MyISAM storage engine for MySQL repairs and modifies the maximum file size http://andylhz2009.blog.51cto.com/728703/870640

18 "original" MySQL 5.5 PROXY user disguised users http://yueliangdao0608.blog.51cto.com/397025/867417

MySQL read-write separation Amoeba http://freeze.blog.51cto.com/1846439/860111

MySQL Source: innobase Buffer pool http://whuai.blog.51cto.com/3539000/850673

Lamp series-mysql master-slave copy Practice video explanation (old boy produced) http://oldboy.blog.51cto.com/2561410/839399

The Lamp series-mysql master-slave copy principle Video (old boy produced) http://oldboy.blog.51cto.com/2561410/839383

MySQL master-slave replication, semi-synchronous, primary master replication architecture implementation http://leejia.blog.51cto.com/4356849/831772

MySQL semi-synchronous replication (semi-synchronous Replication) http://hzcsky.blog.51cto.com/1560073/820859

MySQL's MMM high-availability architecture test http://centiliux.blog.51cto.com/1454781/774921

MySQL master-slave model, transmission encryption and dual-master model implementation http://lovvvve.blog.51cto.com/3828397/750467

27 migrations from MySQL to Oracle and backup http://gaotengfei.blog.51cto.com/1019560/752002

MySQL tree copy-blackhole storage engine use http://tanzj.blog.51cto.com/802764/742010

MySQL Database AB replication configuration http://zhaoyun.blog.51cto.com/2090116/733377

30 high disk load to bring MySQL down (please browse in Firefox browser) http://liang3391.blog.51cto.com/178205/796988

31 Handling MySQL Replication failure a case http://linuxguest.blog.51cto.com/195664/718576

Navicat for MySQL (UP)--Create DATABASE and table http://xiaosuncunzhang.blog.51cto.com/317407/680107

Haproxy of MySQL from library cluster scheme http://coralzd.blog.51cto.com/90341/671035

34 seconds to kill MySQL single-bidirectional sync http://skyson.blog.51cto.com/2497647/627833

35 easily build MySQL high-availability cluster system http://ixdba.blog.51cto.com/2895551/583232

mysql-mmm-2.2.1 Installation Manual http://linuxguest.blog.51cto.com/195664/578307

Official Manual of Panax Notoginseng mysql-mmm-2.2.1 (translation) http://linuxguest.blog.51cto.com/195664/578311

http://bobwu.blog.51cto.com/2918362/558161 MySQL implementation of non-program read and write separation

A series of MySQL technology serial Chop-mysql Brief Introduction http://z00w00.blog.51cto.com/515114/556983

40 "MySQL" binlog_direct_non_transactional_updates parameter usage http://tanzj.blog.51cto.com/802764/553869

MYSQL master-slave copy read-write separation implementation http://bobwu.blog.51cto.com/2918362/537077

Mysql-cluster http://2904295.blog.51cto.com/2894295/530292

Master-slave configuration for MySQL database (multi-master-to-one) http://lhflinux.blog.51cto.com/1961662/528940

44 using Mysql_multi to implement a machine running multiple MySQL http://lhflinux.blog.51cto.com/1961662/522869

MySQL Primary master replication http://eguys.blog.51cto.com/2517622/521608

Optimized MySQL database (bottom) high-availability architecture scheme for MySQL database http://andrewyu.blog.51cto.com/1604432/510652

Optimization of MySQL database (above) optimization of single-machine MySQL database http://andrewyu.blog.51cto.com/1604432/509635

InnoDB and MyISAM Performance comparison test for MySQL database http://passover.blog.51cto.com/2431658/507265

49 Specifying a database with Mysqlhotcopy backup http://coralzd.blog.51cto.com/90341/499262

MySQL Chinese garbled, unable to insert Chinese solution summary http://shengtang.blog.51cto.com/1290225/498212

51 Testing MySQL binding variable function http://linuxguest.blog.51cto.com/195664/496888

Slave_io_running:no MySQL master-Slave synchronization error resolution and http://hzcsky.blog.51cto.com/1560073/479476

InnoDB as the default storage engine (starting from mysql-5.5.5) http://wenzhihui.blog.51cto.com/2657380/477238

MySQL 5.1.6 or later dynamically turn on slow query log http://wangxiaoyu.blog.51cto.com/922065/470271

55 very useful MySQL control flow function http://shenlan.blog.51cto.com/55742/440009

MYSQL-MMM installation Error-free version http://badb0y.blog.51cto.com/196368/415806

57 Configuring the MySQL Master-slave replication (Replication) service http://7056824.blog.51cto.com/69854/400642

Replication MySQL (Master and Slave Fundamentals and Configuration) http://linuxme.blog.51cto.com/1850814/383742

What is the length of the varchar definition for MySQL, byte or character http://cau99.blog.51cto.com/1855224/383023

MySQL backup strategy talking about http://chlotte.blog.51cto.com/318402/376294

MySQL Replication Study Notes http://chlotte.blog.51cto.com/318402/370543

http://kushun.blog.51cto.com/78838/353858 MySQL cluster (three node)

MySQL mail Server database backup script http://dengweihua1.blog.51cto.com/134932/349375

64 on MySQL cluster http://asram.blog.51cto.com/1442164/294547

MySQL cluster installation configuration http://hx100.blog.51cto.com/44326/343389

[MySQL FAQ] Series--How to migrate data across time zones http://imysql.blog.51cto.com/1540006/308992

67 Network Database Configuration and application of MySQL (i) http://zenfei.blog.51cto.com/763386/327538

68 skillfully using Mysqld_multi to realize the MySQL replication of multiple master to one slave http://linuxguest.blog.51cto.com/195664/312020

QT MySQL Database programming http://chenboqiang.blog.51cto.com/1068057/342624

MySQL cluster installation configuration http://hx100.blog.51cto.com/44326/343389

+heartbeat MySQL dual-machine hot standby cluster + automatic failover (2 seconds) http://qubaoquan.blog.51cto.com/1246748/293027

72 solve the key-value conflict problem of two-way synchronization of two MySQL databases http://qubaoquan.blog.51cto.com/1246748/292841

73 about MySQL's Limit syntax small optimization! http://yueliangdao0608.blog.51cto.com/397025/304996

[MySQL FAQ] Series--data is not big, backup is very slow http://imysql.blog.51cto.com/1540006/308978

75 Slow Log analysis tool for MySQL http://yueliangdao0608.blog.51cto.com/397025/312602

MySQL is haunted! No password can be logged in http://yahoon.blog.51cto.com/13184/315107

http://wiliiwin.blog.51cto.com/928128/259801 MySQL cluster installation configuration

MySQL5 Date type datetime and timestamp related questions http://lavasoft.blog.51cto.com/62575/280284

MySQL multi-instance run http://sharkyan.blog.51cto.com/536264/271144

80 example Analysis MySQL user login http://5ydycm.blog.51cto.com/115934/253382

Bayi MySQL master-slave replication synchronization problem one of the solutions http://sery.blog.51cto.com/10037/247722

Latin1 Code of MySQL4.1 and Chinese and Tibetan garbled solution http://lavasoft.blog.51cto.com/62575/235274

In-depth study of MySQL5 page query http://lavasoft.blog.51cto.com/62575/40626

MySQL5 LOAD DATA in-depth study http://lavasoft.blog.51cto.com/62575/40168

MySQL and DB2 table SQL differences http://lavasoft.blog.51cto.com/62575/20994

MySQL5 uncompressed version of Windows installation Configuration Application Summary http://lavasoft.blog.51cto.com/62575/20568

Backup and repair of http://cliang.blog.51cto.com/880649/225409 MySQL database

The difference between InnoDB and MyISAM in MySQL is http://yanghw.blog.51cto.com/932743/217311

http://liguxk.blog.51cto.com/129038/213343 MySQL Master-slave main mode configuration

MySQL data backup and mysqldump incremental backup http://colderboy.blog.51cto.com/485582/197614

http://yueliangdao0608.blog.51cto.com/397025/188840 MySQL error Code 28 fix

92 What to save you my MySQL write after Oracle acquires Sun http://verdureorange.blog.51cto.com/632758/152368

93 in MySQL to translate the corresponding line http://yueliangdao0608.blog.51cto.com/397025/151474

94 Logical volume Backup and recovery for MySQL http://yueliangdao0608.blog.51cto.com/397025/149921

95 plan to back up MySQL database http://gzmaster.blog.51cto.com/299556/108896

Automatic backup http://gsliuyang.blog.51cto.com/286500/115144 MySQL database

http://lvsheat.blog.51cto.com/431185/131849 MySQL Source Installation method

98 MySQL Master Master, master-slave replication detailed http://colderboy.blog.51cto.com/485582/107836

Application instance parsing http://yueliangdao0608.blog.51cto.com/397025/92045 of MySQL's CSV engine

100 wrote a MySQL row-to-column stored procedure http://yueliangdao0608.blog.51cto.com/397025/80493

The industry's most influential MySQL boutique article highlights (300 articles)