MAC 安装mycat 入门
MAC 安装mycat 入门
HashTable 发表于1年前
MAC 安装mycat 入门
  • 发表于 1年前
  • 阅读 58
  • 收藏 1
  • 点赞 0
  • 评论 0

腾讯云 技术升级10大核心产品年终让利>>>   

  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

这说明分片成功了

 

共有 人打赏支持
粉丝 0
博文 33
码字总数 6555
×
HashTable
如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!
* 金额(元)
¥1 ¥5 ¥10 ¥20 其他金额
打赏人
留言
* 支付类型
微信扫码支付
打赏金额:
已支付成功
打赏金额: