Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql-cluster]

MySQL Cluster, which is a distinct product from MySQL Server, is the industry's only real-time transactional relational database combining 99.999% availability with the low Total Cost of Ownership (TCO) of open source. It features a "shared-nothing" distributed architecture with no single point of failure to assure high availability and performance, allowing you to meet your most demanding mission-critical application requirements.

MySQL Cluster, which is a distinct product from MySQL Server, is the industry's only real-time transactional relational database combining 99.999% availability with the low Total Cost of Ownership (TCO) of open source. It features a "shared-nothing" distributed architecture with no single point of failure to assure high availability and performance, allowing you to meet your most demanding mission-critical application requirements.

111 questions
0
votes
3 answers

MariaDB Galera Cluster

I ma trying setup MariaDB in cluster but looks like I stuck on this error: #mysqld -u mysql 130407 21:36:24 InnoDB: The InnoDB memory heap is disabled 130407 21:36:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130407 21:36:24 InnoDB:…
nonus25
  • 261
  • 1
  • 4
  • 9
0
votes
2 answers

MySQL NDB Data/Memory Usage

I am running a fast growing NDB cluster and I have limited (8GB) of physical memory on each of the two data nodes. I am worried that I will be running out of Data Memory so I started removing old data. However, the deletion doesn't show any…
Ehsan
  • 175
  • 2
  • 8
0
votes
1 answer

Unable to connect to MySQL cluster database

I am unable to connect to mysql cluster database after starting my management node, data node, mysql node. I made the necessary changes by adding the loadbalance in the dbURL. But I am not able to access the connection. The mysqld port is 1186.…
dwyane johnson
  • 13
  • 2
0
votes
1 answer

Setup MySQL replication - multiple machines?

i read a lot of mysql server repliaction tutorials, but there's no hint, if the slave server is on a second machine or on the same server but just another mysqld process? any advice? thanks in advance!
trnc
  • 688
  • 1
  • 12
  • 31
0
votes
1 answer

configuring mysql cluster server

Currently I have two servers: appbe - linux server with apache web server. db0 - linux server with mysql server. I want to add another linux server with another mysql server and and to use mysql-cluster server instead. I created a new linux server…
ufk
  • 333
  • 3
  • 8
  • 31
0
votes
1 answer

MySQL Cluster ndb_mgmd error

I set up MySQL Cluster on Ubuntu. My ndb_mgmd.cnf file looked: [NDBD DEFAULT] NoOfReplicas=2 DataDir= /var/lib/mysql-cluster # Management Node [NDB_MGMD] NodeId=1 HostName=192.168.204.20 DataDir=/var/lib/mysql-cluster # Storage Nodes (one for each…
vesper
  • 3
  • 3
0
votes
1 answer

MySQL hosting: What are the recommended specs and w

I have two specific cases of MySQL hosting. 1) I have a case where I have 2000 plus concurrent users to a single MySQL Database. They are not simple web users, but actual business users who need to connect write and read constantly through about 8-9…
ramdaz
  • 685
  • 1
  • 10
  • 26
0
votes
1 answer

Can I have a Redmine database on a MySQL cluster?

I have two servers, both Debian Linux. Currently I'm using them as a poor man's load balancer for high availability. However, currently I have only 1 MySQL server on the "master", so if the master goes down then the slave is useless. To solve this I…
Nick Bolton
  • 5,126
  • 12
  • 54
  • 62
0
votes
0 answers

kubernetes: URLs for Mysql operator YAML stable versions

Install mysql operator: Following https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-installation-kubectl.html kubectl apply -f https://raw.githubusercontent.com/mysql/mysql-operator/trunk/deploy/deploy-crds.yaml kubectl apply -f…
eastwater
  • 111
  • 2
0
votes
1 answer

kubernetes: Could not delete innodb cluster PODs forcefully

PODs could not be deleted: kubectl get all NAME READY STATUS RESTARTS AGE pod/mycluster-0 0/2 Terminating 0 15h pod/mycluster-1 0/2 Terminating 0 15h pod/mycluster-2 0/2 Terminating …
eastwater
  • 111
  • 2
0
votes
1 answer

Kubernetes InnoDBCluster: all pods should share one PersistentVolumeClaim?

Kubernetes InnoDBCluster: all pods should share one PersistentVolumeClaim? Following: https://dev.mysql.com/doc/mysql-operator/en/mysql-operator-innodbcluster-simple-kubectl.html kubectl create namespace mysql-cluster-test kubectl create secret…
eastwater
  • 111
  • 2
0
votes
1 answer

Zabbix DB connection support DNS SRV Records

I have Zabbix Mysql 3 node Innodb cluster, which gives 3 DNS SRV Records with Mysql Router endpoints. I need to configure Zabbix server and web DB connection as DB host (e.g _mysql._tcp.example.com), but it doesn't work. Are the any configuration…
Ritz
  • 1
0
votes
1 answer

Promote to Master a MySQL slave that has its own slaves

MySQL standby & chained replication Having the current setup (not using GTID) (see link to image): PRODUCTION NODES: MASTER (A) -> SLAVE (A1) + SLAVE (A2) STANDBY NODES: -> SLAVE (B) (with log_slave_updates enabled) -> SLAVE (B1) + SLAVE (B2) The…
MGS
  • 1
  • 2
0
votes
2 answers

MySQL NDB Cluster on FreeBSD 7.1

Got a problem with a MySQL Cluster, All the nodes connect fine to the ndb management node, however when I try to create a table on one of the nodes it returns this error : mysql> use foo; Database changed mysql> create table bar (i int)…
Bruce Grobler
  • 146
  • 1
  • 5
0
votes
0 answers

Getting error while connecting with other nodes in cluster

I create Galera cluster for mysql 8, when i'm restarting the nodes it is connecting in the cluster but after few seconds its getting disconnected. Please help me to fix this issue. Please see the logs- 2021-05-09T19:29:47.376651Z 0 [System]…
John The Hacker
  • 133
  • 9
1 2 3 4 5 6
7
8