MySql Galera Cluster install on Debian7,WSREP 总是disconnected

agan 发布于 2014/03/26 15:08
阅读 1K+
收藏 0

在Debian7上安装好Mysql wsrep后,运行mysql后,wsrep总是提示 disconnected

mysql> show status like 'wsrep%';
+--------------------------+----------------------+
| Variable_name            | Value                |
+--------------------------+----------------------+
| wsrep_cluster_conf_id    | 18446744073709551615 |
| wsrep_cluster_size       | 0                    |
| wsrep_cluster_state_uuid |                      |
| wsrep_cluster_status     | Disconnected         |
| wsrep_connected          | OFF                  |
| wsrep_local_bf_aborts    | 0                    |
| wsrep_local_index        | 18446744073709551615 |
| wsrep_provider_name      |                      |
| wsrep_provider_vendor    |                      |
| wsrep_provider_version   |                      |
| wsrep_ready              | ON                   |
+--------------------------+----------------------+
11 rows in set (0.01 sec)


mysql>


查看日志:

Mar 26 02:39:56 debian764 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysq          l
Mar 26 02:39:56 debian764 mysqld_safe: WSREP: Running position recovery with --log_error=/tmp/t          mp.NhCW5hjSAJ
Mar 26 02:39:58 debian764 mysqld_safe: WSREP: Recovered position 00000000-0000-0000-0000-000000          000000:-1
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 [Warning] Using unique option prefix key_buff          er instead of key_buffer_size is deprecated and will be removed in a future release. Please use           the full name instead.
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 [Note] WSREP: wsrep_start_position var submit          ted: '00000000-0000-0000-0000-000000000000:-1'
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 [Warning] Using unique option prefix myisam-r          ecover instead of myisam-recover-options is deprecated and will be removed in a future release.           Please use the full name instead.
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 [Note] Plugin 'FEDERATED' is disabled.
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 InnoDB: The InnoDB memory heap is disabled
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 InnoDB: Mutexes and rw_locks use GCC atomic b          uiltins
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 InnoDB: Compressed tables use zlib 1.2.3.3
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 InnoDB: Using Linux native AIO
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 InnoDB: Initializing buffer pool, size = 128.          0M
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 InnoDB: Completed initialization of buffer po          ol
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58 InnoDB: highest supported file format is Barr          acuda.
Mar 26 02:39:58 debian764 mysqld: 140326  2:39:58  InnoDB: Waiting for the background threads t          o start
Mar 26 02:39:59 debian764 mysqld: 140326  2:39:59 InnoDB: 5.5.34 started; log sequence number 1          595843
Mar 26 02:39:59 debian764 mysqld: 140326  2:39:59 [Note] Server hostname (bind-address): '0.0.0          .0'; port: 3306
Mar 26 02:39:59 debian764 mysqld: 140326  2:39:59 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
Mar 26 02:39:59 debian764 mysqld: 140326  2:39:59 [Note] Server socket created on IP: '0.0.0.0'          .
Mar 26 02:39:59 debian764 mysqld: 140326  2:39:59 [Note] Event Scheduler: Loaded 0 events
Mar 26 02:39:59 debian764 mysqld: 140326  2:39:59 [Note] WSREP: Read nil XID from storage engin          es, skipping position init
Mar 26 02:39:59 debian764 mysqld: 140326  2:39:59 [Note] WSREP: wsrep_load(): loading provider           library 'none'
Mar 26 02:39:59 debian764 mysqld: 140326  2:39:59 [Note] /usr/sbin/mysqld: ready for connection          s.
Mar 26 02:39:59 debian764 mysqld: Version: '5.5.34'  socket: '/var/run/mysqld/mysqld.sock'  por          t: 3306  MySQL Community Server (GPL), wsrep_25.9.r3928
Mar 26 02:41:44 debian764 mpt-statusd: detected non-optimal RAID status
root@debian764:~#



加载中
返回顶部
顶部