Questions tagged [mysql-cluster]

MySQL's Distributed Database.

Filter by
Sorted by
Tagged with
0
votes
0answers
14 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 ...
0
votes
0answers
20 views

Mysql Router not sending Write request to R/W instance

I am doing InnoDB Cluster Group Replication for the first time. I stuck at the last step Mysql Router. Mysql Router is configured with bootstrapping, But the main issue is MySQL router does not send ...
0
votes
0answers
29 views

MySQL InnoDB Cluster can't be created. Why?

I am trying to setup a MySQL InnoDB Cluster. I configured each node involved using dba.configureInstance(...). Everything was nominal until I ran var cluster = dba.createCluster('clusterNmae'). When I ...
1
vote
0answers
36 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 ...
0
votes
1answer
61 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 ...
0
votes
0answers
16 views

How to setup Galera Cluster when nodes are located multiple sites?

I am setting up a web app that runs on 2 sites and shares db, Initially I setup 1 Galera Cluster with all nodes in it, but sometimes SST on bringing node up takes lot of time and service start times ...
0
votes
1answer
188 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 ...
0
votes
1answer
194 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 ...
0
votes
0answers
51 views

What could cause mysql-router to not open/listen to port 6446 when running as a daemon?

I have a 3 primary node innodb cluster setup which is running as expected. To connect to these I have mysql-router setup, however, when running mysql-router as a daemon service mysql-router start it ...
1
vote
1answer
50 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 ...
0
votes
1answer
13 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 ...
-1
votes
1answer
25 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 ...
0
votes
0answers
21 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 ...
0
votes
1answer
21 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 ...
0
votes
1answer
110 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-...
0
votes
1answer
101 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 ...
1
vote
0answers
30 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 ...
0
votes
0answers
117 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 ...
0
votes
1answer
19 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 ...
0
votes
1answer
540 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....
0
votes
0answers
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-...
0
votes
1answer
208 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 ...
2
votes
1answer
400 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 '-----...
0
votes
1answer
40 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. ...
-1
votes
1answer
325 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 ...
0
votes
1answer
108 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 ...
0
votes
2answers
521 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 ...
1
vote
1answer
30 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 ...
0
votes
1answer
658 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....
0
votes
2answers
1k 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 ...
-1
votes
1answer
276 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 ...
2
votes
1answer
263 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 ...
0
votes
1answer
68 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 ...
0
votes
1answer
7k 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 ...
0
votes
2answers
581 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/...
0
votes
1answer
540 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 ...
0
votes
1answer
90 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 ...
1
vote
1answer
1k 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 ...
0
votes
1answer
224 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, ...
0
votes
1answer
105 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 ...
1
vote
0answers
24 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. ...
-1
votes
1answer
293 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 ...
0
votes
1answer
3k 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. ...
4
votes
2answers
6k 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 ...
0
votes
1answer
54 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 ...
5
votes
2answers
21k 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 ...
0
votes
1answer
263 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 ...
2
votes
1answer
499 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 ...
0
votes
2answers
185 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 ...
5
votes
3answers
3k 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 ...