[root@expmcsffooo2-mdb-cs-single-0 /]# mcsadmin getsystemi
|
getsysteminfo Thu Jan 23 15:37:41 2020
|
|
System columnstore-1
|
|
System and Module statuses
|
|
Component Status Last Status Change
|
------------ -------------------------- ------------------------
|
System ACTIVE Thu Jan 23 15:29:16 2020
|
|
Module pm1 ACTIVE Thu Jan 23 15:29:13 2020
|
|
|
MariaDB ColumnStore Process statuses
|
|
Process Module Status Last Status Change Process ID
|
------------------ ------ --------------- ------------------------ ----------
|
ProcessMonitor pm1 ACTIVE Thu Jan 23 15:27:12 2020 485
|
ProcessManager pm1 ACTIVE Thu Jan 23 15:27:20 2020 607
|
StorageManager pm1 ACTIVE Thu Jan 23 15:28:34 2020 3081
|
DBRMControllerNode pm1 ACTIVE Thu Jan 23 15:28:53 2020 3191
|
ServerMonitor pm1 ACTIVE Thu Jan 23 15:28:54 2020 3221
|
DBRMWorkerNode pm1 ACTIVE Thu Jan 23 15:28:55 2020 3251
|
PrimProc pm1 ACTIVE Thu Jan 23 15:28:59 2020 3406
|
ExeMgr pm1 ACTIVE Thu Jan 23 15:29:03 2020 3461
|
WriteEngineServer pm1 ACTIVE Thu Jan 23 15:29:07 2020 3522
|
DDLProc pm1 ACTIVE Thu Jan 23 15:29:11 2020 3579
|
DMLProc pm1 ACTIVE Thu Jan 23 15:29:16 2020 3626
|
mysqld pm1 ACTIVE Thu Jan 23 15:28:33 2020 3016
|
|
Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0
|
[root@expmcsffooo2-mdb-cs-single-0 /]# mysql
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 40
|
Server version: 10.4.11-5-MariaDB-enterprise-log MariaDB Enterprise Server
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
MariaDB [(none)]> create database b ;
|
Query OK, 1 row affected (0.004 sec)
|
|
MariaDB [(none)]> show databases ;
|
+---------------------+
|
| Database |
|
+---------------------+
|
| b |
|
| calpontsys |
|
| columnstore_info |
|
| infinidb_querystats |
|
| information_schema |
|
| mysql |
|
| performance_schema |
|
+---------------------+
|
7 rows in set (0.001 sec)
|
|
MariaDB [(none)]> create database a ;
|
Query OK, 1 row affected (0.005 sec)
|
|
MariaDB [(none)]> create database c ;
|
Query OK, 1 row affected (0.005 sec)
|
|
MariaDB [(none)]> create database d ;
|
Query OK, 1 row affected (0.005 sec)
|
|
MariaDB [(none)]>
|
MariaDB [(none)]> create table a.a ( a int) engine innidb ;
|
ERROR 1286 (42000): Unknown storage engine 'innidb'
|
MariaDB [(none)]> create table a.a ( a int) engine innodb ;
|
Query OK, 0 rows affected (0.017 sec)
|
|
MariaDB [(none)]> create table b.b ( a int) engine innodb ;
|
Query OK, 0 rows affected (0.021 sec)
|
|
MariaDB [(none)]> create table d.d ( a int) engine innodb ;
|
Query OK, 0 rows affected (0.020 sec)
|
|
MariaDB [(none)]> create table c.a ( a int) engine columnstore ;
|
Query OK, 0 rows affected (0.372 sec)
|
|
MariaDB [(none)]> create table c.b ( a int) engine columnstore ;
|
Query OK, 0 rows affected (1.066 sec)
|
|
MariaDB [(none)]> create table c.d ( a int) engine columnstore ;
|
Query OK, 0 rows affected (0.277 sec)
|
|
|
MariaDB [(none)]> create table a.a1 ( a int) engine innodb ;
|
Query OK, 0 rows affected (0.023 sec)
|
|
MariaDB [(none)]> create table a.a2 ( a int) engine innodb ;
|
Query OK, 0 rows affected (0.017 sec)
|
|
MariaDB [(none)]> create table c.a1 ( a int) engine columnstore ;
|
Query OK, 0 rows affected (0.312 sec)
|
|
MariaDB [(none)]> create table c.a2 ( a int) engine columnstore ;
|
Query OK, 0 rows affected (0.295 sec)
|
|
MariaDB [(none)]> select set_replications('a|a1|a2','a','c');
|
+-------------------------------------+
|
| set_replications('a|a1|a2','a','c') |
|
+-------------------------------------+
|
| Success. |
|
+-------------------------------------+
|
1 row in set (0.021 sec)
|
|
MariaDB [(none)]> insert into a.a values (1),(2),(3);
|
Query OK, 3 rows affected (0.008 sec)
|
Records: 3 Duplicates: 0 Warnings: 0
|
|
MariaDB [(none)]> select * from c.a ;
|
Empty set (0.087 sec)
|
|
MariaDB [(none)]> select list_replications();
|
+----------------------------------------------------------------------------------------+
|
| list_replications() |
|
+----------------------------------------------------------------------------------------+
|
|
|
=== replication_filter ===
|
table: a|a1|a2
|
source database: a
|
target database: c
|
|
|
|
+----------------------------------------------------------------------------------------+
|
1 row in set (0.002 sec)
|
|
MariaDB [(none)]> show create table c.a;
|
+-------+-------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------------------------------------------+
|
| a | CREATE TABLE `a` (
|
`a` int(11) DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=latin1 |
|
+-------+-------------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> show create table a.a;
|
+-------+--------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+--------------------------------------------------------------------------------------+
|
| a | CREATE TABLE `a` (
|
`a` int(11) DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+--------------------------------------------------------------------------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> select * from a.a ;
|
+------+
|
| a |
|
+------+
|
| 1 |
|
| 2 |
|
| 3 |
|
+------+
|
3 rows in set (0.000 sec)
|
|
MariaDB [(none)]> select * from c.a ;
|
Empty set (0.010 sec)
|
|