Database | Zhang Ge Blog

MariaDB Galera Cluster (hereinafter referred to as MGC cluster) is a set of relational storage architecture that realizes multi master, real-time data synchronization and strong consistency on the MySQL innodb storage engine. The business level does not need to do read and write separation, and the database read and write pressure can be distributed to each node according to the established rules, which is fully compatible with MariaDB and MySQL in terms of data

March 16, 2019

Resolve MySQL master slave replication error 1595: Relay log write failure

mysql MySQL master slave replication data base

six thousand six hundred and fifteen nine eleven

First, let me explain the background: I am studying the automated cluster deployment scheme of the Docker based MariaDB Galera Cluster [hereinafter referred to as MGC, and you can consider sharing this scheme later when you have time]. All debugging has been completed, and I want to deploy an MGC cluster in the production environment as the first grayscale test. The main DB version of the production environment is MySQL 5.5. The new MGC uses the latest 10.3.12 stable version of Mariadb, completes the MGC cluster, and imports a complete SQL from the main DBdump

September 20, 2018

MySQL master-slave error reporting solution: Table 'mysql.gtid_slave_pos' doesn't exist

mysql MySQL master slave replication

two thousand one hundred and sixty-two four four

A remote hot standby is performed for an internal database. The hot standby part adopts the galera cluster mode of MariaDB. Then select one of them as the slave slave synchronization between slave and Shenzhen master cluster. The main cluster is the old environment, and the version used is MySQL 5.5.13. Create master slave synchronization MariaDB [(none)]> by using the general method; change master to master_host=\'192.168.1.100\',master_user=\'rpl\',maste...

March 23, 2018

Simple experience sharing of MySQL online DDL modifying table structure

mysql data base

six thousand four hundred and seventy-six sixteen seven

The online DDL is always used to modify the large table of the production environment DBA is a very troublesome problem. This article shares some relevant experience, hoping to be helpful to the students who are still having a headache. Of course, I hope that the god passing by can give some advice if there is a more reliable plan

March 23, 2018

Gh ost: online DDL modifying MySQL table structure tool

mysql data base

four thousand five hundred and forty-three four three

Previously, I shared a tool practice record of pt online schema change online DDL. In the actual use process, I found that many old systems in the department used triggers in large quantities, which made it impossible to use this tool. It's a pity! As a result, many DDL changes have to be made at idle time, such as in the early morning. After consulting my old colleague who is a DBA, he recommended gh ost to me. It is a DDL tool of github open source based on golang language, Gh ost is gitHub, s Online...

February 5, 2017

MySQL command line tool: installation and use of percona toolkit

mysql

one thousand three hundred and three nineteen thirty-four

Introduction: Percona toolkit is derived from Maatkit and Aspersa tools, which are the most famous tools for managing MySQL. Now Maatkit tools are no longer maintained. Please use Percona toolkit! These tools mainly include six categories: development, performance, configuration, monitoring, replication, system, and utility. As an excellent DBA, some of these tools are very useful. If you can master them and apply them flexibly, you will greatly improve your work efficiency. 1、 Introduction to tools percon

July 31, 2016

Python monitoring script for MySQL master-slave, dictionary deadlock, and number of connections

mysql MySQL master slave replication

one thousand one hundred and ninety-five nineteen twenty-seven

Recently, the company's system has added a lot of remote disaster recovery in Tianjin, including remote dual master MySQL. Because the disaster recovery environment is generally only used when there is a major network failure or failure drill, the availability of the disaster recovery system can only be monitored. Many companies do not have complete automated operation and maintenance systems for the Internet, which is a duck driving development model. So, in many cases, you have to write your own script. The more scripts you write, the more likely you are to be confused, scattered and difficult to manage. Therefore, this time I wrote a centralized monitoring script for MySQL, and later new monitoring will be added

May 17, 2016

MySQL error repair record: Table xx is marked as crashed and should be repaired

mysql MySQL startup error

one thousand one hundred and sixty-one eleven thirty-two

After falling asleep last night, I received a QQ message from Brother Song, saying that an error was reported when the Songsong Mall was opened, so I opened the home page address on my mobile phone QQ, and found the following error: MySQL server error report: Array ([0]=> Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT u.user_name, og.goods_nu...

March 29, 2016

Failed to initialize the master info structure

mysql MySQL Field error MySQL master slave replication MySQL startup error

one thousand one hundred and sixty-nine six nine

Early in the morning, I received a MySQL user-defined language alarm: replication interrupt. It seems that the master slave synchronization reported an error. Log in to MySQL, execute show slave status G, and find that save has stopped. Then start slave. The error is reported as follows: ERROR 1201 (HY000): Could not initialize master info structure; m...

January 17, 2015

MySQL error repair: Table xx is marked as crashed and last (automatic?) repair failed

mysql MySQL startup error

one thousand four hundred and sixty-five twenty-two forty-seven

A webmaster found me and said that the database was broken. An error was reported when visiting the website as follows: Error establishing a database connection. After reading the MySQL error log, the error was reported as follows: Error: Table '/ db_name/table_name\' is marked as crashed and last (automatic?) Repair failed is simple. Stop MySQL: ser first

October 14, 2014

Compilation and installation parameters recommended for stand-alone MySQL database optimization

mysql

two thousand nine hundred and eight two nine

MySQL compilation parameters are numerous and complex, which makes novices feel very big. If MySQL is installed in the formal generation environment, there is not enough time to study the meaning of each parameter. I suggest using the compilation parameters collated by Yu Hongchun, which is convenient and efficient! The online installation of MySQL is recommended to adopt the compilation and installation method, so that the performance can be greatly improved. The compilation parameters of the source code package will generate binary code in the Debug mode by default, and the Debug mode will cause a large performance loss to MySQL, so when we compile the product code to be installed, we must not forget

September 28, 2014

Simple installation and basic operation of MongoDB under Linux system

data base

nine hundred and four five one

Mongo DB , NoSql is a very popular non relational database (NoSql) in the IT industry. Its flexible data storage mode is favored by current IT practitioners. Mongo DB well implements the object-oriented idea (OO idea). Every record in Mongo DB is a Document object. The biggest advantage of Mongo DB is that all data persistence operations do not require developers to write SQL statements manually, and CRUD operations can be easily realized by directly calling methods. 1、 Download mongodb