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
2
votes
1 answer

how to use c3p0 with node failover test

We have setup MySQL NDB Cluster with three nodes and here is the details of Setup. Node1 - MultithreadedDataNode1, SQLNode1 Node2 - MultithreadedDataNode2, SQLNode2 Node3 - Management Node we are testing a few failover scenarios to ensure that the…
Patel Parimal
  • 207
  • 2
  • 14
2
votes
1 answer

Load balancing via MySQL JDBC driver (Connector/J)

I have been exploring MySQL JDBC driver and understand that it is able to do load balancing with this url ("jdbc:mysql:loadbalance://"). I looked into the documentation and it seems that only random and best response time methods are used for load…
Tay Wen Bin
  • 111
  • 2
  • 11
2
votes
3 answers

MySQL Cluster vs. Hadoop for handling big data

I want to know the advantages/disadvantages of using a MySQL Cluster and using the Hadoop framework. What is the better solution. I would like to read your opinion. I think the advantages of using a MySQL Cluster are: high availability good…
Tobi Weißhaar
  • 1,617
  • 6
  • 26
  • 35
2
votes
2 answers

Rails adapter solutions for MySQL Cluster (NDB)?

I'm setting up a high-availability environment for a customer. There are a pair of load-balanced hosts serving http requests to our Rails application, which is deployed in parallel on both hosts. Additionally, there are two MySQL hosts available. I…
RonU
  • 5,525
  • 3
  • 16
  • 13
2
votes
1 answer

MySQL Cluster Error: Lock wait timeout exceeded

I was trying to load a ~200G file into MySQL cluster having 4 data nodes, and my DDL for the target table is like this: CREATE TABLE XXXXXX ( ID BIGINT AUTO_INCREMENT PRIMARY KEY, COL1..., COL2..., ....... ) ENGINE = NDB…
MikA
  • 5,184
  • 5
  • 33
  • 42
1
vote
1 answer

how to ues kubernetes api for java to create mysql cluster

First, the yaml file is right,because I can use them directley create a mysql cluster in kubernetes. but when I try to create a mysql cluster by kubernetes api for java, an error occured The commond in yaml file cannot be recognized by the…
ice-sugar gourd
  • 13
  • 3
1
vote
1 answer

Docker swarm stack mysql/mysql-cluster not resolving service names

I'm trying to setup a mysql-cluster on a docker swarm setup. Given we have 3 nodes (1 manager, 2 workers) we are trying to install it on the manager node. This is the my.cnf file (correctly…
Olisan
  • 21
  • 1
  • 7
1
vote
1 answer

Does MySQL clusters support coordinator node?

I'm creating a new app and this time using MySQL instead of cassandra because it's much harder to learn and setup. I learned about MySQL clusters and chose to use this database because all my devs are very familiar with the MySQL query syntax and…
nullcoder
  • 103
  • 2
  • 11
1
vote
1 answer

Setting up InnoDB Cluster - Error on opening connection

I am in the process of setting up an InnoDB cluster using the following tutorial (https://www.sqlshack.com/deploy-mysql-innodb-clusters-for-high-availability/). So far everything has worked: MySQL Server…
Andre
  • 131
  • 1
  • 14
1
vote
0 answers

Unable to connect with mysql server NDB cluster through tcp

Following the guide to create a mysql NDB cluster on https://hub.docker.com/r/mysql/mysql-cluster/ after initializing docker server exposing 3306 and 33060 I'm still unable to connect it using MySQL Workbench but I'm able to access it through CLI.…
Rinaldi Segecin
  • 449
  • 8
  • 23
1
vote
1 answer

how to see the table in my database after creating and migrating models in django

i tried connecting to my sql cloud cluster in visual studio code Code for settings.py is- DATABASES = { 'default': { 'ENGINE': 'django.db.backends.sqlite3', 'NAME':'aras', 'USER':'arasuser', …
ritu
  • 43
  • 1
  • 8
1
vote
1 answer

MySQL 8.0.16 (Windows) Group Replication Fresh Setup : Not able to add second member

I am trying to setup MySQL HA using Group Replication feature. Referred instruction from https://dev.mysql.com/doc/refman/8.0/en/group-replication.html. Read & tried all steps multiple times to ensure all steps are followed properly, but same…
Rajesh Verma
  • 31
  • 1
  • 3
1
vote
1 answer

MySQL NDB Cluster : Disable Replication for a table / database

In our project we are planning to introduce MySQL NDB cluster to have 99% uptime for our multiple applications dependent on MySQL. So MySQL is being deployed in two machines. In both the machines Data Node, Management Server and SQL node is…
Subash Kunjupillai
  • 390
  • 3
  • 12
1
vote
1 answer

Mysql cluster locking all rows

I'm doing this test in order to understand how Mysql NDB cluster works. So I have two sql nodes. Preparation I created the following table: CREATE TABLE tb_id ( id bigint(20) NOT NULL AUTO_INCREMENT, ix bigint(20) default 0, name…
user1995187
  • 393
  • 5
  • 18
1
vote
0 answers

Unable to start SQL Node in Mysql-cluster

mysqld: [ERROR] Could not open required defaults file I'm trying to configure MySQL-Cluster with the Auto-Installer. When I deploy and start the cluster I get the following message when starting the sql nodes Error 1 So I checked the permissions of…
Alex Sáenz Rojas
  • 41
  • 6
1 2
3
…
13 14