Discussions
Categories
- 382.5K All Categories
- 2.1K Data
- 212 Big Data Appliance
- 1.9K Data Science
- 448.4K Databases
- 221.1K General Database Discussions
- 3.7K Java and JavaScript in the Database
- 25 Multilingual Engine
- 540 MySQL Community Space
- 469 NoSQL Database
- 7.8K Oracle Database Express Edition (XE)
- 2.9K ORDS, SODA & JSON in the Database
- 499 SQLcl
- 3.9K SQL Developer Data Modeler
- 186.3K SQL & PL/SQL
- 21.1K SQL Developer
- 293.8K Development
- 7 Developer Projects
- 128 Programming Languages
- 290.5K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.6K Java
- 24 Java Learning Subscription
- 36.9K Database Connectivity
- 151 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.9K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 146 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 200 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 289 LiveLabs
- 36 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.8K Other Languages
- 2.3K Chinese
- 168 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 234 Portuguese
MySQL Enterprise Cluster Issues after Network Gateway Change
Recently we had to change the network gateway for our 2 node MySQL cluster running on top of Oracle Grid (RHEL). None of the IPs changed. We noted the following behavior:
1) Once the change was made on the network, we could access the cluster successfully but we were unable to access the servers directly.
2) Once we updated the default Gateway on each of the two nodes under /etc/sysconfig/network-scripts the reverse became true. We were able to access the nodes individually but the cluster was no longer accessible.
We restarted the cluster and the network on both of the nodes and no change was noted. After being unable to locate any other location with either the old or new gateway configured, we are stuck. Current systems are accessing the active node but if it goes down, our system will fail as they will be unable to switch over. We are looking for guidance to resolve this issue so that we can restore the cluster to full operations.
Answers
-
What specifically did you change in your Network Gateway?
-
Only the IP Address changed from A.B.C.D to A.B.C.E
-
That's what I thought. In your question mentioned that no IP was changed.
Recently we had to change the network gateway for our 2 node MySQL cluster running on top of Oracle Grid (RHEL). None of the IPs changed. We noted the following behavior:
Can you look in the location below and make sure that the file reflects your changed IP.
/etc/hosts
-
The gateway IP address is not in the hosts file, it is (and has only ever been) in a routing table.