Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.8
-
10.1.9-1
Description
Hi everybody,
In the Centos7 start script there is no way to bootstrap a new cluster.
"service mysql bootstrap" is says it is bootstrapping but it always fails trying to connect to another node.
Cheers,
Michael
Config:
[server]
|
|
server-id=2
|
|
# this is only for the mysqld standalone daemon
|
[mysqld]
|
default_storage_engine = InnoDB
|
max_connect_errors = 10
|
max_connections = 100
|
wait_timeout = 3600
|
datadir = /var/lib/mysql
|
|
max_heap_table_size = 100M
|
|
performance_schema = ON
|
|
##team@inbox 2015-10-23 logs setup
|
long_query_time = 0.1
|
slow_query_log = ON
|
log_error = /var/log/mysql/mysql.err
|
slow_query_log_file = /var/log/mysql/slow_query.log
|
sql_error_log_filename = /var/log/mysql/sql_error.log
|
plugin-load = sql_errlog.so
|
|
|
log_bin
|
|
binlog_format = ROW
|
innodb_locks_unsafe_for_binlog = 1
|
|
#binlog_format=row
|
#default_storage_engine=InnoDB
|
innodb_autoinc_lock_mode=2
|
bind-address=0.0.0.0
|
#
|
# Optional setting
|
wsrep_slave_threads=4
|
innodb_flush_log_at_trx_commit=2
|
|
##Galera settings from training material
|
wsrep_on = ON
|
wsrep_cluster_name="test_cluster"
|
wsrep_node_name=node2
|
wsrep_cluster_address="gcomm://192.168.76.199,192.168.76.189"
|
wsrep_node_address=192.168.76.199
|
wsrep_sst_method = xtrabackup-v2
|
wsrep_sst_receive_address=192.168.76.199
|
wsrep_sst_auth=sst:galera
|
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
|
# this is only for embedded server
|
[embedded]
|
|
# This group is only read by MariaDB servers, not by MySQL.
|
# If you use the same .cnf file for MySQL and MariaDB,
|
# you can put MariaDB-only options here
|
[mariadb]
|
|
# This group is only read by MariaDB-10.1 servers.
|
# If you use the same .cnf file for MariaDB of different versions,
|
# use this group for options that older servers don't understand
|
[mariadb-10.1]
|
Attachments
Issue Links
- relates to
-
MDEV-7752 There is no bootstrap command option for MariaDB Galera Cluster in CentOS 7
- Closed
- links to