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.
113
questions
0
votes
0
answers
104
views
MySQL Cluster mysqld not connecting to management
Using Ubuntu 22.04 on AWS EC2 for all nodes. ports 1186 and 3306 are open. I'm trying to follow this tutorial: https://www.digitalocean.com/community/tutorials/how-to-create-a-multi-node-mysql-cluster-...
0
votes
0
answers
35
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 ...
- 101
0
votes
0
answers
15
views
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/...
- 111
0
votes
1
answer
204
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 ...
- 111
0
votes
1
answer
84
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 ...
- 111
0
votes
1
answer
120
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
378
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
0
votes
1
answer
164
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 ...
- 1
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
188
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
166
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
2k
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
199
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
293
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
122
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
653
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
1k
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 ...
- 256
0
votes
0
answers
4k
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
1k
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
1k
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
59
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
602
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
299
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
2k
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
9k
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
78
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
523
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
38
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 ...
- 562
4
votes
1
answer
914
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
3k
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
69
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
582
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 ...
- 608
1
vote
1
answer
951
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
39
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
1k
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
90
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
366
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
1
vote
1
answer
3k
views
MariaDB Galera SST Fails
I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs:
150212 18:...
- 211
0
votes
1
answer
911
views
MySQL replication or MySQL cluster?
Currently i'm running Rails 3 web application with MySQL on one first server and Rails API application on second server that connects to the MySQL database from first server.
I'm not happy that API ...
1
vote
0
answers
2k
views
MySQL Error 1114 the table is full
I've got a MySQL cluster where I build a new database for each customer. The databases are relatively small in size and I currently only have 4 databases on this cluster. I just tried to run my ...
- 381
-1
votes
1
answer
861
views
Error when setting up mysql cluster
I am trying to set up the mysql cluster. But when I try to start the mysqld(API) node, I get this error:
2014-12-02 17:02:37 0 [Warning] Using unique option prefix key_buffer instead of ...
- 101
Related Tags
mysql × 74
mysql-replication × 33
cluster × 17
galera × 9
mariadb × 9
load-balancing × 7
linux × 5
kubernetes × 4
database × 4
innodb × 3
failovercluster × 3
haproxy × 3
replication × 3
virtual-machines × 3
benchmark × 2
drbd × 2
mysql5.5 × 2
mysql5 × 2
mysql8 × 2
percona × 2
scaling × 2
more related tags
Hot Network Questions
- Breathing strategies writing choral music
- How to be (more) critical during Code Reviews?
- Are banking and finance apps safe on android phone with cracked apps
- Deciding to not apply to a college that I have met with a faculty member, advice on what to do
- What does "Googs" really mean?
- Can sound waves be modulated?
- Wavelength of "complementary colours"?
- Difference between heteroskedasticity and overdispersion
- Special topics for introductory probability
- Incompatibility between beamer and pdfrender packages?
- What does this sequence of integral converge to?
- A check is a win
- How to define a root that is obtained by FindRoot as a variable?
- I have been asked to be on a tenure evaluation committee during my sabbatical, how should I respond?
- Two-Move Chess Game
- Can you receive the Foehammer Achievement in a dishonoured save and if you force exit the game before your party dies?
- What does "everything" mean?
- Is it possible to have higher compensation for lost hand luggage checked at the gate?
- How can I determine the cycle lengths in a directed graph?
- Which power source is good for my project?
- Conceptual misunderstanding in Buoyant forces
- 80% of respondents agreed…
- How do we explain the lack of activity in the study of Latin mathematics?
- Why does the heatshield have to be on the outside?