Last active
August 29, 2015 14:25
-
-
Save borislin/a2894851b8102e13e798 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Node 2: | |
| 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 #2 address | |
| wsrep_node_address=10.2.2.43 | |
| # 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=node2 | |
| [/CODE] | |
| The command I run is [CODE] sudo service mysql start [/CODE] | |
| I get "Stale sst_in_progress file in datadir | |
| Starting MySQL (Percona XtraDB Cluster)State transfer in progress, setting sleep higher | |
| . [ OK ]" in the terminal | |
| log file ip-10-2-2-43.err: | |
| [CODE] | |
| 150716 15:44:53 mysqld_safe mysqld from pid file /var/lib/mysql/ip-10-2-2-43.pid ended | |
| 150716 15:47:08 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql | |
| 150716 15:47:08 mysqld_safe WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery.fNkTQi' --pid-file='/var/lib/mysql/ip-10-2-2-43-recover.pid' | |
| 2015-07-16 15:47:08 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:08 0 [Note] /usr/sbin/mysqld (mysqld 5.6.24-72.2-56) starting as process 6077 ... | |
| 150716 15:47:11 mysqld_safe WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1 | |
| Log of wsrep recovery (--wsrep-recover): | |
| 2015-07-16 15:47:08 6077 [Note] Plugin 'FEDERATED' is disabled. | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Using atomics to ref count buffer pool pages | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: The InnoDB memory heap is disabled | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Memory barrier is not used | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Compressed tables use zlib 1.2.3 | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Using Linux native AIO | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Using CPU crc32 instructions | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Initializing buffer pool, size = 128.0M | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Completed initialization of buffer pool | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Highest supported file format is Barracuda. | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: 128 rollback segment(s) are active. | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Waiting for purge to start | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1627027 | |
| 2015-07-16 15:47:08 6077 [Warning] InnoDB: Skipping buffer pool dump/restore during wsrep recovery. | |
| 2015-07-16 15:47:08 6077 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work. | |
| 2015-07-16 15:47:08 6077 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work. | |
| 2015-07-16 15:47:08 6077 [Note] Server hostname (bind-address): '*'; port: 3306 | |
| 2015-07-16 15:47:08 6077 [Note] IPv6 is available. | |
| 2015-07-16 15:47:08 6077 [Note] - '::' resolves to '::'; | |
| 2015-07-16 15:47:08 6077 [Note] Server socket created on IP: '::'. | |
| 2015-07-16 15:47:08 6077 [Note] WSREP: Recovered position: 00000000-0000-0000-0000-000000000000:-1 | |
| 2015-07-16 15:47:08 6077 [Note] Binlog end | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'partition' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'ARCHIVE' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'BLACKHOLE' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_CHANGED_PAGES' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_SYS_TABLES' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_FT_CONFIG' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_FT_DELETED' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_METRICS' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_CMPMEM' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_CMP_RESET' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_CMP' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_LOCKS' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'INNODB_TRX' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'XTRADB_RSEG' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'XTRADB_INTERNAL_HASH_TABLES' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'XTRADB_READ_VIEW' | |
| 2015-07-16 15:47:08 6077 [Note] Shutting down plugin 'InnoDB' | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: FTS optimize thread exiting. | |
| 2015-07-16 15:47:08 6077 [Note] InnoDB: Starting shutdown... | |
| 2015-07-16 15:47:10 6077 [Note] InnoDB: Shutdown completed; log sequence number 1627037 | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'CSV' | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'MyISAM' | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'MRG_MYISAM' | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'MEMORY' | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'sha256_password' | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'mysql_old_password' | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'mysql_native_password' | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'wsrep' | |
| 2015-07-16 15:47:10 6077 [Note] Shutting down plugin 'binlog' | |
| 2015-07-16 15:47:10 6077 [Note] /usr/sbin/mysqld: Shutdown complete | |
| 2015-07-16 15:47:11 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:11 0 [Note] /usr/sbin/mysqld (mysqld 5.6.24-72.2-56) starting as process 6110 ... | |
| 2015-07-16 15:47:11 6110 [Note] Plugin 'FEDERATED' is disabled. | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Using atomics to ref count buffer pool pages | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: The InnoDB memory heap is disabled | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Memory barrier is not used | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Compressed tables use zlib 1.2.3 | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Using Linux native AIO | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Using CPU crc32 instructions | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Initializing buffer pool, size = 128.0M | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Completed initialization of buffer pool | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Highest supported file format is Barracuda. | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: 128 rollback segment(s) are active. | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Waiting for purge to start | |
| 2015-07-16 15:47:11 6110 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1627037 | |
| 2015-07-16 15:47:11 6110 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work. | |
| 2015-07-16 15:47:11 6110 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work. | |
| 2015-07-16 15:47:11 6110 [Note] Server hostname (bind-address): '*'; port: 3306 | |
| 2015-07-16 15:47:11 6110 [Note] IPv6 is available. | |
| 2015-07-16 15:47:11 6110 [Note] - '::' resolves to '::'; | |
| 2015-07-16 15:47:11 6110 [Note] Server socket created on IP: '::'. | |
| 2015-07-16 15:47:11 6110 [Note] Event Scheduler: Loaded 0 events | |
| 2015-07-16 15:47:11 6110 [Note] WSREP: Read nil XID from storage engines, skipping position init | |
| 2015-07-16 15:47:11 6110 [Note] WSREP: wsrep_load(): loading provider library 'none' | |
| 2015-07-16 15:47:11 6110 [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 | |
| [/CODE] | |
| After I typed "sudo mysql" and then "show status like 'wsrep%';", I get the following message: | |
| [CODE] | |
| +--------------------------+----------------------+ | |
| | 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.00 sec) | |
| [/CODE] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment