Questions tagged [mysql-cluster]
MySQL's Distributed Database.
148
questions
-1
votes
2
answers
52
views
I am very frustrated by problems trying to set up mysql-cluster. There are no service files for NDB daemons
I am trying to get mysql-cluster going on Ubuntu 22 from the official MySQL apt repo.
I keep running into complications.
Certain ndb-related daemons are required ... like ndbd. But there are no ...
- 103
0
votes
2
answers
41
views
Can't drop an NDB database because the storage engine is unavailable
I tried to set up a MySQL cluster and failed. I finally got it switched back to standard MySQL, but now I have an ndbinfo database that I cannot drop. It causes my automysqlbackup cron job to report ...
- 103
1
vote
0
answers
8
views
Linux - MySQL Master/Slave cluster - upgrade 8.0.17 to 8.0.25
I'm running a cluster of MySql, 1 master, 1 slave (manage by an external app) on Linux and I would like to upgrade to the latest version in the same release without downtime.
8.0.17 to 8.0.25
...
0
votes
0
answers
24
views
InnoDB Cluster Nodes on Different OS
I am trying to create following scenario using InnoDB Cluster:
Primary Instance on Linux Server
Secondary Instances on Windows Server
But I got this error.
I just wanted to know, if this is even ...
- 19
0
votes
1
answer
32
views
MySQL partition failed
I do partition with 6.595.057 rows in MySQL with the Galera cluster. When I tried partition in server without galera, partition successfull. But when I tried partition in server with galera cluster, ...
0
votes
1
answer
44
views
NDB Cluster Read and Write Process multiple Access
When using the MySQL NDB Cluster distributed database, the following general problem has arisen: To insert a new Record / Row, the last row in the database should be read, see if it is compatible with ...
0
votes
2
answers
364
views
What is the best solution for synchronous sync and load balancing an InnoDB database
I'm trying to find the best setup to horizontally scale an ecommerce which is currently on a single dedicated server, but even reading some of the replies here on DBA I'm still confused on what is the ...
- 1
0
votes
0
answers
93
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 ...
- 101
1
vote
1
answer
402
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 ...
- 11
0
votes
1
answer
2k
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 ...
- 11
0
votes
1
answer
911
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 ...
- 3
1
vote
1
answer
2k
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 ...
1
vote
1
answer
167
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 ...
- 21
0
votes
1
answer
151
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 ...
- 21
-1
votes
1
answer
119
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
0
answers
103
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
1
answer
40
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 ...
- 11
0
votes
1
answer
336
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
1
answer
191
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 ...
- 121
1
vote
1
answer
136
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
0
answers
238
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 ...
- 145
0
votes
1
answer
52
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 ...
- 101
0
votes
1
answer
959
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
0
answers
4k
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
1
answer
423
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
...
- 13
2
votes
1
answer
622
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 '-----...
- 23
0
votes
1
answer
100
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. ...
- 103
-1
votes
1
answer
583
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 ...
- 11
0
votes
1
answer
118
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
2
answers
970
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
1
answer
33
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 ...
- 21
0
votes
1
answer
1k
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....
- 113
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 ...
-1
votes
1
answer
342
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 ...
- 99
2
votes
1
answer
422
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 ...
- 121
0
votes
1
answer
93
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 ...
- 129
1
vote
1
answer
15k
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 ...
- 173
0
votes
2
answers
783
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/...
- 3
1
vote
1
answer
704
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
1
answer
119
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 ...
- 73
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 ...
- 11
0
votes
1
answer
276
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, ...
- 103
0
votes
1
answer
122
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
0
answers
29
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. ...
- 155
-1
votes
1
answer
348
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 ...
- 101
0
votes
1
answer
5k
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. ...
- 3
4
votes
2
answers
8k
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 ...
- 813
0
votes
1
answer
94
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 ...
- 441
7
votes
2
answers
30k
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 ...
- 373
0
votes
1
answer
414
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 ...