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
2answers
944 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
536 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
490 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 ...
3
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
669 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
78 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
738 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
186 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
202 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
276 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
262 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
121 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
686 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
116 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
380 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
338 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
303 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 ...