NDB Cluster : MySQL's Distributed MultiMaster Storage Engine
1
vote
1answer
43 views
Which one to use? InnoDB Replication or MySQL Cluster?
I am building a url shortener and I use InnoDB as the storage engine for link data. I will start with a single VPS containing both application instance and MySQL database instance on the same Virtual ...
0
votes
0answers
23 views
ERROR while doing coalesce partition Mysql Cluster
My table contains 3299000 rows. My Mysql Cluster contains 2 storage nodes with NoOfReplicas=2. By default it contains 2 partitions and after that i added 3 partitions more one by one using command ...
0
votes
1answer
22 views
Load balancing MySQL ndbcluster
I have successfully setup ndbcluster version 7.1.26. This contains 2 data nodes[NDBD], 2 mysql [MYSQLD] nodes and one management [MGMD] node. Replication works successfully. My Web application is ...
0
votes
1answer
37 views
Redo Logs Mysql Cluster
The mysql cluster has 4 directories namely D8 D9 D10 D11 for redo logfiles.
But while inserting into table only one redo directory is used.
I ran following command to get redo information "all dump ...
1
vote
0answers
23 views
Error in alter table reorganize partition for MySQL Cluster
My cluster contains 48 million rows and cluster contains 4 storage nodes . After that I add online storage node and executed alter table 'customer_tbl' reorganize partition.
Some parameters of ...
0
votes
0answers
24 views
After optimize table statement my data usage increased Mysql Cluster
I deleted 500000 rows in my mysql cluster table having 12468000 rows and then i tried to OPTIMIZE TABLE so that all the freed up data memory can be used by another table also, but after optimizing ...
0
votes
0answers
18 views
Re-use disk data extents after delete Mysql Cluster
In my mysql cluster i have 1 million rows and my disk data tables are using all the disk usage available to them ;i.e; free extents are 0 . Now i deleted 50K rows from ap_perf_tbl but still it show ...
0
votes
0answers
20 views
Why data usage increases when deleting rows Mysql Cluster?
My mysql cluster data nodes data usage increased to 95%. Then i tried to delete 500000 rows and my data usage of nodes started increasing initially and reached to 99% and above and TABLE FULL error is ...
1
vote
1answer
55 views
Data usage increases initially when reorganize partition mysql cluster
In my MySQL cluster, the data usage of 4 data nodes is approximately 77%. I added a new data node online, and attempted to reorganize partition to redistribute data among all data nodes.
But before ...
2
votes
1answer
166 views
How much data is needed to show MySQL Cluster's performance scaling vs. InnoDB
I am evaluating MySQL Cluster as a possible replacement for an InnoDB schema. So far, I have tested it with 10s of MB of data, and found MySQL Cluster slower than InnoDB; however, I have been told ...
0
votes
0answers
29 views
MYSQL Clutser (NDB) varchar storage requirement if indexed(Unique Index)
In MySQL Cluster (ndb engine) disk based table, if a column is varchar(255) with UNIQUE INDEX defined then,
For Latin(default) char set, does varchar column takes fixed size?
For UTF-8 (3 char ...
0
votes
1answer
72 views
Backup plan for MySQL NDB cluster databse not innoDB
I have a Database which will grow more than 250GB all data is in NDB engine(2 datanodes) and no other mysql engine used for data store.
What are the best approaches or plans for MySQL Cluster NDB ...
1
vote
0answers
145 views
MySQL cluster stuck in start phase 4, how to proceed?
Over the weekend our cluster we set up for evaluation had one of its data nodes lose network connectivity briefly. This was while another data node was in the middle of a restart (which had been going ...
0
votes
1answer
67 views
How to removing or reduce the size of redo logs in MySQL cluster
Can anybody tell me that how can we reduce the redo log file size or can we remove the redo log file size in MySQL Cluster and also what will be the impact of it on performance of cluster.Also can we ...
2
votes
1answer
94 views
How to solve the error “Error 'Got error 0 'No error' from NDBCLUSTER' on query”?
I'm currently working with a large network of MySQL 5.1 DBs (using MyISAM tables) and I'm evaluating a move to MySQL Cluster. I would like to have the MySQL Cluster replicate off of one of the ...
1
vote
1answer
83 views
MySQL Cluster Steps To Recover Data If Catstrophic Failure Occurs
I want to know if a catstrophic failure occurs (like a power outage), and all nodes in MySQL Cluster are shutdown in cluster then data will be lost even though a backup was taken? Or it possible that ...
0
votes
1answer
260 views
mysqld crash: is it a bug? [closed]
MySQL cluster forum doesn't seem to be very frequented these days, so I hope I get more help here.
I got the following error on several Windows machines with 32G RAM (using Server version: ...
0
votes
2answers
368 views
MySQL how to release memory used up by SELECT
I executed an INSERT IGNORE combined with SELECT from large table. The SELECT took up 16GB of memory and went into SWAP before I terminated it with CTRL+C.
INSERT IGNORE INTO sid(sid)
SELECT sid ...
0
votes
0answers
591 views
MySQL Cluster: Problem Connecting Nodes to Manager [closed]
After successfully setting up a test MySQL Cluster on Ubuntu I am now attempting it on Centos and have successfully started the management node, however I cannot get the data nodes to connect to the ...
3
votes
2answers
211 views
Is MySQL Clustering a viable option for a DB expecting 5TB of data in 5 years?
We plan to implement MySQL Clustering.The database should support 5 years of data and expected data/year is 1TB.
When we created a test enviornment with the DB size as 200GB, NDB Cluster took more ...
2
votes
2answers
695 views
MySQL Cluster: Problem Connecting the SQL node
In a MySQL cluster I have three hosts, one with a manager node, and the other two are each both a data node and sql node. Connecting to the manager is possible, however only as [ndbd] and not ...
4
votes
2answers
175 views
fast bulk incrementing in MySQL
I have one big table foobar describing a many-to-many-relation and containing millions of foo's, millions of bar's and every bar having several hundereds of foo's -> billions of rows.
CREATE TABLE ...
3
votes
1answer
206 views
Slow-running query on clustered MySQL environment
I've got a very simple query, directly equivalent to
SELECT * FROM sometable t WHERE somecol = 'somevalue' ORDER BY createdon DESC LIMIT 0,20000;
When I run this query on my non-clustered ...
1
vote
0answers
330 views
MySQL Cluster LOAD DATA too slow
mysql-5.5.22 ndb-7.2.6 cluster 64bit running on Centos 6 with each node installed on the same Citrix Xen Server communicating via a virtual private network. Each node has 4GB of RAM, 4 vCPUs and 10GB ...
0
votes
1answer
91 views
Better diagnostics when starting ndb nodes?
I have an ubuntu linux server that uses mysql cluster 7.2.5 x64.
Whenever I start an ndb node and check with ndb_mgm -e show, it stays in "starting" state for a long time. When I use top to check the ...
1
vote
0answers
70 views
Can't connect to MySQL Cluster Storage (data) nodes
I've deployed a MySQL Cluster with a few nodes, and I want to access the storage nodes directly from another machine using NDBAPI.
When I tried to connect from the same host it worked, but when I try ...
2
votes
1answer
210 views
Redesigning a multi-instance MySQL server for performance and resiliency
I've got a single MySQL server which currently runs N separate MySQL instances on, which are rapidly growing beyond the capabilities of that box.
Is it possible to have an active-active MySQL ...
2
votes
1answer
214 views
Dual management node for mysql clustering
I currently have mysql cluster setup and running.
Here is my current setup:
1 - management node
2 - data nodes
2 - mysql nodes
I wish to incorporate a failover for the management node. The ...
1
vote
1answer
124 views
MySQL row length is almost the triple of what I expect
I shamelessly took title and content from this question and adapted it to my similar yet different problem:
This is the table I have:
CREATE TABLE `test` (
`field1` MEDIUMINT(8) UNSIGNED NOT ...
0
votes
1answer
91 views
getting error while installing memcached_function
now i am working with memcached with mysql cluster 7.2
for that i am installed
libevent-1.4.14b-stable.tar.gz
memcached-1.4.5.tar.gz
libmemcached-0.8.tar.gz
then
...
1
vote
1answer
259 views
Unable to connect to MySQL cluster database
I am unable to connect to mysql cluster database after starting my management node, data node, mysql node. I made the necessary changes by adding the loadbalance in the dbURL. But I am not able to ...
2
votes
3answers
442 views
Need help configuring Memcached to store values in MySQL Cluster
I am working on a Memcached implementation with MySQL Cluster 7.2.
I have installed and configured memcached with following parameters:
PORT="11211"
USER="mysql"
MAXCONN="1024"
CACHESIZE="1024"
...
3
votes
1answer
458 views
mysql, changing tables from myisam to ndb
Gents,
Converting a table from myisam to ndb via:
ALTER TABLE piwik_log_profiling ENGINE NDBCLUSTER;
This will fail with:
BLOB column 'query' can't be used in key specification with the used ...
1
vote
1answer
129 views
MySql cluster data node replication
What I'd like to do is to replicate data nodes within a cluster not only for backup/failover purposes but also for scale-out reasons. Is this possible? If not: why? If yes: how do I do it?
Actually, ...
7
votes
4answers
2k views
MySQL Cluster RAM requirement
From MySQL 5.1, the data doesn't need to be entirely in memory anymore.
I've read that the indexed columns (I think the entire index structure) must still be in memory (MySQL High Availability, 2010, ...
2
votes
3answers
1k views
What's the difference between master and slave nodes in MySQL Cluster?
I use MySQL Cluster 7.1.15a.
I have 2 nodes, ndb_mgm -e shows:
[ndbd(NDB)] 2 node(s)
id=3 @X (mysql-5.1.56 ndb-7.1.15, starting, Nodegroup: 0, Master)
id=4 @Y (mysql-5.1.56 ndb-7.1.15, ...
7
votes
2answers
3k views
MySQL Sharding vs MySQL Cluster
Considering performance only, can a MySQL Cluster beat a custom data sharding MySQL solution? sharding = horizontal partitioning
When I refer to sharding, I'm considering sharding made in the ...
1
vote
2answers
247 views
MySQL statement in Project Voldemort site
I've just entered Project Voldemort (a NoSQL key-value datastore) site, and saw something interesting:
"Unlike MySQL replication, both reads and writes scale horizontally"
Well, seems like ...
2
votes
2answers
333 views
Using all the CPU cores by NDBD and MySQL
We are running MariaDB which is a fork of MySQL with NDB cluster engine.
The cluster includes one mysql node and two ndb data nodes. While benchmarking the cluster, we are trying to make a bottleneck ...
1
vote
1answer
687 views
Does mysqld --ndb-cluster need to be run on MySQL Cluster data nodes?
I have my management node and sql node on the same server, and 2 data nodes (3 machines in total). Do I need to run ./mysqld --ndb-cluster (or /etc/init.d/mysql-server start) on 1) the data nodes, or ...
1
vote
0answers
117 views
MySQL Cluster — Storing table data on data nodes [duplicate]
Possible Duplicate:
MySQL Cluster — Storing table data on data nodes
I have setup MySQL Cluster with the MySQL server node and the Management node on a single server, and 2 data nodes ...
3
votes
1answer
184 views
How do I configure a MySQL Cluster with a redundant mysqld host?
this is my first post here, so go easy on me.
I'm trying to rebuild my data architecture (which is currently a set of one primary MySQL server and a redundant fallback; the tables are primarily ...
6
votes
2answers
2k views
What are the benefits of using MySQL Cluster?
I have never dipped my hands in MySQL Cluster and want to know how it can benefit me. When is it best to use it, and does it have performance benefits?
