Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mysql-cluster]

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 failure to assure high availability and performance, allowing you to meet your most demanding mission-critical application requirements.

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 failure to assure high availability and performance, allowing you to meet your most demanding mission-critical application requirements.

106 questions
1
vote
1 answer

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 understand how is it implement or is there a…
dwyane johnson
  • 13
  • 2
1
vote
2 answers

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 you land on the data must be ACID. E.g. when…
Gustav
  • 133
  • 1
  • 7
1
vote
1 answer

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 and InnoDB table types. NDB tables (MySQL Cluster)…
Debianuser
  • 421
  • 4
  • 10
  • 29
1
vote
1 answer

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 cluster, so we are looking at SSDs. Does anyone…
somecallmemike
  • 161
  • 1
  • 4
1
vote
2 answers

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 servers. As I read you cannot cluster directly from…
enedebe
  • 1,006
  • 3
  • 11
  • 17
1
vote
2 answers

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 cluster, the Data node and SQL node are same but…
user53864
  • 1,653
  • 8
  • 36
  • 66
1
vote
2 answers

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 MySQL cluster has THREE MySQL/query nodes (the…
Poni
  • 305
  • 3
  • 13
1
vote
1 answer

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 find a lot of information about it and reviews and…
Sparsh Gupta
  • 1,117
  • 7
  • 20
  • 31
1
vote
1 answer

Mixing of localhost (default for [NDBD]HostName) with other hostname(X.X.X.X) is illegal

I'm trying to create a mysql cluster configuration between two servers has mysql server 5.5 installed. on the main server I execute the ndb management server using the following command: ndb_mgmd -f conf/config.ini --initial…
ufk
  • 323
  • 3
  • 7
  • 26
1
vote
2 answers

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 trying to setup for the MySQL databases with…
user53864
  • 1,653
  • 8
  • 36
  • 66
1
vote
1 answer

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
rajesh
  • 11
  • 1
1
vote
2 answers

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 relocate or increase the HDD size sometime when…
Jonar
  • 171
  • 4
  • 13
1
vote
2 answers

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 then (RAM and servers count) ? Thank you.
John
  • 1,483
  • 2
  • 26
  • 45
1
vote
3 answers

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 newst Ubuntu 10.10 i mean, i can't remeber…
ParisNakitaKejser
  • 251
  • 2
  • 10
1
vote
0 answers

MySQL hangs on SELECT from table with blob fields

I managed to create a mysql InnoDB cluster with three nodes and a router everything works great but when i try to run a select query from the table below from a another server it freezes, but it works when i limit the result to a number under 26 SET…
mbouzahir
  • 77
  • 10
1 2 3
4
5 6 7 8