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
6
votes
2 answers

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 Percona Cluster but my only concern currently is with…
wathou6
  • 63
  • 1
  • 1
  • 3
4
votes
1 answer

I/O high on DRBD disk drbd10 on stacked site

We have 4 Redhat Boxes Dell PowerEdge R630 (say a,b,c,d) having the following OS/packages. RedHat EL 6.5 MySql Enterprise 5.6 DRBD 8.4 Corosync 1.4.7 We have setup 4-way stacked drbd resources as below: Cluster Cluster-1: servers a and b connected…
Manu
  • 101
  • 6
4
votes
0 answers

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 case -- but the login takes up to several…
carillonator
  • 805
  • 3
  • 12
  • 22
4
votes
1 answer

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 dual-master replication, and it seems to work. Server A…
mrz
  • 237
  • 1
  • 10
4
votes
3 answers

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 submitting these forms. Later on our customers do…
Luke
  • 1,892
  • 4
  • 22
  • 27
4
votes
2 answers

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 is not happening. Only core with id=0 is used.…
John
  • 1,483
  • 2
  • 26
  • 45
4
votes
2 answers

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 system has extremely basic architecture: PHP running…
dlo
  • 451
  • 1
  • 4
  • 14
3
votes
1 answer

Transform Galera cluster into single node mariadb server

We want to get rid of all cluster features on our galera cluster (currently consisting of three virtual machines). The connection between the nodes is not stable enough so the cluster is much slower than our previous single node setup was. Is it…
Christopher Thonfeld-Guckes
  • 37
  • 2
  • 7
3
votes
2 answers

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. However, I have a few tables that hold current…
giggsey
  • 83
  • 1
  • 1
  • 9
3
votes
1 answer

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 and why?
Terence Johnson
  • 463
  • 4
  • 12
3
votes
1 answer

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 least some data. I have 4 test servers to dedicate…
Brad
  • 1,389
  • 20
  • 43
3
votes
3 answers

MySQL-Cluster or Multi-Master for production? Performance issues?

We are expanding our network of webservers on EC2 to a number of different regions and currently use master/slave replication. We've found that over the past couple of months our slave has stopped replicating a number of times which required us to…
Phillip B Oldham
  • 1,016
  • 5
  • 15
  • 24
2
votes
1 answer

Failed to allocate nodeid for API at . Returned error: 'No free node id found for mysqld(API)

i have configured mysql-cluster in centos 7 Management Node db1 = 192.168.5.130 Data Nodes db2 = 192.168.5.131 db3 = 192.168.5.132 SQL Nodes db4 = 192.168.5.133 db5 = 192.168.5.134 output for management node as follows.. ndb_mgm> show Cluster…
Karthi Keyan
  • 21
  • 1
  • 4
2
votes
2 answers

What would be a stable, failproof, scalable galera cluster implementation

Context: We are using a MariaDB Gallera cluster with (only) 2 master nodes for a web application. Last night we had a power failure and now we can't seem to recover the data and found out the database was corrupt on both nodes. Our initial…
Malitta N
  • 31
  • 8
2
votes
2 answers

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, and 1 Mgm Node; all on separate machines. All of…
paiego
  • 253
  • 2
  • 8
1
2 3 4 5 6 7 8