安装mycat

最新推荐文章于 2024-09-05 23:08:40 发布

静言思之兮

最新推荐文章于 2024-09-05 23:08:40 发布

阅读量181

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/qq_42989565/article/details/82630899

版权

mysql 专栏收录该内容

3 篇文章

订阅专栏

事先准备好JDK，跟mycat安装包
[root@gaojingbo ~]# cd /root/Desktop/
[root@gaojingbo Desktop]# cd mycat/
[root@gaojingbo mycat]# ls
jdk-8u121-linux-x64.rpm    Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz

[root@gaojingbo mycat]# yum -y install jdk-8u121-linux-x64.rpm 

[root@gaojingbo mycat]# vim /etc/profile
export MYCAT=/usr/local/mycat

[root@gaojingbo mycat]# source /etc/profile

[root@gaojingbo mycat]# rpm -e --nodeps java-1.8.0-openjdk-headless java-1.8.0-openjdk java-1.7.0-openjdk-headless
[root@gaojingbo mycat]# java -version
java version "1.8.0_121"
Java(TM) SE Runtime Environment (build 1.8.0_121-b13)
Java HotSpot(TM) 64-Bit Server VM (build 25.121-b13, mixed mode)

[root@gaojingbo mycat]# useradd mycat
[root@gaojingbo mycat]# ls
jdk-8u121-linux-x64.rpm    Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz

[root@gaojingbo mycat]# tar  xf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz -C /usr/local

[root@gaojingbo mycat]# /usr/local/mycat/bin/mycat start
Starting Mycat-server...
为了节约空间删除安装包
[root@gaojingbo mycat]# rm -rf jdk-8u121-linux-x64.rpm 
[root@gaojingbo mycat]# rm -rf Mycat-server-1.6-RELEASE-20161028204710-linux.tar.gz 
拷贝需要修改的文件到当前目录  防止改错无法恢复
[root@gaojingbo mycat]# cp /usr/local/mycat/conf/server.xml .
[root@gaojingbo mycat]# cp /usr/local/mycat/conf/schema.xml .
[root@gaojingbo mycat]# ls
  schema.xml  server.xml
[root@gaojingbo mycat]# vim /usr/local/mycat/conf/server.xml 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:server SYSTEM "server.dtd">
<mycat:server xmlns:mycat="http://io.mycat/">
                <user name="admin">
                <property name="password">123456</property>
                <property name="schemas">game</property>
        </user>
</mycat:server>

[root@gaojingbo mycat]# vim /usr/local/mycat/conf/schema.xml 
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
        <schema name="game" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
        </schema>
        <dataNode name="dn1" dataHost="localhost1" database="jiaoshi" />
        <dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"
                          writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
                <heartbeat>select user()</heartbeat>
                <writeHost host="hostM1" url="192.168.122.114:3306" user="root"
                                password="123">
                        <readHost host="hostS2" url="192.168.122.38:3306" user="admin" password="123456" />
                </writeHost>
        </dataHost>
</mycat:schema>
#写操作在主服务器上，读操作在从服务器上，
[root@gaojingbo mycat]# /usr/local/mycat/bin/mycat restart
Stopping Mycat-server...
Mycat-server was not running.
Starting Mycat-server...
[root@gaojingbo mycat]# ss -ant |grep -E "8066|9066"
LISTEN     0      100         :::9066                    :::*                  
LISTEN     0      100         :::8066                    :::*    
从服务器上用虚拟帐号登陆测试
[root@cong support-files]# mysql -u admin -p -h 10.30.162.36 -P8066
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.29-mycat-1.6-RELEASE-20161028204710 MyCat Server (OpenCloundDB)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+----------+
| DATABASE |
+----------+
| game     |
+----------+
1 row in set (0.00 sec)

mysql>