Network IO performance

[DRivard]

Hi,

I successfully installed Galera 5.5 on our latest hardware running Ubuntu 12.04. I am connected behind a Gigabit Switch, the DB size is about 40GB, plus all the network adapters (10) are sync in gigabits as per ethtool.

When it needs to make a full state backup from one node to the others (I have 3 live nodes running all the exact same hardware) it only transfer at a 7MB/sec like if it was 100MB switch and not gigabit. I tried to scp a huge file between 2 nodes ans it transfer at 70MB/sec so that is the real speed I want. How do I make mysql to transfer the same speed?

Thank you.

Dominick

[Alex Yurchenko]

Hi Dominick,

Sounds like you're using mysqldump for SST (that's default). Try
setting wsrep_sst_method=rsync in my.cnf

Regards,
Alex

--
Alexey Yurchenko,
Codership Oy, www.codership.com
Skype: alexey.yurchenko, Phone: +358-400-516-011

[DRivard]

Yes, it fixed the problem.

Thank you very much.

Dominick