Partition Backup / Restore

ColumnStore does not support partition backup and restore.
ColumnStore guides only full data backup except mysqldump.
I don't want to use mysqldump because of speed and management.

After several attempts, I found out how to back up and restore specific partitions.
Please confirm that the method below is correct.

▶ Informations.

• DB : test
• Table : security_tbl
• Backup Partition : 0

1. backup
1) Check the partition table information to be backed up.

MariaDB [(none)]> select calshowpartitions('test', 'security_tbl', 'stime');

2) make a script that backs up the* object_id files and the dictionary_object_id files* from 0th partition.
>> mcsmysql -e "set global group_concat_max_len=1024000;"
>> mcsmysql -e "select concat('tar cvf security_0.tar ', group_concat(distinct left(b.filename,length(b.filename)-11) separator ' ')) from information_schema.columnstore_columns a join information_schema.columnstore_files b on a.object_id = b.object_id or a.DICTIONARY_OBJECT_ID = b.object_id where a.table_schema = 'test' and a.table_name = 'security_tbl' and b.partition_id = '0';" -s > backup_security_0.sh

>> ./backup_security_0.sh

3) Make a script that back up the below files.
- table schema file(frm)
- BRM files (/usr/local/mariadb/columnstore/data1/systemFiles)
- Table and column info files (I'm not sure)
> /usr/local/mariadb/columnstore/data1/000.dir/000.dir/003.dir
> /usr/local/mariadb/columnstore/data1/000.dir/000.dir/004.dir
> /usr/local/mariadb/columnstore/data1/000.dir/000.dir/007.dir
> /usr/local/mariadb/columnstore/data1/000.dir/000.dir/008.dir

>> echo "tar cvzf security_0_meta.tgz /usr/local/mariadb/columnstore/mysql/db/test/ /usr/local/mariadb/columnstore/data1/000.dir/000.dir/003.dir/ /usr/local/mariadb/columnstore/data1/000.dir/000.dir/004.dir/ /usr/local/mariadb/columnstore/data1/000.dir/000.dir/007.dir/ /usr/local/mariadb/columnstore/data1/000.dir/000.dir/008.dir/ /usr/local/mariadb/columnstore/data1/systemFiles/" > backup_security_0_meta.sh

>> ./backup_security_0_meta.sh

2. Restore
1) Install ColumnStore on another server.
2) Copy the backup files to another server.
3) Restore the 0th partition file.
>> tar xvf security_0.tar -C /
3) Restore the meta files.
>> tar xvzf security_0_meta.tgz -C /
4) Restart Columnstore
>> mcsadmin restart
>> mcsadmin resumeDatabaseWrites

5) Show the Partitions.
MariaDB [(none)]> select calshowpartitions('test', 'security_tbl', 'stime');
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.00 sec)

6) Disable all Partitions.
MariaDB [(none)]> select caldisablepartitionsbyvalue('test', 'security_tbl', 'stime', '1900-01-01', '2100-01-01');
------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------
1 row in set (0.05 sec)

7) enable the 0th Partition.

MariaDB [(none)]> select calenablepartitions('test', 'security_tbl', '0.0.1');
------------------------------------------------------

------------------------------------------------------

------------------------------------------------------
1 row in set, 1 warning (0.04 sec)

MariaDB [(none)]> select calenablepartitions('test', 'security_tbl', '0.1.1');
------------------------------------------------------

------------------------------------------------------

------------------------------------------------------
1 row in set (0.04 sec)

MariaDB [(none)]> select calenablepartitions('test', 'security_tbl', '0.2.1');
------------------------------------------------------

------------------------------------------------------

------------------------------------------------------
1 row in set (0.04 sec)

MariaDB [(none)]> select calenablepartitions('test', 'security_tbl', '0.3.1');
------------------------------------------------------

------------------------------------------------------

------------------------------------------------------
1 row in set (0.05 sec)

We hope that this feature will be developed in the future.
Thank you.