在Cluster中的任一一个SQL节点上可以创建视图,但是其它的SQL节点不能同步共享该视图。
55.9上执行:
mysql> CREATE TABLE `pay` (
-> `deliver_time` timestamp,-> `pay_method` varchar(64),
-> `qo_item_id` int(10) unsigned,
-> `pay_amount` double(19,2)
-> ) ENGINE=NDB;
Query OK, 0 rows affected (0.19 sec)
mysql> show tables;
+---------------+
| Tables_in_gxf |
+---------------+
| pay |
+---------------+
1 row in set (0.01 sec)
mysql> create ALGORITHM=UNDEFINED view pay_view as select * from pay;
Query OK, 0 rows affected (0.02 sec)
mysql> show tables;
+---------------+
| Tables_in_gxf |
+---------------+
| pay |
| pay_view |
+---------------+
2 rows in set (0.01 sec)
55.10上执行:
mysql> show tables;
+---------------+
| Tables_in_gxf |
+---------------+
| pay |
+---------------+
1 row in set (0.01 sec)