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

mysql cluster: how to connect

I can not connect to my mysql cluster. I followed this tutorial : https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-on-ubuntu-18-04 I tried connecting with workbench and mysql command to both data nodes and…
Peťo Build
  • 11
  • 3
0
votes
1 answer

binlog not recording DML statement in mysqlcluster

I have created a MySQL NDB Cluster consisting of 2 data node, 1 mgm node and 1 mysqld for testing. Also i have created a slave for NDB to INNODB replication. My binlog are not recording DML statement because of which i am not able to do Point in…
nooruddin dalvi
  • 1
0
votes
1 answer

Error_code: 2005 - Mysql Operator - Error connecting to master

In a cluster of 3 nodes, node-1 crashes with the following error in the Mysql container logs: 2020-05-19T17:40:00.273585Z 12 [ERROR] Slave I/O for channel '': error connecting to master…
imriss
  • 1,815
  • 4
  • 31
  • 46
0
votes
1 answer

Simple query with left join cause ndb cluster timeout, but work fine on innodb

Recently I just move my database to ndb cluster, and I got database with around 200.000 record I try to run this query to get monthly report, but always got query timeout in ndb cluster, when I try the query on the InnoDB it give fast query result <…
hudan abdur r
  • 37
  • 1
  • 1
  • 9
0
votes
1 answer

SqlNode is not connected in MySQL NDB Cluster

I am trying to connect my sql node, management node and 1 data node in mysql cluster but when I try ndb_mgm in management node then this output will display Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 …
Sakar Mehra
  • 89
  • 1
  • 11
0
votes
1 answer

Mysql Cluster binlog replication order

We are facing an issue with our mysql replication stack: We actually have a mysql ndb cluster (7.6.11) acting as a master and an innoDB(5.7) as an slave. Everything seemed to be working right until we realized that some statements weren't being…
kaladan
  • 15
  • 2
  • 7
0
votes
0 answers

Galera Cluster with MySQL Enterprise?

Is it possible to install Galera Cluster with MySQL Enterprise? I tried to check on the web but without result. IF it's possible, how I'm going to install it?
ciuordiss
  • 1
0
votes
1 answer

MySQL Cluster: “The table is full” with disk storage

I have a problem with MySQL Cluster. I created a table in order to be stored in the disk but i think it's always stored in memory. I have have created a table with the query below: CREATE TABLE IF NOT EXISTS user ( `FIELD_KEY` varchar(255) NOT…
abouyahya85
  • 115
  • 9
0
votes
1 answer

why sql node can't not connect to mysql cluster?

I build a mysql cluster, one management node,two data node and two sql node。One management node in a centos server,one data node and one sql node in a different centos server,and the other data node and sql node in a third centos server。The…
Edward_zhuo
  • 1
0
votes
1 answer

MySQL NDB Cluster nodes with randomly generated hostname/IP

For the past two years, I've been testing the performance of our software in the Google Compute Engine (GCE), using up to a total of 1k vCPUs for the worker-VMs and the VMs for MySQL NDB Cluster that we use. I have automated the creation of worker…
Irfy
  • 9,323
  • 1
  • 45
  • 67
0
votes
2 answers

Use the Mysql ClusterJ jar file to connect to NDB cluster

I followed the instruction in the ClusterJ tutorial here to connect to MySQL NDB cluster using the NDB api. Below is a sample code of what I am doing right now: Main.java import com.mysql.clusterj.ClusterJHelper; import…
ForeverLearner
  • 1,901
  • 2
  • 28
  • 51
0
votes
1 answer

Bulk Insert and Update in MySQL Cluster

Currently we are using Mysql Cluster with Mybaits. When we do bulk insertion or updation into particular table, it took more than 120 seconds but expectation is below 30 secs. For Example 10k records, First we tried to update the 10k rows at time,…
pandiaraj
  • 580
  • 1
  • 6
  • 18
0
votes
1 answer

mysqlcluster create table get error 708

when I created table in mysqlcluster 7.5.17,I got the error message like Got error 708 'No more attribute metadata records (increase MaxNoOfAttributes)' from NDBCLUSTER so I used ndb_config -q MaxNoOfAttributes got the number for…
wind
  • 11
  • 1
0
votes
1 answer

table partitioning and mysql ndb cluster

I have mysql ndb cluster with 3 datanodes. I want to break one of my tables into partitions based on one column (maybe date), the question is that what happens after I run partitioning script : I will have all partitions of the table on every 3…
siavash
  • 15
  • 7
0
votes
1 answer

mysql ndb alter table failes, cannot drop index

Use case: We have Jenkin job that runs when developer push code for review. The job validates junit and sonar review and we are planning to add liquibase validation against NDB server. Since we have three Jenkins nodes we have created three…
preetham
  • 36
  • 4
1 2 3
…
13 14