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.
117 questions
0 votes
0 answers
40 views
what's the meaning of hostgroup_id explanation for proxysql
At: https://proxysql.com/documentation/ProxySQL-Configuration/ The proxy sql instructions say: NOTE: The backend MySQL servers have read_only = 1 configured on all replicas. ProxySQL considers backend ...
1 vote
0 answers
34 views
AWS RDS MySQL | Unable to launch snapshot in cluster mode
I am unable to launch an existing snapshot(300GB, having around 1000 schemas) into an MySql MultiAZ Cluster v8.0.36. Please find stats for the same Image: SingleAZ (1 node) 8GB Launching ...
0 votes
1 answer
319 views
Kubernetes MySQL Operator 8.4.0 not ready (stuck on start)
I have followed step by step the instructions to deploy the MySQL operator on Kubernetes. Following the instructions from the official page. Once deployed without errors, the operator is not in ready ...
- 1
1 vote
0 answers
120 views
Using Clone for addInstance on MySQL Innodb Cluster uses 100% Memory
When trying to add a new node to a MySQL Innodb cluster using Cluster.addInstance() and selecting the Clone option, within 2 or 3 minutes the donor nodes memory usages hits 100% on a server with 36Gb ...
- 11
0 votes
1 answer
238 views
mySQL master-master replication
I have a 3 server mySQL/PHP/Apache cluster (each on different continents for maximum resilience). I have read a lot of advice which all says - don't do this! Essentially the reasons I want to do this ...
- 157
1 vote
0 answers
215 views
Running Initialization Script After Setting Up Aurora Serverless Cluster v2 Using Terraform
We have successfully created an Aurora Serverless Cluster v2 using the terraform-aws-rds-aurora Terraform module. Now, we want to run an initialization script after the cluster setup to create ...
- 11
1 vote
1 answer
449 views
Oracle MySQL operator for kubernetes backup to S3 using service account
I've installed the operator, and trying to create the innodb cluster with backup profile which uses S3. There is no mention of S3 in the documentation, but they mentioned in a conference about S3 ...
- 113
0 votes
1 answer
703 views
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 ...
- 109
0 votes
1 answer
426 views
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 ...
- 109
0 votes
1 answer
232 views
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), ...
- 1
2 votes
1 answer
1k views
How to MySQL replicate or cluster to setup a failover scenario?
after a massive data problem from my provider in GER, I'm now forced to deal with failover scenarios. But there are a few questions that I can't find any real answers to. So I hope someone can help me ...
- 135
1 vote
1 answer
591 views
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 ...
- 11
0 votes
0 answers
3k views
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-...
- 133
1 vote
0 answers
248 views
MySQL hangs on SELECT from table with blob fields
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 it works ...
- 77
1 vote
0 answers
241 views
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 ...
0 votes
3 answers
4k views
Haproxy with MySQL Cluster Setup
I have 2 MySQL servers with master-master replication between them. The replication is working fine. I need to configure high availability between them so that if either one of them goes down, the ...
- 101
0 votes
1 answer
273 views
GCP Cloud SQL HA mySQL, which public IP to connect?
Taken from this link: https://cloud.google.com/sql/docs/mysql/high-availability#normal After setup a 2nd generation mySQL failover instance in Cloud SQL, found that actually two IP addresses were ...
google-cloud-platform
1 vote
2 answers
2k views
Will InnoDB or NDB cluster boost performance
We have fairly large MySQL database (about 35GB total) and topping about 900qps. Performance is not a big issue for now, but the project is growing constantly and I'd rather start thinking about ...
- 191
0 votes
0 answers
378 views
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 ...
1 vote
0 answers
190 views
MySQL cluster unattended installation
I would like to install MySQL cluster without manual intervention. I tried following the steps on the official guide but couldn't quite get it to work. What I have so far... DEBIAN_FRONTEND=...
- 111
0 votes
0 answers
795 views
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 ...
- 1
0 votes
1 answer
2k views
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 ...
- 266
0 votes
0 answers
5k views
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 ...
- 11
0 votes
1 answer
2k views
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 ...
- 3
1 vote
1 answer
2k views
I cannot remove instance from MySQL InnoDB Cluster, got error about get_string(7): field is NULL (LogicError)
I have a MySQL InnoDB Cluster(version 5.7). I just have two server, a master and a slave. I am try to remove master instance to let slave promote to master. When I execute command cluster....
- 123
1 vote
1 answer
2k views
How could I connect MySQL Server (on a EC2 ) from another EC2?
I create two instances on EC2 (CentOS 7). I am trying to deploy MySQL InnoDB Cluster. When I add instance (slave) I found master cannot be connected. I can use GUI tool on my local to connect the ...
- 123
0 votes
1 answer
2k views
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 ...
0 votes
1 answer
98 views
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 ...
- 11
0 votes
1 answer
1k views
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 ...
- 101
1 vote
0 answers
723 views
The ndb_mgmd daemon does not start
The ndb_mgmd daemon does not start I want to configure a NDB Mysql cluster, I followed the documentation of its official page. Install version 7.5 of mysql-cluster-community and I have the following ...
0 votes
1 answer
348 views
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
0 votes
1 answer
3k views
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 ...
devilHunter
3 votes
1 answer
11k views
Transform Galera cluster into single node mariadb server
We want to get rid of all cluster features on our galera cluster (currently consisting of three virtual machines). The connection between the nodes is not stable enough so the cluster is much slower ...
0 votes
1 answer
1k views
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 ...
- 1
1 vote
2 answers
168 views
How to create a multiple mysql replication
My question is about to create a mysql replication server. Here i have multiple slaves and i want replicate all respective database into multiple master server . Que is that how could i set multiple ...
- 11
0 votes
1 answer
640 views
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 ...
- 101
0 votes
0 answers
92 views
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 ...
- 612
4 votes
1 answer
983 views
I/O high on DRBD disk drbd10 on stacked site
We have 4 Redhat Boxes Dell PowerEdge R630 (say a,b,c,d) having the following OS/packages. RedHat EL 6.5 MySql Enterprise 5.6 DRBD 8.4 Corosync 1.4.7 We have setup 4-way stacked drbd resources as ...
- 101
2 votes
1 answer
4k views
Failed to allocate nodeid for API at <ip-address>. Returned error: 'No free node id found for mysqld(API)
i have configured mysql-cluster in centos 7 Management Node db1 = 192.168.5.130 Data Nodes db2 = 192.168.5.131 db3 = 192.168.5.132 SQL Nodes db4 = 192.168.5.133 db5 = 192.168.5.134 output for ...
- 21
0 votes
1 answer
81 views
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? ...
0 votes
1 answer
638 views
How to import large mysql database (innodb , myisam tables) to MySQL NDB cluster
Mysqlcluster used:- GA 7.4, Centos 7 I have 30GB each physical memory in 2 datanodes and SSD 200GB each but the database size(cumulative size of multiple db's belonging to free radius ) is around ...
- 628
1 vote
1 answer
1k views
HAProxy load balancing issue
I have the following configurations for load balancing a precona cluster. haproxy.cfg global log 127.0.0.1 local1 notice maxconn 4096 user haproxy group haproxy ...
- 123
0 votes
1 answer
46 views
Are There any Web-Based Load-Balancing Managers? [closed]
I've setup load-balancing and clustering on a few linux systems for serving web and database content, and each time it's a fairly laborious process. So I'm wondering, are there any web-based managers,...
0 votes
2 answers
5k views
Galera new cluster WSREP Unknown error 141
I am trying to create a new Galera cluster in the cloud using Ansible (DevOps tool). I can get the cluster started by issuing commands from an SSH shell, but not from Ansible. I have simplified the ...
2 votes
2 answers
2k views
What would be a stable, failproof, scalable galera cluster implementation
Context: We are using a MariaDB Gallera cluster with (only) 2 master nodes for a web application. Last night we had a power failure and now we can't seem to recover the data and found out the database ...
- 31
0 votes
1 answer
1k views
different servers different databases replication mysql
I am not sure if this is possible or not but I have 3 servers. Server A, B and C Server A has database A_dataBase, B_database Server B has database A_dataBase, B_database and C_database Server C has ...
- 483
0 votes
0 answers
116 views
MySQL Master migration
I've run into an unforeseen issue regarding a MySQL Master node: The cloud instance on which it's installed is soon to be retired. I've not needed to perform a migration like this before, so I'm ...
- 131
0 votes
0 answers
2k views
Mariadb galera node error when joinning cluster
I am getting these errors when trying to join nodes to a master. Ubuntu 14.04 MariaDb Galera 5.5.42. I had this problem with rsync as well. No iptables rules blocking connections. Any help would be ...
- 213
0 votes
1 answer
2k views
MySQL Bad Handshake to MySQL Cluster behind Proxy
I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine ...
- 1
0 votes
1 answer
398 views
MySQL Cluster ndb_restore fails without error
I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
- 101