- mysql的安装步骤请参考其他文档
- 下载mycat 选择mac版 地址:https://github.com/MyCATApache/Mycat-download
- 压缩在本地目录 /Users/mzd/dev/mycat
- 修改配置文件
-
wrapper.conf
#******************************************************************** # Wrapper Properties #******************************************************************** # Java Application wrapper.java.command=/Library/Java/JavaVirtualMachines/jdk1.7.0_76.jdk/Contents/Home/bin/java wrapper.working.dir=..
- schema.xml
-
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"> <heartbeat>select user()</heartbeat> <!-- can have multi write hosts --> <writeHost host="hostM1" url="localhost:3306" user="root" password="123456"> <!-- can have multi read hosts --> <!--<readHost host="hostS2" url="192.168.1.200:3306" user="root" password="xxx" />--> </writeHost> <!--<writeHost host="hostS1" url="localhost:3316" user="root"--> <!--password="123456" />--> <!-- <writeHost host="hostM2" url="localhost:3316" user="root" password="123456"/> --> </dataHost>
-
- 连接mysql 创建数据库
localhost:conf mzd$ mysql -uroot -p123456 Warning: Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 28 Server version: 5.6.25 MySQL Community Server (GPL) Copyright (c) 2000, 2015, 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> CREATE database db1; mysql> CREATE database db2; mysql> CREATE database db3;
- 测试mycat
localhost:conf muyl$ mysql -utest -ptest -h127.0.0.1 -P8066
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.8-mycat-1.5.1-RELEASE-20160622153300 MyCat Server (OpenCloundDB)
Copyright (c) 2000, 2015, 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> create table employee (id int not null primary key,name varchar(100),sharding_id int not null);
mysql>insert into employee(id,name,sharding_id) values(1,'leader us',10000);
mysql>insert into employee(id,name,sharding_id) values(2, 'me',10010);
mysql>insert into employee(id,name,sharding_id) values(3, 'mycat',10000);
mysql>insert into employee(id,name,sharding_id) values(4, 'mydog',10010);
分别到数据DB1,DB2查看,可以看到在DB1中有: 1 leader us 10000 3 mycat 10000 DB2中有: 2 me 10010 4 mydog 10010
这说明分片成功了