Stack Overflow
Stack Overflow

Questions tagged [mysql-cluster]

MySQL NDB Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability.

MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database, designed to deliver 99.999% availability. With a distributed, multi-master architecture and no single point of failure, MySQL Cluster scales horizontally on commodity hardware with auto-sharding (partitioning) to serve read and write intensive workloads, accessed via SQL and NoSQL interfaces. ("Cluster" is an overloaded term; this topic is NDB Cluster.)

201 questions
1
vote
2 answers

Designing XtraDB cluster

We have an application which consists of microservices all connected to the same Percona DB instance. Currently it is just one instance with 16 cores/32 GB memory without replication. One of our issues is that sometimes one of our microservices…
Vojtěch
  • 11,312
  • 31
  • 103
  • 173
1
vote
2 answers

mysql crashing with "mysqld got signal 11"

I'm running application which reading and writing data with mysql database. I'm having both mysql ndbclustr and master master replication in same database. (bcoz of master master replication tables' engines are innodb, clustering won't replicate…
chinthakaS
  • 125
  • 1
  • 2
  • 10
1
vote
0 answers

How to do the MySQL master-master replication with conflict resolution,auto sync after fail over

We have a business requirement in that, We need to do the MySQL Master-Master replication by solving the below possible issues. Conflict resolution Auto sync after MySQL server failure Here, We are going to write the data in both the Master MySQL…
Rajasekaran M
  • 163
  • 2
  • 16
1
vote
1 answer

How to connect to ProxySQL from application

I have Percona XtraDB Cluster running in 3 nodes (node1, node2, node3). I've configured ProxySQL in the 4th node (admin). I have an python application code trying to access the cluster. While connecting to 3306 port of node1, I'm able to…
Anju
  • 631
  • 2
  • 9
  • 25
1
vote
1 answer

How data node selection done in MySQL Multi-site clustering - Is it based on geographic proximity of data nodes in a node group

I am exploring the option of deploying MySQL multi-site clustering. The MySQL cluster deployment has three sites and it has two node groups and each node group contains three data nodes with the NoOfReplicas=3. The 3 data nodes in a node group are…
Santhi
  • 21
  • 3
1
vote
1 answer

NDB cluster7.5(MySQL 5.7) is taking more time in fetching data, if number of rows in table is large(2 million)

I am trying to setup NDB cluster(MYsql 5.7) for one of my real time application(with a high volume of read and write concurrency). My Setup - 3 Data Nodes 1 Management Node 1 MySQL node All nodes are of amazon EC2 r3.4xlarge type. OS - centos 7 i…
prashant sindhu
  • 1,769
  • 2
  • 15
  • 25
1
vote
2 answers

MySQL query results returned are semi-random / inconsistently ordered

I'm working with an ndb cluster setup that uses proxysql. There are 4 mysql servers, 4 data nodes, and 2 management nodes. The following happens when I access one of the mysql servers directly, so I think that I can safely rule out proxysql as the…
loungehead
  • 55
  • 5
1
vote
1 answer

Jelastic MySQL cluster and db users

I have created a MySQL Cluster using the "Scalable MySQL Cluster with Master-Slave Replication, ProxySQL Load Balancing and Orchestrator" installation instructions. This works as expected. My Java application can connect to the database using the…
Superdroid
  • 25
  • 5
1
vote
0 answers

'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' in debian6

Well, recently I tried to install mysql_cluster on debian6. At first it works well, but when I try to install mysql_cluster multiply, an error occurs saying, that I cannot login as root anymore. I was trying to modify the pwd of root with the…
Mantou
  • 19
  • 1
  • 4
1
vote
0 answers

mysqlcluster data nodes synchronization rate

mysql cluster version: MySQL-Cluster-gpl-7.4.12-1.el6.x86_64 num of datanodes: 2 num of sqlnodes: 2 num of mgmt nodes: 2 Recently one on my datanode server was down(node4) due to power outage. when i brought the disconnected datanode up i…
sherpaurgen
  • 3,028
  • 6
  • 32
  • 45
1
vote
1 answer

Data nodes cannot connect to MySQL Cluster

I have a problem with my MySQL Cluster running on AWS EC2 instances (3 data nodes and 1 management node, on t2.micro running Ubuntu latest version). I followed this tutorial (with updated version of MySQL Cluster 7.5.5) :…
Griffin_0
  • 47
  • 7
1
vote
2 answers

mysql query stuck with state "sending data"

Below the query that takes almost 7's and Im confused if its normal behaviour in mysqlserver(ndb storage engine), in explain out put it also shows it is using table indexes SELECT radgroupreply.groupname, …
sherpaurgen
  • 3,028
  • 6
  • 32
  • 45
1
vote
1 answer

Mysql Cluster replication issue on create table by select command

I have problem on slave replication on mysql cluster. When I create table with select as CREATE TABLE tmp1 AS SELCT * FROM tmp2 the table can be created but the sql is not recorded in binlog and not replicated to slave. But if I create table by…
Yaochun
  • 11
  • 1
1
vote
1 answer

Mysql and NDB are not connected

i am new in my mysql and i try to configure and run a cluster. i have done the installation and the config , my.cnf . We can see the manager of cluster and the data node correct : MySQL Cluster Management Server mysql-5.7.13 ndb-7.5.3 2016-10-05…
Apostolis Planas
  • 17
  • 4
1
vote
0 answers

Downsizing/Scaling-in MySQL cluster nodes

I am trying to setup mysql cluster within aws autoscaling group. I am starting out with two ec2 instances, each with their own management(ndb_mgmd), data (ndbmtd) and sql (mysqld) node. When scaling out (I have configured live scale out which works…
fahad.hasan
  • 902
  • 8
  • 16
1 2 3
…
13 14