Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can I use Galera plugin to create a cluster and just use the DB now for any application? #137

Open
akarasulu opened this issue Dec 23, 2016 · 1 comment
Labels

Comments

@akarasulu
Copy link
Contributor

I created a galera cluster with two nodes. Now I want to install wordpress and use the mysql database. Will it replicate now?

@eabyshev-zz
Copy link
Contributor

eabyshev-zz commented Dec 27, 2016

@akarasulu yes, replication is working. I created cluster with three nodes.
There is config:

[mysqld]
# Cluster node configurations
wsrep_cluster_address="gcomm://172.19.213.2,172.19.213.4,172.19.213.3"
wsrep_node_address="172.19.213.3"
innodb_buffer_pool_size=400M

# Mandatory settings to enable Galera
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
binlog_format=ROW
default-storage-engine=InnoDB
innodb_autoinc_lock_mode=2
innodb_doublewrite=1
query_cache_size=0
#bind-address=0.0.0.0

# Galera synchronisation configuration
wsrep_sst_method=rsync

Cluster status:

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 37
Server version: 10.1.19-MariaDB-1~trusty mariadb.org binary distribution

Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| wsrep_cluster_size | 3     |
+--------------------+-------+
1 row in set (0.00 sec)

MariaDB [(none)]>

screenshot from 2016-12-27 11 26 04

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants