DanBrother的部落格

drop procedure if exists sp_array_test;

DELIMITER //

Extracts, orders, and then prints grants for MySQL user accounts (pt-show-grants)

# Extracts, orders, and then prints grants for MySQL user accounts

MySQL Stored Procedure - Nested Loop Example

DELIMITER $$

Metabase H2 DB Migration to MySQL 5.7

#### On Aurora New MySQL ####################

MySQL 5.7 :  Steps for Upgrading Percona-Toolkit to the Latest Version

pt-online-schema-change --version

MySQL Slave - Skip Replication for A Particular Table

mysql> stop slave sql_thread;

Export Table Data:
mysql -utest_usr -p"xxx"-h127.0.0.1 -P3306 -e "select * from test_usr.test_table where flag = 1" > test_usr.test_table.txt 2>/dev/null

check_table_fragmentation.sql
>>
MySQL > source check_table_fragmentation.sql

There're MySQL global variable settings that will help for improving the speed of SQL apply in slave db.
That would solve the issue of slave lagging.

export dbuser='root'
export socket_file=/tmp/mysql_3360.sock

-- dry-run

MySQL Trigger Example
https://1drv.ms/w/s!AiM4lZDi7mITgZpt7BobprUleWqgHg?e=AuvIpd

MySQL Master High Availability (MHA) Installation and Configuration

MySQL Master-Slave-Slave Replication on Oracle VM VirtualBox.pdf

MySQL Master-Master-Slave Replication on Oracle VM VirtualBox.pdf

Useful MySQL / MariaDB Backup and Restore Tools - mydumper & myloader

☉ Download the latest "mydumper" RPM from the following URL:

--[On Master Node]
--Setting the Replication Master Configuration (/etc/my.cnf)
[mysqld]

1.
[root@mysql-serv ~]# cat <<EOF >> /etc/yum.repos.d/mysql-community.repo
[mysql56-community]

MySQL 5.5 Installation Procedures on Linux:

# rpm -ivh MySQL-server-5.5.27-1.linux2.6.i386.rpm \

The following example allows remote client (192.168.10.10) to connect to MySQL Server.

GRANT ALL ON *.* to root@'192.168.10.10' IDENTIFIED BY 'mypwd';

mysql> select * from information_schema.user_privileges where grantee like '%192.168.10.10%';