MySQL Cluster, which is a distinct product from MySQL Server, is the industry's only real-time transactional relational database combining 99.999% availability with the low Total Cost of Ownership (TCO) of open source. It features a "shared-nothing" distributed architecture with no single point of ...

learn more… | top users | synonyms

1
vote
1answer
40 views

Compare between MYSQL cluster and MYSQL server

I have created a MYSQL cluster using network speed 100-megabit Ethernet 2 Data Node (3G RAM) 1 Management Node (3G RAM) 2 SQL Node (3G RAM) 2 HAProxy with heartbeat cluster to balance between SQL ...
-4
votes
1answer
64 views

Does MySQL Cluster is compatible with PhpMyAdmin [closed]

I have a problem with MySQL Cluster and PhpMyAdmin, i'm not able to login in PhpMyAdmin when I start MySQL Cluster but I can when I just start MySQL. Someone has any idea how to solve my prob. Thanks
1
vote
1answer
16 views

Clean ndb_binlog_index file

I have a question about one of my ndb clusters. because there are two files too big and I don't know why... ls -la -rw-rw---- 1 mysql mysql 32827950588 May 25 12:35 ndb_binlog_index.MYD -rw-rw---- 1 ...
0
votes
0answers
16 views

Cluster Manager Ignoring Config File

I have just setup my first cluster manually (not using the auto install) and it all works great. I have 1 SQL node, 2 data nodes and 1 management node (all on separate machines). I intend to port ...
1
vote
0answers
41 views

wrong directory 'cannot change the directory'

I am working on mysql cluster. I am following the mysql manual. But when I arrive at this step ndb_mgmd -f /var/lib/mysql-cluster/config.ini` ndbd I have this error: [ndbd] WARNING -- ...
1
vote
1answer
131 views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...
1
vote
2answers
92 views

MySQL Cluster. Have I Chosen the Wrong Data Engine?

We currently have a database running in production that's using MySQL 5.5 with InnoDB tables. As an evaluation, I've setup a MySQL Cluster (7.3) with MySQL (5.6) which has 2 Data Nodes, 2 SQL Nodes, ...
0
votes
1answer
18 views

MySQL Cluster with no access to Data Nodes

I'd like to set up a MySQL Cluster for HA, but the client of the data cannot yet use ClusterJ. I would like create 2 SQL Nodes and access only them from the client. i.e. No access to the NDB Data ...
0
votes
0answers
5 views

Mysql cluster 7.3 giving error while installation [duplicate]

I am installing mysql cluster 7.3 on windows 8. In the last step of installation when i have to "Deploy and start cluster" its giving the error msg "Command [u'net','start','N49'] returned non-zero ...
0
votes
0answers
27 views

MySQL Cluster client says ndbclient not loaded

I'm trying to create a JPA Client for a MySQL Cluster 7.3. (MySQL 5.6). I'm building the jpa client on OS-X and have copied the libndbclient.so.6.0.0 and libndbclient_static.a from the Cluster SQL ...
0
votes
0answers
24 views

Problems creating a JPA Client

I'm trying to create and run a Java client using Cluster JPA. I've set up a simple 4 node cluster with: 1 sql node 2 data nodes 1 management node I've created a maven based java ...
0
votes
1answer
361 views

Can't allocate nodeid for API

I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the ...
0
votes
0answers
54 views

Are there any known issues with different versions of DRBD running on different nodes in the same cluster?

We have two database servers, as part of some trial we tried using Dell Fusion IO disks as the database / logs disks. We've experienced some problems and Dell were not able to resolve them so we're ...
1
vote
0answers
59 views

MySQL Cluster data node in memory limits

What is the maximum amount of RAM per data node I can allocate to MySQL Cluster "in memory" database? I found some info about total size can not be more then 3 TB (48 data nodes) or 64 GB allocated ...
0
votes
0answers
61 views

ndbd on solaris 5.10 can not allocate more than 4gb heap

I have a 2 data node mysql-cluster with 16gb memory and 10gb datamemory. I am trying to add two new data nodes on solaris 5.10 64 bit 16g ram machines. But I can't start the data nodes with more than ...
0
votes
0answers
114 views

What would cause temporary error 4010 (node failure) on a MySQL cluster?

We recently set up a new MySQL cluster and are trying to load data from a flat file. But we get the error “Got temporary error 4010 'Node failure caused abort of transaction' from NDBCLUSTER" when we ...
0
votes
1answer
531 views

Benchmark MySQL Cluster using flexAsynch: No free node id found for mysqld(API)?

I am going to benchmark MySQL Cluster using flexAsynch follow this guide, details as below: mkdir /usr/local/mysqlc732/ cd /usr/local/src/mysql-cluster-gpl-7.3.2 cmake . ...
5
votes
2answers
1k views

MariaDB Cluster vs Percona Cluster for MySQL

What are the advantages and and disadvantages between the two? I've only been able to find information on these two implementations without any specifics on clusters. I'm currently implementing a ...
0
votes
0answers
58 views

MySQL Cluster 7.3 why is the SQL Node starting automatically

This is my first time running MySQL Cluster and I used the auto-installer to create the cluster. This is probably a newbie question but I can't find the answer. So the basic situation is as follows: ...
-1
votes
1answer
517 views

MariaDB Galera Clustering - Active Active - Operation not permitted error

I am having issues with MariaDB and Galera running on RHEL 6.4 & 6.2 64bit servers and getting them to cluster. I installed the required RPM's for Galera clustering: MariaDB-Galera-server ...
0
votes
0answers
86 views

Liferay6.0.6, mysql cluster 7.3, start with error “OPTION SQL_SELECT_LIMIT=DEFAULT” at line 1

I'm deploying liferay 6.0.6 server with a mysql cluster. When I start my liferay, it show error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server ...
1
vote
1answer
921 views

ndb cluster table is full

I'm using ndb cluster au to install with simpletest and high write load opstions. The cluster started successfully. Then I edited create-minimal-mysql.sql file by replacing InnoDB with NDBCLUSTER and ...
2
votes
1answer
210 views

When trying to delete a table from NDB Cluster, I get the error “4243: Index not found”

In a Linux-based NDB-cluster consisting of 7 API nodes, 1 Management node and 4 NDB nodes, I am trying to drop a table. When I try to drop the table using MySQL Client, I receive the following ...
1
vote
0answers
140 views

mysql cluster node lost connection shutdown

I'm testing a mysql cluster with VirtualBox using several virtual machines: Each virtual machine (2 in total) has a mysqld and ndbd node. Plus there's a vm for the ndb_mgmd to manage the cluster. I ...
0
votes
1answer
91 views

mysql cluster .net client connection which host

I'm trying mysql cluster to use in a project for our customer. The configuration I setted up is the following: **Hardware S.O. equipment** Server1 - S.O. Windows 2008 R2 64bit Server2 - S.O. ...
0
votes
3answers
930 views

MariaDB Galera Cluster

I ma trying setup MariaDB in cluster but looks like I stuck on this error: #mysqld -u mysql 130407 21:36:24 InnoDB: The InnoDB memory heap is disabled 130407 21:36:24 InnoDB: Mutexes and rw_locks use ...
3
votes
0answers
262 views

mysql client slow login strace

I am experiencing an issue with slow connections/logins to a loaded mysql server, even when connecting via the unix socket file (CentOS 6.3). Queries are completing very quickly -- (0.00 sec) in this ...
-1
votes
1answer
57 views

how to grow mysql dynamically [closed]

we want to make a website, where we are using Pandora technique and using mysql database. in our website we want to keep one table in which we add columns on run time and update table and this process ...
1
vote
1answer
196 views

MySQL Data Center Replication [closed]

I have a (possibly not so quick question) about the best way to set up a 'global' MySQL Database. I basically need to set up multiple MySQL servers in separate geographical locations that will all ...
3
votes
1answer
286 views

Add MySQL as a resource to pacemaker

I am trying to enable fail over strategy using pacemaker on a mysql Master-Master replication on two virtual machine running openSUSE 12 created by VritualBox. I managed to complete the mysql ...
1
vote
0answers
196 views

How to setup Wordpress High Availability

I have installed Galera Cluster on 3 cluster + 1 management. I wanted to make it like this, Server1: Home (www.domain.com) Server2: For BBpress/Forum (Forum Tab Menu will forward to ...
2
votes
3answers
97 views

MySQL Replication A->B->C

I was setting the MySQL Replication for master -> slave/master -> slave and Replication for master -> slave its works fine but when i have enable this option in my.cnf log-slave-updates=1 for ...
0
votes
2answers
1k views

MySQL NDB Data/Memory Usage

I am running a fast growing NDB cluster and I have limited (8GB) of physical memory on each of the two data nodes. I am worried that I will be running out of Data Memory so I started removing old ...
1
vote
1answer
109 views

MySQL cluster: 20Tb x 3K tables

Over the next 2-3 years we will be scaling up data collection for a project. As a result the amount of data will grow 10-fold. Our current MySQL installation can keep up with the 2Tb of data but for ...
1
vote
1answer
33 views

Purpose of “computer” section in MySQL Cluster 7.2?

According to the cluster documentation, you can either define data nodes with: [ndbd] NodeId=n HostName=1.2.3.4 or [ndbd] NodeId=n ExecuteOnComputer=m [computer] Id=m HostName=1.2.3.4 I don't ...
1
vote
1answer
58 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 ...
1
vote
1answer
380 views

Setting up MySQL Cluster on AWS

I have a web application which currently relies on MySQL. I have it running on AWS at the moment (using a stock RDS) and it can tolerate about 500 requests a second (with a 50/50 mix of INSERTS and ...
3
votes
2answers
117 views

MySQL Replication 'Catchup' UPDATES keep newer record

I've got two MySQL clusters that have Master-Master replication setup between them. Most tables are log based, with only inserts and selects, so they don't have any problems with the replication. ...
1
vote
2answers
2k views

Redundant FreeRADIUS + MySQL

I’m working on some web service having it’s AAA implemented by FreeRADIUS + MySQL on Debian. The problem I’m working right now is HA & scalability of RADIUS. If the FreeRADIUS machine or MySQL ...
1
vote
1answer
208 views

Adding MySQL servers/ data nodes into database clustering without restarting mysql cluster

I currently have mysql clustering up and running. For high scalability is there a way to include either mysql node, data nodes, or management nodes without restarting the entire cluster. I wish to ...
1
vote
2answers
80 views

How can I achieve ACID on multiple physical front-end servers

I'm looking for a way to have several physical front-end servers with ACID data access. In a setup where several servers gets load-balanced using DNS-round robin, the problem is that whatever server ...
0
votes
1answer
139 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 ...
1
vote
1answer
986 views

MySQL cluster for Drupal?

We have a pretty busy site based on Drupal and I was thinking of introducing some form of clustering for HA and Load balancing. However, http://drupal.org/requirements says: Drupal supports MyISAM ...
0
votes
1answer
109 views

Setup MySQL replication - multiple machines?

i read a lot of mysql server repliaction tutorials, but there's no hint, if the slave server is on a second machine or on the same server but just another mysqld process? any advice? thanks in ...
3
votes
1answer
949 views

MySQL on VMware for High Availability

Given a choice between the current database-level HA options for MySQL, like Master-Master, Cluster, or Galera, and vSphere HA for the machine running the MySQL master, which would you use or combine ...
1
vote
1answer
514 views

MySQL Cluster on SSD

We are planning to implement a four node MySQL Cluster and are considering using SSDs as the storage. We would like to get a high level of performance and very low latency on disk IO from the small ...
0
votes
2answers
472 views

Amazon AWS mysql RDS Cluster with outside AWS?

I'm now using AWS RDS multi-AZ with great results, the problem is that I want my infrastructure fault tolerant between regions. I'm looking for some kind of tool to make a cluster with RDS and my ...
1
vote
2answers
895 views

Mysql Cluster not working on Ubuntu

I am unable to setup MySQL Cluster on ubuntu servers. As a starting point I started from the link but I am not successful and the tar ball version I download is 6.3.45. As I wanted to test the mysql ...
0
votes
2answers
458 views

How to achieve high availability with MySQL cluster?

This question is not about how to install the servers nor its capabilities, but more of a design question. So I have a cluster of MySQL servers. I also have a DNS record "data.example.com". The ...
1
vote
1answer
626 views

mysql cluster with PHP

I have a very common LAMP stack with about 6-7 machines with PHP and Apache and a few machines with MySQL server (master+slave, sharding) I am exploring options of moving to MySQL Cluster. I couldnt ...