Mycat安装和测试
准备工作:
IP 主机名 数据库名 安装软件
192.168.230.129 master db1 mycat,mysql
192.168.230.130 slave1 db2 mysql
192.168.230.131 slave2 db3 mysql
1、安装mysql客户端
[root@master ~]# yum -y install mysql
[root@slave1 ~]# yum -y install mysql
[root@slave2 ~]# yum -y install mysql
2、安装mysql服务端
[root@master ~]# yum -y install mysql-server
[root@slave1 ~]# yum -y install mysql-server
[root@slave2 ~]# yum -y install mysql-server
[root@master ~]# yum -y install mysql-devel
[root@slave1 ~]# yum -y install mysql-devel
[root@slave1 ~]# yum -y install mysql-devel
3、添加mysql用户及权限并配置数据库
三台服务器都安装mysql以后 ,三台机器同样配置数据库
具体步骤如下:
3.1、配置编码格式,vi /etc/my.cnf ,添加default-character-set=utf8
[root@master ~]# vi /etc/my.cnf
[root@slave1 ~]# vi /etc/my.cnf
[root@slave2 ~]# vi /etc/my.cnf
default-character-set=utf8
3.2.、添加开机启动项
[root@master ~]# chkconfig --add mysqld
[root@master ~]# chkconfig mysqld on
[root@slave1 ~]# chkconfig --add mysqld
[root@slave1 ~]# chkconfig mysqld on
[root@slave2 ~]# chkconfig --add mysqld
[root@slave2 ~]# chkconfig mysqld on
3.3、启动mysql
[root@master ~]# service mysqld start
[root@slave1 ~]# service mysqld start
[root@slave2 ~]# service mysqld start
3.4、配置root用户并设置密码
master主机、slave1主机、salve2主机,三台主机的mysql均进行如下配置
[root@master ~]# mysql -uroot -p
mysql> use mysql;
mysql> select user,host from user;
mysql> delete from user where user = "";
mysql> select user,host from user;
mysql> update user set host='%' where host='127.0.0.1';
mysql> update user set password = PASSWORD('123456') where user = 'root';
3.5、添加新用户
mysql> insert into mysql.user(Host,User,Password) values("%","mycat",password("123456"));