******************************************************************************
0.使用场景
******************************************************************************
数据库软件:mariadb-galera-10.0.19-linux-x86_64.tar.gz
集群管理:galera-25.3.5-1.rhel6.x86_64.rpm
节点同步方式(xtrabackup,rsync):percona-xtrabackup-2.2.8-5059.el6.x86_64.rpm
节点同步使用sockt:socat-2.0.0-b7.tar.gz
安装galera是为了获得/usr/lib64/galera/libgalera_smm.so;
安装xtrabackup是为了配置同步方式xtrabackup,节点数据同步的时候用到;
安装socat是因为同步数据使用socket方式进行端到端的数据交换;
数据库节点:
192.168.50.10 db01 db01.mysql.com
192.168.50.20 db02 db02.mysql.com
192.168.50.30 db03 db03.mysql.com
******************************************************************************
1.系统安装
******************************************************************************
--------1.desktop安装即可,选择自定义
选择下面两个包,其它根据自己需求选择
base system
legacy unix compatibility(rsh telnet ksh tftp )
Desktops
legacy x window system compatibility (xorg-x11-xdm)
-------2 配置yum源
cd /etc/yum.repos.d
mv CentOS-Base.repo CentOS-Base.repo.old
wget http://mirrors.163.com/.help/CentOS6-Base-163.repo
yum makecache
检查可更新的rpm包
#yum check-update
更新所有的rpm包
#yum update
---3.关闭防火墙和selinux
chkconfig --level 123456 iptables off
service iptables stop
/usr/sbin/sestatus -v | grep "SELinux status"
vi /etc/selinux/config
SELINUX=disabled
---4.修改各个节点hosts
#vi /etc/hosts
192.168.50.10 db01 db01.mysql.com
192.168.50.20 db02 db02.mysql.com
192.168.50.30 db03 db03.mysql.com
---4.rz
yum install lrzsz -y
******************************************************************************
2.mysql安装部分
******************************************************************************
一:卸载旧版本
使用下面的命令检查是否安装有MySQL Server
rpm -qa | grep mysql
有的话通过下面的命令来卸载掉
rpm -e mysql //普通删除模式
rpm -e --nodeps mysql
rpm -e --nodeps mysql-devel
rpm -e --nodeps mysql-libs
// 强力删除模式,如果使用上面命令删除时,提示有依赖的其它文件,
则用该命令可以对其进行强力删除
yum remove mysql-libs
二:安装MySQL
1.安装编译代码需要的包
yum -y install cmake gcc gcc-c++ autoconf automake zlib* libxml* \
ncurses ncurses-devel libtool-ltdl-devel* make bison bison-devel libaio \
openssl-devel libevent-devel \
libaio-devel pam-devel boost-devel valgrind-devel \
libnl-devel popt-devel popt-static
2.为mysql新建组和用户
groupadd mysql
useradd -s /sbin/nologin -g mysql -M mysql
passwd mysql
mysql01!
id mysql
3.设置用户的系统资源限制
#vi /etc/security/limits.conf
mysql soft nproc 2047
mysql hard nproc 16384
mysql soft nofile 1024
mysql hard nofile 65536
4.编译安装
tar xf mariadb-galera-10.0.19.tar.gz
cd cd mariadb-10.0.19
编译安装
/***
cmake . -LH --查看cmake支持的mysql相关参数
shell> cmake . -L # overview
shell> cmake . -LH # overview with help text
shell> cmake . -LAH # all params with help text
shell> ccmake . # interactive display
重新编译时,需要清除旧的对象文件和缓存信息
# make clean
# rm -f CMakeCache.txt
****/
cmake \
-DCMAKE_INSTALL_PREFIX=/data/mysql \
-DMYSQL_UNIX_ADDR=/data/mysql/mysql.sock \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_SPHINX_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DMYSQL_DATADIR=/data/mysql/data \
-DMYSQL_TCP_PORT=33306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_EXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_WSREP=1 \
-DWITH_INNODB_DISALLOW_WRITES=1
make -j4
make install
三:配置MySQL
1.新建数据文件、临时文件,修改/usr/local/mysql权限
mkdir -p /data/mysql
mkdir /data/mysql/{innodb_data,data,tmp} -p
mkdir /data/mysql/mysql_logs/{binary_log,innodb_log,query_log,slow_query_log,error_log} -p
2.修改权限
chown -R mysql /data/mysql
chgrp -R mysql /data/mysql
3.修改参数
#rm -rf /etc/my.cnf
#vi /data/mysql/my.cnf
##链接文件
#ln -fs /data/mysql/my.cnf /etc/my.cnf
ll /etc/my.cnf
lrwxrwxrwx. 1 root root 23 Nov 18 17:30 /etc/my.cnf -> /data/mysql/my.cnf
chown -R mysql /data/mysql
chgrp -R mysql /data/mysql
5.初始化数据库
cd /data/mysql/scripts
# ./mysql_install_db --defaults-file=/etc/my.cnf --user=mysql --basedir=/data/mysql \
--datadir=/data/mysql/data
6.启动MySQL
chown -R mysql /data/mysql
chgrp -R mysql /data/mysql
--6.1建议安全启动
/data/mysql/bin/mysqld_safe &
/data/mysql/bin/mysqld_safe --datadir='/data/mysql/data' &
--6.2添加服务,拷贝服务脚本到init.d目录,并设置开机启动
cd /data/mysql/
cp support-files/mysql.server /etc/init.d/mysql
chkconfig mysql on
7.配置mysql用户
MySQL启动成功后,root默认没有密码,我们需要设置root密码。
7.1修改/etc/profile文件,在文件末尾添加
#vi /etc/profile
PATH=/data/mysql/bin:$PATH
export PATH
#source /etc/profile
现在,我们可以在终端内直接输入mysql进入,mysql的环境了
执行下面的命令修改root密码
--7.2修改mysql管理员密码
1.修改当前用户密码
mysql -uroot -p
SET PASSWORD = PASSWORD('pass01');
flush privileges;
2.给所有的root用户设定密码:
第一种方式(推荐)
# mysql -uroot -p
MariaDB [(none)]>
MariaDB [(none)]> select host,user,password from mysql.user;
+-------------+------+----------+
| host | user | password |
+-------------+------+----------+
| localhost | root | |
| db02.zp.com | root | |
| 127.0.0.1 | root | |
| ::1 | root | |
| localhost | | |
| db02.zp.com | | |
+-------------+------+----------+
6 rows in set (0.00 sec)
update mysql.user set password = password('pass01') where user = 'root' limit 100;flush privileges;
flush privileges;
3.删除所有匿名用户(不要删除root@localhost)
DROP USER ''@'localhost';delete from mysql.user where user='' limit 10;commit;flush privileges;
delete from mysql.user where host='db01.mysql.com';flush privileges;
--7.3设置root用户可以远程访问
--方法1:授权法
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'pass01' \
WITH GRANT OPTION;flush privileges;
select host,user,password from mysql.user;
--7.4 登录mysql
#mysql -hlocalhost -uroot -ppass01
----7.5设置linux脚本
vi ~/.bash_profile
#ocpyang set(绑定mysql到内网IP只能写内网IP)
alias mysql="mysql -U -hlocalhost -uroot -ppass01 --auto-rehash"
alias errorlog="cat /data/mysql/mysql_logs/error_log/error.log"
alias mycnf="cd /data/mysql"
export PATH=/data/mysql/scripts:$PATH
source ~/.bash_profile
----7.7修改权限
chown -R mysql /data/mysql
chgrp -R mysql /data/mysql
----7.8 常见启动错误或警告
cat /data/mysql/mysql_logs/error_log/error.log
Warning] 'proxies_priv' entry '@% root@mysql.ocp.com' ignored in --skip-name-resolve mode.
解决办法:
delete from mysql.proxies_priv where host='db01.mysql.com';commit;flush privileges;
******************************************************************************
3.galera相关配置
******************************************************************************
---3.1 新建wsrep用户
GRANT ALL PRIVILEGES ON *.* TO 'wsrep'@'%' IDENTIFIED BY 'wsrep' ;flush privileges;
---3.2 安装galera
--3.2.1 安装galera所依赖的软件
yum install boost-devel
yum install check-devel
wget http://cznic.dl.sourceforge.net/project/scons/scons/2.3.4/scons-2.3.4.tar.gz
tar zxvf scons-2.3.4.tar.gz
cd scons-2.3.4
python setup.py install
--3.2.2 安装galera
#rpm -ql | grep galera
#cd /soft
#rpm -ivh galera-25.3.5-1.rhel6.x86_64.rpm
# ls /usr/lib64/galera
libgalera_smm.so
---3.2.3
#tar xf socat-2.0.0-b7.tar.gz
#cd socat
#./configure
#make & make install
---3.2.4 修改mysql的配置文件
mkdir /etc/my.cnf.d
cd /soft/mariadb-10.0.19/support-files
cp wsrep.cnf /etc/my.cnf.d/
#vi /etc/my.cnf.d/wsrep.cnf
#notde01
[mysqld]
wsrep_on=ON
binlog_format=ROW
default-storage-engine=innodb
#为了降低冲突
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
innodb_flush_log_at_trx_commit = 2 #可以提高性能,galera保证不丢数据
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/galera/libgalera_smm.so #修改
wsrep_cluster_name="galera_cluster" #修改
wsrep_cluster_address="gcomm://" #修改
wsrep_node_address='192.168.50.10,192.168.50.20,192.168.50.30' #修改
wsrep_node_name='db01' #修改
wsrep_slave_threads=4
wsrep_certify_nonPK=1
wsrep_max_ws_rows=131072
wsrep_max_ws_size=1073741824
wsrep_debug=0
wsrep_convert_LOCK_to_trx=0
wsrep_retry_autocommit=1
wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_notify_cmd=
wsrep_sst_method=mysqldump #可以修改#rsync,xtrabackup,mysqldump
wsrep_sst_auth=root:pass01 #修改
#notde02
[mysqld]
wsrep_on=ON
binlog_format=ROW
default-storage-engine=innodb
#为了降低冲突
innodb_autoinc_lock_mode=2
innodb_flush_log_at_trx_commit = 2 #可以提高性能,galera保证不丢数据
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/galera/libgalera_smm.so #修改
wsrep_cluster_name="galera_cluster" #修改
wsrep_cluster_address="gcomm://192.168.50.10,192.168.50.20,192.168.50.30" #修改
wsrep_node_address='192.168.50.20' #修改
wsrep_node_name='db02' #修改
wsrep_slave_threads=4
wsrep_certify_nonPK=1
wsrep_max_ws_rows=131072
wsrep_max_ws_size=1073741824
wsrep_debug=0
wsrep_convert_LOCK_to_trx=0
wsrep_retry_autocommit=1
wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_notify_cmd=
wsrep_sst_method=mysqldump #可以修改#rsync,xtrabackup,mysqldump,xtrabackup-v2
wsrep_sst_auth=root:pass01 #修改
#notde03
[mysqld]
wsrep_on=ON
binlog_format=ROW
default-storage-engine=innodb
#为了降低冲突
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
innodb_flush_log_at_trx_commit = 2 #可以提高性能,galera保证不丢数据
query_cache_size=0
query_cache_type=0
wsrep_provider=/usr/lib64/galera/libgalera_smm.so #修改
wsrep_cluster_name="galera_cluster" #修改
wsrep_cluster_address="gcomm://192.168.50.10,192.168.50.20,192.168.50.30" #修改
wsrep_node_address='192.168.50.30' #修改
wsrep_node_name='db03' #修改
wsrep_slave_threads=4
wsrep_certify_nonPK=1
wsrep_max_ws_rows=131072
wsrep_max_ws_size=1073741824
wsrep_debug=0
wsrep_convert_LOCK_to_trx=0
wsrep_retry_autocommit=1
wsrep_auto_increment_control=1
wsrep_drupal_282555_workaround=0
wsrep_causal_reads=0
wsrep_notify_cmd=
wsrep_sst_method=mysqldump #可以修改#rsync,xtrabackup,mysqldump,xtrabackup-v2
wsrep_sst_auth=root:pass01 #修改
echo '!includedir /etc/my.cnf.d/' >>/etc/my.cnf
---4.使用rsync、xtrabackup、mydupm
--4.1 使用rsync
yum -y install rsync
#tar xvzf socat-2.0.0-b8.tar.gz
#cd socat-2.0.0-b8
#./configure
#make & make install
--强烈建议将xtrabackup和socat加入path
#vi /etc/profile
PATH=/data/mysql/bin:/usr/local/bin/socat:/usr/local/xtrabackup/bin:$PATH
export PATH
ln -s /usr/local/bin/socat /usr/sbin/
ln -s /usr/local/xtrabackup/bin/* /usr/sbin/
--4.2 使用xtrabackup
---5.初始化启动
--方法1:
修改 my.cnf 并设置 wsrep_cluster_address=gcomm:// ,启动后再来修改配置.
--方法2:
使用下面这个命令来启动 mysql (支持 RedHat 和 CentOS 系统)
/data/mysql/bin/mysqld_safe --datadir='/data/mysql/data' --wsrep-cluster-address="gcomm://" &
/data/mysql/bin/mysqld_safe --datadir='/data/mysql/data' &
----6.各节点启动相关
# netstat -lntp | grep 33306
tcp 0 0 :::33306 :::* LISTEN 3072/mysqld
# pkill mysqld
NODE1先启动,其它节点无顺序.
----7.查看群集连接情况
SHOW STATUS LIKE 'wsrep_cluster_size';
SHOW STATUS LIKE 'wsrep%';
mariadb-galera-10.0.19 on centos 6.5
最新推荐文章于 2018-07-13 12:36:50 发布