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
261 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
163 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 ...
1
vote
2answers
990 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
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 ...
1
vote
1answer
553 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
525 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 ...
4
votes
2answers
2k views

Why mysql cluster does not use multiple cores of the CPU?

I have a problem with the ndbmtd process. When I use following configuration I expect both cores on our server with Intel(R) Pentium(R) CPU G6950 @ 2.80GHz will be fully utilized. Unfortunately this ...
1
vote
1answer
725 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 ...
0
votes
1answer
80 views

configuring mysql cluster server

Currently I have two servers: appbe - linux server with apache web server. db0 - linux server with mysql server. I want to add another linux server with another mysql server and and to use ...
3
votes
3answers
1k views

Database scalability with write-heavy application

I have a write-heavy application. The application is best compared to surveys - the customer creates custom questionares and this is saved to the database. Most of the requests are from their users ...
2
votes
1answer
2k views

MySQL Multi-Master Replication vs. MySQL Cluster

I need a MySQL database that is fast and supports many connections. Most of the connections will only be reading, but a few will be reading/writing. All connections will need to read and write at ...
0
votes
2answers
802 views

MySQL Binary Logs more than 15 GB

Binary log in one of my server has grown more than 15 GB even after setting the max size to 1 GB. The MySQL server is as well not starting. Can anyone highlight what might have caused it ? Thanks.
1
vote
2answers
193 views

Working setup for MySQL HA & LB

I have to setup High Availability and Load balancing for web(apache-tomcat+mod_jk) and MySQL(where all clients info is stored) server which are running on the same machine(ubuntu server). First I am ...
2
votes
2answers
203 views

Mysql cluster Vs basic Mysql db setup(not cluster)

Why mysql cluster requires more ram as compared to basic mysql db setup (no cluster)? What is the ideal ram requirement for a mysql cluster with 2 mysql servers on 2 different hosts ?
4
votes
2answers
286 views

Is MySQL Cluster appropriate for a small, low-volume multi-homed system?

I'd like to multi-home a proprietary web-based application for a relatively small user base with modest dataset size. Scalability is not as much of a concern as extremely high availability. The ...
0
votes
1answer
281 views

Can I have a Redmine database on a MySQL cluster?

I have two servers, both Debian Linux. Currently I'm using them as a poor man's load balancer for high availability. However, currently I have only 1 MySQL server on the "master", so if the master ...
1
vote
1answer
127 views

Mysql cluster strange behaviour

I have 2 mysql clusters on two different servers with management node on each of them. It went down someway. I ran following commands to start the cluster: Start the management node on srv1: srv1: ...
0
votes
1answer
729 views

MySQL hosting: What are the recommended specs and w

I have two specific cases of MySQL hosting. 1) I have a case where I have 2000 plus concurrent users to a single MySQL Database. They are not simple web users, but actual business users who need to ...
0
votes
1answer
118 views

mysql clustering

i am very new to mysql clustering.Can anybody explain me how to take backup on mysql clustering and how restore mysql clustering backup
1
vote
2answers
390 views

Scaling MySQL Database

What are the methods or tools used to scale mysql database. We have mysql database that is increasing in size daily. We just allotted a fix hard drive size on it so my concern is that we will need to ...
1
vote
2answers
345 views

MySQL cluster question

I am thinking about using MySQL cluster, but I am curious if it supports big databases - around 50-60GB or what is the limit (mainly Radius telco accounting are stored). What would be architecture ...
1
vote
3answers
310 views

looking for MySQL failover and loadbalace setup for clusting

i have setup my clusting for 3 mysql servers, 1 master and 2 nodes what i need to do right now its setup a failover system and loadbalace setup. Can sombardy link to a good article about that? i use ...