mycat的安装

分手后的思念是犯贱 2022-11-07 04:29 220阅读 0赞

准备好环境，mysql主从  
主节点：192.168.37.101  
从节点：192.168.37.100

配置不同的server-id，主的小于从  
并开启log-bin

mysql> grant all privileges on *.* to 'myslave'@'192.168.37.100' identified by 'myslave' with grant option;
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)

得到master的log文件

从节点，设置server-id，开启log-bin

mysql> stop slave;
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    mysql> change master to master_host='192.168.37.101',master_user='myslave',master_password='myslave',master_log_file='mysql-bin.000001';
    Query OK, 0 rows affected (0.10 sec)
    mysql> start slave;
    Query OK, 0 rows affected (0.01 sec)

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1YW5nYmFva2FuZw_size_16_color_FFFFFF_t_70]

如上主从环境测试成功。  
为了使用SqlYog连上，可以设置root的远程授权（非必须）

mysql> grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
    Query OK, 0 rows affected (0.00 sec)

mycat的安装启动  
下载上传到服务器，解压到/usr/local下，即能用（前提有jdk环境）  
conf/server.xml配置一个用户

<user name="mycat">
                    <property name="password">123456</property>
                    <property name="schemas">TESTDB</property>
            </user>

conf/schema.xml

<?xml version="1.0"?>
    <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
    <mycat:schema xmlns:mycat="http://io.mycat/">
    
            <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"></schema>
            <dataNode name="dn1" dataHost="host1" database="testdb" />
            <dataHost name="host1" maxCon="1000" minCon="10" balance="0"
                              writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
                    <heartbeat>select user()</heartbeat>
                    <writeHost host="hostM1" url="192.168.37.101:3306" user="root"
                                       password="123456">
                            <readHost host="hostS2" url="192.168.37.100:3306" user="root" password="123456" />
                    </writeHost>
            </dataHost>
    </mycat:schema>

启动，进入到bin目录，执行如下命令

[root@k8s-node1 bin]# ./mycat 
    Usage: ./mycat {  console | start | stop | restart | status | dump }
    [root@k8s-node1 bin]# ./mycat start
    Starting Mycat-server...
    [root@k8s-node1 bin]# ./mycat status
    Mycat-server is running (82222).

mycat默认使用8066端口，我们使用sqlYog，用我们自定义的用户密码连接mycat，成功。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1YW5nYmFva2FuZw_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1YW5nYmFva2FuZw_size_16_color_FFFFFF_t_70]: /images/20221023/3df299eae3d1422e9ce6b622e4de98d0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h1YW5nYmFva2FuZw_size_16_color_FFFFFF_t_70 1]: /images/20221023/c7af0e57dae44d959b7e7773429f63d3.png