mycat做读写分离验证

最新推荐文章于 2022-09-06 17:57:51 发布

菜鸟devops

最新推荐文章于 2022-09-06 17:57:51 发布

阅读量1.2k

点赞数

2016年05月16日 13:33:56

阅读数：26453

mycat是最近很火的一款国人发明的分布式数据库中间件，它是基于阿里的cobar的基础上进行开发的

搭建之前我们先要配置mysql的主从复制，这个过程很长，我这里就不写了，有兴趣的可以看看我写的这篇文章。

mycat在应用当中的作用可以看下图

mycat可以让程序员只需要关心业务代码的编写，而不用担心后端数据库集群的负载均衡，读写分离，分库分表的数据分片逻辑的编写，只要直接连接mycat就可以了

首先我们准备一台干净的centos机器，安装好jdk

解压mycat的安装包到/user/local/下

设置mycat的环境变量

 vi /etc/profile

使配置文件立即生效

source /etc/profile

进入mycat的配置文件目录

cd /usr/local/mycat/conf/

vi schema.xml

这个配置文件主要是用来配置数据库节点，逻辑表等等东西的

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://org.opencloudb/">

<schema name="pcx_schema" checkSQLschema="false" sqlMaxLimit="100" dataNode="pcxNode"></schema>

<dataNode name="pcxNode" dataHost="dtHost" database="pcx" />




<dataHost name="dtHost" maxCon="500" minCon="20" balance="1"
writeType="0" dbType="mysql" dbDriver="native" switchType="2" slaveThreshold="100">

<heartbeat>show slave status</heartbeat>

<writeHost host="hostMaster" url="192.168.1.6:3306" user="root" password="root" />
<writeHost host="hostSlave" url="192.168.1.7:3306" user="root" password="root" />
</dataHost>
</mycat:schema>

接下来配置用户权限,系统变量

 vi server.xml

<?xml version="1.0" encoding="UTF-8"?>
<!-- - - Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License. - You
may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0
- - Unless required by applicable law or agreed to in writing, software -
distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT
WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the
License for the specific language governing permissions and - limitations
under the License. -->
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://org.opencloudb/">
<system>

<property name="defaultSqlParser">druidparser</property>
<property name="charset">utf8mb4</property>
</system>

<user name="user1">
<property name="password">root</property>
<property name="schemas">pcx_schema</property>
</user>

<user name="user2">
<property name="password">root</property>
<property name="schemas">pcx_schema</property>
<property name="readOnly">true</property>
</user>
</mycat:server>