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
1
vote
0answers
75 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-...
1
vote
0answers
65 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 ...
1
vote
0answers
32 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
0answers
79 views

MariaDB binary logging and master-master replication

I am trying to set up MariaDB master-master replication on a Debian server. Server version: 10.3.25-MariaDB-0+deb10u1 Debian 10. I have read many tutorials and all of them says it´s necessary to edit ...
0
votes
2answers
695 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 ...
0
votes
0answers
23 views

2 node cluster fiber channel storage migration

Inheriting a 2 node 2008R2 active/passive failover cluster running an instance of MS SQL I'd need to migrate the database to a new type storage. Currently each node has x2 2-port HBAs where each has ...
0
votes
1answer
56 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 ...
1
vote
2answers
796 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 ...
0
votes
0answers
158 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
0answers
66 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=...
0
votes
0answers
390 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 ...
0
votes
1answer
491 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 ...
0
votes
0answers
2k 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 ...
0
votes
1answer
949 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 ...
1
vote
1answer
682 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....
1
vote
1answer
284 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 ...
0
votes
1answer
825 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
1answer
50 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 ...
0
votes
1answer
787 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 ...
1
vote
0answers
362 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
1answer
151 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=...
0
votes
1answer
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 ...
3
votes
1answer
6k 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
1answer
817 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
vote
2answers
66 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 ...
0
votes
1answer
365 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 ...
0
votes
0answers
25 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 ...
4
votes
1answer
767 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 ...
2
votes
1answer
2k 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 ...
0
votes
1answer
61 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
1answer
487 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 ...
1
vote
1answer
824 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 ...
0
votes
1answer
37 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
2answers
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 ...
2
votes
2answers
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 ...
0
votes
1answer
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 ...
0
votes
0answers
74 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 ...
0
votes
0answers
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 ...
1
vote
1answer
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 ...
0
votes
1answer
302 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 ...
2
votes
1answer
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:...
0
votes
1answer
854 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
0answers
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 ...
-1
votes
1answer
831 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 ...
0
votes
0answers
83 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 ...
0
votes
1answer
109 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, ...
1
vote
1answer
126 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%, ...
1
vote
1answer
147 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 ...
-4
votes
1answer
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
1
vote
1answer
312 views

Clean ndb_binlog_index file

I have a question about one of my ndb clusters. because there are two files too big and I don't know why... ls -la -rw-rw---- 1 mysql mysql 32827950588 May 25 12:35 ndb_binlog_index.MYD -rw-rw---- 1 ...