msyql 月影笔记本

CentOS7 下的mysql安装与配置
https://www.cnblogs.com/chxuyuan/p/7707392.html

# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
# rpm -ivh mysql-community-release-el7-5.noarch.rpm
# yum install mysql-community-server

使用 mysqlbinlog 分析binlog 日志的方法

mysqlbinlog --start-datetime="2017-07-05 13:40:00" --stop-datetime="2017-07-05 15:00:00" --base64-output=decode-rows -v  mysql-bin.000128 > oms-mysql-bin2017-07-05.log

主从不同步的方法

配上 master_auto_position=1 可以跳过同步，有两个线程io线程和sql线程

• 要么备份主库，然后在从库恢复一遍
• 要么用 pt-table-checksum 和 pt-table-sync 做数据校验

安全登入mysql server之Login Paths
https://blog.csdn.net/jolly10/article/details/80826514

AIWALY mysql生产标准备份脚本
https://note.aiwaly.com/note/5caafe1bb6004605cd000201

Question处理

一个真实的现网mySql死锁问题处理
https://mp.weixin.qq.com/s/rLdHuwEb7gKjgpbsh1ioSA

SQLPad

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Presto, Pinot, Drill, SAP HANA, Snowflake, BigQuery, SQLite, and many others via ODBC.
http://rickbergfalk.github.io/sqlpad/#/