2017年09月_lwei_998

原创 ERROR 1062 (23000): Duplicate entry '5' for key 'PRIMARY'

现象：MySQL 主从切换后，新的master上写入数据报主键冲突.错误如下：ERROR 1062 (23000): Duplicate entry '5' for key 'PRIMARY'原因:主从切换后只有一张表有问题，其它的表都正常。由于使用了replace into 方式插入导致新插入数据，导致slave上表的AUTO_INCREMENT小于Master。

2017-09-29 15:54:47 6315

原创 Coordinator stopped because there were error(s) in the worker(s).

MySQL5.7 多源复制其中的一个chaannel 报错如下：mysql> select * from performance_schema.replication_applier_status_by_worker where LAST_ERROR_NUMBER>0\G*************************** 1. row *******************

2017-09-25 11:12:23 7159

原创 Can't execute the query because you have a conflicting read lock

mysql> create table t (id int(10) );ERROR 1223 (HY000): Can't execute the query because you have a conflicting read lockmysql> select id,user,host,command,time,state from information_sch

2017-09-19 18:16:54 3978

原创 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

测试环境应用连不上MySQL，怀疑数据库有问题。错误信息如下：SEVERE: Unable to create initial connections of pool.com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failureThe last packet sent suc

2017-09-14 15:09:33 1578

原创 failed executing transaction 'ANONYMOUS' at master

测试MySQL5.6 到MySQL5.7跨版本的多源复制功能，MySQL5.6中(Master)更新mysql.user表时，遇到如下错误：Master1： mysql> delete from mysql.user where user=’master1’; Query OK, 1 row affected (0.00 sec)Slave: mysql>show slave status\

2017-09-14 14:33:00 11688 1

原创 mysqld_safe Can't log to error log and syslog at the same time.

由于安全审计需要，要将mysql的error log 记录到syslog中。mysqld_safe –verbose –help|grep syslog –syslog Log messages to syslog with ‘logger’ –skip-syslog Log messages to error l

2017-09-08 16:33:39 3047

原创 Logstash API Monitor

Logstash 5.0 开始，提供了输出自身进程的指标和状态监控的 API。官方文档： https://www.elastic.co/guide/en/logstash/current/monitoring-logstash.html#monitoringNode Info API https://www.elastic.co/guide/en/logstash/current/node-in

2017-09-06 18:12:13 5146 1

原创 OneProxy6.1.3 读写分离配置

oneproxy基于一主一从的MySQL 读写分离配置步骤环境准备： a. 搭建好MySQL 主从复制环境 b. 下载并安装好oneproxy，并能正常启动oneproxy读写分离配置 1.MySQL Master上建立三个用户 a)metadb用户，创建oneproxy schema的库和表。 create database oneproxy; GRANT SELECT, INSERT

2017-09-05 18:09:51 1235

原创 OneProxy高可用

进程级高可用 /oneproxy/conf/proxy.conf 中增加如下配置 [oneproxy] keepalive = 1ps -ef|grep oneproxy root 25927 1 0 13:59 ? 00:00:00 /opt/oneproxy/bin/oneproxy –defaults-file=/oneproxy/conf/p

2017-09-04 16:24:58 790

lwei_998的专栏