Details
-
Task
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Hello,
I have installed MariaDB 10.4.13 from source and trying to configure Galera Cluster, but when I run "/usr/sbin/galera_new_cluster" it fails with the following messages:
2020-04-01 6:21:57 1 [Note] WSREP: Min available from gcache for CC from group: 2 |
2020-04-01 6:21:57 1 [Note] WSREP: Server vm1-cluster-litespeed-pro synced with group |
2020-04-01 6:21:57 1 [Note] WSREP: Server status change joined -> synced |
2020-04-01 6:21:57 1 [Note] WSREP: Synchronized with group, ready for connections |
2020-04-01 6:21:57 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:23:05 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown |
2020-04-01 6:23:05 0 [Note] WSREP: Shutdown replication |
2020-04-01 6:23:05 0 [Note] WSREP: Server status change synced -> disconnecting |
2020-04-01 6:23:05 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
Here the full logs:
2020-04-01 6:21:35 0 [Note] WSREP: Loading provider /usr/lib64/galera/libgalera_smm.so initial position: 00000000-0000-0000-0000-000000000000:-1 |
wsrep loader: [INFO] wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so' |
wsrep loader: [INFO] wsrep_load(): Galera 26.4.4(r4599) by Codership Oy <info@codership.com> loaded successfully. |
2020-04-01 6:21:35 0 [Note] WSREP: CRC-32C: using hardware acceleration. |
2020-04-01 6:21:35 0 [Note] WSREP: Found saved state: 312fcda7-73de-11ea-9c54-ee110f5fad29:2, safe_to_bootstrap: 1 |
2020-04-01 6:21:35 0 [Note] WSREP: GCache DEBUG: opened preamble: |
Version: 2 |
UUID: 312fcda7-73de-11ea-9c54-ee110f5fad29
|
Seqno: 2 - 2 |
Offset: 1280 |
Synced: 1 |
2020-04-01 6:21:35 0 [Note] WSREP: Recovering GCache ring buffer: version: 2, UUID: 312fcda7-73de-11ea-9c54-ee110f5fad29, offset: 1280 |
2020-04-01 6:21:35 0 [Note] WSREP: GCache::RingBuffer initial scan... 0.0% ( 0/134217752 bytes) complete. |
2020-04-01 6:21:35 0 [Note] WSREP: GCache::RingBuffer initial scan...100.0% (134217752/134217752 bytes) complete. |
2020-04-01 6:21:35 0 [Note] WSREP: Recovering GCache ring buffer: found gapless sequence 2-2 |
2020-04-01 6:21:35 0 [Note] WSREP: GCache::RingBuffer unused buffers scan... 0.0% ( 0/176 bytes) complete. |
2020-04-01 6:21:35 0 [Note] WSREP: GCache::RingBuffer unused buffers scan...100.0% (176/176 bytes) complete. |
2020-04-01 6:21:35 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): found 0/1 locked buffers |
2020-04-01 6:21:35 0 [Note] WSREP: GCache DEBUG: RingBuffer::recover(): used space: 176/134217728 |
2020-04-01 6:21:35 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 1.1.1.1; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; 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 = galera.cache; gcache.page_size = 128M; gcache.recover = yes; gcache.size = 128M; gcomm.thread_prio = ; 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 |
2020-04-01 6:21:35 0 [Note] WSREP: Service thread queue flushed. |
2020-04-01 6:21:35 0 [Note] WSREP: ####### Assign initial position for certification: 312fcda7-73de-11ea-9c54-ee110f5fad29:2, protocol version: -1 |
2020-04-01 6:21:35 0 [Note] WSREP: Start replication |
2020-04-01 6:21:35 0 [Note] WSREP: Connecting with bootstrap option: 1 |
2020-04-01 6:21:35 0 [Note] WSREP: Setting GCS initial position to 312fcda7-73de-11ea-9c54-ee110f5fad29:2 |
2020-04-01 6:21:35 0 [Note] WSREP: protonet asio version 0 |
2020-04-01 6:21:35 0 [Note] WSREP: Using CRC-32C for message checksums. |
2020-04-01 6:21:35 0 [Note] WSREP: backend: asio |
2020-04-01 6:21:35 0 [Note] WSREP: gcomm thread scheduling priority set to other:0 |
2020-04-01 6:21:35 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory) |
2020-04-01 6:21:35 0 [Note] WSREP: restore pc from disk failed |
2020-04-01 6:21:35 0 [Note] WSREP: GMCast version 0 |
2020-04-01 6:21:35 0 [Note] WSREP: (09858f60-bf8d, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567 |
2020-04-01 6:21:35 0 [Note] WSREP: (09858f60-bf8d, 'tcp://0.0.0.0:4567') multicast: , ttl: 1 |
2020-04-01 6:21:35 0 [Note] WSREP: EVS version 1 |
2020-04-01 6:21:35 0 [Note] WSREP: gcomm: bootstrapping new group 'Pro' |
2020-04-01 6:21:35 0 [Note] WSREP: start_prim is enabled, turn off pc_recovery |
2020-04-01 6:21:35 0 [Note] WSREP: EVS version upgrade 0 -> 1 |
2020-04-01 6:21:35 0 [Note] WSREP: PC protocol upgrade 0 -> 1 |
2020-04-01 6:21:35 0 [Note] WSREP: Node 09858f60-bf8d state prim |
2020-04-01 6:21:35 0 [Note] WSREP: view(view_id(PRIM,09858f60-bf8d,1) memb { |
09858f60-bf8d,0 |
} joined {
|
} left {
|
} partitioned {
|
})
|
2020-04-01 6:21:35 0 [Note] WSREP: save pc into disk |
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr without UUID: tcp://1.1.1.1:4567 |
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr proto entry 0x55c70572d900 |
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr without UUID: tcp://2.2.2.2:4567 |
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr proto entry 0x55c705735e00 |
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr without UUID: tcp://3.3.3.3:4567 |
2020-04-01 6:21:35 0 [Note] WSREP: discarding pending addr proto entry 0x55c70573e370 |
2020-04-01 6:21:35 0 [Note] WSREP: gcomm: connected |
2020-04-01 6:21:35 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636 |
2020-04-01 6:21:35 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0) |
2020-04-01 6:21:35 0 [Note] WSREP: Opened channel 'Pro' |
2020-04-01 6:21:35 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 1 |
2020-04-01 6:21:35 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 0985f60b-73e1-11ea-8c36-3773663e5842 |
2020-04-01 6:21:35 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 0985f60b-73e1-11ea-8c36-3773663e5842 |
2020-04-01 6:21:35 0 [Note] WSREP: STATE EXCHANGE: got state msg: 0985f60b-73e1-11ea-8c36-3773663e5842 from 0 (vm1-cluster-litespeed-pro) |
2020-04-01 6:21:35 2 [Note] WSREP: Starting rollbacker thread 2 |
2020-04-01 6:21:35 0 [Note] WSREP: Quorum results: |
version = 6, |
component = PRIMARY,
|
conf_id = 0, |
members = 1/1 (joined/total), |
act_id = 2, |
last_appl. = 2, |
protocols = 2/10/4 (gcs/repl/appl), |
vote policy= 0, |
group UUID = 312fcda7-73de-11ea-9c54-ee110f5fad29
|
2020-04-01 6:21:35 1 [Note] WSREP: Starting applier thread 1 |
2020-04-01 6:21:35 0 [Note] WSREP: Flow-control interval: [16, 16] |
2020-04-01 6:21:35 0 [Note] WSREP: Restored state OPEN -> JOINED (3) |
2020-04-01 6:21:35 0 [Note] WSREP: Member 0.0 (vm1-cluster-litespeed-pro) synced with group. |
2020-04-01 6:21:35 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 3) |
2020-04-01 6:21:35 1 [Note] WSREP: ####### processing CC 3, local, ordered |
2020-04-01 6:21:35 1 [Note] WSREP: Process first view: 312fcda7-73de-11ea-9c54-ee110f5fad29 my uuid: 09858f60-73e1-11ea-bf8d-63939b145668 |
2020-04-01 6:21:35 1 [Note] WSREP: Server vm1-cluster-litespeed-pro connected to cluster at position 312fcda7-73de-11ea-9c54-ee110f5fad29:3 with ID 09858f60-73e1-11ea-bf8d-63939b145668 |
2020-04-01 6:21:35 1 [Note] WSREP: Server status change disconnected -> connected |
2020-04-01 6:21:35 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:21:35 1 [Note] WSREP: ####### My UUID: 09858f60-73e1-11ea-bf8d-63939b145668 |
2020-04-01 6:21:35 1 [Note] WSREP: Cert index reset to 00000000-0000-0000-0000-000000000000:-1 (proto: 10), state transfer needed: no |
2020-04-01 6:21:35 0 [Note] WSREP: Service thread queue flushed. |
2020-04-01 6:21:35 1 [Note] WSREP: ####### Assign initial position for certification: 00000000-0000-0000-0000-000000000000:-1, protocol version: -1 |
2020-04-01 6:21:35 1 [Note] WSREP: REPL Protocols: 10 (5) |
2020-04-01 6:21:35 1 [Note] WSREP: ####### Adjusting cert position: -1 -> 3 |
2020-04-01 6:21:35 0 [Note] WSREP: Service thread queue flushed. |
2020-04-01 6:21:35 1 [Note] WSREP: ================================================ |
View:
|
id: 312fcda7-73de-11ea-9c54-ee110f5fad29:3 |
status: primary
|
protocol_version: 4 |
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
|
final: no |
own_index: 0 |
members(1): |
0: 09858f60-73e1-11ea-bf8d-63939b145668, vm1-cluster-litespeed-pro |
=================================================
|
2020-04-01 6:21:35 1 [Note] WSREP: Server status change connected -> joiner |
2020-04-01 6:21:35 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:21:35 1 [Note] WSREP: Server status change joiner -> initializing |
2020-04-01 6:21:35 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:21:35 0 [Note] InnoDB: Using Linux native AIO |
2020-04-01 6:21:35 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins |
2020-04-01 6:21:35 0 [Note] InnoDB: Uses event mutexes |
2020-04-01 6:21:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 |
2020-04-01 6:21:35 0 [Note] InnoDB: Number of pools: 1 |
2020-04-01 6:21:35 0 [Note] InnoDB: Using SSE2 crc32 instructions |
2020-04-01 6:21:35 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmpfs/mysql (disabling future attempts) |
2020-04-01 6:21:35 0 [Note] InnoDB: Initializing buffer pool, total size = 240G, instances = 16, chunk size = 128M |
2020-04-01 6:21:47 0 [Note] InnoDB: Completed initialization of buffer pool |
2020-04-01 6:21:50 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). |
2020-04-01 6:21:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active. |
2020-04-01 6:21:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables |
2020-04-01 6:21:57 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... |
2020-04-01 6:21:57 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. |
2020-04-01 6:21:57 0 [Note] InnoDB: Waiting for purge to start |
2020-04-01 6:21:57 0 [Note] InnoDB: 10.4.13 started; log sequence number 80877; transaction id 63 |
2020-04-01 6:21:57 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool |
2020-04-01 6:21:57 0 [Note] Plugin 'FEEDBACK' is disabled. |
2020-04-01 6:21:57 0 [Note] InnoDB: Buffer pool(s) load completed at 200401 6:21:57 |
2020-04-01 6:21:57 0 [Note] Server socket created on IP: '0.0.0.0'. |
2020-04-01 6:21:57 0 [Warning] 'user' entry '@vm1-cluster-litespeed-pro' ignored in --skip-name-resolve mode. |
2020-04-01 6:21:57 0 [Warning] 'proxies_priv' entry '@% root@vm1-cluster-litespeed-pro' ignored in --skip-name-resolve mode. |
2020-04-01 6:21:57 0 [Note] WSREP: wsrep_init_schema_and_SR (nil) |
2020-04-01 6:21:57 0 [Note] WSREP: Server initialized |
2020-04-01 6:21:57 0 [Note] WSREP: Server status change initializing -> initialized |
2020-04-01 6:21:57 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:21:57 1 [Note] WSREP: Bootstrapping a new cluster, setting initial position to 00000000-0000-0000-0000-000000000000:-1 |
2020-04-01 6:21:57 0 [Note] Reading of all Master_info entries succeeded |
2020-04-01 6:21:57 0 [Note] Added new Master_info '' to hash table |
2020-04-01 6:21:57 0 [Note] /usr/sbin/mysqld: ready for connections. |
Version: '10.4.13-MariaDB-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution |
2020-04-01 6:21:57 10 [Note] WSREP: Recovered cluster id 312fcda7-73de-11ea-9c54-ee110f5fad29 |
2020-04-01 6:21:57 1 [Note] WSREP: Server status change initialized -> joined |
2020-04-01 6:21:57 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:21:57 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:21:57 1 [Note] WSREP: Lowest cert indnex boundary for CC from group: 3 |
2020-04-01 6:21:57 1 [Note] WSREP: Min available from gcache for CC from group: 2 |
2020-04-01 6:21:57 1 [Note] WSREP: Server vm1-cluster-litespeed-pro synced with group |
2020-04-01 6:21:57 1 [Note] WSREP: Server status change joined -> synced |
2020-04-01 6:21:57 1 [Note] WSREP: Synchronized with group, ready for connections |
2020-04-01 6:21:57 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:23:05 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown |
2020-04-01 6:23:05 0 [Note] WSREP: Shutdown replication |
2020-04-01 6:23:05 0 [Note] WSREP: Server status change synced -> disconnecting |
2020-04-01 6:23:05 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:23:05 0 [Note] WSREP: Closing send monitor... |
2020-04-01 6:23:05 0 [Note] WSREP: Closed send monitor. |
2020-04-01 6:23:05 0 [Note] WSREP: gcomm: terminating thread |
2020-04-01 6:23:05 0 [Note] WSREP: gcomm: joining thread |
2020-04-01 6:23:05 0 [Note] WSREP: gcomm: closing backend |
2020-04-01 6:23:05 0 [Note] WSREP: PC protocol downgrade 1 -> 0 |
2020-04-01 6:23:05 0 [Note] WSREP: view((empty)) |
2020-04-01 6:23:05 0 [Note] WSREP: gcomm: closed |
2020-04-01 6:23:05 0 [Note] WSREP: New SELF-LEAVE. |
2020-04-01 6:23:05 0 [Note] WSREP: Flow-control interval: [0, 0] |
2020-04-01 6:23:05 0 [Note] WSREP: Received SELF-LEAVE. Closing connection. |
2020-04-01 6:23:05 0 [Note] WSREP: Shifting SYNCED -> CLOSED (TO: 3) |
2020-04-01 6:23:05 0 [Note] WSREP: RECV thread exiting 0: Success |
2020-04-01 6:23:05 0 [Note] WSREP: recv_thread() joined. |
2020-04-01 6:23:05 0 [Note] WSREP: Closing replication queue. |
2020-04-01 6:23:05 0 [Note] WSREP: Closing slave action queue. |
2020-04-01 6:23:05 1 [Note] WSREP: ================================================ |
View:
|
id: 312fcda7-73de-11ea-9c54-ee110f5fad29:-1 |
status: non-primary
|
protocol_version: 4 |
capabilities: MULTI-MASTER, CERTIFICATION, PARALLEL_APPLYING, REPLAY, ISOLATION, PAUSE, CAUSAL_READ, INCREMENTAL_WS, UNORDERED, PREORDERED, STREAMING, NBO
|
final: yes |
own_index: -1 |
members(0): |
=================================================
|
2020-04-01 6:23:05 1 [Note] WSREP: Non-primary view |
2020-04-01 6:23:05 1 [Note] WSREP: Server status change disconnecting -> disconnected |
2020-04-01 6:23:05 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:23:05 1 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification. |
2020-04-01 6:23:05 1 [Note] WSREP: Applier thread exiting ret: 0 thd: 1 |
2020-04-01 6:23:05 1 [Warning] Aborted connection 1 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) |
2020-04-01 6:23:05 2 [Note] WSREP: rollbacker thread exiting 2 |
2020-04-01 6:23:05 2 [Warning] Aborted connection 2 to db: 'unconnected' user: 'unauthenticated' host: '' (This connection closed normally without authentication) |
2020-04-01 6:23:05 0 [Note] Event Scheduler: Purging the queue. 0 events |
2020-04-01 6:23:05 0 [Note] InnoDB: FTS optimize thread exiting. |
2020-04-01 6:23:05 0 [Note] WSREP: dtor state: CLOSED |
2020-04-01 6:23:05 0 [Note] WSREP: MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0 |
2020-04-01 6:23:05 0 [Note] WSREP: apply mon: entered 0 |
2020-04-01 6:23:05 0 [Note] WSREP: apply mon: entered 0 |
2020-04-01 6:23:05 0 [Note] WSREP: mon: entered 3 oooe fraction 0 oool fraction 0 |
2020-04-01 6:23:05 0 [Note] WSREP: cert index usage at exit 0 |
2020-04-01 6:23:05 0 [Note] WSREP: cert trx map usage at exit 0 |
2020-04-01 6:23:05 0 [Note] WSREP: deps set usage at exit 0 |
2020-04-01 6:23:05 0 [Note] WSREP: avg deps dist 0 |
2020-04-01 6:23:05 0 [Note] WSREP: avg cert interval 0 |
2020-04-01 6:23:05 0 [Note] WSREP: cert index size 0 |
2020-04-01 6:23:05 0 [Note] WSREP: Service thread queue flushed. |
2020-04-01 6:23:05 0 [Note] WSREP: wsdb trx map usage 0 conn query map usage 0 |
2020-04-01 6:23:05 0 [Note] WSREP: MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 |
2020-04-01 6:23:05 0 [Note] WSREP: Shifting CLOSED -> DESTROYED (TO: 3) |
2020-04-01 6:23:05 0 [Note] WSREP: Flushing memory map to disk... |
2020-04-01 6:23:05 0 [Note] InnoDB: Starting shutdown... |
2020-04-01 6:23:05 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool |
2020-04-01 6:23:05 0 [Note] InnoDB: Buffer pool(s) dump completed at 200401 6:23:05 |
2020-04-01 6:23:13 0 [Note] InnoDB: Shutdown completed; log sequence number 86882; transaction id 78 |
2020-04-01 6:23:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" |
2020-04-01 6:23:13 0 [Note] /usr/sbin/mysqld: Shutdown complete |
|
Here is my.cnf file:
[server]
|
log_error=/var/log/mariadb/error.log
|
skip-name-resolve
|
interactive_timeout = 60 |
wait_timeout = 60 |
tmpdir = /var/tmpfs/mysql
|
skip-external-locking
|
key_buffer_size = 64M
|
max_allowed_packet = 512M
|
table_open_cache = 8192 |
sort_buffer_size = 512K
|
read_buffer_size = 256K
|
read_rnd_buffer_size = 512K
|
myisam_sort_buffer_size = 512K
|
thread_cache_size = 1072 |
query_cache_type = 1 |
query_cache_size = 256M
|
query_cache_limit = 4M
|
thread_concurrency = 16 |
max_connections = 1024 |
tmp_table_size = 512M
|
max_heap_table_size = 512M
|
|
# InnoDB configuration
|
innodb_buffer_pool_size = 240G
|
innodb_buffer_pool_instances = 16 |
innodb_log_file_size = 2G
|
innodb_log_buffer_size = 64M
|
innodb_flush_log_at_trx_commit = 1 |
innodb_lock_wait_timeout = 50 |
innodb_file_per_table = 1 |
|
long_query_time = 1 |
slow_query_log = 1 |
slow_query_log_file = /var/log/mariadb/slow-query.log
|
log-bin=/var/log/mariadb/mysql-bin
|
log-bin-index=/var/log/mariadb/mysql-bin.index
|
|
binlog_format=row
|
innodb_autoinc_lock_mode=2 |
default_storage_engine=InnoDB
|
bind-address=0.0.0.0 |
|
#[galera]
|
#The main settings
|
|
innodb_rollback_on_timeout=1 |
innodb_lock_wait_timeout=600 |
|
innodb_doublewrite=1 |
innodb_flush_log_at_trx_commit=0 |
|
# Galera Provider Configuration
|
wsrep_on=ON
|
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
|
|
# Galera Synchronization Configuration
|
wsrep_sst_method=rsync
|
|
#Node IP addresses and Cluster Settings for both Nodes |
wsrep_cluster_address='gcomm://1.1.1.1,2.2.2.2,3.3.3.3' |
|
#ClusterName
|
wsrep_cluster_name='Pro' |
|
#The current Node cluster
|
wsrep_node_address='1.1.1.1' |
|
#Current Node Name (Server Name)
|
wsrep_node_name='vm1-cluster-litespeed-pro' |
|