- 博客(9)
- 收藏
- 关注
原创 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 6500
原创 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 7222
原创 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 4086
原创 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 1610
原创 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 11922 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 3110
原创 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 5207 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 1275
原创 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 821
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人