Questions tagged [mysql-cluster]

MySQL's Distributed Database.

Filter by
Sorted by
Tagged with
0
votes
0answers
13 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
26 views

Errors when importing dump from MariaDB with InnoDB engine to MySQL Cluster with NDB engine

When i import DB dump from MariaDB 10.3 with InnoDB engine to MySQL Cluster 7.6 with NDB engine i receive errors: ERROR 1112 (42000) at line 159: Table 'NAME' uses an extension that doesn't exist in ...
0
votes
0answers
8 views

Error in NdbJTie : message missing NULL ptr in end of keyData list

Question: com.mysql.clusterj.ClusterJDatastoreException: Error in NdbJTie: returnCode , code 4,276, mysqlCode -1, status 2, classification 1, message Missing NULL ptr in end of keyData list I am ...
0
votes
0answers
26 views

MySQL Cluster: “The table is full” with disk storage

I have a problem with MySQL Cluster. I created a table in order to be stored in the disk but i think it's always stored in memory. I have have created a table with the query below: CREATE TABLE ...
0
votes
0answers
23 views

mysql pointing to 0:-1 partition

We have a Galera cluster on 3 nodes. On one of the nodes with SAN storage we experienced slowness in the cluster. iotop in the node with SAN storage shows that mysqld pointing to 00000...:-1 ...
0
votes
1answer
109 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
181 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
1answer
58 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
87 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
24 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
103 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
59 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
81 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
43 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
27 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
265 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
598 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
167 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
71 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
112 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
54 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
2k 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
347 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
295 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
45 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
807 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
163 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
81 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
201 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
2k 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
votes
2answers
3k 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
51 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
10k 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
168 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
406 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
144 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
1k 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
13k 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
63 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
1answer
92 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
72 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
191 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
424 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
267 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
127 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
573 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
5k 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
589 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 ...