Stack Overflow
Stack Overflow

Questions tagged [mysql-cluster]

MySQL NDB Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability.

MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability. With a distributed, multi-master architecture and no single point of failure, MySQL Cluster scales horizontally on commodity hardware with auto-sharding (partitioning) to serve read and write intensive workloads, accessed via SQL and NoSQL interfaces. ("Cluster" is an overloaded term; this topic is NDB Cluster.)

201 questions
0
votes
1 answer

NDB cluster creating undo logs and data files

Few things that I'm considering about NDBcluster when storing data in disk storage. In my configuration i defined DataMemory=20G. So what would be the best total size of undo log files? I saw in a blog it should be 6xDataMemory. Is this a…
chinthakaS
  • 125
  • 1
  • 2
  • 10
0
votes
1 answer

ClusterJ cannot connect to dockerized Mysql cluster from outside the container

I have setup MySQL cluster on my PC using mysql/mysql-cluster image on docker hub, and it starts up fine. However when I try to connect to the cluster from outside docker (via the host machine) using clusterJ it doesn't connect. Initially I was…
R. Antunes
  • 1
  • 2
0
votes
1 answer

Mysql Cluster data ndoe can not start to connecto management node

Now, every config is ok , but when I use ./ndbd --initial on data node , it will ouput log : ndb_mgm : Forced node shutdown completed. Occured during startphase 0. Caused by error 2350: 'Invalid configuration received from Management…
Lnn
  • 59
  • 5
0
votes
2 answers

How to drop a local DB but keep included ndbcluster table in the NDB cluster

I have the following case, but no possibility to make a test. Would be thankful for the advice. A) local host with the MySQL server (an old mysql 5.0) A.1) This MySQL server has a few databases A.2) One of these databases contains some innoDB…
Yaroslav Fedorina
  • 36
  • 6
0
votes
1 answer

MySQL NDB Cluster Buffer Overflow Error

I have a mysql cluster setup in docker using the official mysql-cluster image in dockerhub.I also have other conatiners like which has Redis and a node application running in same network as that of the mysql cluster. When I try to run…
Reev Ranj
  • 11
  • 2
0
votes
1 answer

myql ndb cluster data nodes not synced and different response to same query

One of my Sql nodes failed wiht "too many connection error", When reviewing the status of the cluster with ndb_mgm, I realize that data node 2 was shutdown, so I restart it and restart the sql node. after 2 hours "starting" data node 2, it came up,…
RADU
  • 78
  • 1
  • 8
0
votes
2 answers

NDB Cluster Migration

I am having problem with NDB Migration. Currently, I have 2 replicas in NDB Cluster. I want to move the cluster into a new hardware. So, in the new machine I setup datanodes and sqlnodes & pointed the management node to the old cluster. Once the sql…
curiousitguy
  • 3
  • 1
0
votes
0 answers

Mysql cluster + proxy - production architecture questions

I'm launching a big project of mine which took me more than a year. if this work as I want, this would need a solid database architecture, but I'm a developer and kind of noob for database configuration. Application is made with Spring/Mysql served…
mcfly
  • 774
  • 1
  • 8
  • 18
0
votes
1 answer

MySQL NDB Cluster and Master Master replication

I'm asking this to see whether I'm doing the things are correctly or to get advise what needs to be done. Thing is I'm trying to run both NDB clustering and Master Master replication to same database. In here What I'm trying to do is create a db…
chinthakaS
  • 125
  • 1
  • 2
  • 10
0
votes
1 answer

Achive both Load balancing and HA with MySQL NDB cluster

How to configure an application with a MySQL NDB cluster database so as the High availability as well the load balancing can be catered altogether. We can have these two capabilities separately by configuring the database connection url…
Samitha Chathuranga
  • 1,689
  • 5
  • 30
  • 57
0
votes
1 answer

Failed to allocate nodeid for API at . Returned error: 'No free node id found for mysqld(API).'

OS and mysql cluster version OS: Linux centos7 mysql cluster: mysql-cluster-community-7.5.8-1.el7.x86_64 Server list 192.168.1.101 ndbd node1 192.168.1.102 ndbd node2 192.168.1.103 ndb_mgmd 192.168.1.104 mysql(api) node1 192.168.1.105 …
Jaune
  • 65
  • 1
  • 8
0
votes
1 answer

NDB Cluster DataNode Consuming much RAM

I have set up NBC Cluster at my Office. There are two physical Machines with 128G/each. The database size is around 2G. We are an ISP and we have kept the RADIUS database in the cluster. The thing that is worrying me at the moment is, in both the…
Badalnu Chha
  • 1
0
votes
1 answer

ERROR 3014 (HY000): Table storage engine 'NDBCLUSTER' found required create option missing

I am trying to create a disk table CREATE TABLE table1_disk (col0 INT(11) NOT NULL AUTO_INCREMENT, col1 VARCHAR(20) DEFAULT NULL, PRIMARY KEY (col0)) ENGINE=ndbcluster DEFAULT CHARSET=latin1 TABLESPACE ts_1 STORAGE DISK; Error: Table storage…
Raghu DV
  • 258
  • 5
  • 18
0
votes
1 answer

Management node not showing all the nodes.

In Management Node configuration file /var/lib/mysql-cluster/config.ini i have specified two data nodes and two SQL nodes. it's showing only one data node and one SQL node. [ndb_mgmd default] # Directory for MGM node log…
Raghu DV
  • 258
  • 5
  • 18
0
votes
1 answer

Got temporary error 899 'Rowid already allocated' from NDBCLUSTER

im experiencing this NDB CLUSTER Error for a while now. It started after a cluster shutdown for 2 days due to production shutdown. Any insights will help. TIA
Dan
  • 1
  • 3
1 2 3
…
13 14