Backup options in Columnstore

[Kladizkov theone]

How do we take a backup of data from MariaDB Columnstore? Suppose if the database size exceeds 800 GB? What options do I have?

[Todd Stoffel]

Something like this would work:

#!/bin/bash

rm -rf /backup

mkdir -p /backup/{mysql,columnstore}

mariadb-backup --user=your_user --password=your_password --backup --rsync --target-dir=/backup/mysql

mcs cluster set mode --mode readonly

rsync -av /var/lib/columnstore/ /backup/columnstore/

mcs cluster set mode --mode readwrite

[Kladizkov theone]

Thank you for the reply.

How long do you think the "mariadb-backup" might take to backup a db of size 800 GB? I know this can vary due to various factors, but could you please provide an approx based on your experience?

[Faisal Saeed]

Hi Kladizkov,

As you already stated, it depends on various factors like Storage speed and your current rate of TPS on the InnoDB tables, but typically I have seen 1TB or database take around 30 minutes to 1 hour to backup and then you would still need to execute "maria-backup --prepare" which will take longer if the server was very busy with ongoing transactions if the server is low utilization or idle, then the prepare stage would take a few seconds.

Best Regards,

Faisal Saeed | Principal Solution Architect

MariaDB Corporation | Tel: +65 9386 5771 | fai...@mariadb.com | Twitter: @RF_FaisalZ

Schedule a Meeting with me

--
You received this message because you are subscribed to the Google Groups "MariaDB ColumnStore" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mariadb-columns...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/mariadb-columnstore/396630f4-5557-40d5-a5aa-3aa9553eb4a8n%40googlegroups.com.

[Todd Stoffel]

How much of that 800 GB is in Columnstore vs InnoDB?