脚踏实地、勇往直前!
全部博文(1005)
发布时间:2017-06-20 22:03:14
搭建了mariadb galera集群后,整个集群停掉后如何启动呢,我们要先启动那个节点呢,今天我尝试把集群机器全部停掉,然后任意启动一个节点,发现报如下的错误:170620 21:32:55 [ERROR] WSREP: It may not be safe to bootstrap the cluster from this node. It was not the last one to leave the cluster and may not c.........【阅读全文】
发布时间:2017-06-09 16:58:43
在5.7以前的版本,我们通常通过innodb_locks,innodb_trx,innodb_table_waits,show processlist,show engine innodb status这些系统视图和命令进行排查,5.7之后,安装之后多了一个sys的数据库,这个数据库下的x$session系统会对排查表锁提供了很大帮助,如下显示系统当前的会话信息,关键的几个信息:thd_id : 线程.........【阅读全文】
发布时间:2017-06-01 14:57:57
1.解压缩并创建相应目录[root@izwz9gxsbwybwg9n5xdi47z opt]# tar -zxvf mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz[root@izwz9gxsbwybwg9n5xdi47z opt]# mv mysql-5.7.18-linux-glibc2.5-x86_64 mysql5718[root@izwz9gxsbwybwg9n5xdi47z opt]# cd mysql5718[root@izwz9gxsbwybwg9n5xdi47z mysql5718]# mkdir db1[roo.........【阅读全文】
发布时间:2017-05-31 22:26:15
错误信息:2017-05-31T14:14:07.001316Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.2017-05-31T14:14:07.001451Z 0 [ERROR] SSL error: Unable to get private key from 'server-key.pem'2017-05-31T14:14:07.001463Z 0 [Warning] Failed.........【阅读全文】
发布时间:2017-05-31 19:03:10
问题:2017-05-31T10:31:05.945111Z 0 [Note] InnoDB: Need to create a new innodb_system data file 'ibdata2'.2017-05-31T10:31:05.945126Z 0 [Note] InnoDB: Need to create a new innodb_system data file 'ibdata3'.2017-05-31T10:31:05.945131Z 0 [Note] InnoDB: Need to create a new innodb_system data file 'i.........【阅读全文】