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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
18 views

Loadbalance mysql-proxy

I am looking for a solution setting up a MySQL Server in a redundant way. As for now, I have played around with MySQL, creating a InnoDB Cluster with 3 nodes, 1 primary and 2 secondary ones which give ...
user avatar
  • 101
0 votes
0 answers
23 views

Does storage engine ndbcluster support Data-at-Rest Encryption?

I want to enable Data-at-Rest Encryption in ndbcluster. I try to find how to make that but it doesn't solve this problem. Is there another way ? (I care about every solution. Although MySQL Enterprise ...
user avatar
0 votes
0 answers
56 views

All Nodes in Gallera Cluster(MariaDB) has seqno: -1

I Have 4 nodes in Galera Cluster and all of their has seqno: -1 and safe_to_bootstrap: 0 in grastate.dat , i can bootstrap one node manually and now all node is online and working fine but my ...
user avatar
0 votes
0 answers
1k 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-...
user avatar
1 vote
0 answers
105 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 ...
user avatar
1 vote
0 answers
72 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 ...
user avatar
0 votes
2 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 ...
user avatar
  • 101
0 votes
1 answer
114 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 ...
user avatar
  • 103
1 vote
2 answers
1k 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 ...
user avatar
0 votes
0 answers
216 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 ...
user avatar
1 vote
0 answers
94 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=...
user avatar
  • 111
0 votes
0 answers
518 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 ...
user avatar
  • 1
0 votes
1 answer
712 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 ...
user avatar
0 votes
0 answers
3k 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 ...
user avatar
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 ...
user avatar
  • 3
1 vote
1 answer
982 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....
user avatar
  • 123
1 vote
1 answer
676 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 ...
user avatar
  • 123
0 votes
1 answer
1k 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 ...
user avatar
0 votes
1 answer
54 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 ...
user avatar
0 votes
1 answer
991 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 ...
user avatar
1 vote
0 answers
455 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 ...
user avatar
0 votes
1 answer
214 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=...
user avatar
  • 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 ...
user avatar
3 votes
1 answer
7k 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 ...
user avatar
0 votes
1 answer
856 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 ...
user avatar
  • 1
1 vote
2 answers
70 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 ...
user avatar
0 votes
1 answer
457 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 ...
user avatar
  • 101
0 votes
0 answers
26 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 ...
user avatar
  • 532
4 votes
1 answer
833 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 ...
user avatar
  • 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 ...
user avatar
0 votes
1 answer
68 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? ...
user avatar
0 votes
1 answer
527 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 ...
user avatar
1 vote
1 answer
907 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 ...
user avatar
  • 123
0 votes
1 answer
38 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,...
user avatar
0 votes
2 answers
4k 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 473
0 votes
0 answers
79 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 1
0 votes
1 answer
322 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 ...
user avatar
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:...
user avatar
  • 211
0 votes
1 answer
882 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 ...
user avatar
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 ...
user avatar
  • 371
-1 votes
1 answer
848 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 ...
user avatar
  • 101
0 votes
0 answers
84 views

MySQL cluster data node restarts when its twin fails

Configuration: Server #1: 1 mgm node, 1 data node, 1 sql node Server #2: 1 mgm node, 1 data node, 1 sql node Specification: MySQL Cluster 7.3.6 x86_64 Debian 7.6 x86_64 It's been deployed by using ...
user avatar
  • 195
0 votes
1 answer
117 views

Tools for heterogeneous systems and way to start MySQL cluster automatically

I'm trying to auto start of MySQL Cluster. There are several nodes and several distinct processes, and I must start them in the proper order. Firstly, I must start ndb_mgmd on management nodes, ...
user avatar
  • 105
1 vote
1 answer
129 views

Unable to start MySQL server while configuring MySQL Cluster using its auto installer GUI?

We are trying to configure MySQL Cluster using its Auto Installer GUI. When we click on 'Deploy and Start MySQL Cluster' button, it showing a small popup with progress. Once it is reached at 57%, ...
user avatar
1 vote
1 answer
156 views

Compare between MYSQL cluster and MYSQL server

I have created a MYSQL cluster using network speed 100-megabit Ethernet 2 Data Node (3G RAM) 1 Management Node (3G RAM) 2 SQL Node (3G RAM) 2 HAProxy with heartbeat cluster to balance between SQL ...
user avatar
  • 255
-4 votes
1 answer
2k views

Does MySQL Cluster is compatible with PhpMyAdmin [closed]

I have a problem with MySQL Cluster and PhpMyAdmin, i'm not able to login in PhpMyAdmin when I start MySQL Cluster but I can when I just start MySQL. Someone has any idea how to solve my prob. Thanks
user avatar