MAC 安装mycat 入门

2019独角兽企业重金招聘Python工程师标准>>>

1. mysql的安装步骤请参考其他文档
2. 下载mycat  选择mac版  地址：https://github.com/MyCATApache/Mycat-download
3. 压缩在本地目录  /Users/mzd/dev/mycat
4. 修改配置文件

   1. wrapper.conf

      #********************************************************************
      # Wrapper Properties
      #********************************************************************
      # Java Application
      wrapper.java.command=/Library/Java/JavaVirtualMachines/jdk1.7.0_76.jdk/Contents/Home/bin/java
      wrapper.working.dir=..
      

       

   2. schema.xml 

   3. <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>

       

5. 连接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;

    

6. 测试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

这说明分片成功了

 

转载于:https://my.oschina.net/tank1988/blog/706838