Today I bring you links to my technical articles collection and conclude with mysql. Let’s start with a few casual things about mysql recently:

(1) I had an innovative project in my last home. The mysql cluster WAS built by myself, which was a simple version of high availability solution. The construction method was shared before, and the link was: Build a high availability mysql cluster.

(2) HALF a year ago, I started to watch “mysql Actual Combat 45 lecture” by Alibaba-Dinqi teacher. I just finished the tutorial, which is really refreshing. Lecture 12 and 39, “Why does my MySQL tremble?” and “Why is the increment primary key not continuous?” these two articles impressed me the most, because they answered two questions THAT I had been thinking about but did not understand. Great! I will do it again when I have time.

(3) not long ago encountered zero width space in mysql storage strange problem, after a bit of trouble to know, utF8 encoding zero width space support is not friendly, with UTF8MB4 words can completely support, remark.

List of articles:

Part One

  • Create a New Rails project using MySql as the database
  • Sina Weibo, Tencent Weibo mysql database main table conjecture
  • How to enable remote access to the MySQL database in Linux
  • Mysql master-slave synchronization (unidirectional and bidirectional)
  • Ubuntu 18.04 Install the MySQL8.0 database
  • mysql – Syntax error or access violation: 1055 Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column
  • MySql(30)—— Install mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz(centos)
  • Understand Mysql locks in depth
  • Mysql high concurrency optimization
  • Mysql implements random queries
  • MySQL database design summary
  • MySQL > update MySQL > update MySQL > update MySQL
  • Redo log and undo log
  • Django. Core. Exceptions. ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; You have 0.9.2
  • MySQL Database interview question (2020 latest edition)
  • MySQL purge thread
  • MySQL 5.7 Semi-synchronous replication technology
  • MySQL semi-synchronous replication mode description and configuration example
  • MySQL database interview questions
  • MySQL uses Procedure analyse() functions to optimize table structures
  • The introduction of Mysql database optimization tool PROCEDURE ANALYSE
  • Optimize table structure
  • Mysqldump parameter description
  • Mysql index Create index, modify index, delete index command statement
  • MySQL performance optimization (6) : partition
  • MySQL prefix index and index selectivity

Part Two

  • MySQL large table drop solution
  • Innodb mysql quick drop 2T large table method example
  • Mysql nested transaction in laravel project
  • Run the mysqladmin flush-hosts method for the mysql database
  • MyCat implements read and write separation of MySQL dual primary and secondary
  • Mysql primary/secondary replication and read/write separation
  • MySQL Router 8
  • MySQL Router 8.0 installation and description
  • Mycat core configuration (schema.xml configuration)
  • MySQL Router is used to implement high availability, load balancing, and read/write separation
  • Use MyCat to separate MySQL reads and writes
  • Mysql – Maxscale for read/write separation and load Balancing
  • Mysql2docx automatically generates database documentation
  • Mysql group replication with multiple master mode (full synchronization)
  • Full synchronous replication of mysql
  • MySQL High availability group replication (4) : A detailed analysis of group replication theory
  • Mysql semi-synchronous replication, group replication, full synchronization mechanism
  • How can I solve the problem that the primary/secondary replication delay of MySQL databases is too long
  • The cause and solution of primary/secondary synchronization delay in MySQL
  • MySQL8.0 create a database and authorize users
  • MySQL storage engine InnoDB and MyISAM difference and basic details
  • Zabbix — Monitors MySQL primary/secondary status
  • Zabbix monitors mysql master/slave status and alarms
  • 1209 – The MySQL server is running with the –read-only option so it cannot execute this statement
  • MySQL 8 — Group replication installation and deployment
  • MySQL :: MySQL 8.0 Reference Manual :: 18.8 Group Replication System Variables
  • Mysql keepalive+ mysql high availability
  • Limitations and limitations of using MySQL group replication
  • MySQL_Cluster_DataSheet_v3.doc
  • MySql (16) : MySql Cluster

Part Three

  • MySQL semi-synchronous replication
  • Mysql series (4) Asynchronous replication, full synchronous replication, and semi-synchronous replication
  • MySQL 5.7 Test results performance whitepaper
  • MySQL crash-safe
  • MySQL :: MySQL Internals Manual :: 10.9 Date and Time Data Type Representation
  • Mysql force index and ignore index
  • The prefix index
  • Transaction nesting solution
  • These 8 often overlooked SQL errors have you ever stepped on the pit
  • Differences between MyISAM and InnoDB (9 differences)
  • To write good Join statements, you need to know this
  • Calculate the distance between latitude and longitude and sort SQL statements
  • What is index push down
  • Mycat configuration and usage details
  • Mycat configuration file server.xml
  • MyCat configuration file: server.xml
  • Json at main · MyCATApache/Mycat2
  • Configure schema · MyCATApache/Mycat2 Wiki
  • MVCC multi-version concurrency control
  • The savepoint principle

Mysql article: github.com/mysticzhong…