CentOS 6.4 Heartbeat+mysql+nfs实现高可用的mysql集群
1、创建用户# groupadd -g 3306 mysql
# useradd -g mysql -u 3306 -s /sbin/nologin -M mysql
# id mysql
uid=3306(mysql) gid=3306(mysql) 组=3306(mysql)
2、解压MySQL安装包
# tar xf mysql-5.6.12-linux-glibc2.5-x86_64.tar.gz -C /usr/local/
# ln -sv /usr/local/mysql-5.6.12-linux-glibc2.5-x86_64 /usr/local/mysql
"/usr/local/mysql" -> "/usr/local/mysql-5.6.12-linux-glibc2.5-x86_64"
3、赋予MySQL安装包权限
# chown -R root.mysql /usr/local/mysql/
# ll /usr/local/mysql/
总用量 76
drwxr-xr-x2 root mysql4096 12月 31 09:15 bin
-rw-r--r--1 root mysql 17987 6月20 2013 COPYING
drwxr-xr-x3 root mysql4096 12月 31 09:16 data
drwxr-xr-x2 root mysql4096 12月 31 09:16 docs
drwxr-xr-x3 root mysql4096 12月 31 09:16 include
-rw-r--r--1 root mysql7469 6月20 2013 INSTALL-BINARY
drwxr-xr-x3 root mysql4096 12月 31 09:16 lib
drwxr-xr-x4 root mysql4096 12月 31 09:15 man
drwxr-xr-x 10 root mysql4096 12月 31 09:16 mysql-test
-rw-r--r--1 root mysql2496 6月20 2013 README
drwxr-xr-x2 root mysql4096 12月 31 09:16 scripts
drwxr-xr-x 28 root mysql4096 12月 31 09:15 share
drwxr-xr-x4 root mysql4096 12月 31 09:16 sql-bench
drwxr-xr-x3 root mysql4096 12月 31 09:16 support-files
4、挂载NFS的共享目录并创建MySQL数据存放目录
# mkdir /mydata
# mount -t nfs4 192.168.1.198:/mydata /mydata
# ll /mydata/
总用量 16
drwx------ 2 mysql mysql 16384 12月 31 09:02 lost+found
# mkdir /mydata/data
# ll /mydata/
总用量 20
drwxr-xr-x 2 mysql mysql4096 12月 31 09:24 data
drwx------ 2 mysql mysql 16384 12月 31 09:02 lost+found
5、初始化数据库
# yum -y install libaio
# /usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/mydata/data/ --basedir=/usr/local/mysql/
6、拷贝配置文件、服务启动脚本文件
# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
cp：是否覆盖"/etc/my.cnf"？ yes
# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
7、修改MySQL配置文件
# vim /etc/my.cnf
datadir = /mydata/data
innodb_file_per_table = 1
8、启动服务并登陆测试
# service mysqld start
Starting MySQL.. SUCCESS!
# /usr/local/mysql/bin/mysql -e "show databases;"
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
9、拷贝MySQL配置文件、启动服务脚本文件到node2节点上
# scp /etc/init.d/mysqld /etc/init.d/mysqld
# scp /etc/init.d/mysqld node2:/etc/init.d/mysqld
10、停止MySQL服务
# service mysqld stop
Shutting down MySQL.. SUCCESS!
页:
[1]