|
Galera 10.0.20 on CentOS 6.60.使用场景数据库软件：mariadb-galera-10.0.20-linux-x86_64.tar.gz集群管理：galera-3-25.3.10节点同步方式（xtrabackup,rsync)：percona-xtrabackup-2.2.8-5059.el6.x86_64.rpm节点同步使用sockt：socat-2.0.0-b7.tar.gz安装galera是为了获得libgalera_smm.so；安装xtrabackup是为了配置同步方式xtrabackup，节点数据同步的时候用到；安装socat是因为同步数据使用socket方式进行端到端的数据交换；数据库节点:127.0.0.1 localhost localhost192.168.50.10 db01 db01.mysql.com192.168.50.20 db02 db02.mysql.com192.168.50.30 db03 db03.mysql.com1.系统安装——–0.删除postfixyum remove postfix——–1.系统安装参见:Linux for Mysql 系统安装规范——-2 配置yum源cd /etc/yum.repos.dmv CentOS-Base.repo CentOS-Base.repo.old阿里镜像wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo163镜像wget http://mirrors.163.com/.help/CentOS6-Base-163.repoyum makecache检查可更新的rpm包yum check-update更新所有的rpm包yum update—3.关闭防火墙和selinuxchkconfig –level 123456 iptables offservice iptables stop/usr/sbin/sestatus -v | grep “SELinux status”vi /etc/selinux/configSELINUX=disabled—4.修改各个节点hostsvi /etc/hosts192.168.50.10 db01 db01.mysql.com192.168.50.20 db02 db02.mysql.com192.168.50.30 db03 db03.mysql.com—4.rzyum install lrzsz -y2.mysql安装部分一：卸载旧版本使用下面的命令检查是否安装有MySQL Serverrpm -qa | grep mysql有的话通过下面的命令来卸载掉rpm -e mysql //普通删除模式rpm -e –nodeps mysqlrpm -e –nodeps mysql-develrpm -e –nodeps mysql-libs// 强力删除模式，如果使用上面命令删除时，提示有依赖的其它文件，则用该命令可以对其进行强力删除yum remove mysql-libs二：安装MySQL1.安装编译代码需要的包yum -y install cmake gcc gcc-c++ autoconf automake zlib* libxml*ncurses ncurses-devel libtool libtool-ltdl-devel* make bison bison-developenssl-devel libevent-devellibaio libaio-devel pam-devel boost boost-devel valgrind-devellibnl-devel popt-devel popt-static bzr2.为mysql新建组和用户groupadd mysqluseradd -s /sbin/nologin -g mysql -M mysqlpasswd mysqlmysql01!id mysql3.设置用户的系统资源限制vi /etc/security/limits.confmysql soft nproc 2047mysql hard nproc 16384mysql soft nofile 1024mysql hard nofile 655364.编译安装tar xf mariadb-galera-10.0.20.tar.gzcd mariadb-10.0.20编译安装/*cmake . -LH –查看cmake支持的mysql相关参数shell> cmake . -L # overviewshell> cmake . -LH # overview with help textshell> cmake . -LAH # all params with help textshell> 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=1make -j4make install三：配置MySQL1.新建数据文件、临时文件,修改/usr/local/mysql权限mkdir -p /data/mysqlmkdir /data/mysql/{innodb_data,data,tmp} -pmkdir /data/mysql/mysql_logs/{binary_log,innodb_log,query_log,slow_query_log,error_log} -p2.修改权限chown -R mysql /data/mysqlchgrp -R mysql /data/mysql3.修改参数rm -rf /etc/my.cnfvi /data/mysql/my.cnf链接文件ln -fs /data/mysql/my.cnf /etc/my.cnfll /etc/my.cnflrwxrwxrwx. 1 root root 23 Nov 18 17:30 /etc/my.cnf -> /data/mysql/my.cnfchown -R mysql /data/mysqlchgrp -R mysql /data/mysql5.初始化数据库cd /data/mysql/scripts./mysql_install_db –defaults-file=/etc/my.cnf –user=mysql –basedir=/data/mysql–datadir=/data/mysql/data6.启动MySQLchown -R mysql /data/mysqlchgrp -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/mysqlchkconfig mysql on7.配置mysql用户MySQL启动成功后，root默认没有密码，我们需要设置root密码。7.1修改/etc/profile文件，在文件末尾添加vi + /etc/profilePATH=/data/mysql/bin:$PATHexport PATHsource /etc/profile现在，我们可以在终端内直接输入mysql进入，mysql的环境了执行下面的命令修改root密码–7.2修改mysql管理员密码1.修改当前用户密码mysql -uroot -pSET PASSWORD = PASSWORD(‘pass01’);flush privileges;2.给所有的root用户设定密码：第一种方式(推荐)# mysql -uroot -pMariaDB [(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;delete from mysql.user where host=’db02.mysql.com’;flush privileges;delete from mysql.user where host=’db03.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 登录mysqlmysql -hlocalhost -uroot -ppass01—-7.5设置linux脚本vi + ~/.bash_profileocpyang 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:$PATHsource ~/.bash_profile—-7.7修改权限chown -R mysql /data/mysqlchgrp -R mysql /data/mysql—-7.8 常见启动错误或警告cat /data/mysql/mysql_logs/error_log/error.logWarning] ‘proxies_priv’ entry ‘@% [email protected]’ ignored in –skip-name-resolve mode.解决办法:delete from mysql.proxies_priv where host=’db01.mysql.com’;commit;flush privileges;delete from mysql.proxies_priv where host=’db02.mysql.com’;commit;flush privileges;delete from mysql.proxies_priv where host=’db03.mysql.com’;commit;flush privileges;—–7.9 软连接mysql的bin目录ln -sf /data/mysql/bin/* /usr/bin/3.galera相关配置—–3.1 galera安装(参见galera安装配置)—3.2 新建wsrep用户GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON . TO ‘wsrep’@’%’ IDENTIFIED BY ‘wsrep’ ;flush privileges;CREATE USER ‘wsrep’@’localhost’ IDENTIFIED BY ‘wsrep’;GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON . TO ‘wsrep’@’localhost’;FLUSH PRIVILEGES;—3.2.3 安装socathttp://www.dest-unreach.org/socat/http://www.dest-unreach.org/socat/download/tar xf socat-1.7.3.0.tar.gzcd socat-1.7.3.0./configuremake -j4make install—3.2.4 修改mysql的配置文件mkdir /etc/my.cnf.dcd /soft/mariadb-10.0.20/support-filescp wsrep.cnf /etc/my.cnf.d/vi /etc/my.cnf.d/wsrep.cnfnode01[mysqld]wsrep_on=ONbinlog_format=ROWdefault-storage-engine=innodb为了降低冲突innodb_autoinc_lock_mode=2innodb_locks_unsafe_for_binlog=1innodb_flush_log_at_trx_commit = 2 #可以提高性能，galera保证不丢数据query_cache_size=0query_cache_type=0wsrep_provider=/data/mysql/lib/plugin/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.10 #修改wsrep_node_name=db01 #修改wsrep_slave_threads=4wsrep_certify_nonPK=1wsrep_max_ws_rows=131072wsrep_max_ws_size=1073741824wsrep_debug=0wsrep_convert_LOCK_to_trx=0wsrep_retry_autocommit=1wsrep_auto_increment_control=1wsrep_drupal_282555_workaround=0wsrep_causal_reads=0wsrep_notify_cmd=wsrep_sst_method=xtrabackup-v2 #可以修改#rsync,xtrabackup,mysqldumpwsrep_sst_auth=root:pass01 #修改node02[mysqld]wsrep_on=ONbinlog_format=ROWdefault-storage-engine=innodb为了降低冲突innodb_autoinc_lock_mode=2innodb_flush_log_at_trx_commit = 2 #可以提高性能，galera保证不丢数据query_cache_size=0query_cache_type=0wsrep_provider=/data/mysql/lib/plugin/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=4wsrep_certify_nonPK=1wsrep_max_ws_rows=131072wsrep_max_ws_size=1073741824wsrep_debug=0wsrep_convert_LOCK_to_trx=0wsrep_retry_autocommit=1wsrep_auto_increment_control=1wsrep_drupal_282555_workaround=0wsrep_causal_reads=0wsrep_notify_cmd=wsrep_sst_method=xtrabackup-v2 #可以修改#rsync,xtrabackup,mysqldump,xtrabackup-v2wsrep_sst_auth=root:pass01 #修改node03[mysqld]wsrep_on=ONbinlog_format=ROWdefault-storage-engine=innodb为了降低冲突innodb_autoinc_lock_mode=2innodb_locks_unsafe_for_binlog=1innodb_flush_log_at_trx_commit = 2 #可以提高性能，galera保证不丢数据query_cache_size=0query_cache_type=0wsrep_provider=/data/mysql/lib/plugin/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=4wsrep_certify_nonPK=1wsrep_max_ws_rows=131072wsrep_max_ws_size=1073741824wsrep_debug=0wsrep_convert_LOCK_to_trx=0wsrep_retry_autocommit=1wsrep_auto_increment_control=1wsrep_drupal_282555_workaround=0wsrep_causal_reads=0wsrep_notify_cmd=wsrep_sst_method=xtrabackup-v2 #可以修改#rsync,xtrabackup,mysqldump,xtrabackup-v2wsrep_sst_auth=root:pass01 #修改echo ‘!includedir /etc/my.cnf.d/’ >>/etc/my.cnf—4.使用rsync、xtrabackup、mydupm–4.1 使用rsyncyum -y install rsynctar xvzf socat-2.0.0-b8.tar.gzcd socat-2.0.0-b8./configuremake & make install–强烈建议将xtrabackup和socat加入pathvi /etc/profilePATH=/data/mysql/bin:/usr/local/bin/socat:$PATHexport PATHln -sf /usr/local/bin/socat /usr/sbin/—–4.2 使用xtrabackup(推荐)tar xf Percona-XtraBackup-2.2.11-r7956d1d-el6-x86_64-bundle.taryum localinstall -y percona-*—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’ &–node1查看日志cat /data/mysql/data/innobackup.backup.log—-6.各节点启动相关netstat -lntp | grep 33306tcp 0 0 :::33306 :::* LISTEN 3072/mysqldpkill mysqldNODE1先启动,其它节点无顺序.—-7.查看群集连接情况SELECT VARIABLE_VALUE as “cluster size” FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME=”wsrep_cluster_size”;SHOW STATUS LIKE ‘wsrep_cluster_size’;SHOW STATUS LIKE ‘wsrep%’;
(以上内容不代表本站观点。) --------------------------------- |
本網站是"非商業"(non-commercial)。
