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

How to set affinity for percona mysql helm deployment?

I have a percona mysql cluster deployed in my kubernetes cluster and can't figure it out how to use "pxc.affinity.advanced" parameter to add tolerations. In the values.yaml file it looks like this: affinity: antiAffinityTopologyKey:…
alex suru
  • 9
  • 2
0
votes
0 answers

Error on Starting MySQL Cluster 8.0 Data Node on Ubuntu 22.04 LTS

When I start the data nodeid 1 (10.1.1.103) of MySQL Cluster 8.0 on Ubuntu 22.04 LTS I am getting the following error: # ndbd Failed to open /sys/devices/system/cpu/cpu0/cache/index3/shared_cpu_list: No such file or directory 2023-01-02 17:16:55…
Steven J. Garner
  • 344
  • 2
  • 8
0
votes
1 answer

Using MySQL NDB Cluster, I get a permission denied error when accessing slave nodes

I followed this tutorial to create a multi-node MySQL Cluster deployed on AWS EC2 instances. I can query the master node using: mysql -u root -D mydb -h -P 3306 But if I do the same but with a slave node IP, I get: ERROR 2002 (HY000):…
Simon Tran
  • 1,461
  • 1
  • 11
  • 28
0
votes
1 answer

Mysql cluster Error 1114 the table is full when alter an innodb table into storage disk with engine NDB

I am running the command ALTER TABLE beijing_xiaohongmen TABLESPACE ts_1 STORAGE DISK ENGINE NDBCLUSTER; where ts_1 has two .dat file with 1024M each and table beijing_xiaohongmen is an innodb table. However, I meet ERROR 1114 (HY000): The table…
user19993631
  • 1
  • 1
0
votes
2 answers

How to connect to MySQL database cluster

I tried to install a MySQL cluster with the Docker image below. mysql/mysql-cluster - Docker Image | Docker Hub The Docker image is pulled and run successfully. Despite that I could connect to the cluster in the terminal (as shown in the screen…
user13746660
0
votes
0 answers

Laravel / PHP / MySQL - Packets out of order

Application coded in Laravel (5.2) / PHP (5.6) using PDO library is generating Packets out of order exception on random requests (Specially after we setup cluster environment with Oracle / MySql 8.0). Below is the complete exception local.ERROR:…
Muhammad Khalid Noor
  • 1
  • 3
0
votes
1 answer

MySQL Cluster - Composite foreign key error: Missing index for constraint

I want to add composite foreign key to my MySQL Cluster table. When I try locally the statement is executed, but on cluster I get the following error: Failed to add the foreign key constraint. Missing index for constraint... in the referenced table…
Aline137
  • 73
  • 1
  • 7
0
votes
1 answer

MySQL Cluster - The table is full

I created MySQL Cluster with 1 management, 2 data and 2 SQL nodes. When I run my app (spring boot) the app crashes while creating tables with the error: The table 'user' is full [Failed SQL: ALTER TABLE user ADD CONSTRAINT ... FOREIGN KEY... I have…
Aline137
  • 73
  • 1
  • 7
0
votes
0 answers

MySQL Cluster Docker ndb_mgmd: [ERROR] unknown variable 'user=mysql'

Hi I was following the official mysql cluster documentation for creating a MySQL cluster on Docker. https://hub.docker.com/r/mysql/mysql-cluster However when I looked at the logs I can see that the management node and the data nodes are failing with…
dragonfoxSL
  • 1
  • 3
0
votes
2 answers

MySQL-Cluster fails to start

This is not my first time creating an ndb cluster but I hadn't received such a problem. I am following this manual by team mysql. I am using the default configuration echoed in this GitHub repository. When I start my ndb_mgmd container, it returns…
Davood Falahati
  • 1,474
  • 16
  • 34
0
votes
1 answer

MYSQL CLUSTER shows mgmd init error in ubuntu 20

My Linux Server is ubuntu 20 MySQL Cluster Management Server mysql-8.0.23 ndb-8.0.23 MySQL distrib mysql-8.0.23 ndb-8.0.23, for Linux (x86_64) When I try to start(command：ndb_mgmd -f config.ini --ndb-nodeid=11) the mysql cluster mgmd node, it always…
Rex Wang
  • 3
  • 1
0
votes
2 answers

How to test performance of MySQL NDB cluster(NDB storage engine) using SYSBENCH?

I want to test the performance of my NDB cluster. I am thinking of using sysbench. Are there any particular configuration changes required to make it work with the NDB cluster? Is there any flag that I need to use during runtime to mention the…
himanshu
  • 175
  • 3
  • 12
0
votes
0 answers

MySQL hangs on SELECT from table with blob fields

This question has been moved to dba.stackexchange.com I managed to create a mysql InnoDB cluster with three nodes and a router everything works great but when i try to run a select query from the table below from a another server it freezes, but…
mbouzahir
  • 1,424
  • 13
  • 16
0
votes
0 answers

MySQL Cluster Replication

I am using docker-compose to create MySQL cluster (NDB). After cluster gets created, I am unable to see data replication when querying through other mysql API node. For example, this is my configuration: ndb_mgm> show Connected to Management Server…
Ishan
  • 13
  • 7
0
votes
0 answers

Adding New node to NDB Cluster

I have a server which running Management_node, data_node and mysql-server running whose IP is 10.19.95.36 There were running with one more node whose IP is 10.19.95.37 but the second server was off now. So just one node is running and it's…
user13493257
  • 51
  • 1
  • 4
1 2 3
…
13 14