1. 参考文档，rest-api的确可以实现给后端MySQL添加本地用户，但radon只能在本机访问 报错如下： 2018/05/15 17:17:45.892306 auth.go:139: [ERROR] proxy: auth.user[root].failed(password.invalid):want[[89 223 240 70 44 7 2 202 154 74 149 248 53 42 238 70 192 194 109 206]]!=got[[77 34 129 174 3 224 34 45 152 251 202 58 202 169 175 254 225 178 11 148]] 2018/05/15 17:17:45.892361 server.go:153: [WARNING] server.user[root].auth.check.failed

[summary] When scatter sql to backends, the column name should be with quote '' e.g.: create table db.t(keyint primary key,colint); For the ddl with rename table, we remove all quotes \'' to uniform standars. e.g.: alter table t1 rename t2.

[test case] src/planner/ddl_plan_test.go

[patch codecov] src/planner/ddl_plan.go 95.1% coverage: 89.8% of statements

when create table with COLLATE,it is wrong: mysql> CREATE TABLE data_gps_htest ( -> CAR_ID VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_bin', -> IO_STTS VARCHAR(16) NULL DEFAULT NULL COLLATE 'utf8_bin', -> CAR_STTS VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_bin', -> ALARM_STTS VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_bin', -> EXTS VARCHAR(4000) NULL DEFAULT NULL COLLATE 'utf8_bin', -> GPS_TYPE VARCHAR(18) NULL DEFAULT NULL COLLATE 'utf8_bin', -> SGN_STTS VARCHAR(32) NULL DEFAULT NULL COLLATE 'utf8_bin', -> TMN_MILE INT(11) NULL DEFAULT NULL, -> INDEX DATA_GPS_H_IDX (CAR_ID) -> ) -> COLLATE='utf8_bin' -> ROW_FORMAT=COMPRESSED; ERROR 1149 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use, syntax error at position 79 near 'collate'

As mentioned in title, remote access failed, and radon server would log error server.unpack.auth.error: invalid authPluginName, got caching_sha2_password but only support mysql_native_password.

I guess it may related to the version of maraidb latest, any solution?

Besides, in local machine, enter into mysql command line, execute use mysql, would report ERROR 1227 (42000): Access denied; lacking privileges for database mysql

When the twopc-enable is true in the config，and execute the join which visit multiple backends，the client will hang, as the problem appears in TPCC. To avoid doing a lot of preparation about the TPCC environment，a simple example is as follows:

create database join_hang;
use join_hang;
CREATE TABLE `a` (`i` int(11) DEFAULT NULL,`j` varchar(255) DEFAULT NULL ) PARTITION BY HASH(i);
CREATE TABLE `b` (`i` int(11) DEFAULT NULL,`j` varchar(255) DEFAULT NULL ) PARTITION BY HASH(i);
insert into a(i,j) values(1,'a'),(2,'a'),(3,'a'),(4,'a');
insert into b(i,j) values(1,'a'),(2,'a'),(3,'a'),(4,'a');

mysql> select * from a;
+------+------+
| i    | j    |
+------+------+
|    1 | a    |
|    4 | a    |
|    3 | a    |
|    2 | a    |
+------+------+
4 rows in set (0.01 sec)

mysql> select * from b;
+------+------+
| i    | j    |
+------+------+
|    1 | a    |
|    4 | a    |
|    3 | a    |
|    2 | a    |
+------+------+
4 rows in set (0.01 sec)

mysql> select a.i, a.j, b.i, b.j from a join b where a.i<2 and b.j='a';
+------+------+------+------+
| i    | j    | i    | j    |
+------+------+------+------+
|    1 | a    |    1 | a    |
|    1 | a    |    4 | a    |
|    1 | a    |    3 | a    |
|    1 | a    |    2 | a    |
+------+------+------+------+
4 rows in set (0.01 sec)

mysql> select a.i, a.j, b.i, b.j from a join b where a.i<2 and b.j='a';

It will always hang for a long time.

Summary

We have 3 type tables:

1. global table: every backend has

CREATE TABLE t1(a int...) GLOBAL;

2. single table: on one deterministic backend

CREATE TABLE t1(a int...) SINGLE;

3. partition table: by hash

CREATE TABLE t1(a int...) PARTITION BY HASH(a);

4. If table without GLOBAL/SINGLE and PARITION BY HASH, we will do partition table conversion by PRIMARY KEY:

CREATE TABLE t1(a int parimary key) ;

to

CREATE TABLE t1(a int parimary key) PARTITION BY HASH(a);

WIP

• [x] Table type supports (@BohuTANG )
• [ ] Single Router (@zhyass )
• [ ] Single Table Planner (@zhyass )
• [ ] Single Table Rebalance (@zhyass )
• [ ] Document (@zhyass )
• [ ] Show Create Table with Table Type (@andyli029 )

[summary]

1. reference: https://dev.mysql.com/doc/refman/5.7/en/set-variable.html

SET variable = expr [, variable = expr] ...

variable: {
    user_var_name
  | param_name
  | local_var_name
  | {GLOBAL | @@GLOBAL.} system_var_name
  | [SESSION | @@SESSION. | @@] system_var_name
}

2. reference: https://dev.mysql.com/doc/refman/5.7/en/set-transaction.html

SET [GLOBAL | SESSION] TRANSACTION
    transaction_characteristic [, transaction_characteristic] ...

transaction_characteristic: {
    ISOLATION LEVEL level
  | access_mode
}

level: {
     REPEATABLE READ
   | READ COMMITTED
   | READ UNCOMMITTED
   | SERIALIZABLE
}

access_mode: {
     READ WRITE
   | READ ONLY
}

[test case] src/proxy/set_test.go src/vendor/github.com/xelabs/go-mysqlstack/sqlparser/set_test.go [patch codecov] src/proxy/set.go 94.6% src/vendor/github.com/xelabs/go-mysqlstack/sqlparser/ast.go 88.0%

table struct: CREATE TABLE wp_options ( option_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, option_name varchar(191) DEFAULT NULL, option_value longtext NOT NULL, autoload varchar(20) NOT NULL DEFAULT 'yes', PRIMARY KEY (option_id), UNIQUE KEY option_name (option_name) ) single;

SQL: INSERT INTO wp_options(option_id,option_name,option_value,autoload) VALUES(38,"active_plugins","a:4:{i:0;s:23:"anti-spap";}","yes");

Radon err:

2019/09/19 19:58:14.550460 query.go:69: [ERROR] query[INSERT INTO wp_options(option_id,option_name,option_value,autoload) VALUES(38,"active_plugins","a:4:{i:0;s:23:"anti-spap"].parser.error: syntax error at position 135 near 'a:4:{i:0;s:23:"anti-spap"' 2019/09/19 19:58:14.550505 server.go:240: [ERROR] server.handle.query.from.session[75].error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use, syntax error at position 135 near 'a:4:{i:0;s:23:"anti-spap"' (errno 1149) (sqlstate 42000).query[INSERT INTO wp_options(option_id,option_name,option_value,autoload) VALUES(38,"active_plugins","a:4:{i:0;s:23:"anti-spap"]

[summary] Now when we create user, it has all privileges, so we should give host and [select|insert|update|delete] options to limit the privilege.

[test case] TestCtlV1CreateUserError TestCtlV1CreateUserHostAndPriv TestCtlV1AlterUser TestCtlV1DropUser

[patch codecov] ctl/v1/user.go (96.6%)

[summary]

Syntax: RADON RESHARD tbl_name TO new_tbl_name

You can use RADON RESHARD to shift data from one SINGLE table to another PARTITION table, the cmd execute the shift cmd and will return immediately, the shift will run in background on other goroutine.

NOTICE: the SINGLE table with the primary key can be partitioned.

TODO: the shift progress bar will call other interface

[test case]

src/proxy/admin_reshard_test.go src/proxy/admin_shift_test.go src/router/frm_test.go

[patch codecov] src/proxy/admin_reshard.go: 98.4% src/proxy/admin_shift.go: 81.8% src/router/frm.go: 100%

https://github.com/radondb/radon/issues/480#issuecomment-636710899

[summary] Package errgroup provides synchronization, error propagation, and Context cancelation for groups of goroutines working on subtasks of a common task. We can use the errgroup to handle error under concurrency. [test case] N/A [patch codecov] src/backend/txn.go 89.8% src/backend/xa.go 91.1% src/executor/engine/join_engine.go 95.7% src/executor/engine/union_engine.go 93.9%

I create a sigle node radon with mysql5.7 follw docs how_to_build_and_run_radon.md

when Step5. Connect mysql client to radon respone " Access denied for user 'root' "

It means my username or passwd incorrect? what is the default username and passwd of radondb