环境
centos7 + mycat1.5GA + MariaDB 5.5.44
服务器 |
dn1 |
dn2 |
dn3 |
WriterHost |
是 |
是 |
|
- ReadHost |
|
|
是 |
Writer容灾节点 |
是 |
是 |
|
Mycat |
是 |
|
|
mariaDB环境部署
1. 安装
[root@localhost ~]# yum -y install mariadb*
[root@localhost ~]# systemctl start mariadb.service
[root@localhost ~]# systemctl enable mariadb.service
[root@localhost ~]# mysql
2. 设置远程连接
mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY"123456";
mysql>flush privileges;
3. 忽略大小写
cat /etc/my.cnf的[mysqld]下加入lower_case_table_names= 1,并重启服务
4. 关闭linux防火墙
systemctlstop firewalld.service
systemctldisable firewalld.service
Mycat环境部署
1. 安装JDK7与MYCAT
[root@localhost mycat]# ll /usr/java
total 94024
drwxr-xr-x. 8 10 143 4096 Apr 4 2013jdk1.7.0_21
-rw-r--r--. 1 root root 96272413 Jan 4 12:21 jdk-7u21-linux-x64.gz
[root@localhost mycat]# ll /opt
total 11212
drwxr-xr-x. 7 root root 79 Jan 4 12:17 mycat
-rw-r--r--. 1 root root 11477321 Jan 4 12:17Mycat-server-1.5-GA-20160217103036-linux.tar.gz
</