← Back to team overview

maria-discuss team mailing list archive

Re: can we use load data infile from moving a database to a 4 node cluster


Hi Arun,

Galera requires only InnoDB tables, so the fastest way would be to take an
Xtrabackup snapshot of your MariaDB 10 standalone database, restore it on
one node of the Galera cluster and then turn on the 3 other nodes.

Of course LOAD DATA INFILE is supported by Galera, but it would be slower.

On Tue, Aug 16, 2016 at 9:55 AM bbnlaccts acnts <bbnlaccts@xxxxxxxxx> wrote:

> Hi,
> I am planning on moving a mariadb 10 database to a 4 node galera cluster.
> Since the db is kind of big with around 40 gigs capacity and i am getting
> very less maintenance window to complete this activity.
> Hence planning on using load data infile on alll the big tables.
> Can anybody please do let me know if i am going to see any drawbacks/bugs
> in this concept.
> Are there any precautionary measures i need to take in order to accomplish
> this task.
> Your help is greatly appreciated
> Thanks
> Arun
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
Guillaume Lefranc
Remote DBA Services Manager
MariaDB Corporation