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.
114
questions
6
votes
2
answers
11k
views
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 ...
- 63
4
votes
3
answers
10k
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 ...
- 1,942
4
votes
2
answers
354
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 ...
- 471
4
votes
1
answer
915
views
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 ...
- 101
4
votes
1
answer
1k
views
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-...
- 237
4
votes
0
answers
856
views
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 ...
- 815
3
votes
2
answers
4k
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,493
3
votes
3
answers
3k
views
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 ...
- 1,026
3
votes
1
answer
9k
views
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 ...
3
votes
1
answer
9k
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 ...
- 1,425
3
votes
1
answer
3k
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 ...
- 463
3
votes
2
answers
147
views
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.
...
- 83
2
votes
2
answers
5k
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.
- 23
2
votes
2
answers
2k
views
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, ...
- 253
2
votes
1
answer
382
views
How to MySQL replicate or cluster to setup a failover scenario?
after a massive data problem from my provider in GER, I'm now forced to deal with failover scenarios. But there are a few questions that I can't find any real answers to. So I hope someone can help me ...
- 135
2
votes
2
answers
1k
views
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 ...
- 31
2
votes
1
answer
7k
views
ndb cluster table is full
I'm using ndb cluster au to install with simpletest and high write load opstions.
The cluster started successfully. Then I edited create-minimal-mysql.sql file by replacing InnoDB with NDBCLUSTER and ...
- 129
2
votes
1
answer
3k
views
Failed to allocate nodeid for API at <ip-address>. 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 ...
- 21
2
votes
3
answers
305
views
MySQL Replication A->B->C
I was setting the MySQL Replication for master -> slave/master -> slave
and Replication for master -> slave its works fine but when
i have enable this option in my.cnf
log-slave-updates=1
for ...
- 261
2
votes
1
answer
658
views
MySQL cluster not working in ubuntu
I have a problem while installing and configuring MySQL cluster running on Ubuntu 10.10
This is configuration for Cluster management
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=10MB
IndexMemory=25MB
...
- 21
2
votes
1
answer
159
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: ...
- 51
2
votes
1
answer
1k
views
When trying to delete a table from NDB Cluster, I get the error "4243: Index not found"
In a Linux-based NDB-cluster consisting of 7 API nodes, 1 Management node and 4 NDB nodes, I am trying to drop a table.
When I try to drop the table using MySQL Client, I receive the following error:...
2
votes
2
answers
237
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 ?
- 51
1
vote
2
answers
78
views
How to create a multiple mysql replication
My question is about to create a mysql replication server.
Here i have multiple slaves and i want replicate all respective database into multiple master server .
Que is that how could i set multiple ...
- 11
1
vote
2
answers
6k
views
Redundant FreeRADIUS + MySQL
I’m working on some web service having it’s AAA implemented by FreeRADIUS + MySQL on Debian.
The problem I’m working right now is HA & scalability of RADIUS. If the FreeRADIUS machine or MySQL ...
- 11
1
vote
1
answer
879
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 ...
- 161
1
vote
2
answers
725
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 ...
- 171
1
vote
2
answers
2k
views
Will InnoDB or NDB cluster boost performance
We have fairly large MySQL database (about 35GB total) and topping about 900qps. Performance is not a big issue for now, but the project is growing constantly and I'd rather start thinking about ...
- 191
1
vote
2
answers
174
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 ...
- 133
1
vote
1
answer
2k
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 ...
- 1,147
1
vote
1
answer
167
views
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 ...
- 2,369
1
vote
1
answer
926
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
2
answers
2k
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 ...
- 1,733
1
vote
1
answer
2k
views
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 ...
- 333
1
vote
2
answers
271
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 ...
- 1,733
1
vote
2
answers
412
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,493
1
vote
1
answer
1k
views
How could I connect MySQL Server (on a EC2 ) from another EC2?
I create two instances on EC2 (CentOS 7). I am trying to deploy MySQL InnoDB Cluster. When I add instance (slave) I found master cannot be connected.
I can use GUI tool on my local to connect the ...
- 123
1
vote
1
answer
176
views
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 ...
- 255
1
vote
1
answer
1k
views
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 ...
- 87
1
vote
1
answer
3k
views
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/...
- 51.6k
1
vote
1
answer
49
views
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 ...
- 123
1
vote
1
answer
2k
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 ...
- 421
1
vote
2
answers
992
views
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 ...
- 1,076
1
vote
2
answers
2k
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 ...
- 315
1
vote
3
answers
346
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 ...
1
vote
0
answers
38
views
Running Initialization Script After Setting Up Aurora Serverless Cluster v2 Using Terraform
We have successfully created an Aurora Serverless Cluster v2 using the terraform-aws-rds-aurora Terraform module. Now, we want to run an initialization script after the cluster setup to create ...
- 11
1
vote
0
answers
189
views
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 ...
- 77
1
vote
0
answers
172
views
openstack aodh charm remains in waiting state “'shared-db' incomplete”
please I need your help, We are running a platform built on the openstack framework(Rocky). Recently we decided to install the Aodh service on our platform so as to enable autoscaling with Heat. Our ...
1
vote
0
answers
122
views
MySQL cluster unattended installation
I would like to install MySQL cluster without manual intervention. I tried following the steps on the official guide but couldn't quite get it to work.
What I have so far...
DEBIAN_FRONTEND=...
- 111
1
vote
1
answer
2k
views
I cannot remove instance from MySQL InnoDB Cluster, got error about get_string(7): field is NULL (LogicError)
I have a MySQL InnoDB Cluster(version 5.7). I just have two server, a master and a slave.
I am try to remove master instance to let slave promote to master.
When I execute command cluster....
- 123
Related Tags
mysql × 74
mysql-replication × 33
cluster × 17
mariadb × 9
galera × 9
load-balancing × 7
linux × 5
kubernetes × 4
database × 4
virtual-machines × 3
haproxy × 3
replication × 3
failovercluster × 3
innodb × 3
ubuntu × 2
google-cloud-platform
benchmark × 2
drbd × 2
percona × 2
scaling × 2
mysql5 × 2
mysql5.5 × 2
more related tags
Hot Network Questions
- Would a larger pipe bring hot water to a sink faster or slower than smaller pipe?
- Why does this bubble level have spirit tubes in pairs?
- Is it an anti-pattern to create ORM entities based on existing database schema?
- What is this quadruple-dotted X above the staff?
- How to project a vertex to the nearest point along a vector?
- Is "stife" a name for smoking cooking oil?
- Does China have no homeless people?
- Does the expansion and contraction of a variable star affect the measured radial velocity?
- What is the minimal density of a set A such that A+A = N?
- Did Cornelius Vanderbilt's descendants lose their family wealth by 1973?
- What was the first work that used an earworm as a defense against a mental attack or probe?
- How do I show employers that a long commute won't hinder my ability to perform my assigned duties?
- BKK transit on separate tickets without a transit visa
- bullet resistant space armor material?
- Why does the typical magneto switch have R on the left and L on the right?
- What are the best practices while printing digitally created PDFs?
- 220v Washer Dryer Machine Voltage Tolerance
- Does one accepted false statement allow proving anything?
- How does one express the ordering of thoughts?
- Diploria labyrinthiformis - can we reproduce Ernst Haeckel's drawing of a brain coral?
- This is on the bottom of a bronze vase (Characters identified: 萬歷秊製)
- Issue with the Hook Modifier in Curve Distortion
- Can I decline a professor's request for video conferencing?
- 90's movie involving a super-soldier, a fear-smelling "monster", and a trapped man and woman