4. PT table checksum to verify master-slave data
4.0 references and installation
4.1. Pt table checksum verification principle
4.2 notes and common parameters
4.2.2 description of common parameters
4.3 best practices
4.4 troubleshooting of common problems
Posted by paran0id Dan on Sun, 23 Feb 2020 02:12:25 -0800
Find out the bank teller's account opening records within half an hour. See if there are 3 or more accounts opened within half an hour.
A table is given, in which is the operation record of a teller. The structure of the table records is as follows:
Cid (customer id)
Ctime (t ...
Posted by davidska on Sat, 22 Feb 2020 23:32:13 -0800
Chapter 3 Using MySQL
Chapter 3 Using MySQL
Understanding databases and tables
Simple Records - MySQL will always - [English]Ben Forta
You'll learn how to connect to and log in to MySQL, how to execute MySQL statements, and how to get information ...
Posted by TravisJRyan on Sat, 22 Feb 2020 18:48:14 -0800
[SQL from bit by bit Analysis series articles] is a bit by bit summary in actual development, from the simplest SQL query to comprehensive analysis query
When analyzing SQL, related operations in mybatis and Hibernate will also be analyzedClick to view details
This section describes inserting data in ...
Posted by Paul1893 on Sat, 22 Feb 2020 09:04:51 -0800
The previous several articles have prepared the database and data, and now they will be developed later. Some of them may be different from others on the Internet. I did it for the first time, and all the functions have been realized. This article is about development, registration and login. First, pas ...
Posted by diex on Sat, 22 Feb 2020 01:25:49 -0800
At present, MHA (Master High Availability) is a relatively mature solution in the aspect of MySQL high availability. In the process of MySQL failover, MHA can automatically complete the database failover operation within 0-30 seconds, and in the process of failover, MHA can guarantee the consistency of data to the greatest extent, so as to ach ...
Posted by KenGR on Fri, 21 Feb 2020 07:39:14 -0800
Author: ye Jinrong, co-founder of zhishutang, and co-founder of 3306pai community
What causes the util and iowait of disk I/O of online database server to keep soaring?
1. Problem description
A friend Xiaoming's online database gave a serious alarm. The business side reported that writing data was blocked all the time. Many locks ro ...
Posted by revaaron on Fri, 21 Feb 2020 05:07:54 -0800
Python crawler learning - crawl the public service platform of construction market supervision
The code is only for learning and communication. Please do not use it for illegal purposes. In case of infringement, please click here Contact author delete
The code is only for learning and communication ...
Posted by Tubby on Wed, 19 Feb 2020 08:16:37 -0800
Basic concepts of Docker
Frequently used commands
Container operation example
Docker mirror image
Docker container data volume
Dockerfile architecture (reserved word instruction)
Example of Docker installing mysql
Push the local image to alicloud
Posted by kanenas.net on Wed, 19 Feb 2020 02:27:08 -0800
Linux system, Apache, Mysql, PHP
Ensure the existing development environment package before installing the configuration
[root@localhost ~]# yum -y install pcre-devel zlib-devel links
Turn off selinux and iptables
[root@localhost ~]# vi /etc/selinux/config # Modify the configuration file and turn ...
Posted by falcon1 on Mon, 17 Feb 2020 22:51:48 -0800