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
0
votes
1 answer

ndbclient native library is missing in Mysql Cluster installation

I'm trying to run ClusterJ which cannot find ndbclient library. In my MySql Cluster 7.4 installation under Windows I have ndbclient_static.lib file in lib catalog. Why ndbclient library is not there? Or am I missing something here?
0
votes
1 answer

How to import large mysql database (innodb , myisam tables) to MySQL NDB cluster

Mysqlcluster used:- GA 7.4, Centos 7 I have 30GB each physical memory in 2 datanodes and SSD 200GB each but the database size(cumulative size of multiple db's belonging to free radius ) is around 55GB. Is it possible to migrate my mysql…
sherpaurgen
  • 616
  • 6
  • 10
  • 26
0
votes
1 answer

Are There any Web-Based Load-Balancing Managers?

I've setup load-balancing and clustering on a few linux systems for serving web and database content, and each time it's a fairly laborious process. So I'm wondering, are there any web-based managers, or possibly just monitoring interfaces, for…
0
votes
2 answers

Galera new cluster WSREP Unknown error 141

I am trying to create a new Galera cluster in the cloud using Ansible (DevOps tool). I can get the cluster started by issuing commands from an SSH shell, but not from Ansible. I have simplified the configuration to two nodes, but cannot get the…
0
votes
1 answer

different servers different databases replication mysql

I am not sure if this is possible or not but I have 3 servers. Server A, B and C Server A has database A_dataBase, B_database Server B has database A_dataBase, B_database and C_database Server C has database C_database Currently Server A and B are…
user50946
  • 483
  • 2
  • 7
  • 18
0
votes
0 answers

MySQL Master migration

I've run into an unforeseen issue regarding a MySQL Master node: The cloud instance on which it's installed is soon to be retired. I've not needed to perform a migration like this before, so I'm unsure if one of these options I've come up with is…
0
votes
0 answers

Mariadb galera node error when joinning cluster

I am getting these errors when trying to join nodes to a master. Ubuntu 14.04 MariaDb Galera 5.5.42. I had this problem with rsync as well. No iptables rules blocking connections. Any help would be great with this. WSREP: Failed to prepare for…
Nvasion
  • 213
  • 1
  • 2
  • 6
0
votes
1 answer

MySQL Bad Handshake to MySQL Cluster behind Proxy

I have just set up a MySQL cluster using five hyperV linux boxes (2x management nodes, 2 data nodes and 1 proxy) having followed (with a bit of tweaking) the instructions here. Everything works fine superficially, I can connect via the proxy to the…
Paul
  • 1
  • 2
0
votes
1 answer

MySQL Cluster ndb_restore fails without error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be working reasonably well, I am having difficulty…
egmackenzie
  • 101
  • 4
0
votes
1 answer

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 depends on database from first server and decided…
0
votes
0 answers

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 MySQL Cluster Auto-Installer. Every thing works…
Rad
  • 195
  • 3
  • 10
0
votes
1 answer

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, then I must be sure that it is working. After that, I…
ckorzhik
  • 115
  • 4
0
votes
1 answer

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 nodes. Is this a valid configuration? Can I connect…
paiego
  • 253
  • 2
  • 8
0
votes
0 answers

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 4Gb heap. I have checked maxshm memory, max…
fsniper
  • 121
  • 3
0
votes
1 answer

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. Windows 2008 R2 64bit Client1 - S.O. Windows 7 64bit…
greg
  • 1
  • 1