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 : 192.168.53.0/24 : eth0
10Gb LAN: 192.168.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 192.168.43.0/24 (10Gb)
Application Server - SQL Node Traffic: using LAN 192.168.53.0/24 (1Gb)
Data Node - SQL Node Traffic: using LAN 192.168.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.
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