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

0
votes
0answers
7 views

Web-Application scalability topology in different geographical locations [closed]

I am trying to make an always-on scalable application in two different locations. I have four components I understand that I need: DNS, Load balancing, Database, and the Web server. Database: For ...
0
votes
0answers
52 views

MySQL Error 1114 the table is full

I've got a MySQL cluster where I build a new database for each customer. The databases are relatively small in size and I currently only have 4 databases on this cluster. I just tried to run my ...
-1
votes
1answer
27 views

Error when setting up mysql cluster

I am trying to set up the mysql cluster. But when I try to start the mysqld(API) node, I get this error: 2014-12-02 17:02:37 0 [Warning] Using unique option prefix key_buffer instead of ...
0
votes
0answers
18 views

Error 2352: Ndbd file system inconsistency error

I have a simple mysql cluster with 2 nodes (id 3 and 4) that was working perfect. But, yesterday all querys started to fail, so I've just rebooted both nodes. But now, on node 3, the ndbd daemon is ...
0
votes
0answers
27 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
38 views

MySQL cluster data node restarts when its twin fails

Configuration: Server #1: 1 mgm node, 1 data node, 1 sql node Server #2: 1 mgm node, 1 data node, 1 sql node Specification: MySQL Cluster 7.3.6 x86_64 Debian 7.6 x86_64 It's been deployed by ...
0
votes
0answers
20 views

Configure Virtual IPs for a SQL Cluster in Level Platforms (AVG Managed Workplace)

We're using Level Platforms as our monitoring solution for networking devices and servers. I am trying to add a SQL cluster into monitoring. However, since we have a virtual IP set up for failover, ...
0
votes
1answer
43 views

Tools for heterogeneous systems and way to start MySQL cluster automatically

I'm trying to auto start of MySQL Cluster. There are several nodes and several distinct processes, and I must start them in the proper order. Firstly, I must start ndb_mgmd on management nodes, ...
0
votes
0answers
28 views

MySQL Cluster replication: NDB$MAX_DELETE_WIN() changes always applied in primary

I am building TWO mysql clusters (A & B) with master-master replication: A --> B --> A I followed the official MySQL doc to setup conflict resolution. Eventually we may have more than 2 ...
1
vote
1answer
63 views

Unable to start MySQL server while configuring MySQL Cluster using its auto installer GUI?

We are trying to configure MySQL Cluster using its Auto Installer GUI. When we click on 'Deploy and Start MySQL Cluster' button, it showing a small popup with progress. Once it is reached at 57%, ...
1
vote
1answer
72 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
238 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
44 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
22 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
87 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
328 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
322 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
45 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
78 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
43 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
1k 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 ...
1
vote
0answers
86 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
71 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 ...
1
vote
1answer
1k 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 . ...
6
votes
2answers
3k 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 ...
-1
votes
1answer
742 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 ...
1
vote
1answer
2k 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
332 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
194 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
127 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
1k 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
378 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
261 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
385 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
229 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
111 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
119 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
36 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
72 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
474 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
118 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
266 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
82 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
164 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
1k 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
110 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
1k 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 ...