The mysql-cluster tag has no wiki summary.
0
votes
0answers
13 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
16 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
23 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
54 views
What does “WSREP Aborter Idle” mean in a MariaDB Galera cluster?
I've tried to Google WSREP Aborter Idle but there are literally 3 results. Does anyone know what this means?
Should I be concerned that the these processes have been opened for so long or is this ...
0
votes
1answer
57 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
29 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
38 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
13 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 ...
1
vote
1answer
50 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 ...
0
votes
0answers
22 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
1answer
55 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 ...
0
votes
0answers
52 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 ...
1
vote
2answers
130 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
65 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
240 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
289 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
60 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
51 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
0answers
19 views
What does “Remove fully qualified host names from /etc/hosts and use these in config.ini for all clusters hosts” means?
Caution You cannot mix localhost and other host names or IP addresses
in config.ini. For these reasons, the solution in such cases (other
than to use IP addresses for all config.ini HostName ...
0
votes
1answer
74 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
196 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
...
0
votes
1answer
79 views
Can Mysql Cluster AQL(Push-Down Join) be trigger with sharding table at the same time?
From the jonas slide, I knew that the feature of "Push-Down Join" can make join 70x faster. the most important factor is to eliminate the round trip between API node and data nodes. where all data in ...
1
vote
0answers
98 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
2answers
515 views
MySQL Cluster - Table is full [Error 1114] while still creating tables
I am trying to forward engineer a MySQL Workbench model with about 100 tables to a development single-node cluster and, while creating the 51th table, I end up getting a "1114 table is full" error, ...
0
votes
1answer
86 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
89 views
Creating a database redundancy based on Mysql
I have this requirement where my web application running on a tomcat is behind a loadbalancer and I am planning to deploy this application on multiple servers.
This webapp though needs a database ( ...
2
votes
1answer
188 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 ...
0
votes
0answers
68 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
44 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
93 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
86 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
45 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
26 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
32 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
87 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
1answer
61 views
MySql Cluster for educational use
I am student and I am writing Master of Science paper about in-memory databases. I want to use MySql Cluster for benchmarks in my work.
Can I use MySql Cluster free of charge for educational purposes ...
1
vote
1answer
104 views
Error on data node startup in MySQL-cluster
Running a 24 core server (with HT enabled) I tried increasing MaxNoOfExecutionThreads to 24 to perform some benchmarks and got the following error:
2013-02-27 11:21:44 [ndbd] INFO -- Trying to ...
0
votes
2answers
142 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)
...
2
votes
1answer
160 views
Which database to use? [closed]
Hey there. I am looking for a free to use for commercial website database that should have these design features, in the given order:
Auto-Sharding (getting more free space by adding more server ...
0
votes
3answers
137 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
49 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
371 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 ...
1
vote
0answers
237 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 ...
3
votes
1answer
196 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
...
0
votes
1answer
205 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
179 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
122 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
92 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
311 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
1k 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 ...
