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.

111 questions
1
vote
1 answer

MariaDB Galera SST Fails

I am running a 3 node MariaDB 10 Galera Cluster on CentOS 6. I have use this set-up before without issue else where but now when adding a 3rd node the SST fails with this error in the logs: 150212 18:03:02 [Warning] WSREP: 1.0 (server1.example.com):…
kemra102
  • 211
  • 4
  • 12
1
vote
0 answers

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 script to create a database for another customer and…
Jason
  • 381
  • 1
  • 7
  • 20
1
vote
1 answer

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%, after that the progress won't be changed at all.…
Sreejith PM
  • 11
  • 2
1
vote
1 answer

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 Nodes and I have created a separated MYSQL server…
Steve
  • 255
  • 2
  • 11
1
vote
1 answer

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 mysql mysql 6493449216 May 25 12:35…
mferpan
  • 43
  • 3
1
vote
1 answer

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 Percona data with a second data center so that we…
user209180
  • 87
  • 1
  • 2
  • 6
1
vote
2 answers

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 API nodes. Here's what happens: INFO -- Node…
Zenexer
  • 521
  • 8
  • 20
1
vote
0 answers

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 RAM per data node.
user201790
  • 11
  • 1
1
vote
1 answer

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 . -DCMAKE_INSTALL_PREFIX=/usr/local/mysqlc732/ -DWITH_NDB_TEST=ON make make…
quanta
  • 51,413
  • 19
  • 159
  • 217
1
vote
0 answers

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 was trying out several scenarios (basically failure…
User Conscious
  • 13
  • 2
1
vote
0 answers

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 forum.domain.com) Server3: BuddyPress Activity (Social Tab Menu…
RiseCakoPlusplus
  • 21
  • 1
1
vote
1 answer

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 larger queries there is a fair amount of IOWait.…
ethrbunny
  • 2,369
  • 4
  • 41
  • 75
1
vote
1 answer

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 see a substantial difference between the two. The…
internetdotcom
  • 123
  • 9
1
vote
1 answer

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 than 2 hours to restart. Is MySQL Clustering a…
srj
  • 11
  • 1
1
vote
1 answer

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 SELECTS) and under 1 second response time. However,…
Schodemeiss
  • 230
  • 1
  • 2
  • 7
1 2
3
4 5 6 7 8