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

Starting MySql Cluster ndb_mgm

I am trying to start maysql cluster ndb_mgm, but its giving me the following error, my my.ini file is like this, [mysql_cluster] # Options for management node process config-file=C:/mysql/bin/config.ini what is meant by unknown variable
dennypanther
  • 53
  • 1
  • 10
0
votes
3 answers

MySQL Cluster Auto-Installer

I am using MySQL Cluster Auto-Installer. I click the next button while keeping the default configurations. But finally when i click Deploy and start cluster it will give me the following error. I cant find any information regarding this message in…
dennypanther
  • 53
  • 1
  • 10
0
votes
1 answer

Big Data or relational database (like MySQL cluster)?

I am going to deal with a huge amount of data in my project. I have read about big data concepts but never used it yet. But reading all those Big Data Documents I am still not sure whether my requirement needs Big Data or is it good to handle with…
Dev
  • 309
  • 1
  • 8
  • 24
0
votes
1 answer

Does WSO2 support MySQL Master/Slave Cluster?

I have tried to use MySQL Master/Slave cluster in WSO2 cluster deployment, but failed when startup. Does WSO2 only support MySql Share-Nothing cluster? How does it support MySQL Master/Slave? My datasource was configured as below: …
Leon Yang
  • 37
  • 6
0
votes
1 answer

How to do a rolling restart of mysql ndb cluster in an automated manner

Is there any way that I can have single point of control to perform cluster activities such as rolling restart without logging into each specific node such and Management, API and restarting each one manually.
user3540835
  • 453
  • 4
  • 15
0
votes
1 answer

Restart Windows Service with Additional Parameters

This may be a daft question, but I can't for the life of me find an answer. Basically I am trying to restart a Windows Service, whilst passing across an additional parameter. In more detail: I'm setting up a MySQL cluster for testing on my Windows…
IGGt
  • 2,627
  • 10
  • 42
  • 63
0
votes
1 answer

Best way of backing up mysql clustered database

I have a mysql cluster database spread on 2 servers. I want to create a backup system for this database based on the following requirements: 1. Recovery/restore should be very easy and quick. Even better if i can switch connection string at any time…
Nisho
  • 365
  • 1
  • 3
  • 14
0
votes
1 answer

Error when setting up mysql cluster

I am trying to set up the mysql cluster. But when I try to start the mysqld(API) node, I get this error: 2014-12-02 17:02:37 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future…
wwood
  • 489
  • 6
  • 19
0
votes
1 answer

Mysql cluster using 2 mysqld(API) results in different tables per access

I am running a mysql cluster with 4 data nodes, and 2 servers with a access(API) and managment node on each. If I create a table using API node 1 it shows as not existing if I try access it on API node 2. Can anyone explain why this is or how to…
user3696793
  • 23
  • 4
0
votes
1 answer

MySQL cluster data node restarts when its twin fails

Configuration: Server #1: 1 mgm node (#49), 1 data node (#1), 1 sql node (Real IP 192.168.1.128) Server #2: 1 mgm node (#50), 1 data node (#2), 1 sql node (Real IP 192.168.1.130) Virtual IP: 192.168.1.240 (using keepalived, server #1 as…
Rad
  • 4,292
  • 8
  • 33
  • 71
0
votes
1 answer

MySQLcluster configuration

I have installed MySQL cluster (NDB 7.3 ) with 1 management node 4 data nodes 3 sql node. I have 4 partitions and two node groups. I have couple of questions. Can i view data stored in each data node separately? Where can i find the data sync…
Jagadeeshwaran k
  • 53
  • 7
0
votes
1 answer

Remote data node starting issue in MySQL Cluster

I'm playing with MySql Cluster and faced a problem with not common configuration. The most of tutorials describes configuration where data node and MySQL Server node residing on the same PC. But I'm trying to put management node and MySQL server…
Shoar
  • 131
  • 2
  • 2
  • 12
0
votes
0 answers

MySQL could not replicate in case master is down in cluster and then gets up

I have MySQL cluster (NDB) containing 2 servers[NodeA and NodeB]. I have another machine having InnoDB[NodeC] outside cluster. NodeA is master for NodeC replication slave. Problem arises when NodeA is down in cluster, and some transaction take place…
Nikhil
  • 207
  • 1
  • 3
  • 15
0
votes
1 answer

Mysql cluster Insert Stalls TCROLLBACKREQ

I have a mysql cluster with 4 data nodes. I am trying to do an insert of 8 million rows, using load data infile in chunks of 50k to keep transactions small. Like clockwork, after every 1 million rows inserted into the table, the insert stalls for…
andrejbranch
  • 1
  • 1
0
votes
0 answers

Mysql Cluster error when storing data

I am facing following exception, com.mysql.clusterj.ClusterJDatastoreException: Datastore exception. Return code: -1 Error code: 1,234 MySQL code: -1 Status: 1 Classification: 7 Message: bucket_storage2 Which parameter in config.ini i need to…
Sohan
  • 6,252
  • 5
  • 35
  • 56
1 2 3
…
13 14