Programming VIP

Preface: The previous articles introduce the use of DML and DDL statements. This article will mainly describe the commonly used query grammar. In fact, MySQL official website gives many sample databases for your practical query. Below we take the most commonly used employee sample database as the standard, and introduce in detail their commonly ...

1. Set the executed gtid number of 3308 instances as the gtid number at the end of the full backup on that day View the name of the binlog file that ends when the xtrabackup is fully backed up on that day, the pos location point of the binlog, and the Gtid number that ends when the full backup is completed: [root@mgr01 backup]# cat /data/backu ...

1. Driver Manager maintains a driver list Take our familiar Mysql Driver for example: package com.mysql.jdbc; import java.sql.SQLException; public class Driver extends NonRegisteringDriver implements java.sql.Driver { // // Register ourselves with the DriverManager // static { try { java.sql.DriverManager.re ...

1.Spring Configuration Data Source 1.1 Role of Data Source (Connection Pool) Data sources (connection pools) are used to improve program performance, such as Pre-instantiate the data source to initialize part of the connection resources Getting f ...

Configure mysql mainly by calling CMD There are three core steps: 1. Decompress mysql file in specified path by code (nuget gets sharpzipXXX, cross-volume copy writes recursive file copy by itself), and add the bin path of mysql to the path of ...

1. Preface Classes have two main levels, one is the functional level and the other is the implementation level. Functional hierarchy, generally applied to current classes that do not meet diverse business needs, allows subclasses to inherit (spe ...

In earlier versions of MySQL 5.1, the innodb_file_io_threads parameter defaulted to 4, which was unchangeable on linux systems but adjustable on windows systems. The function of this parameter is that InnoDB uses background threads to process the ...

The shell script is multithreaded, which is somewhat difficult to understand because it is implemented with named pipes. Multithreading means that what was originally done by one process is now done by multiple threads. If a process needs 10 hours to complete something, now allocate 10 threads, divide them up, and then do it at the same time, ...

Environmental Science: 192.168.205.37: as MHA server 192.168.205.47: as Master server 192.168.205.57: as Slave1 server192.168.205.67: as Slave2 server Edition: OS: centos 7 1810 with mini install mariadb-server 5.5.60mha4mysql-manager-0.56-0.el6.noarch.rpm mha4mysql-node-0.56-0.el6.noarch.rpm Purpose: MHA uses a program written in perl scrip ...

1. Triggers: In the bank deposit and withdrawal business, each time a user accesses a loan, the system needs to modify the balance of the corresponding account, and it also needs to automatically record this operation (generate transaction details), while the above operation is performed on two tabl ...