0
votes
0answers
24 views

MySQL Cluster lock wait timeout exceeded when trying to deal with huge amount of queries

I'm trying to deal with many connections and sometime I get following error: ERROR : Lock wait timeout exceeded; try restarting transaction The bigger number of queries the least number of ...
0
votes
1answer
24 views

MySQL cluster replication: Slave cluster should not store any data except data replicated from master cluster?

I am researching MySQL cluster replication. I read a section "We assume that the slave server or cluster is dedicated to replication of the master, and that no other data is being stored on it" in ...
1
vote
1answer
40 views

MySQL cluster: Failover between data node

Today, I do some expirements for understanding MySQL cluster better. MySQL cluster works fine: ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration ...
0
votes
1answer
26 views

MySQL Cluster work well but ndb_desc doesn't work

I have deployed and configured MySQL cluster. It works fine. ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration [ndbd(NDB)]2 node(s) id=2@192.168.56.2 ...
0
votes
1answer
24 views

MySQL replication issue when master gets restarted

I have the following environment: NodeA and NodeB in NDB cluster. NodeC InnoDB outside cluster. NodeB is replication master and NodeC is slave. I have set up replication and it works fine. The ...
0
votes
1answer
62 views

Problem with MySQL Cluster in practice

I am researching MySQL cluster. For the purpose, I do a demo with 4 virtual machines. I have some problems in practice. Topology My topology contains four nodes Node 1: management node, ip address ...
1
vote
1answer
25 views

MySQL Cluster MaxNoOfConcurrentOperations and RAM

Why increasing of MaxNoOfConcurrentOperations lead to higher consumption of RAM? I need high value for fast filling tables with some random data, but i noticed that my datanodes are swapping at ...
1
vote
1answer
42 views

MySQL Cluster ndb_desc and parttions

I have mysql cluster with two datanodes and noofreplicas=2. According to documentation there must be 1 nodegroup, 2 partitions and 4 parts at all (2 primary and 2 backup). I have a table with 1000000 ...
0
votes
0answers
9 views

What is the preferred mode of replication for a MySQL Cluster?

Reading about MySQL Cluster, I'd like to know about what are the preferred models of replication. I understand that it supports asynchronous replication out of the box, but I'm not sure of how it ...
0
votes
0answers
72 views

MySQL Cluster management node does not start (node has different checksum)

Please help me to start data management node. I have installed cluster with autoinstaller and it was working. Now i'm trying to change config (i want to change amount of DataMemory) and run cluster. I ...
0
votes
0answers
53 views

Cluster with shared storage

I actually use MariaDB Galera Cluster with 3 master nods. Workload is about 70% read, 30% write and it's very important to have consistent data with every select - this is why I choose Galera ...
0
votes
0answers
21 views

MySQL distributed database with mysql access to each node

I have task to implement particular database structure: Multiple mysql servers with data using the same schema. Each server can see and edit only his particular part of data. And One master server ...
1
vote
1answer
55 views

How Many Nodes For MySQL Cluster Setup?

I quit not fully understand how exactly MySQL Cluster does to bring faster queries and faster databases operations. I have 1 MGM cluster (management cluster) 1 MySQL API cluser (mysqld) 2 ...
0
votes
0answers
20 views

Altering NOT NULL column in offline table

Regarding the MySQL Cluster documentation we are not allowed to modify a column to NOT NULL on ONLINE tables. i.e. ALTER TABLEfoo_barMODIFY COLUMNbazdecimal(11,8) NOT NULL Our hosting provider tells ...
0
votes
0answers
55 views

Upgrade 2 servers with master-master replication without data loss

We have two MySQL servers running with master-master replication in a Pacemaker cluster. If a database operation should be done, the primary server is asked first to do the job, if it fails, the ...
0
votes
1answer
56 views

Why there is a start (*) after Nodegroup:0 in MySQL cluster? What does it means?

I am new to MySQL and MySQL cluster setup. However going through several blogs and Web links I've finally able to manage the cluster up and running. I have 1 management, 1 SQL and 3 data nodes ...
0
votes
1answer
255 views

mysql cluster table full error

I installed a new mysql cluster on windows (for evaluation). I created a table using command below. After I insert just over 1 million records into the table it gives me the "table datadump is full" ...
0
votes
1answer
44 views

Disk page size for MySQL and MySQL cluster [closed]

As I know database reads data from disk in some constant page size (even if one byte is needed, whole page will be copied from disk to memory). What are disk page sizes for MySQL and MySQL Cluster? Is ...
0
votes
0answers
47 views

Why so much traffic between SQL Node and Data Node?

For a MySQL cluster I use one SQL Node and two DataNodes. On one Data Node I have started the linux command tcpdump and have observed the communication between the SQL and Data Node while I have ...
2
votes
1answer
121 views

MySQL cluster DataMemory and DiskPageBufferMemory parameters

I want to setup a MySQL cluster. The amount of data is more than double the amount of RAM. I have 3 Data Nodes each with 8GB RAM. QUESTIONS What is a good rule for the DataMemory and ...
1
vote
1answer
79 views

MySQL cluster concurrency

I have a little application that executes select queries against a MySQL cluster. By using 1 thread to read a record the latency is x. By using 2 threads to read records concurrently the avg latency ...
1
vote
2answers
316 views

Mysql cluster fast inserts but slow selects

I have a mysql cluster with 3 Data Nodes and one SQL node. Curently I have 1million 1kb records. The inserts are very fast, takes only a few ms. But the selects are very slow >20s. All machines are ...
1
vote
2answers
96 views

What is a mysqld process in a MySQL cluster?

As I know, a mysqld process is a kind of a router of a MySQl cluster. It directs requests to the right ndbd node. Assuming I have 3 ndbd nodes on 3 different machines and I don't use replication. How ...
2
votes
2answers
449 views

MySQL Cluster - Got error 1601 'Out extents, tablespace full' from NDB

I am trying to do some tests on MySQL Cluster. I am creating my database using following commands: CREATE DATABASE test1; use test1; CREATE LOGFILE GROUP lg1 ADD UNDOFILE 'undofile.dat' ENGINE = NDB; ...
1
vote
1answer
630 views

MySQL cluster 5.6 doesn't convert invalid TIMESTAMP value to '0000-00-00 00:00:00'?

According to the document: Invalid DATE, DATETIME, or TIMESTAMP values are converted to the “zero” value of the appropriate type ('0000-00-00' or '0000-00-00 00:00:00'). but it doesn't ...
0
votes
1answer
82 views

Approximation of table size for MySQL cluster

I want to make some approximation of table size for MySQL cluster. Please read my reasoning and tell me, if I am right or am I making mistake somewhere. I have simple table with PK (int) and ...
0
votes
0answers
59 views

Can I have a Distributed Database in which one database is MariaDB and the other one is MySQL Cluster?

This is a hypothetical question of course, I just want to know, because that's one of the question i'm going to be asked in my presentation and I have a feeling that the answer is "yes" after all my ...
0
votes
1answer
87 views

MySQL Cluster - strange syntax error

I have MySQL Cluster instance and want one column (BLOB) to be stored on disk instead of memory. I tried to follow this tutorial: ...
0
votes
0answers
388 views

Cannot start MySQL cluster with single node

For some testing I have installed MySQL Cluster. I can get it to work with configuration suggested in Lunix guick start guide. My configuration: [ndb_mgmd] hostname=localhost ...
1
vote
0answers
181 views

Delete operation mysql cluster

I am trying to delete some entries from table on a cluster and I get this error ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase ...
0
votes
1answer
127 views

Windows Service Management Node Won't Start

I'm trying to set up a basic Cluster on my Win7 PC for testing. But I am stuck at the first hurdle. I have installed the Management Node as a Service: ...
0
votes
1answer
57 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
168 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
122 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 ...
1
vote
1answer
110 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 ...
0
votes
2answers
163 views

MySQL Cluster - partitions on disk

I have question about MySQL Cluster: Is it possible to have database larger than amount of RAM? (to not have all cluster data in-memory, but some data will reside on clusters nodes hard disks) ...
1
vote
3answers
158 views

Where can I learn about MySQL master/slave, master/master, or clustering setups?

What are the best resources you've read or watched about setting up master/slave or clustering for database replication? I don't know much about this. I have a database that is getting rather large ...
1
vote
0answers
52 views

memcached+mysql cluster maximum memory

I'm deploying a system with memcached and mysql cluster. The command line is: memcached -E lib/ndb_engine.so -e "connectstring=maddy:1186;role=dev" I can't specify the -m argument since I used -E ...
3
votes
1answer
236 views

MySQL licensing

I have looked at a few questions posted in stackoverflow http://stackoverflow.com/questions/225987/can-someone-explain-mysqls-license-and-what-it-means-to-closed-source-developme ...
1
vote
1answer
299 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
211 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
143 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 ...
1
vote
2answers
98 views

Distributing MySQL database on n systems

I have a webserver in my application which talks to a single MySQL node. Instead of having just one MySQL node, I want to have a cluster of n nodes which form my database. Is it possible to do ...
4
votes
2answers
375 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
2k 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 ...
3
votes
1answer
285 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
2answers
1k views

MySQL Cluster On Cloud vs MySQL Cluster On Dedicated Cluster

I saw this interesting article : http://mikaelronstrom.blogspot.com/2012/02/105bn-qpm-using-mysql-cluster-72.html and it made me get interested in MySQL Cluster. After little chat with hosting ...
2
votes
3answers
460 views

MySQL Cluster Installation

I am very new to mysql-cluster.I downloaded the binaries and was trying to configure it on my local machine. Can anybody suggest how to install it on single machine with the 1 management node,2 data ...