I'm having a Galera cluster (3 nodes, but currently using only one), MariaDB 10.0 Galera.
However, my ibdata1 is growing HUGE (although using inno_file_per_table=1).
Now i want to "shrink" it by using mysqldump (see here) but this is a really time consuming task for my load (around 12-15 hours, tried it with an equal server) The database size we are talking about is around 150G (and ibdata1 grew to 163G over years due to unclever decisions). Now my main goal is to reduce downtime, say: Only the time it takes to create the dump.
My idea was to use mysqldump as SST method, but: How long is the cluster blocked? Only the time it takes to create the mysqldump or the time it takes to create + recover on the joiner?
Do you have another idea to do this with a small downtime?