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
0answers
17 views

ndb_mgm - command not found after installing MySql management server

ndb_mgm - command not found after installing MySql management server Ubuntu 16.04 mysql-cluster-community-management-server_8.0.20-1ubuntu16.04_amd64.deb server management started under system ...
0
votes
1answer
30 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 ...
0
votes
0answers
15 views

Percona xtradb cluster breaks with conflict message when importing data into it

I have been banging my head over the wall for the past 2 weeks on this. I initially thought this was due to a bad or unsupported DDL syntax. But right now I am not sure of anything anymore. I have a ...
0
votes
0answers
26 views

Second SQL Node does not connect when 1st is online

Our mysql cluster with two nodes is online for several years now and started to cause issues two days ago. The issue is that the second sql node changes from connected to disconnected state all the ...
1
vote
2answers
161 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
20 views

Can't run new Galera Cluster

I'm trying to run a new Galera Cluster on my local machine. I'm using CentOS 7 on Parallels Desktop. I followed all the instruction to bootstrap a new cluster but I keep getting this: MariaDB [(none)]...
0
votes
0answers
9 views

Mysql NDB with non stackable switch and teaming (Centos7)

My question concerns database, Linux and network. I have network latency and problems probably due to trunking & teaming issue when I try to add 2 more data nodes. Both 48ports switchs are ...
0
votes
0answers
45 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
40 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
189 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
347 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
459 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
503 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
82 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
504 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
402 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
243 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
103 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
1k 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
4k 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
682 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
65 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
294 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
24 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
695 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
60 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
421 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
633 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
36 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
3k 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
59 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 ...
0
votes
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
294 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 ...
1
vote
1answer
2k 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
839 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
809 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
107 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
124 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
145 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
279 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 ...
1
vote
1answer
1k views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...