By TinyCyanCrab
I’m testing the Galera cluster.
The environment is Centos 7.2. DB is MySQL 5.6.
The success message was confirmed using the following instructions.
/etc/init.d/mysql start --wsrep-new-cluster
Starting MySQL… SUCCESS!
But if you check the cluster size, it says 0.
mysql -uroot -p -e “SHOW STATUS LIKE ‘wsrep_cluster_size’”
Enter password: ±-------------------±------+ | Variable_name | Value | ±-------------------±------+ | wsrep_cluster_size | 0 | ±-------------------±------+
The cnf file of the initial node I set is as follows.
/etc/my.cnf.d/galera.cnf
[mysqld] binlog_format=ROW default-storage-engine=innodb innodb_autoinc_lock_mode=2 bind-address=0.0.0.0
Galera Provider Configuration
wsrep_on=ON wsrep_provider=/usr/lib64/galera-3/libgalera_smm.so
Galera Cluster Configuration
wsrep_cluster_name=“test_cluster” wsrep_cluster_address=“gcomm://”
Galera Synchronization Configuration
wsrep_sst_method=rsync
Galera Node Configuration
wsrep_node_address=“my node_1 ip” wsrep_node_name=“galera1”
I turned off both firewall and selinux.
Please tell me the solution.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Start building today
From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.
