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

ClusterJ removes schema after failure to initialize domain type handler

We have mysql-cluster-gpl-7.4.11-winx64 running on Windows 8 64bits. I use 7.4.11 ClusterJ with Java 1.8 64bits. When I try to run the same code on Windows 10 64 bits I get following messages in the log: Jun 29, 2016 12:11:11 PM…
Alexander Nurmsalu
  • 156
  • 2
  • 10
0
votes
0 answers

Mysql cluster insert operation inner mechanics

Maybe i have missed something. But haven't found anything well documented about insert mechanics. As i understand, insert is synchronous operation and it's inserting new data to all data nodes related to this partition. So basically how much…
Somebody
  • 9,316
  • 26
  • 94
  • 142
0
votes
1 answer

ndbclient native library is missing in Mysql Cluster installation

I get following error when trying to run ClusterJ based Java application: java.lang.UnsatisfiedLinkError: no ndbclient in java.library.path at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1865) at…
Alexander Nurmsalu
  • 156
  • 2
  • 10
0
votes
0 answers

Cannot Get MySQL Cluster to Install Correctly

So, I'm trying to install MySQL Cluster with 6 data nodes (All CentOS 7.0 Core Install), 2 SQL nodes (All CentOS 7.0 Core Install), and a management node (CentOS 7.0 Core Install). On all servers, I ran the following commands after downloading the…
Gary Mathis
  • 171
  • 1
  • 4
0
votes
1 answer

MySQL Cluster ERROR failed with Error 'Got error 240 'Unknown error code' from NDBCLUSTER' on query

In one of our environment mysql replication is failing intermittently. Below are the related mysql server logs. mysql> show slave status \G; *************************** 1. row *************************** Slave_IO_State: Waiting…
praitheesh
  • 41
  • 6
0
votes
2 answers

Is it possible that, decentralized solution with mysql

Is it possible that decentralized mysql solution. Where updates in one mysql server has to reflect on all other regions. Like wise other region changes should sync with remaning regions.
neotam
  • 2,611
  • 1
  • 31
  • 53
0
votes
1 answer

Can I update, insert and delete records from multiple mysql servers in cluster

Can I update, insert and delete from the multiple mysql nodes in the mysql cluster ?
neotam
  • 2,611
  • 1
  • 31
  • 53
0
votes
1 answer

I cant create table with an ndbcluster engine on ubuntu

When I try to create a table: CREATE TABLE tblCustomer (ID INT) ENGINE=NDBCLUSTER; When I show the table status, it is still InnoDB. And when I try to: SHOW ENGINES; There's no ndbcluster indicated. Is there something that I'm missing there? On my…
JRA
  • 1
  • 1
0
votes
0 answers

mysql cluster group by performance issue

I am working on database performance optimization issue, and I did a simple test on mysql cluster, the question is why a single group by statement in 30M records will take 1m20s so long. environment: linux x64 centos mysql cluster 7.4.8 cluster: 1…
Lei Chi
  • 216
  • 1
  • 14
0
votes
1 answer

MySQL NDB auto_increment backfilling

We had standalone DB with innodb engine, on it `auto_increment was working perfectly giving sequential numbers 1,2,3,4,5 But when we moved to NDB Cluster, it started backfilling available numbers. for example if i have 12,13,14,16,17 if i add new…
Satish
  • 16,544
  • 29
  • 93
  • 149
0
votes
1 answer

Can not start mysqld, unsupported engine InnoDB

I am trying to start mysqld on one of my data nodes in NDBCluster. The node connects to the management server correctly, but when trying to start mysqld, the start fails when it encounters an old InnoDB table I have. I have edited my.cnf to…
mikemmb73
  • 75
  • 2
  • 3
  • 13
0
votes
1 answer

Wildfly XA-Datasource - galera cluster

I develop an application that use jta transaction (JAVA TRANSACTION API) and which is using multiple resources (databases). So i've set xa-datasources in my wildfly environnement. The problem is that i need a clustered database (f.e :Mariadb +…
Jimmy Pannier
  • 261
  • 1
  • 2
  • 16
0
votes
2 answers

Rundeck project and job sync between 2 instances with backend as mysql cluster

I have set up 2 rundecks in 2 VMs and mysql cluster so Rundeck #1 on VM#1 connects to Mysql DB#1 and similarly Rundeck #2 on VM#2 connects to Mysql DB#2. The problem now I have is whenever I am creating a project / job in rundeck #1 that I am not…
KronnorK
  • 539
  • 5
  • 17
0
votes
2 answers

Failed to allocate nodeid, error: 'Error: Could not alloc node id

ndb_mgmd does not seem to correctly read the config file this is part of my config file [ndbd] # Options for data node "A": # (one [ndbd] section per data node) hostname=abhyas.db01 # Hostname or IP…
anu
  • 1,017
  • 1
  • 19
  • 36
0
votes
0 answers

Galera cluster not starting, wsrep issue

I followed this tutorial (and read others as well) https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-on-ubuntu-12-04-servers to install galera cluster with maria DB on Ubuntu 14.04 on DigitalOcean. I…
Prem
  • 71
  • 4
1 2 3
…
13 14