MySQL Cluster : MySQL's Distributed Database

learn more… | top users | synonyms

1
vote
2answers
414 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 ...
2
votes
1answer
387 views

All four data nodes in MySQL Cluster in same node group

I am testing MySQL Cluster 7.2. I have two servers, mysql1 and mysql2. I want the management server and two data nodes to run on mysql1 and two other data nodes to run on mysql2. My config.ini file ...
1
vote
1answer
96 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
1answer
278 views

Does MariaDB-Galera Cluster support LAST_INSERT_ID and mysql_info?

As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query? LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock ...
1
vote
1answer
351 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 ...
0
votes
1answer
59 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
38 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
323 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" ...
2
votes
0answers
636 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 ...
1
vote
0answers
11 views

MySQL Cluster Master Master Replication - broken Leg

I have two MySQL Clusters which normally operate with Master - Master Replication between two of their nodes. Site 1 gets the majority of the write traffic, with Site 2 writing small amounts of ...
1
vote
0answers
236 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 ...
1
vote
0answers
133 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
0answers
53 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 ...
1
vote
0answers
501 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
0answers
16 views

Data usage increase although remove data in table MySQL Cluster

I try to test my MySQL cluster system. I add data to a table and use command ndb_mgm all report memoryusage. The data usage in data node increases. When I remove all data in the table and use command ...
0
votes
0answers
9 views

Is online schema change possible with MySQL Cluster?

I believe that this is the first question on this community. I'm surveying MySQL Cluster for next project in my workplace. I read a lot official/unofficial pages on the web. But I'm not a native ...
0
votes
0answers
15 views

ERROR 1297: Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER when importing data

I have the cluster built by one MGM Node and two data/sql nodes When importing data to an NDB node the importation crashes returning the following: ndb_2# mysql -u root -p db < data.sql Enter ...
0
votes
0answers
9 views

Can I use MySQL-SERVER tunning variables in MYSQL CLUSTER?

When tunning MySQL-SERVER for best performance, the edition is done down my.cnf file. Such as: max_connections = 500 wait_timeout = 600 sort_buffer_size = 2M Can I improve MySQL CLUSTER ...
0
votes
0answers
13 views

error add new data node to mysql cluster

i'm deploying MySQL Cluster and i have prolem when i want add a new data node to cluster, i follow this link enter link description here , but i get error at step 5. When i run command: ndbd -c ...
0
votes
0answers
16 views

MySQL Cluster online backup vs mysqldump. Automatization of cluster backups

There is some special kind of backups in MySQL Cluster: online backup It creates copies of data at Data Nodes. If I understand correctly this is backup of all data that can be stored at Data Nodes, ...
0
votes
0answers
106 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
0answers
10 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
24 views

MySQL Cluster Datafile Sizing and Information_schema files tables

I'm trying to migrate a system to MySQL Cluster which holds space around 30GB while it's originally stored in single mysql database where the storage engine is InnoDB. I try to write non-indexed ...
0
votes
0answers
116 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
82 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
23 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 ...
0
votes
0answers
25 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
71 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
0answers
49 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 ...
0
votes
0answers
27 views

Maximum number of records in MySQl NDB

I have a MySQL cluster table that consist of 1 primary key int (32) and 10 varchars of size 100. I use disk data tables. I have three data nodes with together 22GB RAM. How many records can I store ...
0
votes
0answers
29 views

MySQL cluster with RAID0

I use several EC2 (M1.LARGE) instances with ephemeral storage. Would RAID0 improve write and read performance? I'am only interested in performance. Has someone experience? Is the speedup=2??
0
votes
0answers
85 views

MySQL cluster performance very poor on Amazon

We have currently a project running where we need to store 1 to 20,30 million 500B to 2kB records. We need to use MySQL cluster on 4 EC2 instances (8GB Ram, 2 cores) and ephemeral storage (Records ...
0
votes
0answers
473 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 ...