Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql-cluster]

MySQL's Distributed Database.

0
votes
0answers
26 views

Parameters MASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be set when MASTER_AUTO_POSITION is active

I am trying to setup mysql 5.7 GTID replication but when I try to reset CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=1; I get the following error: ERROR 1776 (HY000): ...
0
votes
0answers
11 views

DataMemory and disk usage in MySQL NDBCLUSTER

Environment: mysql:5.7.23-ndb-7.6.7, CentOS 7.5.1804. There are 2 data node, 2 mgmd, and 2 mysqld. CREATE TABLE IF NOT EXISTS table_name_today ( id MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY ...
-1
votes
0answers
18 views

Can not start mysql cluster localhost mix with remote address

I am trying to use mysql cluster installer ndb_setup.py to set up 2 nodes mysql cluster and getting following error 2018-12-13 00:25:50 [MgmtSrvr] WARNING -- at line 35: [DB] BackupMaxWriteSize ...
0
votes
1answer
22 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
36 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
17 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. ...
0
votes
1answer
34 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
34 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
60 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
0answers
21 views

MySQL Shell Python Client library

Is there a python client library available to interact with MySQL Admin API and to do similar stuff that MySQL Shell does. From the documentation of MySQL Shell, I could see that there is a --py mode ...
1
vote
1answer
23 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
121 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
1answer
696 views

Node 3 can't connect in galera cluster

I have a cluster of mariadb 10.2.14 galera. We use amazon ec2 machine, with external drive for data and log for mariadb. My galera cluster is working correct with 2 node. But i get this error when ...
0
votes
2answers
194 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 ...
0
votes
1answer
108 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 ...
0
votes
2answers
59 views

Growing MySQL NDB Database. How to get High Availability?

Since last 2 year, we were using NDB Cluster for live database of our app, which is now have size of 7-10 GB, running on 6 Dedicated servers (6 data node, 2 api node, 1 mgm node) to have get maximun ...
1
vote
1answer
89 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
47 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
1k 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
287 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
182 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
31 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 ...
0
votes
0answers
230 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 ...
1
vote
1answer
586 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
99 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
57 views

by mistakenly deleted config.ini in mysql cluster

I was trying to delete cache file of mysql cluster for rolling restart but by mistake I have deleted directory /var/lib/mysql-cluster from both the nodes. I have ndb_1_config.bin.1 file but how can I ...
1
vote
0answers
22 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. ...
0
votes
1answer
156 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
1k 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. ...
1
vote
2answers
2k 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
35 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 ...
2
votes
1answer
6k 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
0answers
33 views

mysql process couldn't work on mysql cluster system

I try to create a mysql cluster system on Oracle Linux 7 however i can't start mysql process. it gives error. I deleted mysql and installed. rpm -Uvh MySQL-Cluster-client-gpl-7.2.26-1.el7.x86_64.rpm ...
0
votes
1answer
139 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
368 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
121 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 ...
4
votes
3answers
794 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 ...
1
vote
1answer
9k 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 ...
2
votes
0answers
60 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-...
0
votes
0answers
1k views

How to remove a failed node from the MariaDB Galera Cluster?

Assuming I have 5 nodes in the galera cluster. 2 nodes have failed and I can't restore them. I decided to remove 2 failed nodes from the cluster. How can we remove those two failed nodes?
0
votes
1answer
85 views

What is MySQL Cluster's Practical Memory Limit?

We are designing a cloud SaaS, and are actively considering MySQL Cluster choice for our DB. We will be writing more than 100M rows/day to the DB. We need to understand if there is any practical ...
0
votes
1answer
59 views

How mysqlcluster can be durable and consistent?

I'm little noob and learning on how to use mysqlcluster,i have 1 management 2 datanode and 2 sqlnodes.According to a book "mysql cookbook" -alex davies and localcheckpoints and globalcheckpoints By ...
1
vote
0answers
169 views

Can I fix Lost arbitrator node errors in MySQL Cluster / NDB?

I have a cluster of eight MySQL Cluster nodes running NDB. At seemingly random intervals (around 1.5 weeks on average, but they seem to come in spurts when they show up), I see a pair of messages like ...
1
vote
1answer
336 views

three-table JOIN query on a MySQL Cluster has become unusably slow

I have a select query called by a script to our MySQL Cluster that has gone from running in a second or two to taking well over a minute per query (and it has to run this query 24000 times). Nothing ...
1
vote
1answer
214 views

Where do i change the my.cnf on mysql cluster

I'm trying to change the max_allowed_packet setting on mysql cluster (version 7.4.8) - i have 5 nodes 2x SQL Node 2x Data Node 1x Managament Node I have updated the my.cnf on all of the servers -> [...
2
votes
0answers
101 views

Add index to mysql table with ndbcluster engine

I'm having trouble while adding index on mysql table with ndbcluster storage engine below is the error . [mysqlcluster ver. 7.4 GA] mysql> alter table `sks_staff_office` add index `pid_index` (pid)...
0
votes
1answer
393 views

Problem in starting MySQL Cluster

I have installed MySQL Cluster necessary packages and I am now using Auto installer to config the nodes properly. when I try to start the Cluster In Deploy Configuration part, all the nodes (1 ...
2
votes
1answer
2k views

MySQL Cluster: API node won't start successfully

I am working on setting up a MySQL NDB cluster in a test environment. I have 1 management node, 2 SQL nodes and 4 NDB nodes. The management nodes and NDB nodes all start successfully. They are ...
3
votes
1answer
4k views

Is MySQL Cluster a right choice?

I'm having a MySQL dual-master Replication of MySQL, each one of the servers have 21 GB memory, I'm now searching for a clustering solution for this project, It's possible to have 6 server: two of ...
1
vote
1answer
549 views

MySQL Cluster - How the Sharding works?

Right now I have a MySQL database with a couple of tables with around 20MM rows each; This DB is located on a single server ( 4gb RAM, 60GB storage, 2 CPUs) each table size is 4gb +-, but my server ...