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

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 run it. It show: ERROR 1114(HY000) at line 1703:…
supper aban_89
  • 129
  • 1
  • 5
2
votes
1 answer

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: mysql> drop table table_name; ERROR 1051…
2
votes
3 answers

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 updating the master bin log my replications is starting…
nonus25
  • 161
  • 1
  • 3
  • 9
2
votes
2 answers

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.
Reena
  • 23
  • 1
  • 3
2
votes
1 answer

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…
Firman
  • 21
  • 1
2
votes
2 answers

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 ?
Champion
  • 51
  • 1
  • 7
2
votes
1 answer

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: mysqlc/bin/ndb_mgmd --initial -f…
Champion
  • 51
  • 1
  • 7
1
vote
2 answers

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 optimisation beforehand. I recently learned about…
Deniss Kozlovs
  • 191
  • 1
  • 9
1
vote
0 answers

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=noninteractive sudo apt-get install -y debconf-utils #…
Mr. 14
  • 111
  • 2
1
vote
1 answer

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.removeInstance('root@mysql-master:3306'). I got a error: The…
Rukeith
  • 123
  • 6
1
vote
1 answer

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 master, but I cannot use mysql cli to connect slave…
Rukeith
  • 123
  • 6
1
vote
0 answers

The ndb_mgmd daemon does not start

The ndb_mgmd daemon does not start I want to configure a NDB Mysql cluster, I followed the documentation of its official page. Install version 7.5 of mysql-cluster-community and I have the following scheme 1 manager node: 192.168.10.137 2 nodes…
1
vote
2 answers

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 master in a single server.
1
vote
1 answer

HAProxy load balancing issue

I have the following configurations for load balancing a precona cluster. haproxy.cfg global log 127.0.0.1 local1 notice maxconn 4096 user haproxy group haproxy #debug #quiet defaults log …
Anuruddha
  • 123
  • 4
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