mycat在windows环境下的安装和启动

腾讯网友春天之虎 發表於 2023-8-21 00:00:00

<p>
<span><strong> 1、下载</strong></span></p>
<p>
从如下地址下载mycat的安装包：</p>
<p>
http://www.mycat.io/</p>
<p>
<span><strong>2、解压</strong></span></p>
<p>
解压下载的安装包</p>
<p>
<span><strong>3、安装</strong></span></p>
<p>
安装mycat前需要先安装jdk和mysql。mycat1.6版本建议使用的jdk是1.7以上版本，mysql建议使用5.6版本。安装玩jdk和mysql后，进入mycat解压目录下的bin目录，如本文的路径如下：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_299833">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">D:\Program Files (x86)\mycat\bin</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
安装shift键，点击鼠标右键，选择"在此处打开命令窗口"打开命令行窗口（注意需要管理员账户登录，如果不是请使用管理员身份运行cmd打开命令行窗口）。在打开的命令行窗口中执行如下命令安装mycat：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_220004">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">mycat.bat </code><code class="bash functions">install</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<span><strong>4、启动和停止</strong></span></p>
<p>
可以使用如下命令启动mycat服务</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_769655">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">mycat.bat start</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
启动后可以通过如下命令查看mycat的运行状态：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_734893">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">mycat.bat status</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
可以使用如下命令停止mycat服务</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_279526">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">mycat.bat stop</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<span><strong>5、测试</strong></span></p>
<p>
5.1、修改mycat与mysql的链接信息</p>
<p>
我们打开mycat安装目录，并进入conf目录，打开schema.xml配置文件，schema.xml配置文件是mycat中重要的配置文件之一，它涵盖了mycat的逻辑库、表、分片规则、分批按节点及数据源。这里我们对默认的schema.xml进行简单的修改配置（注意备份一个原始的配置文件），主要配置本机的mysql链接信息。找到dataHost节点，按照当前自己mysql的配置信息来修改配置。如下为我修改后的该部分配置：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_345080">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"><dataHost name=</code><code class="bash string">"localhost1"</code> <code class="bash plain">maxCon=</code><code class="bash string">"1000"</code> <code class="bash plain">minCon=</code><code class="bash string">"10"</code> <code class="bash plain">balance=</code><code class="bash string">"0"</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash spaces">     </code><code class="bash plain">writeType=</code><code class="bash string">"0"</code> <code class="bash plain">dbType=</code><code class="bash string">"mysql"</code> <code class="bash plain">dbDriver=</code><code class="bash string">"native"</code> <code class="bash plain">switchType=</code><code class="bash string">"1"</code> <code class="bash plain">slaveThreshold=</code><code class="bash string">"100"</code><code class="bash plain">> </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash spaces">  </code><code class="bash plain"><heartbeat></code><code class="bash functions">select</code> <code class="bash plain">user()<</code><code class="bash plain">/heartbeat</code><code class="bash plain">> </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash spaces">  </code><code class="bash plain"> </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash spaces">  </code><code class="bash plain"><writeHost host=</code><code class="bash string">"hostM1"</code> <code class="bash plain">url=</code><code class="bash string">"localhost:3306"</code> <code class="bash plain">user=</code><code class="bash string">"root"</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash spaces">        </code><code class="bash plain">password=</code><code class="bash string">"root"</code><code class="bash plain">> </code>
</div>
<div class="line number7 index6 alt2">
<code class="bash spaces">    </code><code class="bash plain"> </code>
</div>
<div class="line number8 index7 alt1">
<code class="bash spaces">    </code><code class="bash plain"> </code>
</div>
<div class="line number9 index8 alt2">
<code class="bash spaces">  </code><code class="bash plain"><</code><code class="bash plain">/writeHost</code><code class="bash plain">> </code>
</div>
<div class="line number10 index9 alt1">
<code class="bash spaces">  </code><code class="bash plain"> </code>
</div>
<div class="line number14 index13 alt1">
<code class="bash spaces">  </code><code class="bash plain"> </code>
</div>
<div class="line number15 index14 alt2">
<code class="bash plain"><</code><code class="bash plain">/dataHost</code><code class="bash plain">></code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
我主要修改了hostM1的链接密码，同时注释了名称为hostS2的只读标签和名称为hostM2的写标签。</p>
<p>
5.2、创建数据库</p>
<p>
按照schema.xml配置中的示例，我们需要建立分别名为db1、db2、db3的数据库。链接mysql，建立相关的数据库：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_216209">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">mysql -uroot -proot; </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">create database db1 character </code><code class="bash functions">set</code> <code class="bash plain">utf8; </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">create database db2 character </code><code class="bash functions">set</code> <code class="bash plain">utf8; </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">create database db3 character </code><code class="bash functions">set</code> <code class="bash plain">utf8;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
5.3、链接数据库</p>
<p>
使用数据库链接工具或命令。本文使用navicat链接数据库。使用navicat链接数据库时的主要参数配置如下：</p>
<p>
端口号：8066</p>
<p>
用户名和密码可以查看mycat conf目录中的server.xml中的定义，本文使用的是默认的root,123456来连接，连接成功后只能操作名为TESTDB的数据库；</p>
<p>
5.4、全局表的测试</p>
<p>
使用navicat打开命令列界面。输入如下命令创建数据表：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_757565">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">USE TESTDB; </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">create table company(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100),sharding_id int not null);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
之后使用如下命令查看创建表命令的执行状态：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_506159">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">explain create table company(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100),sharding_id int not null);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
因为company在schema.xml中北定义为了全局表，所以正常情况下可以看到如下类似结果：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_521888">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">+-----------+----------------------------------------------------------------------------------------------+ </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">| DATA_NODE | SQL                                             | </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">+-----------+----------------------------------------------------------------------------------------------+ </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">| dn1    | create table company(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100),sharding_id int not null) | </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">| dn2    | create table company(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100),sharding_id int not null) | </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">| dn3    | create table company(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100),sharding_id int not null) | </code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">+-----------+----------------------------------------------------------------------------------------------+ </code>
</div>
<div class="line number8 index7 alt1">
<code class="bash spaces"> </code><code class="bash plain">rows </code><code class="bash keyword">in</code> <code class="bash functions">set</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
紧接着我们尝试执行如下命令执行一条插入数据的操作：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_947339">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">insert into company(</code><code class="bash functions">id</code><code class="bash plain">,name,sharding_id) values(1,</code><code class="bash string">'leader us'</code><code class="bash plain">,10000);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
然后类似执行explain命令查看insert命令的执行状态：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_502360">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">explain insert into company(</code><code class="bash functions">id</code><code class="bash plain">,name,sharding_id) values(1,</code><code class="bash string">'leader us'</code><code class="bash plain">,10000);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
正常情况下我们会看到如下结果：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_204436">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">+-----------+----------------------------------------------------------------------+ </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">| DATA_NODE | SQL                                 | </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">+-----------+----------------------------------------------------------------------+ </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">| dn1    | insert into company(</code><code class="bash functions">id</code><code class="bash plain">,name,sharding_id) values(1,</code><code class="bash string">'leader us'</code><code class="bash plain">,10000) | </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">| dn2    | insert into company(</code><code class="bash functions">id</code><code class="bash plain">,name,sharding_id) values(1,</code><code class="bash string">'leader us'</code><code class="bash plain">,10000) | </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">| dn3    | insert into company(</code><code class="bash functions">id</code><code class="bash plain">,name,sharding_id) values(1,</code><code class="bash string">'leader us'</code><code class="bash plain">,10000) | </code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">+-----------+----------------------------------------------------------------------+ </code>
</div>
<div class="line number8 index7 alt1">
<code class="bash spaces"> </code><code class="bash plain">rows </code><code class="bash keyword">in</code> <code class="bash functions">set</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
之后我们直接登录到mysql服务器分别查看db1、db2、db3三个数据库，可以看到数据库中都创建了名为company的数据表，同时表中都插入了名为leader us的数据。</p>
<p>
5.5、水平分表测试</p>
<p>
如5.4中的操作。我们在navicat的命令列窗口中执行如下命令创建travelrecord表：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_558302">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">create table travelrecord(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100));</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
之后使用explain查看：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_639090">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">explain create table travelrecord(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100));</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
结果如下：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_900417">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">+-----------+--------------------------------------------------------------------------+ </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">| DATA_NODE | SQL                                   | </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">+-----------+--------------------------------------------------------------------------+ </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">| dn1    | create table travelrecord(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100)) | </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">| dn2    | create table travelrecord(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100)) | </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">| dn3    | create table travelrecord(</code><code class="bash functions">id</code> <code class="bash plain">int not null primary key,name varchar(100)) | </code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">+-----------+--------------------------------------------------------------------------+ </code>
</div>
<div class="line number8 index7 alt1">
<code class="bash spaces"> </code><code class="bash plain">rows </code><code class="bash keyword">in</code> <code class="bash functions">set</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
然后执行如下命令插入一条数据：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_946050">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">insert into travelrecord(</code><code class="bash functions">id</code><code class="bash plain">,name) values(1,</code><code class="bash string">'hp'</code><code class="bash plain">);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
执行explain查看执行结果：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_845583">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">explain insert into travelrecord(</code><code class="bash functions">id</code><code class="bash plain">,name) values(1,</code><code class="bash string">'hp'</code><code class="bash plain">);</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
结果如下：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_984848">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">+-----------+--------------------------------------------------+ </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">| DATA_NODE | SQL                       | </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">+-----------+--------------------------------------------------+ </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">| dn1    | insert into travelrecord(</code><code class="bash functions">id</code><code class="bash plain">,name) values(1,</code><code class="bash string">'hp'</code><code class="bash plain">) | </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">+-----------+--------------------------------------------------+ </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash spaces"> </code><code class="bash plain">row </code><code class="bash keyword">in</code> <code class="bash functions">set</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
可以登录到数据库分别查看，三个数据库中都创建了travelrecord的数据表，但是仅db1（dn1对应的数据库）中插入了数据。</p>
<p>
原文链接：https://blog.csdn.net/singgel/article/details/79699468</p>

頁: [1]

琼殿技术论坛's Archiver

mycat在windows环境下的安装和启动