系统到了数据库瓶颈了,cpu load值居高不下,报表sql过多,故要做读写分离,
mycat中间件说白了就是把多个物理库外面包装了一层逻辑库,对外表现为单个数据库服务,但是功能还是很强大的像sql优化,分区分片,负载均衡,读写分离等等,但要说的是mycat目前还不是很稳定,有不少bug会造成内存突然爆满,尤其是使用mysql之外的其他物理数据库。
话不多说,上代码:
下载网址:http://www.mycat.io/选1.6版本就够用
解压完的目录结构类似tomcat的结构。
步骤:
1、因为是oracle数据库,第一步要做的就是把ojdbc驱动jar包复制到mycat的lib文件夹下
2、配置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://io.mycat/">
<system>
<property name="useSqlStat">0</property> <!-- 1为开启实时统计、0为关闭 -->
<property name="useGlobleTableCheck">0</property> <!-- 1为开启全加班一致性检测、0为关闭 -->
<property name=