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.

106 questions
1
vote
0 answers

openstack aodh charm remains in waiting state “'shared-db' incomplete”

please I need your help, We are running a platform built on the openstack framework(Rocky). Recently we decided to install the Aodh service on our platform so as to enable autoscaling with Heat. Our infrastructure is running mysql/percona-cluster in…
0
votes
0 answers

mysql data node not connecting to node manager on AWS EC2

I am trying to setup mySql manager + data node + sql server (Server A) and another data node cluster on (Server B). Both running on Ubuntu 16.04 amd_64 Server A /etc/hosts also on Server B Both private ip 172.xx.xx.xx…
0
votes
0 answers

Can't connect to MySQL cluster from HAProxy + keepalived cluster

I'm new to clustering. I'm trying to configure keepalived in HA with HAProxy and MySQL cluster (+2 NDB cluster node). Configuration with 1 HAProxy (without keepalived and virtual ip address) seems to work properly (I can connect from client MySQL to…
0
votes
1 answer

MySQL Cluster -> Galera MariaDB Cluster Replication not working, but no errors

I am setting up a database migration between a 2-node master cluster running MySQL Cluster 7.2 (MySQL 5.5) and a 2-node slave cluster (plus arbitrator) running MariaDB 10.3 with Galera clustering. I currently have all but one of the Galera…
Brian Bauman
  • 216
  • 1
  • 2
  • 10
0
votes
0 answers

Failed to read uuid:seqno and wsrep_gtid_domain_id from joiner script?

I have a Galera Cluster in production which hosts 3 nodes. Nodes are Debian 9.5. I did some stupid stuff and edited my.cnf and corrupted some stuff. I reverted it back after long hours of fighting. 2 of my nodes manage to recover fine, they are…
Ümit Yayla
  • 11
  • 1
  • 4
0
votes
1 answer

InnoDB Cluster - MySQL 8.0.13 upgrade to 8.0.14 on Ubuntu 18.04.1 LTS - Cluster creation fails

With the recent upgrade of MySQL from 8.0.13 to 8.0.14 on Ubuntu 18.04.1 LTS, I started getting an error by the time I issue the dba.createCluster('mycluster') after following the procedure to create from scratch a 3 machine InnoDB Cluster using the…
0
votes
1 answer

Mysql InnoDb cluster adding new instance causes exception

I have created Centos 7 VM instance on Google cloud. I installed MySql 8.0 on this. Configured all proper settings. Edited my.cnf. After finalizing my instance I created the snapshot of this instance and created two more instances from this…
0
votes
1 answer

Cluster using virtual machine software with 2 workstations

I want to do a benchmark between databases (MySQL Cluster, HBase and Cassandra). I need 8 nodes. I have 2 workstations Dual-processor Z600: 1. workstation1: 16 core - 16 Go RAM 2. workstation2: 8 core - 16 Go RAM I would like to know if it's…
0
votes
1 answer

mysql service suddenly stopped working

I am suddenly not able to start mysql service /etc/init.d/mysql start Starting MySQL...... ERROR! The server quit without updating PID file (/var/lib/mysql/mysql.pid). I have tried to do the following but still not working chmod -R 777…
all_techie
  • 101
  • 1
0
votes
1 answer

How do i stop xinetd mysql service check to log every success?

How do I stop xinetd mysql service check to log every success? It creates a log entry every second the check is successful, I cant use log_on_failure as the service just checks mysqld and turns status=1 in case it is not running. Below is my…
AXPA
  • 1
  • 1
0
votes
1 answer

Unable to connect to SQL Node MySQL Cluster

I have a Management node, 2 Data Node and 2 SQL Node in 2 server. Management in one of the server. Im unable to connect to my SQL Node for some reason that don't know. I thought maybe I did something to the config file(which I did) so I fresh set up…
devilHunter
0
votes
1 answer

Do slow nodes bottleneck a Galera Cluster?

Let's say I have a 5 node cluster, with 3 SSD RAID 10 nodes and a 2 SSD RAID 1 nodes. Will the RAID 1 nodes slow down the entire network? How do the Galera cluster writes work? Does it have to wait until the slowest node (RAID 1) finish writing the…
Kevin
  • 1
  • 2
0
votes
1 answer

I/O usage high on drdb drives

The I/O usage is high on drives of drdb, but the usage is very low on the underlying drive. Is it right to ignore usage of I/O on DRDB drive as the underlying disk usage is fine. We have 4 Redhat Boxes Dell PowerEdge R630 (say a,b,c,d) having the…
Manu
  • 101
  • 6
0
votes
0 answers

How to write One data to Two MySQL NDB Cluster?

My company decided to upgrade the current MySQL NDB Cluster and reduce node size for increasing . The buy new Cluster machine with 4 nodes. Current cluster has 6 nodes. For make test on new cluster they suggest reprogram the current client scripts…
Sencer H.
  • 532
  • 1
  • 8
  • 17
0
votes
1 answer

ndbclient native library is missing in Mysql Cluster installation

I'm trying to run ClusterJ which cannot find ndbclient library. In my MySql Cluster 7.4 installation under Windows I have ndbclient_static.lib file in lib catalog. Why ndbclient library is not there? Or am I missing something here?