国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

<table name=nt_noden primaryKey=nvidn autoincrement=ntruen dataNode=ndn1,dn2n rule=nrule1n />

非分片表

<table name=nt_noden primaryKey=nvidn autoincrement=ntruen dataNode=ndn1" />

wget  https://github.com/MyCATApache/Mycat-download/raw/master/1.5-RELEASE/Mycat-server-1.5.1-RELEASE-20160622153300-linux.tar.gz
tar zxf Mycat-server-1.5.1-RELEASE-20160622153300-linux.tar.gz
mv mycat  /application/
echo "export PATH=/application/mycat/bin:$PATH">>/etc/profile
source /etc/profile
echo $PATH

wget http://download.oracle.com/otn-pub/java/jdk/8u91-b14/jdk-8u91-linux-x64.rpm
rpm -ivh jdk-8u91-linux-x64.rpm

配置環(huán)境變量

echo "export JAVA_HOME=/usr/java/jdk1.8.0_91/"   >>/etc/profile
echo "export PATH=$JAVA_HOME/bin:/application/mycat/bin/:$PATH">>/etc/profile
echo "export CLASSPATH=$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar">>/etc/profile
source  /etc/profile
[root@Linuxdemo3 ~]# java -version
java version "1.8.0_91"
Java(TM) SE RuntimeEnvironment(build 1.8.0_91-b14)
JavaHotSpot(TM)64-BitServer VM (build 25.91-b14, mixed mode)

主庫(kù)上對(duì)rep和rep_r用戶授權(quán)如下：
用戶：rep  密碼：oldboy 端口：3306
權(quán)限：all
命令：
grant replication slave on test.* to 'rep'@'10.0.0.%' identified by 'oldboy';
grant replication slave on test.* to 'rep_r'@'10.0.0.%' identified by 'oldboy';
flush privileges;
注：為了方便下面的主從切換，兩個(gè)用戶都授予了所有的權(quán)限，生產(chǎn)環(huán)境盡量不要這樣子授權(quán)！

[root@Linuxdemo3 mycat]# pwd
/application/mycat
[root@Linuxdemo3 mycat]# ll
total 24
drwxr-xr-x 2 root root 4096Jul  403:13 bin
drwxrwxrwx 2 root root 4096Dec13  2015 catlet
drwxrwxrwx 2 root root 4096Jul  403:13 conf
drwxr-xr-x 2 root root 4096Jul  403:13 lib
drwxrwxrwx 2 root root 4096Dec13  2015 logs
-rwxrwxrwx 1 root root  219Jun2215:33 version.txt

[root@Linuxdemo3 conf]#  vim server.xml
        </system>
        <user name="rep">
                <property name="password">oldboy</property>
                <property name="schemas">test</property>
        </user>
        <user name="rep_r">
                <property name="password">oldboy</property>
                <property name="schemas"> test</property>
                <property name="readOnly">true</property>
        </user>

[root@Linuxdemo3 conf]#  vim schema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://org.opencloudb/">
        <schema name="test" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
        </schema>
        <dataNode name="dn1" dataHost="localhost1" database="test"/>
        <dataNode name="dn2" dataHost="localhost1" database=" test "/>
        <dataNode name="dn3" dataHost="localhost1" database=" test "/>
        <dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"
                writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
                <heartbeat>select user()</heartbeat>
                <writeHost host="hostM1" url="10.0.0.202:3306" user="rep"
                        password="oldboy">
                </writeHost>
                 <readHost host="hostS1" url="10.0.0.202:3307" user="rep_r"
                        password="oldboy"/>
                 </readHost>
                 </dataHost>             
</mycat:schema>

<dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"
                writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">

需要配置的位置：

balance="1"   writeType="0"   switchType="1"

balance

writeType 

switchType 

<writeHost host="hostM1" url="10.0.0.202:3306" user="rep"
                        password="oldboy">
                        <!-- can have multi read hosts -->
                <readHost host="hostS1" url="10.0.0.202:3306" user="rep_r"
                        password="oldboy"/>

[root@Linuxdemo3 conf]#/application/mycat/bin/mycat start
StartingMycat-server...
[root@Linuxdemo3 logs]#

mysql -urep -poldboy -h10.0.0.202 -P8066
mysql> explain create table company(id int not null primary key,name varchar(100));
+-----------+---------------------------------------------------------------------+
| DATA_NODE | SQL                                                                 |
+-----------+---------------------------------------------------------------------+
| dn1       | create table company(id int not null primary key,name varchar(100)) |
| dn2       | create table company(id int not null primary key,name varchar(100)) |
| dn3       | create table company(id int not null primary key,name varchar(100)) |
+-----------+---------------------------------------------------------------------+
3 rows in set (0.06 sec)
 
mysql> create table company(id int not null primary key,name varchar(100));
Query OK, 0 rows affected (1.82 sec)
 
mysql> explain insert into company(id, name) values (100, 'abc');
+-----------+---------------------------------------------------+
| DATA_NODE | SQL                                               |
+-----------+---------------------------------------------------+
| dn1       | insert into company(id, name) values (100, 'abc') |
| dn2       | insert into company(id, name) values (100, 'abc') |
| dn3       | insert into company(id, name) values (100, 'abc') |
+-----------+---------------------------------------------------+
3 rows in set (0.00 sec)
 
mysql> insert into company(id, name) values (100, 'abc');
Query OK, 1 row affected (0.24 sec)

[root@Linuxdemo3 conf]#  vim schema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://org.opencloudb/">
        <schema name="test" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
        </schema>
        <dataNode name="dn1" dataHost="localhost1" database="test"/>
        <dataNode name="dn2" dataHost="localhost1" database=" test "/>
        <dataNode name="dn3" dataHost="localhost1" database=" test "/>
        <dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"
                writeType="0" dbType="mysql" dbDriver="native" switchType="2"  slaveThreshold="100">
                <heartbeat>show slave status</heartbeat>
                <writeHost host="hostM1" url="10.0.0.202:3306" user="rep"
                        password="oldboy">
                </writeHost>
                 <readHost host="hostS1" url="10.0.0.202:3307" user="rep_r"
                        password="oldboy"/>
                 </readHost>
<writeHost host="hostM2" url="10.0.0.202:3307" user="rep"
                        password="oldboy">
                </writeHost>
                 </dataHost>             
</mycat:schema>

重啟mycat服務(wù)

[root@Linuxdemo2 conf]#/application/mycat/bin/mycat restart
StoppingMycat-server...
StoppedMycat-server.
StartingMycat-server...

[root@Linuxdemo2 conf]#/data/3306/mysql stop

/application/mycat/bin/xml_to_yaml.sh	根據(jù)mycat配置生成 zookeeper yaml 配置工具
/application/mycat/bin/init_zk_data.sh	將生成的yaml配置文件導(dǎo)入遠(yuǎn)程zookeeper
/application/mycat/conf/myid.properties	zookeeper 路徑配置參數(shù)信息
/application/mycat/conf/zk-create.yaml	自動(dòng)生成的zk配置
1）確認(rèn)安裝好zookeeper 環(huán)境 
2）啟動(dòng)mycat服務(wù)，確認(rèn)本地服務(wù)一切正常。 
3）執(zhí)行xml_to_yaml.sh腳本（確認(rèn)本地配置過 JAVA_HOME 和 MYCAT_HOME環(huán)境變量，）
[root@Linuxdemo3 bin]#./xml_to_yaml.sh
4)執(zhí)行 init_zk_data.sh 腳本,注意下默認(rèn)情況下腳本會(huì)將zookeeper定位在同一臺(tái)服務(wù)器上面，如有需要可以調(diào)整下 ZK 的 IP : PORT
[root@Linuxdemo3 bin]#./init_zk_data.sh

管理命令與監(jiān)控

mysql -urep -poldboy  -h10.0.0.202-P9066 -Dtest   

mysql> show @@help;
+--------------------------------------+-----------------------------------+
| STATEMENT                            | DESCRIPTION                       |
+--------------------------------------+-----------------------------------+
| clear @@slowwhere datanode =?      |Clear slow sql by datanode        |
| clear @@slowwhere schema =?        |Clear slow sql by schema          |
| kill @@connection id1,id2,...        |Kill the specified connections    |
| offline                              |ChangeMyCat status to OFF        |
| online                               |ChangeMyCat status to ON         |
| reload @@config                      |Reload basic config from file     |
| reload @@config_all                  |Reload all config from file       |
| reload @@route                       |Reload route config from file     |
| reload @@user                        |Reload user config from file      |
| rollback @@config                    |Rollback all config from memory   |
| rollback @@route                     |Rollback route config from memory |
| rollback @@user                      |Rollback user config from memory  |
| show @@backend                       |Report backend connection status  |
| show @@cache                         |Report system cache usage         |
| show @@command                       |Report commands status            |
| show @@connection                    |Report connection status          |
| show @@connection.sql                |Report connection sql             |
| show @@database                      |Report databases                  |
| show @@datanode                      |Report dataNodes                  |
| show @@datanodewhere schema =?     |Report dataNodes                  |
| show @@datasource                    |Report dataSources                |
| show @@datasourcewhere dataNode =?|Report dataSources                |
| show @@heartbeat                     |Report heartbeat status           |
| show @@parser                        |Report parser status              |
| show @@processor                     |Report processor status           |
| show @@router                        |Report router status              |
| show @@server                        |Report server status              |
| show @@session                       |Report front session details      |
| show @@slowwhere datanode =?       |Report datanode slow sql          |
| show @@slowwhere schema =?         |Report schema slow sql            |
| show @@sqlwhere id =?              |Report specify SQL                |
| show @@sql.detail where id =?       |Report execute detail status      |
| show @@sql.execute                   |Report execute status             |
| show @@sql.slow                      |Report slow SQL                   |
| show @@threadpool                    |Report threadPool status          |
| show @@time.current                  |Report current timestamp          |
| show @@time.startup                  |Report startup timestamp          |
| show @@version                       |ReportMycatServer version       |
| stop @@heartbeat name:time           |Pause dataNode heartbeat          |
|switch@@datasource name:index       |Switch dataSource    

2、更新配置文件

mysql> reload @@config;
Query OK,1 row affected (0.13 sec)
Reload config success

3、顯示mycat數(shù)據(jù)庫(kù)的列表，對(duì)應(yīng)的在scehma.xml配置的邏輯庫(kù)

mysql> show @@database;
+----------+
| DATABASE |
+----------+
| oldboy   |
+----------+
1 row in set(0.00 sec)

mysql> show @@datanode;
+------+-------------------+-------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| NAME | DATHOST           | INDEX | TYPE  | ACTIVE | IDLE | SIZE | EXECUTE | TOTAL_TIME | MAX_TIME | MAX_SQL | RECOVERY_TIME |
+------+-------------------+-------+-------+--------+------+------+---------+------------+----------+---------+---------------+
| dn1  | localhost1/oldboy |     0| mysql |      0|   10|1000|     457|          0|        0|       0|            -1|
| dn2  | localhost1/oldboy |     0| mysql |      0|   10|1000|     457|          0|        0|       0|            -1|
| dn3  | localhost1/oldboy |     0| mysql |      0|   10|1000|     457|          0|        0|       0|            -1|
+------+-------------------+-------+-------+--------+------+------+---------+------------+----------+---------+---------------+
3 rows in set(0.00 sec)

mysql> show @@heartbeat;
+--------+-------+-------------+------+---------+-------+--------+---------+--------------+---------------------+-------+
| NAME   | TYPE  | HOST        | PORT | RS_CODE | RETRY | STATUS | TIMEOUT | EXECUTE_TIME | LAST_ACTIVE_TIME    | STOP  |
+--------+-------+-------------+------+---------+-------+--------+---------+--------------+---------------------+-------+
| hostM1 | mysql |10.0.0.202|3306|       1|     0| idle   |       0|1,1,1        |2015-12-2921:39:40|false|
| hostS1 | mysql |10.0.0.202|3307|       1|     0| idle   |       0|3,3,3        |2015-12-2921:39:40|false|
+--------+-------+-------------+------+---------+-------+--------+---------+--------------+---------------------+-------+
2 rows in set(0.01 sec)

mysql> show @@version;
+--------------------------------------+
| VERSION                              |
+--------------------------------------+
|5.5.8-mycat-1.4-alpha-20150520235658|
+--------------------------------------+
1 row in set(0.00 sec)

mysql> show @@connection;
+------------+------+-----------+------+------------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
| PROCESSOR  | ID   | HOST      | PORT | LOCAL_PORT | SCHEMA | CHARSET | NET_IN | NET_OUT | ALIVE_TIME(S)| RECV_BUFFER | SEND_QUEUE | txlevel | autocommit |
+------------+------+-----------+------+------------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
|Processor0|    6|127.0.0.1|9066|      46490| oldboy | utf8:33|    281|    6164|          1008|        4096|          0|         |            |
+------------+------+-----------+------+------------+--------+---------+--------+---------+---------------+-------------+------------+---------+------------+
1 row in set(0.00 sec)

mysql> show @@backend;
+------------+------+---------+-------------+------+--------+--------+---------+------+--------+----------+------------+--------+---------+---------+------------+
| processor  | id   | mysqlId | host        | port | l_port | net_in | net_out | life | closed | borrowed | SEND_QUEUE | schema | charset | txlevel | autocommit |
+------------+------+---------+-------------+------+--------+--------+---------+------+--------+----------+------------+--------+---------+---------+------------+
|Processor0|    1|      30|10.0.0.202|3306|  14881|   3554|    1068|5041|false  |false    |          0| oldboy | utf8:33|3       |true       |
|Processor0|    2|      32|10.0.0.202|3306|  14883|   3554|    1068|5041|false  |false    |          0| oldboy | utf8:33|3       |true       |
|Processor0|    3|      24|10.0.0.202|3306|  14875|   3515|    1068|5041|false  |false    |          0| oldboy | utf8:33|3       |true       |
|Processor0|    4|      28|10.0.0.202|3306|  14879|   3561|     986|5041|false  |false    |          0| oldboy | utf8:33|0       |true       |

9、顯示數(shù)據(jù)源

mysql> show @@datasource;
+----------+--------+-------+-------------+------+------+--------+------+------+---------+
| DATANODE | NAME   | TYPE  | HOST        | PORT | W/R  | ACTIVE | IDLE | SIZE | EXECUTE |
+----------+--------+-------+-------------+------+------+--------+------+------+---------+
| dn1      | hostM1 | mysql |10.0.0.202|3306| W    |      0|   10|1000|     525|
| dn1      | hostS1 | mysql |10.0.0.202|3306| R    |      0|    8|1000|     522|
| dn3      | hostM1 | mysql |10.0.0.202|3306| W    |      0|   10|1000|     525|
| dn3      | hostS1 | mysql |10.0.0.202|3306| R    |      0|    8|1000|     522|
| dn2      | hostM1 | mysql |10.0.0.202|3306| W    |      0|   10|1000|     525|
| dn2      | hostS1 | mysql |10.0.0.202|3306| R    |      0|    8|1000|     522|
+----------+--------+-------+-------------+------+------+--------+------+------+---------+
6 rows in set(0.01 sec)