About Percona percona xtradb cluster and Multiple NICS

[xdeleon]

Hello:

Is there any information about the use of percona xtradb cluster with multiple NIC, for example to be use for internal cluster communication? Is this recommended?.. Do exist documentation about best practices?

Thanks for your comments.

Regards,

[przemek]

Hello,

It depends on the circumstance/environment. If you want/can separate the inter-node cluster communication from normal MySQL traffic coming from the application clients, you can do it.
You may set the MySQL port for clients with:

bind_address=$IP1

and the Galera side to another IP with

[B]wsrep_node_address=$IP2[/B]

see the manual:
http://galeracluster.com/documentation-webpages/mysqlwsrepoptions.html#wsrep-node-address
Other wsrep and provider related variables will inherit the IP given in this one, but also may be set explicitly if really needed.

[xdeleon]

Thanks for reply.

My question was intentioned in know if you consider a good practice to use 2 channels, one for client (throughput: 1GB) and other for internal cluster communication (throughput 10GB).

In our enviroment exists a database cluster with 4 nodes (DB Size aprox: 15 GB), each node resides in one server. We use one channel to client and internal cluster communication (throughput 1GB). We want to liberate the traffic and accelerate the recovery process when a node is downed. Our intention is add an NIC to each server.

Thanks for your help.

Regards,

[xdeleon]

Hello!

I’ll appreciate your comments.

Regards,