思级有容数据库双主模式安装部署

双主部署方案

MD5值：a7ec27503d786f662afff5f6ae9e6433

Glibc-2.17
一 环境准备
entos7更换yum源
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
yum clean all
yum makecache

yum install -y gcc gcc-c++  make zlib zlib-devel pcre pcre-devel  libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel ncurses ncurses-devel curl curl-devel e2fsprogs e2fsprogs-devel krb5 krb5-devel openssl openssl-devel openldap openldap-devel nss_ldap openldap-clients openldap-serervs libmcrypt-devel lrz* tar wget ncdu psmisc net-tools

1 硬件配置
#两台greatdb服务器，keepalived和greatdb复用服务器
node1 192.168.159.128
node2 192.168.159.129
2关闭selinux以及防火墙
不启用selinux
打开/etc/selinux/config，把 SELINUX=enforcing 改为 SELINUX= disabled

getenforce

disabled

关闭防火墙

systemctl stop firewalld

systemctl disable firewalld

3 主机名以及ip地址规划

cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.159.128 node1
192.168.159.129 node2

二 安装powerdb并配置主主复制（两台服务器都执行）
1.数据库安装
groupadd powerdb
useradd -m powerdb -g powerdb -d /home/powerdb
[root@node1 powerdbdata]# mkdir -p /powerdbdata/tmp
[root@node1 ~]# mkdir -p /home/powerdbdata/sgb/data19101

#目录位置根据用户实际磁盘挂在调整

上传powerdb安装包到/usr/local目录

[root@node1 ~]# cd /usr/local/
[root@node1 local]# tar -zxvf SgrDB-4.0.0.8021-Linux-glibc2.17-x86_64.tar.gz
[root@node1 local]# ln -s SgrDB-4.0.0.8021-Linux-glibc2.17-x86_64 powerdbd
[root@node1 local]# chown -R powerdb:powerdb powerdbd/
[root@node1 powerdbdata]# chown -R powerdb:powerdb /home/powerdbdata/

配置powerdb环境变量

[root@node1 local]# echo “PATH=$PATH:/usr/local/powerdbd/bin” >> /etc/profile
[root@node1 local]# source /etc/profile

[root@node1 local]# cat my19101.cnf

[client]
socket=/home/powerdbdata/sgb/data19101/powerdb19101.sock

[mysqld]
server-id=1910116 #两个powerdb的server-id不能相同
log-bin=sgrdb-bin
socket=/home/powerdbdata/sgb/data19101/powerdb19101.sock
datadir=/home/powerdbdata/sgb/data19101
basedir = /usr/local/powerdbd
port=19101
default_authentication_plugin = mysql_native_password
back_log = 5000
binlog_format = row
binlog_ignore_db = powerdb_tmp
character_set_server = utf8
enforce_gtid_consistency = 1
expire_logs_days = 30
federated = 1
gtid_mode = on
innodb_buffer_pool_instances = 4
innodb_buffer_pool_size = 100M #根据实际情况调整
innodb_change_buffering = all
innodb_doublewrite = true
innodb_file_per_table = 1
innodb_flush_log