MYSQL

[Upgrade] MySQL database upgrade to 8.x version tips

December 6, 2021 MYSQL, software, system No comments

Recently we upgrade our database cluster to version 8.x .

Read this PDF to get some  experience    MySQL_8.x_upgrade[……]

Read more

[Archiving] Antdeck Platform for MySQL

March 5, 2020 Architect, backup, MYSQL, rdbms, storage, system No comments

We use Antdeck paltform to do mysql data archiving jobs. This platform was developed by ruzuojun . He is also the author of  Lepus 

Read this pdf [……]

Read more

online-schema-change tool ddl problem

October 24, 2018 Internals, MYSQL, rdbms No comments

On our job schedule system. Using osc-tool cause deadlock problem.
We investigated the root cause in detail and published this PDF doc.

OSC_DDL_PR[……]

Read more

Donkey System

January 18, 2018 Architect, Architecture, linux, MYSQL, software, system No comments

Donkey system is a fully automatic MySQL database change system.
It gives a great help both to the release of the business and the company’s automate[……]

Read more

Logcenter Project architect

August 16, 2017 Architect, Architecture, bigdata, hadoop, hive, network, NoSQL, rdbms No comments

We created a project called LC (log center) for ops department
All member of ops are using this system for analyzing in a lower layer.
We collects[……]

Read more

MySQL special character rollback

August 16, 2017 Architect, Internals, MYSQL, replication No comments

Actually, Mysqlbinlog tools can’t miner mysql binlog exactly correct.

In this post ,a special environment we got may hexadecimal characters what we[……]

Read more

[JKDB] BACKUP AND RESTORE

May 11, 2017 Architect, backup, hardware, IDC, maintain, MYSQL, rdbms, replication, system No comments

JKDB PLATFORM – our company’s data management platform

In this post, we introduce backup-restore module,focus on automatic backup and restore in a[……]

Read more

Donkey – system for MySQL automatic maintenance

February 17, 2017 Architect, Architecture, maintain, MYSQL, system No comments

We build this system based on Inception (Qunar)。

All of MySQL DDL/DML operations are based on Donkey system, with strict approval process to keep o[……]

Read more

TCP Trace

September 21, 2016 Architecture, MYSQL, redis, system No comments

I found a useful tool named sniffer to help us analyze network packages (this tool can capture packages on specific port)

I use sniffer to analyze[……]

Read more

MySQL TCPCOPY

June 29, 2016 Architect, Architecture, hardware, MYSQL, network No comments

we use tcpcopy to make real traffic on our core systems. Many problems will be found in advance if we enlarge queries several times.

Read this PDF[……]

Read more