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

INSERT INTO ndbtable SELECT FROM table uses ridiculous amounts of memory in MySQL Cluster

If I move 300,000 rows from a table (either innodb or ndb) into a ndb table like so: INSERT INTO ndbtable2 SELECT a, b,IFNULL(c,UTC_TIMESTAMP()),CASE WHEN b = 'X' THEN e ELSE d END,f FROM ndbtable1; Query OK, 308372 rows affected (5 min 12.59…
KCD
  • 9,873
  • 5
  • 66
  • 75
-1
votes
1 answer

MySQL Cluster - Create new table but not found in other mysql server

i Have create a mysql cluster with docker-compose. version: '3.9' services: management: image: mysql/mysql-cluster:8.0 volumes: - ./mysql.conf/my.cnf:/etc/my.cnf - ./mysql.conf/mysql-cluster.cnf:/etc/mysql-cluster.cnf …
Pamungkas Jayuda
  • 1,194
  • 2
  • 13
  • 31
-1
votes
1 answer

NDB Cluster TCP/IP Connections Using Direct Connections

I'm using MySQL Cluster Manager for my NDB Cluster. I want to setup direct TCP connections between two nodes (https://dev.mysql.com/doc/mysql-cluster-excerpt/5.7/en/mysql-cluster-tcp-definition-direct.html). I have set up correctly two ndbtmd…
xShink
  • 21
  • 3
-1
votes
2 answers

Mysql Cluster in Windows

I am trying to use MySQL Cluster 7.5 version , after opening the web browser and clicking on :create new MySQL cluster", and getting in the "define cluster" page , I write the IP of the remote data node in to the host list field ,but I get error…
Karthik.M
  • 67
  • 11
-1
votes
1 answer

MySQL Failover on Two Azure Servers

I am considering setup of two web servers in a single availability set on Azure and running a local copy of MySQL Server Community Edition on each server to save costs. The web applications on each would be identical. I'm thinking a master/slave…
Adam
  • 4,590
  • 10
  • 51
  • 84
-2
votes
1 answer

mysql cluster data disk increase more and more

I have mysql cluster two management four api nodes and four data nodes. now I have a question,the data node disk space unceasing growth。The data nodes have 2TB of storage space.Datamemory configured 170GB of space,the indexmemory is configured with…
wind
  • 11
  • 1
1 2 3
13
14