Mariadb-Galera10二进制包安装

Mariadb-Galera10二进制包安装

官方网站:

https://mariadb.com/kb/en/mariadb/getting-started-with-mariadb-galera-cluster/

http://galeracluster.com/documentation-webpages/installmariadbsrc.html

环境:

CentOS 7.1 x64

mariadb-galera-10.0.24

galera-25.3.14

说明:mariadb-10.1.x版本，galera wsrep(Write Set replication)API库已经内嵌到版本中，而10.0.x的版本是分开的两个包mariadb-galera(mariadb的galera版本),galera(提供wsrep API的库libgalera_smm.so)

一.安装mariadb-galera

wget http://mirrors.ctyun.cn/MariaDB/mariadb-galera-10.0.24/bintar-linux-glibc_214-x86_64/mariadb-galera-10.0.24-linux-glibc_214-x86_64.tar.gz

mariadb-galera的安装步骤和安装mariadb完全一样

请参看MariaDB-10.1.x二进制包安装

二.安装galera

方式一: 二进制包

wget http://mirrors.ctyun.cn/MariaDB/mariadb-galera-10.0.24/galera-25.3.14/bintar/galera-25.3.14-glibc_214-x86_64.tar.gz

tar -xvf galera-25.3.14-glibc_214-x86_64.tar.gz -C /opt/

ln -s /opt/galera-25.3.14-glibc_214-x86_64 /opt/galera

ln -s /opt/galera/usr/bin/garbd /usr/bin/

ln -s /opt/galera/usr/lib/* /usr/lib64/

ln -s /opt/galera/etc/init.d/garb /etc/init.d/

ln -s /opt/galera/usr/share/man/man8/garbd.8.gz /usr/share/man/man8/

ln -s /opt/galera/usr/share/doc/galera-* /usr/share/doc/

方式二：rpm包

wget http://mirrors.ctyun.cn/MariaDB/mariadb-galera-10.0.24/galera-25.3.14/rpm/galera-25.3.14-1.rhel7.el7.centos.x86_64.rpm

yum -y install boost-program-options

rpm -ivh galera-25.3.14-1.rhel7.el7.centos.x86_64.rpm

两种方法任选一种即可，其实是干的相同事情，个人推荐rpm包，多方便啊

[root@db02 ~]# mysql -uroot -p

Enter password:

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

Your MariaDB connection id is 12

Server version: 10.0.24-MariaDB-wsrep MariaDB Server, wsrep_25.13.raf7f02e

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

MariaDB [(none)]> SHOW DATABASES;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

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

3 rows in set (0.00 sec)

MariaDB [(none)]> SHOW ENGINESG

*************************** 1. row ***************************

Engine: MRG_MyISAM

Support: YES

Comment: Collection of identical MyISAM tables

Transactions: NO

XA: NO

Savepoints: NO

*************************** 2. row ***************************

Engine: CSV

Support: YES

Comment: CSV storage engine

Transactions: NO

XA: NO

Savepoints: NO

*************************** 3. row ***************************

Engine: BLACKHOLE

Support: YES

Comment: /dev/null storage engine (anything you write to it disappears)

Transactions: NO

XA: NO

Savepoints: NO

*************************** 4. row ***************************

Engine: MyISAM

Support: YES

Comment: MyISAM storage engine

Transactions: NO

XA: NO

Savepoints: NO

*************************** 5. row ***************************

Engine: FEDERATED

Support: YES

Comment: FederatedX pluggable storage engine

Transactions: YES

XA: NO

Savepoints: YES

*************************** 6. row ***************************

Engine: ARCHIVE

Support: YES

Comment: Archive storage engine

Transactions: NO

XA: NO

Savepoints: NO

*************************** 7. row ***************************

Engine: InnoDB

Support: DEFAULT

Comment: Percona-XtraDB, Supports transactions, row-level locking, and foreign keys

Transactions: YES

XA: YES

Savepoints: YES

*************************** 8. row ***************************

Engine: PERFORMANCE_SCHEMA

Support: YES

Comment: Performance Schema

Transactions: NO

XA: NO

Savepoints: NO

*************************** 9. row ***************************

Engine: MEMORY

Support: YES

Comment: Hash based, stored in memory, useful for temporary tables

Transactions: NO

XA: NO

Savepoints: NO

*************************** 10. row ***************************

Engine: Aria

Support: YES

Comment: Crash-safe tables with MyISAM heritage

Transactions: NO

XA: NO

Savepoints: NO

10 rows in set (0.00 sec)

MariaDB [(none)]> STATUS;

--------------

mysql Ver 15.1 Distrib 10.0.24-MariaDB, for Linux (x86_64) using readline 5.1

Connection id: 12

Current database:

Current user: root@localhost

SSL: Not in use

Current pager: stdout

Using outfile: ''

Using delimiter: ;

Server: MariaDB

Server version: 10.0.24-MariaDB-wsrep MariaDB Server, wsrep_25.13.raf7f02e

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: latin1

Db characterset: latin1

Client characterset: utf8

Conn. characterset: utf8

UNIX socket: /tmp/mysql.sock

Uptime: 25 min 45 sec

Threads: 1 Questions: 31 Slow queries: 0 Opens: 1 Flush tables: 1 Open tables: 64 Queries per second avg: 0.020

--------------