Shulou(Shulou.com)06/01 Report--

After completing the mycat installation, start an example to get familiar with mycat as soon as possible

1. Environmental description 1. Server description server name address description mycat server 10.211.55.13mycat middleware server mysql server 10.211.55.9mysql server 2. Mysql library and table description library name indicates that db01 has only one user table db02item table db03item table

The item table on db02,db03 saves the data according to the id%2 model, that is, the data is segmented.

Db01 create table statement

CREATE TABLE `users` (`id`users` (11) NOT NULL AUTO_INCREMENT, `name` varchar (50) NOT NULL DEFAULT'', `indate`datetime NOT NULL DEFAULT '0000-00-0000: 0000 KEY (`id`) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8db02,db03 create the expression CREATE TABLE `item` (`id` int (11) NOT NULL AUTO_INCREMENT, `value`value`int (11) NOT NULL DEFAULT' 0) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf83, `indate`datetime NOT NULL DEFAULT '0000-00-0000: 00Rom 00mm prime KEY (`id`) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf83. Mycat server description

Mycat directory: / usr/local/mycat

At this point, our environment is ready.

2. Configure mycat service 1. Server.xml configuration

The path is at / usr/local/mycat/conf/server.xml

00 1 0 8066 9066 300000 0.0.0.0 4096 32 0 1 1m 1k 0 384m true 123456 TESTDB user TESTDB true 2. Configure rule.xml

The path is at: / usr/local/mycat/conf/rule.xml

Function must be under tableRule, or you will report an error and cannot find it.

Id mod-long 2 160 3. Configure schema.xml

The path is at: / usr/local/mycat/conf/schema.xml

The declaration must also be in order, with the least need to be called at the end.

Select user () 4. Start mycat > cd / usr/local/mycat/bin >. / mycat start

If an error occurs, you can view the / usr/local/mycat/logs/wrapper.log log

Third, verify 1. Verify the query write of the user table

The account number and password are declared by server.xml.

> / usr/local/mysql/bin/mysql-h20.211.55.13-uroot-P8066-p1234562. Check the library mysql > show databases;+-+ | DATABASE | +-+ | TESTDB | +-+ 1 row in set (0.00 sec)

Found a TESTDB library

3. View the table mysql > use TESTDB;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with-ADatabase changedmysql > show tables;+-+ | Tables in TESTDB | +-+ | item | | users | +-+ 2 rows in set (0.00 sec)

You see the item and users tables, which is the logical table we declared in schema.xml, which actually corresponds to the table on the mysql server

4. Verify that user writes mysql > insert into users (`id`, `name`, `indate`) values (1, 'test_name',' 2017-01-01'); Query OK, 1 row affected (0.08 sec) mysql >

If you look at the actual users table, the data also exists.

5. Verify query mysql > select * from users +-+ | id | name | indate | +-+ | 1 | test_name | 2017-01-01 00:00:00 | +-+- -+-+ 1 row in set (0.06 sec)

It can also be found that the execution was successful.

two。 Verify item Table 1. Verify write

Because if id is distributed, id cannot judge by itself, so id must be specified, otherwise an error will be prompted. This will be explained later on how to solve the problem

Mysql > insert into item (`id`, `value`, `indate`) values (1,1, '2017-01-01'); Query OK, 1 row affected (0.01sec)

Looking at the actual library, I found that it was written in the db03 library.

Write another

Mysql > insert into item (`id`, `value`, `indate`) values (2,2, '2017-01-01'); Query OK, 1 row affected (0.01sec)

It was found that it was written in the db02 library, so the sharding method was also successful.

two。 Verification query +-+ | id | value | indate | +-+ | 2 | 2 | 2017-01-01 00:00:00 | | 1 | 1 | 2017-01-01 00:00:00 | | +-+ 2 rows in set (0.03 sec) |

There are also two records.

Welcome to my blog.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.