mysql galera recently in learning, but in the process of start out some mistakes, please the great god
System version: centos6.4 x86_64
Linux kernel version: node1 2.6.32-431. El6. X86_64 # 1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux
IP address:
Node1:192.168.2.155
2:192.168.2.164
Node3:192.168.2.148
Three host has been done for mutual SSH secret login free
Installation:
Mysql version: mysql - 5.5.37 _wsrep_25. 10 - Linux - x86_64. Tar. Gz
Galera version: galera 25.3.18-1. The rhel6. El6. X86_64. RPM
Installation is successful, mysql master configuration file content (three hosts the main configuration file out of the node name, IP address, wsrep_cluster_address different outside the rest are all the same) :
[client]
Port=3306
Socket=/var/lib/mysql/mysql. The sock
[mysqld_safe]
The log - error=/var/log/mysqld. Log
Pid - file=/var/run/mysqld/mysqld. Pid
[mysqld]
Wsrep_provider=/usr/lib64/galera libgalera_smm. So
Wsrep_provider_options="gcache. Size=300 m; Gcache. Page_size=300 m "
Wsrep_cluster_name="test"
Wsrep_cluster_address="gcomm://"
# wsrep_cluster_address="gcomm://node1, 2, node3"
Wsrep_node_name=node1
Wsrep_node_address="192.168.2.155"
Wsrep_sst_method=rsync
Port=3306
Socket=/var/lib/mysql/mysql. The sock
User=mysql
Basedir=/usr/local/mysql
Datadir=/usr/local/mysql/data
Default_storage_engine=InnoDB
# innodb_buffer_pool_size=1 g
# innodb_log_file_size=256 m
Innodb_autoinc_lock_mode=2
Innodb_locks_unsafe_for_binlog=1
Innodb_flush_log_at_trx_commit=0
Innodb_doublewrite=0
Innodb_file_per_table=1
Binlog_format=ROW
The log - bin=mysql - bin
Server - id=101
Relay - log=mysql - relay - bin
# read_only=1
The log - slave - updates=1
to start the first node success, (startup wsrep_cluster_address="gcomm://") listen on port:
/root @ node1 ~ # netstat anpt | grep mysql
TCP 0 0 0.0.0.0:4567 0.0.0.0: * LISTEN 1824/mysqld
TCP 0 0 0.0.0.0:3306 0.0.0.0: * LISTEN 1824/mysqld
mysql database to view the information (in fact the things I can not understand) :
Mysql> Show status like "wsrep %";
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
Value | | Variable_name |
+ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- - + -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- +
| wsrep_local_state_uuid | bb - 506029 a719 e6 - bcaf - 4-11 f90af8c4c28 |
7 | | wsrep_protocol_version |
| | wsrep_last_committed | 1
| | wsrep_replicated | 1
286 | | wsrep_replicated_bytes |
| | wsrep_repl_keys | 1
31 | | wsrep_repl_keys_bytes |
191 | | wsrep_repl_data_bytes |
| | wsrep_repl_other_bytes | 0
6 | | wsrep_received |
818 | | wsrep_received_bytes |
| | wsrep_local_commits | 0
| | wsrep_local_cert_failures | 0
| | wsrep_local_replays | 0
| | wsrep_local_send_queue | 0
| | wsrep_local_send_queue_max | 1
| | wsrep_local_send_queue_min | 0
0.000000 | | wsrep_local_send_queue_avg |
| | wsrep_local_recv_queue | 0
| | wsrep_local_recv_queue_max | 1
| | wsrep_local_recv_queue_min | 0
0.000000 | | wsrep_local_recv_queue_avg |
| | wsrep_local_cached_downto | 1
| | wsrep_flow_control_paused_ns | 0
0.000000 | | wsrep_flow_control_paused |
| | wsrep_flow_control_sent | 0
| | wsrep_flow_control_recv | 0
1.000000 | | wsrep_cert_deps_distance |
0.000000 | | wsrep_apply_oooe |
0.000000 | | wsrep_apply_oool |
1.000000 | | wsrep_apply_window |
0.000000 | | wsrep_commit_oooe |
0.000000 | | wsrep_commit_oool |
1.000000 | | wsrep_commit_window |
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull
