How to enable SQL & Data nodes to use dedicated LAN

(Doc ID 2320016.1)

Last updated on OCTOBER 25, 2017

Applies to:

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

Goal

Assume two LAN segments :

1Gb LAN :  10.1.53.0/24 : eth0

10Gb LAN: 10.1.43.0/24 : 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 10.1.43.0/24 (10Gb)

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

Data Node - SQL Node Traffic: using LAN 10.1.43.0/24 (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.


 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms