Skip to content

Instantly share code, notes, and snippets.

@borislin

borislin/PXC Node 1

Created July 16, 2015 16:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save borislin/2b09185b1291ae4840dd to your computer and use it in GitHub Desktop.
Save borislin/2b09185b1291ae4840dd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PXC Node 1
Node 1:
my.cnf (owner is mysql)
[CODE]
[mysqld]
datadir=/var/lib/mysql
user=mysql
# Path to Galera library
wsrep_provider=/usr/lib64/libgalera_smm.so
# Cluster connection URL
wsrep_cluster_address=gcomm://10.2.2.42,10.2.2.43,10.2.2.44
# In order for Galera to work correctly binlog format should be ROW
binlog_format=ROW
# MyISAM storage engine has only experimental support
default_storage_engine=InnoDB
# This changes how |InnoDB| autoincrement locks are managed and is a requirement for Galera
innodb_autoinc_lock_mode=2
# Node #1 address
wsrep_node_address=10.2.2.42
# SST method
#wsrep_sst_method=xtrabackup-v2
# Cluster name
wsrep_cluster_name=percona_cluster
# Authentication for SST method
wsrep_sst_auth="sstuser:s3cret"
wsrep_node_name=node1
[/CODE]
The command I run is [CODE] sudo service mysql start --wsrep_cluster_address="gcomm://" [/CODE]
I get "Starting MySQL (Percona XtraDB Cluster). [ OK ]" in the terminal
log file ip-10-2-2-42.err:
[CODE]
150716 15:46:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150716 15:46:59 mysqld_safe Skipping wsrep-recover for 0121eb99-2a36-11e5-a9f8-06450a29fc1c:28 pair
150716 15:46:59 mysqld_safe Assigning 0121eb99-2a36-11e5-a9f8-06450a29fc1c:28 to wsrep_start_position
2015-07-16 15:47:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2015-07-16 15:47:00 0 [Note] /usr/sbin/mysqld (mysqld 5.6.24-72.2-56) starting as process 7352 ...
2015-07-16 15:47:00 7352 [Note] WSREP: Read nil XID from storage engines, skipping position init
2015-07-16 15:47:00 7352 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/libgalera_smm.so'
2015-07-16 15:47:00 7352 [Note] WSREP: wsrep_load(): Galera 3.11(ra0189ab) by Codership Oy <info@codership.com> loaded successfully.
2015-07-16 15:47:00 7352 [Note] WSREP: CRC-32C: using hardware acceleration.
2015-07-16 15:47:00 7352 [Note] WSREP: Found saved state: 0121eb99-2a36-11e5-a9f8-06450a29fc1c:28
2015-07-16 15:47:00 7352 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 10.2.2.42; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; pc.ignore_quorum = false; pc.ignore_sb = false; pc
2015-07-16 15:47:00 7352 [Note] WSREP: Service thread queue flushed.
2015-07-16 15:47:00 7352 [Note] WSREP: Assign initial position for certification: 28, protocol version: -1
2015-07-16 15:47:00 7352 [Note] WSREP: wsrep_sst_grab()
2015-07-16 15:47:00 7352 [Note] WSREP: Start replication
2015-07-16 15:47:00 7352 [Note] WSREP: Setting initial position to 0121eb99-2a36-11e5-a9f8-06450a29fc1c:28
2015-07-16 15:47:00 7352 [Note] WSREP: protonet asio version 0
2015-07-16 15:47:00 7352 [Note] WSREP: Using CRC-32C for message checksums.
2015-07-16 15:47:00 7352 [Note] WSREP: backend: asio
2015-07-16 15:47:00 7352 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)
2015-07-16 15:47:00 7352 [Note] WSREP: restore pc from disk failed
2015-07-16 15:47:00 7352 [Note] WSREP: GMCast version 0
2015-07-16 15:47:00 7352 [Note] WSREP: (e57c227a, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567
2015-07-16 15:47:00 7352 [Note] WSREP: (e57c227a, 'tcp://0.0.0.0:4567') multicast: , ttl: 1
2015-07-16 15:47:00 7352 [Note] WSREP: EVS version 0
2015-07-16 15:47:00 7352 [Note] WSREP: gcomm: connecting to group 'percona_cluster', peer ''
2015-07-16 15:47:00 7352 [Note] WSREP: start_prim is enabled, turn off pc_recovery
2015-07-16 15:47:00 7352 [Note] WSREP: Node e57c227a state prim
2015-07-16 15:47:00 7352 [Note] WSREP: view(view_id(PRIM,e57c227a,1) memb {
e57c227a,0
} joined {
} left {
} partitioned {
})
2015-07-16 15:47:00 7352 [Note] WSREP: save pc into disk
2015-07-16 15:47:00 7352 [Note] WSREP: gcomm: connected
2015-07-16 15:47:00 7352 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636
2015-07-16 15:47:00 7352 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)
2015-07-16 15:47:00 7352 [Note] WSREP: Opened channel 'percona_cluster'
2015-07-16 15:47:00 7352 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1
2015-07-16 15:47:00 7352 [Note] WSREP: Waiting for SST to complete.
2015-07-16 15:47:00 7352 [Note] WSREP: STATE_EXCHANGE: sent state UUID: e57c73b8-2bd1-11e5-8a51-ce28202ce0b9
2015-07-16 15:47:00 7352 [Note] WSREP: STATE EXCHANGE: sent state msg: e57c73b8-2bd1-11e5-8a51-ce28202ce0b9
2015-07-16 15:47:00 7352 [Note] WSREP: STATE EXCHANGE: got state msg: e57c73b8-2bd1-11e5-8a51-ce28202ce0b9 from 0 (node1)
2015-07-16 15:47:00 7352 [Note] WSREP: Quorum results:
version = 3,
component = PRIMARY,
conf_id = 0,
members = 1/1 (joined/total),
act_id = 28,
last_appl. = -1,
protocols = 0/7/3 (gcs/repl/appl),
group UUID = 0121eb99-2a36-11e5-a9f8-06450a29fc1c
2015-07-16 15:47:00 7352 [Note] WSREP: Flow-control interval: [16, 16]
2015-07-16 15:47:00 7352 [Note] WSREP: Restored state OPEN -> JOINED (28)
2015-07-16 15:47:00 7352 [Note] WSREP: Member 0.0 (node1) synced with group.
2015-07-16 15:47:00 7352 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 28)
2015-07-16 15:47:00 7352 [Note] WSREP: New cluster view: global state: 0121eb99-2a36-11e5-a9f8-06450a29fc1c:28, view# 1: Primary, number of nodes: 1, my index: 0, protocol version 3
2015-07-16 15:47:00 7352 [Note] WSREP: SST complete, seqno: 28
2015-07-16 15:47:00 7352 [Note] Plugin 'FEDERATED' is disabled.
2015-07-16 15:47:00 7352 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-07-16 15:47:00 7352 [Note] InnoDB: The InnoDB memory heap is disabled
2015-07-16 15:47:00 7352 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2015-07-16 15:47:00 7352 [Note] InnoDB: Memory barrier is not used
2015-07-16 15:47:00 7352 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-07-16 15:47:00 7352 [Note] InnoDB: Using Linux native AIO
2015-07-16 15:47:00 7352 [Note] InnoDB: Using CPU crc32 instructions
2015-07-16 15:47:00 7352 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-07-16 15:47:00 7352 [Note] InnoDB: Completed initialization of buffer pool
2015-07-16 15:47:00 7352 [Note] InnoDB: Highest supported file format is Barracuda.
2015-07-16 15:47:00 7352 [Note] InnoDB: 128 rollback segment(s) are active.
2015-07-16 15:47:00 7352 [Note] InnoDB: Waiting for purge to start
2015-07-16 15:47:00 7352 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1641490
2015-07-16 15:47:00 7352 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2015-07-16 15:47:00 7352 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2015-07-16 15:47:00 7352 [Note] Server hostname (bind-address): '*'; port: 3306
2015-07-16 15:47:00 7352 [Note] IPv6 is available.
2015-07-16 15:47:00 7352 [Note] - '::' resolves to '::';
2015-07-16 15:47:00 7352 [Note] Server socket created on IP: '::'.
2015-07-16 15:47:00 7352 [Note] Event Scheduler: Loaded 0 events
2015-07-16 15:47:00 7352 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.24-72.2-56' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel72.2, Revision 1, WSREP version 25.11, wsrep_25.11
2015-07-16 15:47:00 7352 [Note] WSREP: Initialized wsrep sidno 1
2015-07-16 15:47:00 7352 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
2015-07-16 15:47:00 7352 [Note] WSREP: REPL Protocols: 7 (3, 2)
2015-07-16 15:47:00 7352 [Note] WSREP: Service thread queue flushed.
2015-07-16 15:47:00 7352 [Note] WSREP: Assign initial position for certification: 28, protocol version: 3
2015-07-16 15:47:00 7352 [Note] WSREP: Service thread queue flushed.
2015-07-16 15:47:00 7352 [Note] WSREP: Synchronized with group, ready for connections
2015-07-16 15:47:00 7352 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
[/CODE]
After I typed "sudo mysql" and then "show status like 'wsrep%';", I get the following message:
[CODE]
+------------------------------+--------------------------------------+
| Variable_name | Value |
+------------------------------+--------------------------------------+
| wsrep_local_state_uuid | 0121eb99-2a36-11e5-a9f8-06450a29fc1c |
| wsrep_protocol_version | 7 |
| wsrep_last_committed | 28 |
| wsrep_replicated | 0 |
| wsrep_replicated_bytes | 0 |
| wsrep_repl_keys | 0 |
| wsrep_repl_keys_bytes | 0 |
| wsrep_repl_data_bytes | 0 |
| wsrep_repl_other_bytes | 0 |
| wsrep_received | 2 |
| wsrep_received_bytes | 138 |
| 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 |
| wsrep_local_send_queue_avg | 0.000000 |
| wsrep_local_recv_queue | 0 |
| wsrep_local_recv_queue_max | 1 |
| wsrep_local_recv_queue_min | 0 |
| wsrep_local_recv_queue_avg | 0.000000 |
| wsrep_local_cached_downto | 0 |
| wsrep_flow_control_paused_ns | 0 |
| wsrep_flow_control_paused | 0.000000 |
| wsrep_flow_control_sent | 0 |
| wsrep_flow_control_recv | 0 |
| wsrep_cert_deps_distance | 0.000000 |
| wsrep_apply_oooe | 0.000000 |
| wsrep_apply_oool | 0.000000 |
| wsrep_apply_window | 0.000000 |
| wsrep_commit_oooe | 0.000000 |
| wsrep_commit_oool | 0.000000 |
| wsrep_commit_window | 0.000000 |
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_cert_index_size | 0 |
| wsrep_cert_bucket_count | 22 |
| wsrep_gcache_pool_size | 131072 |
| wsrep_causal_reads | 0 |
| wsrep_cert_interval | 0.000000 |
| wsrep_incoming_addresses | 10.2.2.42:3306 |
| wsrep_evs_delayed | |
| wsrep_evs_evict_list | |
| wsrep_evs_repl_latency | 0/0/0/0/0 |
| wsrep_evs_state | OPERATIONAL |
| wsrep_gcomm_uuid | e57c227a-2bd1-11e5-ab1b-7eb0864f38e7 |
| wsrep_cluster_conf_id | 1 |
| wsrep_cluster_size | 1 |
| wsrep_cluster_state_uuid | 0121eb99-2a36-11e5-a9f8-06450a29fc1c |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
| wsrep_local_bf_aborts | 0 |
| wsrep_local_index | 0 |
| wsrep_provider_name | Galera |
| wsrep_provider_vendor | Codership Oy <info@codership.com> |
| wsrep_provider_version | 3.11(ra0189ab) |
| wsrep_ready | ON |
+------------------------------+--------------------------------------+
58 rows in set (0.00 sec)
[/CODE]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment