Mariadb / mysql galera import speed

[dade73]

Hi everyone,

I'm trying to import data in mariadb with galera cluster. There is a way to limit or lower down the import speed to avoid the flowcontrol on the destination cluster?

Thank you!

cheers

davide

[john_wang · Accepted solution]

Hello @dade73 ,

Welcome to Qlik Community!

If I understood correctly, you want to 'slow down' the Full load performance to avoid impact from Replicate task full load stage. is that correct?

If yes, then there may be some options include:

1- if the target cluster is in cloud, there is some parameters in the Database to control the performance

2- You may set the full load parallel table max number to 1

3- you may limit the network speed (between Replicate server and target database) by work with your network management team

Hope this helps.

Regards,

John.

[dade73]

Thank you! work like charm!

Regards

Davide