MariaDB [testdb]> CREATE TABLE data ENGINE=SPIDER  COMMENT='host "node1", user "monitor", password "password", port "3306"';

Query OK, 0 rows affected (0.014 sec)

MariaDB [testdb]> show create table data\G

*************************** 1. row ***************************

       Table: data

Create Table: CREATE TABLE `data` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `code` varchar(10) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=SPIDER DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='host "node1", user "monitor", password "password", port "3306"'

1 row in set (0.002 sec)

MariaDB [testdb]> CREATE TABLE data ENGINE=SPIDER  COMMENT='host "node1", user "monitor", password "password", port "3306"';

ERROR 12500 (HY000): unknown

MariaDB [testdb]> select * from mysql.servers;

+-------------+-------+--------+----------+----------+------+--------+---------+-------+

| Server_name | Host  | Db     | Username | Password | Port | Socket | Wrapper | Owner |

+-------------+-------+--------+----------+----------+------+--------+---------+-------+

| node1       | node1 | testdb | monitor  | password | 3306 |        | mariadb |       |

+-------------+-------+--------+----------+----------+------+--------+---------+-------+

1 row in set (0.001 sec)

MariaDB [testdb]>   CREATE TABLE remote_node1 ENGINE=SPIDER REMOTE_SERVER="node1" REMOTE_TABLE="data"

    -> ;

ERROR 12500 (HY000): unknown