Tag Archives: MySQL

案例：推进GTID解决MySQL主主不同步问题

Posted on July 2, 2020 by Alfred Zhao

之前文章介绍过MySQL修改lower_case_table_names参数，如果之前大写存储的表将无法识别，需要特殊处理。
最近遇到一例应用开发人员在修改这个参数之后，为了清除之前大写存储的表，做了误操作，导致主主不同步。 Continue reading →

Posted in MySQL故障处理 | Tagged , | Comments Off on 案例：推进GTID解决MySQL主主不同步问题

小知识：MySQL配置文件优先级

Posted on June 22, 2020 by Alfred Zhao

今天在RHEL7上，严格按之前的安装规范文档，部署MySQL环境时，发现通过服务的方式启动MySQL失败： Continue reading →

Posted in MySQL安装部署 | Tagged , , | Comments Off on 小知识：MySQL配置文件优先级

MySQL主主+Keepalived架构安装部署

Posted on May 18, 2020 by Alfred Zhao

根据当前客户的生产环境，模拟安装部署一套MySQL主主+Keepalived架构的测试环境，方便后续自己做一些功能性的测试。 Continue reading →

Posted in MySQL安装部署 | Tagged , , | Comments Off on MySQL主主+Keepalived架构安装部署

MySQL多实例安装（相同版本）

Posted on January 31, 2020 by Alfred Zhao

本文以MySQL5.7为例，介绍在同一台机器下如何安装多个MySQL实例。 Continue reading →

Posted in MySQL安装部署 | Tagged , | Comments Off on MySQL多实例安装（相同版本）

MySQL入门04-MySQL主从配置

Posted on June 14, 2016 by Alfred Zhao

MySQL主从配置.. Continue reading →

Posted in MySQL安装部署 | Tagged | Comments Off on MySQL入门04-MySQL主从配置

MySQL入门03-MySQL配置安全性、易用性

Posted on June 13, 2016 by Alfred Zhao

MySQL配置安全性、易用性.. Continue reading →

Posted in MySQL安装部署 | Tagged | Comments Off on MySQL入门03-MySQL配置安全性、易用性

MySQL入门02-MySQL二进制版本快速部署

Posted on June 1, 2016 by Alfred Zhao

在上篇文章 MySQL入门01-MySQL源码安装 中，我们介绍了MySQL源码安装的方法。源码安装虽然有着更加灵活和更加优化等诸多优势。 Continue reading →

Posted in MySQL安装部署 | Tagged , | Comments Off on MySQL入门02-MySQL二进制版本快速部署

MySQL入门01-MySQL源码安装

Posted on May 23, 2016 by Alfred Zhao

MySQL源码安装，操作系统：CentOS 6.7，MySQL版本：5.6.30。 Continue reading →

Posted in MySQL安装部署 | Tagged , | Comments Off on MySQL入门01-MySQL源码安装