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
0 answers

Got error 851 'Maximum 8052 bytes of FIXED columns supported, use varchar or COLUMN_FORMAT DYNAMIC

When I try to create a table in NDB Cluster 7.3.5 with disk storage, I get following error: Got error 851 'Maximum 8052 bytes of FIXED columns supported, use varchar or COLUMN_FORMAT DYNAMIC instead' from NDBCLUSTER The DDL for table is as given…
Patel Parimal
  • 207
  • 2
  • 14
0
votes
1 answer

what happens when single and one and only management node goes down in NDB Cluster

I have set up the MySQL NDB Cluster (mysql-cluster-gpl-7.3.5-linux-glibc2.5-x86_64) with 5 Nodes as described below: Node A: multithreaded data node1, SQL node1 Node B: multithreaded data node2, SQL node2 Node C: management node1 So I have kept one…
Patel Parimal
  • 207
  • 2
  • 14
0
votes
1 answer

Connecting to MySQL Cluster from WCF

I have configured server to use MySQL Cluster. The Cluster works fine. This is my server architecture: Server 1: Cluster Manager: 10.176.133.219 Server 2: Data Node & Sql Node: 10.176.168.129 Server 3: Data Node & Sql Node: 10.176.137.66 My…
Nisho
  • 365
  • 1
  • 3
  • 14
0
votes
0 answers

Can't create a table

I want to test mysql cluster. I installed, configured and ran. But I can't create a table connected to my engine=ndbcluster. I got this error ERROR 1005 (HY000): Can't create table 'user_database.user_table' (errno: 157) Everything is connected…
user3435212
  • 21
  • 4
0
votes
2 answers

Procedure + Insert

I would like to create a procedure with a while but I have an error. Here is my procedure: Delimiter // create procedure procedure1 () BEGIN Declare i INT; set i=1; while i< 74 do execute immediate 'insert into main values(3,"samples")' set…
user214158
0
votes
2 answers

Create table Mysql cluster Issue

I have a huge issue trying to solve it for a few hours. I installed, configured and ran the mysql-cluster but when I want to create a table I get the following issue: create table simples (id int not null primary key) engine=ndb; ERROR 157…
user3435212
  • 21
  • 4
0
votes
1 answer

MySQL Cluster Architecture Considerations

We are going to deploy a newly created WebApplication in the next weeks from a project i'm working in as a software guy. We do not expect high load in the first 6 month, but we want to build the system architecture in a scalable way. I have a idea,…
Thomas Spycher
  • 956
  • 13
  • 32
0
votes
4 answers

mysql cluster node js connection error

I am trying to connect mysql cluster with node js My program var nosql = require('mysql-js'); var dbProperties = { "implementation" : "ndb", "database" : "users" }; nosql.openSession(dbProperties, null, onSession); I am getting this…
ohm
  • 140
  • 1
  • 5
0
votes
2 answers

Node.js system requirements for 50.000 concurrent connections

The situation is that about 50.000 electronic devices are going to connect to a webservice created in node.js once per minute. Each one is going to send a POST request containg some JSON data. All this data should be secured. The web service is…
skatz
  • 125
  • 3
  • 13
0
votes
1 answer

MySQL Cluster Node Specific Hardware

I am looking at setting up a MySQL Cluster with two high end dell servers (duel opteron 4386 cpus, 16gb ram and RAID 10 SAS). I also have a handful of other high end machines that are i7 with 20gb+ ram each on average. What is the hardware focus for…
imperium2335
  • 23,402
  • 38
  • 111
  • 190
0
votes
0 answers

Trouble with AWS EC2s used in MySQL Cluster

While configuring and attempting to run a 4-node / 4-host MySQL Cluster, using AWS, I've hit a roadblock while trying to register the first Data Node with the Manager. It appears to be an issue with the fact that the data node (DN) has a public IP…
paiego
  • 3,619
  • 34
  • 43
0
votes
1 answer

How WordPress select database engine while installing website?

Is this default database storage engine? I want to install my WordPress website with MYSQL "NDB CLUSTER" storage engine. I tried to install wordpress site, but it's installed with InnoDB. Please help me to resolve this. I used this SET…
Prabhu Ganapathy
  • 167
  • 2
  • 10
0
votes
1 answer

How many mysqld nodes in comparison with data nodes in a mysql cluster?

I have a cluster with 3 ndbd nodes. How many MySQLd nodes do I need. What is a good rule. One MySQLd for 3 ndbd?
user3054547
  • 13
  • 4
0
votes
1 answer

Start data node without --initial mysql cluster

I have setup a cluster with disk based tables, with 2 datanodes ,one mgmt , and 2 sql nodes. Cluster is working fine... So I just wanted to test its HA , so I manually killed one datanode with KILL command at a linux prompt and I connected to sql…
sai
  • 165
  • 1
  • 10
0
votes
1 answer

methods of scaling mysql inserts

I've got a php-cli script which makes +2 million mysql queries(1/2 select statements using indexes, 1/2 row inserts of a couple varchar(25), int(5) columns ) on an amazon server's crontab. The script itself takes hours to run. I'd like to get it…
rocketas
  • 1,679
  • 3
  • 18
  • 30
1 2 3
…
13
14