- 3,734,166 Users
- 2,246,899 Discussions
- 7,857,145 Comments
- 380.9K All Categories
- 2.1K Data
- 203 Big Data Appliance
- 1.9K Data Science
- 446.1K Databases
- 220.4K General Database Discussions
- 23 Multilingual Engine
- 506 MySQL Community Space
- 459 NoSQL Database
- 7.7K Oracle Database Express Edition (XE)
- 2.8K ORDS, SODA & JSON in the Database
- 438 SQLcl
- 3.9K SQL Developer Data Modeler
- 185.4K SQL & PL/SQL
- 20.8K SQL Developer
- 291.3K Development
- 6 Developer Projects
- 117 Programming Languages
- 288.1K Development Tools
- 96 DevOps
- 3K QA/Testing
- 645.2K Java
- 18 Java Learning Subscription
- 36.9K Database Connectivity
- 148 Java Community Process
- 104 Java 25
- 22.1K Java APIs
- 137.7K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 12 Java Essentials
- 138 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
- 195 Java User Groups
- 179 LiveLabs
- 34 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 165 Deutsche Oracle Community
- 1.2K Español
- 1.9K Japanese
- 225 Portuguese
NDB instance take (too) long to recover
Hi NDB experts,
I have a question concerning MYSQL NDB, the in memory solution.
Question is technical, not sales related.
in most cluster configurations we setup we chose 2 NDB instances, 2 MGM's,2 arbitrators and 2 or more mysqld instances.
When the "primary" (President) NDB goes down the remaining NDB instance takes full control.
We noticed that sometimes this happens in "seconds", at other moments this takes minutes (even upto 40 mintes).
the time used is required to recover the database.
This is evident from the NDB logs.
Obviously this takes unacceptable long down time.
Personally I believe this is due to :
LCP - GCP not "in sync", with respect to the remaining NDB instance, when the primary goes down.
I'm not able however, to find "how this works" (and with this if i'm correct)
A better understanding of this mechanism may lead to better tuning or setup with that avoiding the long down time.
Is there any document available that provides the answer ?
Many thanks in advance