dble
dble copied to clipboard
actiontech
A High Scalability Middle-ware for MySQL Sharding
* **dble version：** 5.6.29-dble-9.9.9.9-3973be7c76d1c0fc2f285a75c4218c27e57febe2-20190725053413 * **preconditions ：** no * **configs：** **server.xml** ```xml 111111 schema1,schema2,schema3 ``` * **steps：** step1. execute the following sql: ```sql show databases; -- This comment continues to...
* **dble version：** 5.6.29-dble-9.9.9.9-359645c-20181029082136 * **preconditions ：** no * **configs：** **schema.xml** ``` select user() select user() ``` **rule.xml** ``` id fixed_uniform_string id fixed_nonuniform_string id enum_integer id enum_string id range id...
Raised by: chenshujun Make a guide of testing and observing on GC algorithm choice.
* **dble version：5.6.29-dble-9.9.9.9-884fc6b612d64cc22101226536f8fd1d24580857-20190221031624** * preconditions *： ``` create table sharding_four(id int, c varchar(10)) charset utf8mb4; insert into sharding_four values(1, 'a'),(2, '吃'),(3,'啊'),(4,'吧'),(1004,'吃'); ``` schema.xml ``` ``` * **steps：** step1. execute sqls...
Raised by: @sevenFH As titled.
Raised by: helingyun **Steps:** 1. concurrently Query: ``` set autocommit = 0; update test_global1 set k=k-1 where id = 1; update test1 set k=k+1 where id = 666; commit; ```...
``` public class TestStatement { Connection conn=null; Statement stm=null; String sql_simple_sql="select * from t3"; String[] sql_muti_sql=new String[2]; String create_sql="create table t3(id int primary key,name varchar(8))"; String drop_sql="DROP TABLE IF EXISTS...
dble: ``` mysql> select @@sql_mode; +---------------------------------------------------------+ | @@sql_mode | +---------------------------------------------------------+ | IGNORE_SPACE,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | +---------------------------------------------------------+ 1 row in set (0.00 sec) ``` Two-node result set consistent: ``` mysql> select @@sql_mode; +--------------------------------------------+...
steps： ``` mysql> select HEX(R_bit) like (select 1) from test_shard; +--------------------------------+ | HEX(R_bit) LIKE ( SELECT 1 ) | +--------------------------------+ | 1 | | 0 | | 0 | |...
version:5.6.29-dble-2.18.02.0-dev-20180327092843 steps: 1, rename the attachment file to main.cpp 2, g++ -g main.cpp -o ps.o -I/opt/mysql/include -L/opt/mysql/lib -lmysqlclient 3,run [./ps.o] (ps:run [./ps.o debug] will get the result connecting directly to...
Metadata
Owner
Metadata
A High Scalability Middle-ware for MySQL Sharding