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.
116
questions
0
votes
1
answer
918
views
MySQL replication or MySQL cluster?
Currently i'm running Rails 3 web application with MySQL on one first server and Rails API application on second server that connects to the MySQL database from first server.
I'm not happy that API ...
1
vote
0
answers
2k
views
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 ...
- 381
-1
votes
1
answer
865
views
Error when setting up mysql cluster
I am trying to set up the mysql cluster. But when I try to start the mysqld(API) node, I get this error:
2014-12-02 17:02:37 0 [Warning] Using unique option prefix key_buffer instead of ...
- 101
0
votes
0
answers
89
views
MySQL cluster data node restarts when its twin fails
Configuration:
Server #1: 1 mgm node, 1 data node, 1 sql node
Server #2: 1 mgm node, 1 data node, 1 sql node
Specification:
MySQL Cluster 7.3.6 x86_64
Debian 7.6 x86_64
It's been deployed by using ...
- 195
0
votes
1
answer
121
views
Tools for heterogeneous systems and way to start MySQL cluster automatically
I'm trying to auto start of MySQL Cluster.
There are several nodes and several distinct processes, and I must start them in the proper order.
Firstly, I must start ndb_mgmd on management nodes, ...
- 115
1
vote
1
answer
139
views
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%, ...
- 11
1
vote
1
answer
190
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
-4
votes
1
answer
2k
views
Does MySQL Cluster is compatible with PhpMyAdmin [closed]
I have a problem with MySQL Cluster and PhpMyAdmin, i'm not able to login in PhpMyAdmin when I start MySQL Cluster but I can when I just start MySQL. Someone has any idea how to solve my prob. Thanks
1
vote
1
answer
347
views
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 ...
- 43
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
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
0
votes
1
answer
177
views
MySQL Cluster with no access to Data Nodes
I'd like to set up a MySQL Cluster for HA, but the client of the data cannot yet use ClusterJ.
I would like create 2 SQL Nodes and access only them from the client. i.e. No access to the NDB Data ...
- 253
1
vote
2
answers
5k
views
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 ...
- 601
1
vote
0
answers
217
views
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 ...
- 11
0
votes
0
answers
118
views
ndbd on solaris 5.10 can not allocate more than 4gb heap
I have a 2 data node mysql-cluster with 16gb memory and 10gb datamemory. I am trying to add two new data nodes on solaris 5.10 64 bit 16g ram machines. But I can't start the data nodes with more than ...
- 121
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.8k
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
-1
votes
1
answer
1k
views
MariaDB Galera Clustering - Active Active - Operation not permitted error
I am having issues with MariaDB and Galera running on RHEL 6.4 & 6.2 64bit servers and getting them to cluster. I installed the required RPM's for Galera clustering:
MariaDB-Galera-server
MariaDB-...
- 234
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
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:...
1
vote
0
answers
819
views
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 ...
0
votes
1
answer
676
views
mysql cluster .net client connection which host
I'm trying mysql cluster to use in a project for our customer.
The configuration I setted up is the following:
**Hardware S.O. equipment**
Server1 - S.O. Windows 2008 R2 64bit
Server2 - S.O. ...
- 1
0
votes
3
answers
8k
views
MariaDB Galera Cluster
I ma trying setup MariaDB in cluster but looks like I stuck on this error:
#mysqld -u mysql
130407 21:36:24 InnoDB: The InnoDB memory heap is disabled
130407 21:36:24 InnoDB: Mutexes and rw_locks use ...
- 261
4
votes
0
answers
868
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 ...
- 825
-1
votes
1
answer
73
views
how to grow mysql dynamically [closed]
we want to make a website, where we are using Pandora technique and using mysql database.
in our website we want to keep one table in which we add columns on run time and update table and this process ...
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
1
vote
0
answers
430
views
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)...
2
votes
3
answers
319
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
0
votes
2
answers
5k
views
MySQL NDB Data/Memory Usage
I am running a fast growing NDB cluster and I have limited (8GB) of physical memory on each of the two data nodes. I am worried that I will be running out of Data Memory so I started removing old data....
- 175
1
vote
1
answer
168
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,379
1
vote
1
answer
50
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
114
views
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 ...
- 11
1
vote
1
answer
2k
views
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 ...
- 230
3
votes
2
answers
158
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
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
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
181
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
0
votes
1
answer
364
views
Unable to connect to MySQL cluster database
I am unable to connect to mysql cluster database after starting my management node, data node, mysql node. I made the necessary changes by adding the loadbalance in the dbURL. But I am not able to ...
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
0
votes
1
answer
129
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 ...
- 698
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
1
vote
1
answer
884
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
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,086
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,753
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 ...
- 325
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
0
votes
1
answer
111
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 mysql-...
- 333
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
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,952
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
Related Tags
mysql × 75
mysql-replication × 35
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
- Michael Noll's early computer art - arranging graphic elements in a circular manner
- What exactly constitutes the Ubuntu iso file that you download when you "download Ubuntu"?
- What does one call the left and right sides of a building, in order to fix a point of view?
- What words of endearment may I use for describing a misbehaving child?
- Preprinting 19☐☐ year on UK postal vote envelopes
- C++ - Find all duplicate files (follow-up)
- Should Christians repent for the failures of Christianity to live up to Christ's commands in Church history?
- The incomplete sonnets at the beginning of Don Quixote - what does the pattern mean?
- Are Quantum Computers Bad at Addition?
- Why did the USA provide a $1 billion Patriot battery but not a $34 million F-16 to Ukraine?
- Ghost Story set on a Victorian age ocean going liner. Everyone who has slept in a certain cabin for the last four voyages has jumped overboard
- When is it important for a practitioner to understand CIs?
- If a Dragonborn is affiliated with a particular dragon race, is it more likely to inherit that race's alignment?
- What are some good examples of spectral sequences which degenerate after the first nontrivial differential?
- Examples of concrete games to apply Borel determinacy to
- Can a firmware upgrade take away the ability to unlock a bootloader?
- Breaking New Ground
- Simplest way to create a clickable list in MacOS that will cause selected programs to run
- Inductor energy storing in buck converter
- How does a Neural Net handle an unseen class for a Categorical Feature?
- Optimizing Multiple Subplot Visualization and Navigation in Matplotlib
- Did any country in the G20 not condemn the Iranian drone & missile attack on Israel?
- Layover in Beijing extended by two days
- Separating Gamma in two independent functions