Questions tagged [ndbcluster]
NDB Cluster : MySQL's Distributed MultiMaster Storage Engine
113
questions
0
votes
0answers
20 views
MySQL Cluster Data node can't get the node ID?
I have a MySQL Multi Node ( Cluster ) like this
A is ndb_mgmd and also the client
B and C is ndbd
I have successfully set up everything but the Data Node just cant get the Node Id.
In ndb_mgmd server ...
-1
votes
1answer
13 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
9 views
Secondary management node not connecting
So this is the idea of the MySQL cluster:
192.168.0.82 = Management Node 1+ SQL Node 2
192.168.0.85 = Management Node 2 + SQL Node 2
192.168.0.83 = Data Node 1
192.168.0.84 = Data Node 2
The ...
0
votes
1answer
78 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
0answers
46 views
NDB cluster cant create new table. Error code:1005
While creating a new table i am getting Error code 1005.
Here is my query:
CREATE TABLE `ps_subscription_persistence_1`
( `id` varchar(40) NOT NULL,
`packet` varchar(204) DEFAULT NULL,
KEY `...
1
vote
0answers
28 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
100 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
104 views
MySQL CLustering Options
I have two MySQL Database Servers i.e.
One is Active Server --> Master and second is Passive Server --> Slave.
And as we know we have 3-4 MySQL HR,DR Solutions / Clustering options.For example
01 : ...
1
vote
0answers
68 views
MariaDB Galera slave thinks it's replicating, but it isn't
I have a MariaDB 10.3 Galera slave node with general logging turned on. It's consuming binlogs generated by a MySQL 5.5 NDB cluster. The binlog format is row-based in both databases.
SHOW ALL ...
0
votes
1answer
454 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
1answer
158 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
...
0
votes
2answers
201 views
Max DATAFILE size in NDB engine
My database setup is using NDB cluster with 2-3 nodes, on CentOS. While trying to test out the performance, i tried to store ~7mil records (around 2GB size) into one of the table. at around ~200k, it ...
0
votes
1answer
110 views
partition in ndbcluster
My environment will use 2-3 cluster nodes. The db schema at first was designed without knowing the limitation/rules with NDBCLUSTER on (BIG mistake! I know). Some things I notice and want to ...
0
votes
1answer
49 views
Ndb cluster change variable for heartbeat and disconnect
I search for a variable that I can increase in the server that I don't get any more this error:
Node 2 missed heartbeat 2
Node 3 Disconnected
Node 2 Disconnected
I don't find anything.
Regards,
0
votes
1answer
34 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
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
155 views
MySQL clusters - sync a table [closed]
I've been developing a software that runs on hardware and now I need to synchronise DB on them, but only partly - several tables using MySQL Clusters(don't matter which style), each of hardware can ...
-1
votes
1answer
251 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 ...
1
vote
1answer
74 views
What does SPJ stand for in MySQL parlance?
MySQL has a lot of references to SPJ in MySQL including in official Oracle slides but I can't find what it actually stands for. I see it show up in a few blogs too.
I looked in the source and found ...
2
votes
1answer
383 views
Can't connect to MySQL NDB manager using ndb_desc
I've got a basic MySQL NDB cluster running - it works well. Manager, data and SQL nodes are all OK. 1 manager, 2 SQL nodes, 4 data nodes. 2 of the data nodes are from the initial creation, 2 are ...
1
vote
0answers
83 views
MySQL NDB Installer won't start (webserver already running)
I have encountered an odd error where I accidentally closed the shell that was running the python script that launched the installer for NDB cluster. The site stopped working, however, when I try to ...
0
votes
2answers
545 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
486 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
78 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
1answer
118 views
Adding Memcached plugin to Mysql Cluster Fails to start
I was able to setup a new mysql cluster, with total 6 VMs. New requirement is to add memcache plugin to mysql cluster, memcache failing to start with this error message WARNING -- Failed to allocate ...
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
214 views
MySQL Cluster Only Sync Partially [closed]
I am new to MySQL, but I have to solve this problem quickly.
I installed FileRun (which is a file share service) on two nodes, those two nodes have MySQL Cluster backend.
In Filerun GUI, I created a ...
1
vote
0answers
19 views
How do I control the data that goes into each data node in NDBCLUSTER
I am currently working with NDBCLUSTER.
I have the following table(a dummy example, since I cannot disclose details about actual application, but the structure is similar):
create table student(
...
1
vote
0answers
221 views
Why ndb data memory is 94% if i m using disk storage cluster
I have following structure
2 data node
1 management node
2 sql node
i have create one log file of initial size 200M
then created table space and added 3 data file
data1.dat (initial size: 10GB)
...
1
vote
0answers
28 views
Unexpectedly long query time NDBCluster
I'm having an issue where some queries take an abnormal execution time, meaning 3 to 5 seconds.
This part of the schema is 2 tables A and B, where A has many to one relation to table B.
Table A:
...
0
votes
1answer
210 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
100 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
52 views
MySQL cluster and big database?
I hava a big mysql database(Innodb) about 50G, how can i import to mysql cluster.
What is the best solution to translate db, save on disk or get a amount memory?
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
272 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. ...
1
vote
1answer
216 views
Creating MySQL NDB cluster on Hyper-V
I want to create a MySQL NDB cluster on Hyper-V for testing so I have some questions in this regard.
Can I use Windows XP 32 bit? (because I already have a VM) If not then can I use Windows 7 or 10?
...
0
votes
1answer
238 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
481 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
181 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 ...
2
votes
1answer
1k views
Poor usage of timestamp index
with a small table (about 2 M of rows, 5 classic columns, id, description, title, created_at, coordinates (point)) doing a WHERE created_at BETWEEN ... AND ... ORDER BY created_at LIMIT 50 is very ...
2
votes
0answers
66 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-...
1
vote
2answers
977 views
Out of operation records in local data manager (increase MaxNoOfLocalOperations) from NDBCLUSTER
MaxNoOfConcurrentOperations=150000
MaxNoOfConcurrentTransactions=150000
MaxNoOfLocalOperations=150000
I have above parameters in config.ini, when i try to delete rows in a table i get below error
...
0
votes
1answer
94 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
238 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
531 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 ...
2
votes
1answer
1k views
All queries are so slow on mysql NDB cluster
Here is my situation:
I got over 10G of web logs (around 30 million rows) and I mainly search it with various conditions.
e.g.:
select * from tbl
where ip = '123.123.12.3'
and agent = '...
1
vote
1answer
450 views
MySQL NDB cluster maximum data size
According to the limitations outlined at http://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations.html, there can only be 48 data nodes.
Does that mean, with number of replicas 2, I can ...
2
votes
0answers
156 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)...
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 ...
