MariaDB Galera кластер на CentOS 6 з трьох нод

mariadb-galera-cluster-centos-6
Збираємо кластер MariaDB із трьох нод на CentOS x64 6.7 Minimal.
На усіх нодах налаштовані статичні IP адреси.
Нода1 – 10.20.20.11
Нода2 – 10.20.20.12
Нода3 – 10.20.20.13

На усіх трьох нодах встановлюємо необхідні пакунки:

# yum -y install wget ntp lsof

1	# yum -y install wget ntp lsof

На усіх нодах, повинен бути правильно налаштований час, це обов’язково. Інакше ви стикнетесь із тим, що при передачі стану ноди із донора, нода що синхронізується, буде просто чогось чекати, без будь-яких ознак активності.

Запускаємо службу ntpd і додаємо її у автозавантаження:

# service ntpd start
# chkconfig ntpd on

1 2	# service ntpd start # chkconfig ntpd on

Вимикаємо Selinux:

# sed -i.bak 's#SELINUX=enforcing#SELINUX=disabled#g' /etc/selinux/config
# setenforce 0

1 2	# sed -i.bak 's#SELINUX=enforcing#SELINUX=disabled#g' /etc/selinux/config # setenforce 0

Відкриваємо порти 4567,4568 (Galera), 3308 (MariaDB), 4444 (rsync_sst) у iptables:

iptables -A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 3308 -j ACCEPT
iptables -A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4567 -j ACCEPT
iptables -A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4568 -j ACCEPT
iptables -A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4444 -j ACCEPT

iptables -A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 3308 -j ACCEPT

iptables -A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4567 -j ACCEPT

iptables -A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4568 -j ACCEPT

iptables -A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4444 -j ACCEPT

Приклад конфігурації iptables:

# cat /etc/sysconfig/iptables
# Generated by iptables-save v1.4.7 on Tue Sep 29 18:43:45 2015
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [21247:2382963]
-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT
-A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
#Galera Cluster replication traffic
-A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4567 -j ACCEPT
#Galera Cluster Incremental State Transfer
-A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4568 -j ACCEPT
#Rsync_SST
-A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4444 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited
COMMIT
# Completed on Tue Sep 29 18:43:45 2015

# cat /etc/sysconfig/iptables

# Generated by iptables-save v1.4.7 on Tue Sep 29 18:43:45 2015

*filter

:INPUT ACCEPT [0:0]

:FORWARD ACCEPT [0:0]

:OUTPUT ACCEPT [21247:2382963]

-A INPUT -m state --state RELATED,ESTABLISHED -j ACCEPT

-A INPUT -p icmp -j ACCEPT

-A INPUT -i lo -j ACCEPT

-A INPUT -p tcp -m state --state NEW -m tcp --dport 22 -j ACCEPT

-A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT

#Galera Cluster replication traffic

-A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4567 -j ACCEPT

#Galera Cluster Incremental State Transfer

-A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4568 -j ACCEPT

#Rsync_SST

-A INPUT -s 10.20.0.0/16 -i eth0 -p tcp -m tcp --dport 4444 -j ACCEPT

-A INPUT -j REJECT --reject-with icmp-host-prohibited

-A FORWARD -j REJECT --reject-with icmp-host-prohibited

COMMIT

# Completed on Tue Sep 29 18:43:45 2015

Встановлюємо репозиторії Percona та MariaDB:

# yum -y install http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

# vi /etc/yum.repos.d/MariaDB.repo

# yum -y install http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

# vi /etc/yum.repos.d/MariaDB.repo

Вставляємо у файл:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/rhel6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

[mariadb]

name = MariaDB

baseurl = http://yum.mariadb.org/10.1/rhel6-amd64

gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

gpgcheck=1

Встановлюємо пакунки MariaDB та Percona:

# yum -y install MariaDB-server MariaDB-Galera-server MariaDB-client galera rsync

1	# yum -y install MariaDB-server MariaDB-Galera-server MariaDB-client galera rsync

На всіх трьох нодах виконуємо:

# service mysql start
Starting MySQL.... SUCCESS!
# mysql_secure_installation
...
...
# service mysql stop

# service mysql start

Starting MySQL.... SUCCESS!

# mysql_secure_installation

...

# service mysql stop

Зберігаємо копію файла конфігурації і заповнюємо новий файл:

# mkdir /var/log/mysql
# cd /etc/my.cnf.d/
# mv server.cnf server.cnf.bak
# vi server.cnf


[mysqld]

log_error=/var/log/mysql/mysql_error.log

general_log_file=/var/log/mysql/mysql.log
general_log = 0

#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

user=mysql
port=3308
# (This must be substituted by wsrep_format)

binlog_format=ROW

# Currently only InnoDB storage engine is supported
default-storage-engine=innodb

# to avoid issues with 'bulk mode inserts' using autoinc
innodb_autoinc_lock_mode=2

# This is a must for paralell applying
transaction-isolation = REPEATABLE-READ

# Query Cache is not supported with wsrep
query_cache_size=0
query_cache_type=0

# Override bind-address
# In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST
# it will have (most likely) disastrous consequences on donor node
bind-address=0.0.0.0

##
## WSREP options
##
wsrep_on=on
# Full path to wsrep provider library or 'none'
wsrep_provider=/usr/lib64/galera/libgalera_smm.so

# Provider specific configuration options
#wsrep_provider_options=

# Logical cluster name. Should be the same for all nodes.
wsrep_cluster_name="mariadb_cluster"

# Group communication system handle
wsrep_cluster_address=gcomm://10.20.20.11,10.20.20.12,10.20.20.13

# Human-readable node name (non-unique). Hostname by default.
wsrep_node_name=node1

# Base replication &lt;address|hostname&gt;[:port] of the node.
# The values supplied will be used as defaults for state transfer receiving,
# listening ports and so on. Default: address of the first network interface.
wsrep_node_address=10.20.20.11

# Address for incoming client connections. Autodetect by default.
#wsrep_node_incoming_address=192.168.56.221

# How many threads will process writesets from other nodes
wsrep_slave_threads=1

# DBUG options for wsrep provider
#wsrep_dbug_option

# Generate fake primary keys for non-PK tables (required for multi-master
# and parallel applying operation)
wsrep_certify_nonPK=1

# Maximum number of rows in write set
wsrep_max_ws_rows=131072

# Maximum size of write set
wsrep_max_ws_size=1073741824

# to enable debug level logging, set this to 1
wsrep_debug=0

# convert locking sessions into transactions
wsrep_convert_LOCK_to_trx=0

# how many times to retry deadlocked autocommits
wsrep_retry_autocommit=1

# change auto_increment_increment and auto_increment_offset automatically
wsrep_auto_increment_control=1

# retry autoinc insert, which failed for duplicate key error
wsrep_drupal_282555_workaround=0

# enable "strictly synchronous" semantics for read operations
wsrep_causal_reads=0

# Command to call when node status or cluster membership changes.
# Will be passed all or some of the following options:
# --status - new status of this node
# --uuid - UUID of the cluster
# --primary - whether the component is primary or not ("yes"/"no")
# --members - comma-separated list of members
# --index - index of this node in the list
wsrep_notify_cmd=

##
## WSREP State Transfer options
##

# State Snapshot Transfer method
wsrep_sst_method=rsync

# Address which donor should send State Snapshot to.
# Should be the address of THIS node. DON'T SET IT TO DONOR ADDRESS!!!
# (SST method dependent. Defaults to the first IP of the first interface)
#wsrep_sst_receive_address=

# SST authentication string. This will be used to send SST to joining nodes.
# Depends on SST method. For mysqldump method it is root: wsrep_sst_auth=

# Desired SST donor name.
#wsrep_sst_donor=

# Reject client queries when donating SST (false)
#wsrep_sst_donor_rejects_queries=0

# Protocol version to use
# wsrep_protocol_version=

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

# mkdir /var/log/mysql

# cd /etc/my.cnf.d/

# mv server.cnf server.cnf.bak

# vi server.cnf

[mysqld]

log_error=/var/log/mysql/mysql_error.log

general_log_file=/var/log/mysql/mysql.log

general_log = 0

#log_slow_queries = /var/log/mysql/mysql-slow.log

#long_query_time = 2

#log-queries-not-using-indexes

user=mysql

port=3308

# (This must be substituted by wsrep_format)

binlog_format=ROW

# Currently only InnoDB storage engine is supported

default-storage-engine=innodb

# to avoid issues with 'bulk mode inserts' using autoinc

innodb_autoinc_lock_mode=2

# This is a must for paralell applying

transaction-isolation = REPEATABLE-READ

# Query Cache is not supported with wsrep

query_cache_size=0

query_cache_type=0

# Override bind-address

# In some systems bind-address defaults to 127.0.0.1, and with mysqldump SST

# it will have (most likely) disastrous consequences on donor node

bind-address=0.0.0.0

## WSREP options

wsrep_on=on

# Full path to wsrep provider library or 'none'

wsrep_provider=/usr/lib64/galera/libgalera_smm.so

# Provider specific configuration options

#wsrep_provider_options=

# Logical cluster name. Should be the same for all nodes.

wsrep_cluster_name="mariadb_cluster"

# Group communication system handle

wsrep_cluster_address=gcomm://10.20.20.11,10.20.20.12,10.20.20.13

# Human-readable node name (non-unique). Hostname by default.

wsrep_node_name=node1

# Base replication <address|hostname>[:port] of the node.

# The values supplied will be used as defaults for state transfer receiving,

# listening ports and so on. Default: address of the first network interface.

wsrep_node_address=10.20.20.11

# Address for incoming client connections. Autodetect by default.

#wsrep_node_incoming_address=192.168.56.221

# How many threads will process writesets from other nodes

wsrep_slave_threads=1

# DBUG options for wsrep provider

#wsrep_dbug_option

# Generate fake primary keys for non-PK tables (required for multi-master

# and parallel applying operation)

wsrep_certify_nonPK=1

# Maximum number of rows in write set

wsrep_max_ws_rows=131072

# Maximum size of write set

wsrep_max_ws_size=1073741824

# to enable debug level logging, set this to 1

wsrep_debug=0

# convert locking sessions into transactions

wsrep_convert_LOCK_to_trx=0

# how many times to retry deadlocked autocommits

wsrep_retry_autocommit=1

# change auto_increment_increment and auto_increment_offset automatically

wsrep_auto_increment_control=1

# retry autoinc insert, which failed for duplicate key error

wsrep_drupal_282555_workaround=0

# enable "strictly synchronous" semantics for read operations

wsrep_causal_reads=0

# Command to call when node status or cluster membership changes.

# Will be passed all or some of the following options:

# --status - new status of this node

# --uuid - UUID of the cluster

# --primary - whether the component is primary or not ("yes"/"no")

# --members - comma-separated list of members

# --index - index of this node in the list

wsrep_notify_cmd=

## WSREP State Transfer options

# State Snapshot Transfer method

wsrep_sst_method=rsync

# Address which donor should send State Snapshot to.

# Should be the address of THIS node. DON'T SET IT TO DONOR ADDRESS!!!

# (SST method dependent. Defaults to the first IP of the first interface)

#wsrep_sst_receive_address=

# SST authentication string. This will be used to send SST to joining nodes.

# Depends on SST method. For mysqldump method it is root: wsrep_sst_auth=

# Desired SST donor name.

#wsrep_sst_donor=

# Reject client queries when donating SST (false)

#wsrep_sst_donor_rejects_queries=0

# Protocol version to use

# wsrep_protocol_version=

Скопіюйте файл на дві інші ноди і впевніться, що для всіх трьох нод наступні налаштування задані правильно:
wsrep_cluster_name = ім’я кластера. Однакове для всіх нод у кластері.
wsrep_cluster_address = рядок з адресами всіх нод кластера виду gcomm://IP1,IP2,..,IPn. Однакове для всіх нод у кластері.
wsrep_node_address = IP адреса ноди із цим файлом конфігурації. Якщо мережевий інтерфейс один можна не заповнювати.
wsrep_node_incoming_address = IP адреса ноди із цим файлом конфігурації. Якщо мережевий інтерфейс один можна не заповнювати.

Тепер можна запускати кластер!
Ініціалізуємо кластер на першій ноді:

[root@mariadbcluster1 my.cnf.d]# mysqld --wsrep-new-cluster &

1	[root@mariadbcluster1 my.cnf.d]# mysqld --wsrep-new-cluster &

…і запускаємо дві інші ноди:

[root@mariadbcluster2 ~]# service mysql start
Starting MySQL..... SUCCESS!

[root@mariadbcluster3 ~]# service mysql start
Starting MySQL..... SUCCESS!

[root@mariadbcluster2 ~]# service mysql start

Starting MySQL..... SUCCESS!

[root@mariadbcluster3 ~]# service mysql start

Starting MySQL..... SUCCESS!

Щоб перевірити стан кластера і впевнитися що всі ноди онлайн, виконаємо наступну команду (з будь-якої ноди):

# mysql -u root -p
Enter password:

The Welcome to  the MariaDB monitor. The Commands end  with  ; or  \ g.
MariaDB Your connection  id is  8
Server version: 5.5.36-MariaDB-wsrep MariaDB Server, wsrep_25.9.r3961
 
Copyright (c) 2000, 2014, the Oracle, the Ab Monty Program and  : others.
 
The Type 'to help;'  or  '\ h'  for  to help. The Type '\ c'  to  the clear the current  input the statement The.
 
MariaDB [(none)]> show For the status like  '% wsrep_cluster_size%' ;
+ -------------------- + ------- +
| variable_name | Value |
+ -------------------- + ------- +
| wsrep_cluster_size | 3 |
+ -------------------- + ------- +
1 row in  the set  (0.00 sec)

# mysql -u root -p

Enter password:

The Welcome to the MariaDB monitor. The Commands end with ; or \ g.

MariaDB Your connection id is 8

Server version: 5.5.36-MariaDB-wsrep MariaDB Server, wsrep_25.9.r3961

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

MariaDB [(none)]> show For the status like '% wsrep_cluster_size%' ;

+ -------------------- + ------- +

| variable_name | Value |

+ -------------------- + ------- +

| wsrep_cluster_size | 3 |

+ -------------------- + ------- +

1 row in the set (0.00 sec)

Усі три ноди онлайн.

Подивитись іншу інформацію по кластеру можна командою:

MariaDB [(none)]> show status like '%wsrep_%';
+------------------------------+-------------------------------------------------------------+
| Variable_name | Value |
+------------------------------+-------------------------------------------------------------+
| wsrep_local_state_uuid | 31f07ce3-b44a-11e3-b945-f72a90507c82 |
| wsrep_protocol_version | 5 |
| wsrep_last_committed | 0 |
| wsrep_replicated | 0 |
| wsrep_replicated_bytes | 0 |
| wsrep_repl_keys | 0 |
| wsrep_repl_keys_bytes | 0 |
| wsrep_repl_data_bytes | 0 |
| wsrep_repl_other_bytes | 0 |
| wsrep_received | 10 |
| wsrep_received_bytes | 2447 |
| wsrep_local_commits | 0 |
| wsrep_local_cert_failures | 0 |
| wsrep_local_replays | 0 |
| wsrep_local_send_queue | 0 |
| wsrep_local_send_queue_avg | 0.000000 |
| wsrep_local_recv_queue | 0 |
| wsrep_local_recv_queue_avg | 0.000000 |
| wsrep_local_cached_downto | 18446744073700051615 |
| wsrep_flow_control_paused_ns | 0 |
| wsrep_flow_control_paused | 0.000000 |
| wsrep_flow_control_sent | 0 |
| wsrep_flow_control_recv | 0 |
| wsrep_cert_deps_distance | 0.000000 |
| wsrep_apply_oooe | 0.000000 |
| wsrep_apply_oool | 0.000000 |
| wsrep_apply_window | 0.000000 |
| wsrep_commit_oooe | 0.000000 |
| wsrep_commit_oool | 0.000000 |
| wsrep_commit_window | 0.000000 |
| wsrep_local_state | 4 |
| wsrep_local_state_comment | Synced |
| wsrep_cert_index_size | 0 |
| wsrep_causal_reads | 0 |
| wsrep_incoming_addresses | 10.20.20.11:3306,10.20.20.12:3306,10.20.20.13:3306 |
| wsrep_cluster_conf_id | 23 |
| wsrep_cluster_size | 3 |
| wsrep_cluster_state_uuid | 31f07ce3-baaa-11e3-b945-f72a90507c82 |
| wsrep_cluster_status | Primary |
| wsrep_connected | ON |
| wsrep_local_bf_aborts | 0 |
| wsrep_local_index | 1 |
| wsrep_provider_name | Galera |
| wsrep_provider_vendor | Codership Oy &lt;info@codership.com&gt; |
| wsrep_provider_version | 25.3.2(r170) |
| wsrep_ready | ON |
+------------------------------+-------------------------------------------------------------+
46 rows in set (0.00 sec)

MariaDB [(none)]> show status like '%wsrep_%';

+------------------------------+-------------------------------------------------------------+

| Variable_name | Value |

+------------------------------+-------------------------------------------------------------+

| wsrep_local_state_uuid | 31f07ce3-b44a-11e3-b945-f72a90507c82 |

| wsrep_protocol_version | 5 |

| wsrep_last_committed | 0 |

| wsrep_replicated | 0 |

| wsrep_replicated_bytes | 0 |

| wsrep_repl_keys | 0 |

| wsrep_repl_keys_bytes | 0 |

| wsrep_repl_data_bytes | 0 |

| wsrep_repl_other_bytes | 0 |

| wsrep_received | 10 |

| wsrep_received_bytes | 2447 |

| wsrep_local_commits | 0 |

| wsrep_local_cert_failures | 0 |

| wsrep_local_replays | 0 |

| wsrep_local_send_queue | 0 |

| wsrep_local_send_queue_avg | 0.000000 |

| wsrep_local_recv_queue | 0 |

| wsrep_local_recv_queue_avg | 0.000000 |

| wsrep_local_cached_downto | 18446744073700051615 |

| wsrep_flow_control_paused_ns | 0 |

| wsrep_flow_control_paused | 0.000000 |

| wsrep_flow_control_sent | 0 |

| wsrep_flow_control_recv | 0 |

| wsrep_cert_deps_distance | 0.000000 |

| wsrep_apply_oooe | 0.000000 |

| wsrep_apply_oool | 0.000000 |

| wsrep_apply_window | 0.000000 |

| wsrep_commit_oooe | 0.000000 |

| wsrep_commit_oool | 0.000000 |

| wsrep_commit_window | 0.000000 |

| wsrep_local_state | 4 |

| wsrep_local_state_comment | Synced |

| wsrep_cert_index_size | 0 |

| wsrep_causal_reads | 0 |

| wsrep_incoming_addresses | 10.20.20.11:3306,10.20.20.12:3306,10.20.20.13:3306 |

| wsrep_cluster_conf_id | 23 |

| wsrep_cluster_size | 3 |

| wsrep_cluster_state_uuid | 31f07ce3-baaa-11e3-b945-f72a90507c82 |

| wsrep_cluster_status | Primary |

| wsrep_connected | ON |

| wsrep_local_bf_aborts | 0 |

| wsrep_local_index | 1 |

| wsrep_provider_name | Galera |

| wsrep_provider_vendor | Codership Oy <info@codership.com> |

| wsrep_provider_version | 25.3.2(r170) |

| wsrep_ready | ON |

+------------------------------+-------------------------------------------------------------+

46 rows in set (0.00 sec)

Щоб упевнитись, що реплікація працює створимо базу даних:

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)

MariaDB [(none)]> create database can_you_see_me_now;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| can_you_see_me_now |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

+--------------------+

3 rows in set (0.00 sec)

MariaDB [(none)]> create database can_you_see_me_now;

Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| can_you_see_me_now |

| mysql |

| performance_schema |

+--------------------+

4 rows in set (0.00 sec)

Ми відразу ж маємо побачити її на інших нодах:

[root@mariadbcluster2 ~]$ mysql -u root -p
Enter password:

1 2	[root@mariadbcluster2 ~]$ mysql -u root -p Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 5.5.36-MariaDB-wsrep MariaDB Server, wsrep_25.9.r3961

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

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

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| can_you_see_me_now |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 4

Server version: 5.5.36-MariaDB-wsrep MariaDB Server, wsrep_25.9.r3961

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

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| can_you_see_me_now |

| mysql |

| performance_schema |

+--------------------+

4 rows in set (0.00 sec)

[root@mariadbcluster3 ~]$ mysql -u root -p
Enter password:

1 2	[root@mariadbcluster3 ~]$ mysql -u root -p Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 9
Server version: 5.5.36-MariaDB-wsrep MariaDB Server, wsrep_25.9.r3961

Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.

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

MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| can_you_see_me_now |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.00 sec)

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 9

Server version: 5.5.36-MariaDB-wsrep MariaDB Server, wsrep_25.9.r3961

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

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| can_you_see_me_now |

| mysql |

| performance_schema |

+--------------------+

4 rows in set (0.00 sec)

MariaDB Galera кластер на CentOS 6 з трьох нод

Stay tuned! :)

Категорії

MariaDB Galera кластер на CentOS 6 з трьох нод

Related posts

Помилка Hyper-V CentOS6 “device eth0 does not seem to be present, delaying initialization”

Як конвертувати pfx сертифікат у pem

Stay tuned! :)

Категорії

Позначки