Questions tagged [mysql-cluster]

MySQL's Distributed Database.

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

MYSQL Cluster replication issue: Update did on table not replicated on slave

I have setup master---slave channel replication but facing issue replication of statement on tables from master to slave NOT OK. New tables created are replicated while update on tables are not ...
user avatar
  • 1
0 votes
0 answers
24 views

Mariadb galera cluster on asymmetric IP addresses fails IST/SST

I have a 3-node WAN cluster. The nodes are connected to each-other by VPN without a central server so as to avoid a single point of failure. Instead, each node is an openvpn server with another as ...
user avatar
0 votes
0 answers
38 views

1205 Lock wait timeout exceeded after switching to multi-primary topology in MySQL InnoDB Cluster

I have set up an InnoDB cluster using MySQL (version 8.0.23) Shell. I added three nodes to my cluster. At first, my topology was a single-primary topology where I had one master node and two slave ...
user avatar
1 vote
0 answers
263 views

Proxysql setup for Percona PXC Multimaster cluster

I have a clean Ubuntu lab setup for PXC Cluster and Proxysql (each a separate VM)and i'm seeing this issue (error below). Is there a specific installation that needs to be followed for PXC cluster? I ...
user avatar
  • 11
0 votes
1 answer
666 views

Mysql Innodb Cluster Replication

Hello Everyone, This is the first time I'm doing cluster replication. But I stuck on Adding Instance. I don't know why this error is coming behind. "The error says The START GROUP_REPLICATION ...
user avatar
  • 11
0 votes
1 answer
662 views

MySQL cluster Replication and Failover via docker-compose

I am using docker-compose to create MySQL cluster (NDB). After cluster gets created. This is my cluster configuration: ndb_mgm> show Connected to Management Server at: mysql-manager-1:1186 Cluster ...
user avatar
  • 3
1 vote
1 answer
751 views

Cannot rejoin or add instance to MySQL InnoDB cluster

I have a MySQL InnoDB cluster running where I had added three nodes, one is having the Primary role and the others are Secondary. Today morning, the two secondary nodes were removed from the cluster ...
user avatar
1 vote
1 answer
102 views

Is there a way to hide mysql innodb cluster queries from general_log?

When I start my innodb cluster I get many lines of cluster related logs in the mysql general_log file like below, how can I hide these from the log? 2020-06-26T14:40:43.719029Z 31774 Connect ...
user avatar
  • 21
0 votes
1 answer
40 views

Is there a way to set different destination order with mysql-router?

I have innodb cluster setup with 3 mysql instances. Each instance is on different server and each server has mysql-router also. I would like each mysql-router on each server to try to connect to the ...
user avatar
  • 21
-1 votes
1 answer
74 views

binlog not recording DML statement in mysqlcluster

I have created a MySQL NDB Cluster consisting of 2 data node, 1 mgm node and 1 mysqld for testing. Also i have created a slave for NDB to INNODB replication. My binlog are not recording DML statement ...
user avatar
0 votes
0 answers
39 views

MySQL cluster with HAProxy balancer outside of local network

I am building a mysql cluster on local network. I have 3 nodes and would like to load balance them using HAProxy. It works fine when I place HAProxy on one of my nodes inside of the network. I bind ...
user avatar
0 votes
1 answer
23 views

SQL Router Not Applying Round Rubin

I configure sql router under three machines and found if I use simple command mysql -u ia -pTest@123 --port=7001 then its not applying round rubin connection request but when i use with protocol ...
user avatar
0 votes
1 answer
240 views

mysql 8 ndbcluster distributed privileges

I've setup a mysql 8 ndbcluster but cannot get the distributed privileges working. following how to setup distributed privileges using NDB_STORED_USER (https://dev.mysql.com/doc/refman/8.0/en/mysql-...
user avatar
0 votes
1 answer
141 views

MySQL database cluster vs. replication setup for large crawler indexes

What is the most efficient way to set up a MySQL cluster or replication in an application that has a crawler/indexing engine with thousands of read/writes and then a separate front-end for public ...
user avatar
  • 121
1 vote
0 answers
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 ...
user avatar
0 votes
0 answers
169 views

ProxySQL and MySQL cluster

This article describes the set-up of MySQL cluster with one cluster node, two data nodes and one MySQL server. This article describes the configuration of ProxySQL where, MySQL servers are added into ...
user avatar
0 votes
1 answer
24 views

What will be with MySQL cluster if network problems between nodes?

I have 2 datacenters, each DC has MGT, SQL and Data nodes. How will MySQL NDB Cluster work if there are network problems between 2 DC? In this case 2 DC will work well, but they don't know ...
user avatar
0 votes
1 answer
695 views

MySQL Cluster - SQL node fail to connect Management Nodes

I am trying to deploy a 2 machines MySQL NDB Cluster with the following architecture: 192.168.1.12 – management node 192.168.1.12 – SQL node 192.168.1.12 – data node 192.168.1.13 – SQL node 192.168....
user avatar
0 votes
0 answers
3k views

Newly built MySQL Galera Cluster does not start up in CentOS 7

I am setting up a 3 node MySQL Galera Cluster lab environment. All 3 nodes are CentOS 7 and followed the steps in below blog to setup mysql-wsrep-5.7 https://www.dreamvps.com/tutorials/install-...
user avatar
0 votes
1 answer
333 views

config file and parameters for ndb_desc

I'm trying to execute ndb_desc from API client. The config and parameters are as below: my.cnf in mysqld: [mysql_cluster] ndb-connectstring=192.168.1.1,192.168.1.2 server-id=5 log-bin=mysql-bin ...
user avatar
2 votes
1 answer
548 views

How can coupled databases be kept in sync with selective uni-directional syncing and with connections that can be off for days?

I am trying to create a database topology that looks like this: .------------. Bad Connection. Bad Connection. | Central DB | May go offline May go offline '-----...
user avatar
0 votes
1 answer
72 views

What steps to take to resize an existing MYSQL NDB Cluster?

I have an existing NDB Cluster. It's grown larger than I expected and I need to make it bigger. When I ask the management console for the ALL REPORT MEMORY, it looks like the datamemory is 65% full. ...
user avatar
  • 103
-1 votes
1 answer
446 views

all gradestate.dat seqno: -1 why?

All my 3 nodes in mariadb galera cluster seqno is -1 and when i restart the whole cluster i need to start with --wsrep_new_cluster just to start the other nodes. can anyone help me with this? all 3 ...
user avatar
0 votes
1 answer
113 views

ProxySQL in PXC and failing all nodes

I'm going to install Percona XtraDB Cluster, and I have two questions about it: 1- Is it the last step? https://www.percona.com/doc/percona-xtradb-cluster/LATEST/verify.html Or installing ProxySQL ...
user avatar
0 votes
2 answers
783 views

MySQL Solution to Sync 3 servers data

I have 3 servers which there is a load-balancer in front of them and sends the requests to these servers randomly. The script is the same in all of these 3servers, but I need to sync the DB in all of ...
user avatar
1 vote
1 answer
31 views

Mysql cluster configuration help

I am new to mysql cluster I was reading around the web how to set it up. I came up with 2 different set up not sure which one is better fail safe vs cost efficient. Our new site have clients in USA ...
user avatar
0 votes
1 answer
788 views

How to delete previous incarnation in MySQL (/w Group Replication)

There exist almost no mentions whatsoever of MySQL "incarnations", so I'm opening this topic to make a precedent, even if I solve it myself. Feel free to help of course :) 2018-08-10T16:21:34....
user avatar
0 votes
2 answers
2k views

MySQL Cluster setup, receiving error "Specify node id"

I am attempting to set up a MySQL Cluster. I have the following setup: One management node Two data nodes One SQL node Below is the config.ini file: [ndbd default] # Options affecting ndbd processes ...
user avatar
-1 votes
1 answer
317 views

MySQL Cluster - Data Node Restarting when database corrupt

I initially Have MySQL cluster with 2 Management and 2 Datanode. I added 2 Data node online and redistribute its data. So my current cluster setup is 4 Management Node + SQL and 4 Data node. There ...
user avatar
2 votes
1 answer
312 views

MySQL InnoDB or MySQL NDB Cluster which one to use

We have an application with 8000 users accessing in parallel(max). We are trying to bring in horizontal scaling. I came across MySQL NDB cluster. Should I go with it? Just for auto sharding and other ...
user avatar
  • 121
0 votes
1 answer
79 views

I can't add extra node after reset root password mariadb 10.1.20

I have a mariadb 10.1.20 cluster with 5 nodes. I don't know root password so I did the following steps: On second node, I stopped mysql service I set wsrep = OFF on /etc/my.cnf.d/server.cnf I ...
user avatar
1 vote
1 answer
10k views

Dba.getCluster: This function is not available through a session to a standalone instance (RuntimeError)

I am using mysql innodb cluster. Connect to my instance use \c root@localhost:3306. The error message pops out when I issue var cluster = dba.getCluster('testCluster'). I've already created the ...
user avatar
  • 63
0 votes
2 answers
643 views

How to migrate MySQL Cluster (NDB) backup to a different ndb cluster?

I have two MySQL Clusters (NDB), Prod and Dev. Each cluster contains SQL nodes, Management nodes and Data nodes. Backups are done on one cluster using the article below: https://dev.mysql.com/doc/...
user avatar
0 votes
1 answer
645 views

Excessive RAM consumption in MySQL Cluster

at this moment I have configured a cluster that has 5 nodes: 2 data nodes 2 SQL nodes 1 node manager My file.config.ini is the following: [ndbd default] NoOfReplicas = 2 # Number of replicas ...
user avatar
0 votes
1 answer
111 views

Scaling MySQL Cluster

I have an NDB cluster which consists of 4 data nodes. Some of the configuration parameters and system resources as : CPU: 32 RAM: 128GB Replication factor: 2 Data memory: 70GB Index memory: 10GB I ...
user avatar
  • 63
1 vote
1 answer
2k views

MySQL Cluster 7.3 - NDB engine - Could not connect to storage engine

Setup I have installed three Oracle Linux 7.3. 2 for data nodes, 1 for management and SQL API node. The machines can ping each other, SSH working, "etc/hosts" files are properly filled: 127.0.0.1 ...
user avatar
  • 11
0 votes
1 answer
257 views

Geographical replication zones in MySQL Cluster?

In a default installation, data is shared indiscriminately across all data nodes. Is it possible to specify that certain tables can only be replicated across a specific group of data nodes? If so, ...
user avatar
0 votes
1 answer
115 views

Deleted config.ini in MySQL cluster by mistake

I was trying to delete cache file of MySQL cluster for rolling restart, but by mistake I deleted the directory /var/lib/mysql-cluster from both the nodes. I have ndb_1_config.bin.1 file, but how can ...
user avatar
1 vote
0 answers
25 views

Mysqlcluster data nodes synchronization rate

mysql cluster version: MySQL-Cluster-gpl-7.4.12-1.el6.x86_64 num of datanodes: 2 num of sqlnodes: 2 num of mgmt nodes: 2 Recently one on my datanode server was down(node4) due to power outage. ...
user avatar
-1 votes
1 answer
328 views

How do stored procedures work with NDB Mysql Cluster?

We are considering to use Mysql Cluster for sharding. However I can't find how it works with stored procedures. Is there a way to dispatch procedure invocation on particular shard, based on sharding ...
user avatar
0 votes
1 answer
4k views

MySQL Node not Connecting to Management Nodes in NDB Cluster

I am trying to deploy a 8 machine MySQL NDB Cluster with 2 Management Nodes, 2 SQL Nodes and 4 Data Nodes. The base operating system is Ubuntu 16.04 and the MySQL Cluster software version is 7.5.4. ...
user avatar
4 votes
2 answers
7k views

Mysql Group replication vs Mysql Cluster

[disclaimer] I'm not new to databases but totally novice about replication and cluster ... As you may know Mysql made available a new functionality : MySql Group Replication. Is anyone can explain ...
user avatar
  • 803
0 votes
1 answer
61 views

Problem in MySQL cluster when using two clusters

I have a master-slave MySQL Cluster 1 which is two way. It is working fine. I have another MySQL master-slave Cluster 2 where data is coming from Cluster 1 master to Cluster 2 master. It is also ...
user avatar
5 votes
2 answers
25k views

How to recover MariaDB Galera Cluster after full crash?

I crashed all my 3 nodes. After all nodes have been started I noticed that mariadb is dead. An I couldn't run it again. I am using CentOS 7 on all servers I tried to start first node and then others ...
user avatar
  • 343
0 votes
1 answer
344 views

mysql cluster with innodb utilizing high memory

I have implemented MySQL cluster with two data, sql and management node respectively. On one of the sql node I have ndb as well innodb engine for the huge tables which I can not able to convert into ...
user avatar
2 votes
1 answer
525 views

MySQL NDB Cluster architecture?

I am looking for information that I am not able to find about MySQL cluster. I have to justify if it is possible to install in a production environment the three types of nodes (MySQL node + Data ...
user avatar
0 votes
2 answers
213 views

MySQL NDB Cluster settings to prefer data node on localhost than remote

My current MySQL NDB Cluster configuration: Server 1 - management node Server 2 - huge machine running both ndbd and mysqld Server 3 - huge machine running both ndbd and mysqld NoOfReplicas = 1 So ...
user avatar
  • 149
6 votes
3 answers
4k views

Mysql Alter Tables took 5 hours to add 1 column

Had an issue recently where to add a column on a table with 1 million rows took 5 hours. I added a column with default value of 1. This was done during the night so there was not much activity on the ...
user avatar
  • 61
5 votes
2 answers
32k views

How to restart MariaDB Galera cluster?

How to restart MariaDB Galera cluster? After all node have been crashed I try to recover the cluster but without success. I have only 2 nodes. As documentation says I set a parameter on one of the ...
user avatar
  • 343
2 votes
0 answers
67 views

Mysql Cluster distribute data only one node..why?

here are following setup ndb_mgm -e show Connected to Management Server at: us-srv1.site.vrack:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=3 @192.168.0.2 (mysql-...
user avatar