My Oracle Support Banner

How to enable SQL & Data nodes to use dedicated LAN (Doc ID 2320016.1)

Last updated on FEBRUARY 26, 2020

Applies to:

MySQL Cluster - Version 7.2 and later
Information in this document applies to any platform.


Assume two LAN segments :

1Gb LAN : : eth0

10Gb LAN: : eth1

This can usually be the case where Physical servers are connected to the network via 1Gb interface and they are interconnected between themselves via 10Gb.

We would like to have a configuration where the following traffic is allowed

Data Node - Data Node Traffic: using LAN (10Gb)

Application Server - SQL Node Traffic: using LAN (1Gb)

Data Node - SQL Node Traffic: using LAN (10Gb)


Traffic handled by SQL Nodes is of two types:

a. Traffic from Data Nodes where actual data retrieval takes place. This can be a lot considering large data can be retrieved and then small subset is sent back to the Application Server.

b. Traffic from Application nodes : This usually is small when compared to the SQL-Data traffic

In many situations is beneficial to segregate traffic between the SQL-Data and SQL-Application server.

This segregation can help in balancing of resource utilization and can also help improve the overall performance.

This isolates the Cluster internal Traffic from any external traffic.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.