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

Is it recommended to use mysql ndb cluster for transactional data ?

We are currently using mysql master slave architecture but with time we are facing issue of storing data on single machine and acaling the machine vertically to overcome that we want to shard data logically at the same time providing high read and…
sangam dubey
  • 1
  • 1
0
votes
1 answer

Connect Yii2 app to My sql cluster

Does it makes any different if I was using mysql db and now I want to use Mysql cluster on my server. How will this affect my yii2 application ?? do I have to make any changes to db connection or just connect to any node ? does this affect Active…
Deena Samy
  • 503
  • 2
  • 7
  • 20
0
votes
1 answer

Connecting to mysql cluster from python application

I have configured the server to use MySQL Cluster. The Cluster architecture is as follows: One Cluster Manager(ip1) Two Data Nodes (ip2,ip3) Two SQL Nodes(ip4,ip5) My Question: Which node should I use to connect from Python application?
Deshani Tharaka
  • 183
  • 4
  • 14
0
votes
2 answers

INSERT INTO SELECT takes long time on cluster

My mysql cluster: Ver 5.6.30-76.3-56 for debian-linux-gnu on x86_64 (Percona XtraDB Cluster (GPL), Release rel76.3, Revision aa929cb, WSREP version 25.16, wsrep_25.16) I've a complicated sql query which inserts for about 36k rows into a table with…
MrRP
  • 822
  • 2
  • 10
  • 25
0
votes
1 answer

Failover Load balance

What is the best solution to have a backup for your servers? I have a Web server and a SQL data server. I would like to have fail over backup for each of them, I don't know what would I need. I've bought another 4 servers to have a backup for web…
Myd
  • 3
  • 3
0
votes
0 answers

Percona cluster automatic fail-over not working

I'm deploying Percona Xtradb-Cluster and get stuck at automatic fail-over. When I stop node 2 in database not auto update status. This is log: 2017-06-23 23:37:29 MySQL_Monitor.cpp:1126:monitor_ping(): [ERROR] Server 192.168.1.11:3306 missed 3…
Zerosk
  • 1
  • 1
0
votes
1 answer

MySQL cluster table is not being replicated on data nodes

I created MySQL cluster by using this guide: From management node: ndb_mgm show Output: Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=2 @10.0.2.5 (mysql-5.6.31…
RNK
  • 5,582
  • 11
  • 65
  • 133
0
votes
1 answer

MySQL Cluster Auto-Installer user permissions

i'm trying to install MySQL Cluster 7.5 with the auto-installer, but i'm having problems with the user account needed for the install. On step 1 you have to specify a linux user and password. If you provide the root user, then the cluster deploy…
L.T
  • 3
  • 3
0
votes
0 answers

Varchar seems casted to integer somehow in MySQL

I have the following column definition: col varchar(8) not null It contains ONLY h and w values: col h h w w w h The problem is that doing the following query: SELECT * FROM t WHERE t.col = 0 limit 100; Gives me some results, while it shouldn't. …
user99999
  • 1,994
  • 5
  • 24
  • 45
0
votes
0 answers

mysql clustering connection is failed through hibernate and spring

Using MySQL workbench I can connect to the cluster db without any issue. but when I use it as the connection string…
Rozane
  • 63
  • 1
  • 4
0
votes
1 answer

MySQL Cluster SQL node failover

I'm trying to setup a mysql cluster for a web application to avoid having a single point of failure. The Mysql documentation says: MySQL Cluster does not provide any sort of automatic failover between SQL nodes. Your application must be prepared…
user3727436
  • 77
  • 1
  • 1
  • 6
0
votes
1 answer

It's posible to use Federated table in MySQL NDB Cluster

I'm developing a application that needs two diferent databases, this is because one of this databases is per client and the other one is a generic database. I'm thinking in make a MySQL NDB Cluster and i need to know if it's possible to uses some…
Algoleigol
  • 161
  • 1
  • 2
  • 10
0
votes
1 answer

why is select query showing unsorted result in mysql cluster?

the query "select * from table_name; " shows different row results when run multiple times. Is this default behaviour of mysql ndbcluster ? Im currently using group by to sort the results Version:-MySQL-Cluster-server-gpl-7.4.11 on centos 6.7
sherpaurgen
  • 3,028
  • 6
  • 32
  • 45
0
votes
2 answers

Use Varnish in front of MySQL Cluster to cache responses

Im trying to user Varnish between my php application and MySQLCluster to cache the Mysql query responses. I tried just setting up the Varnish server so that when domain.com gets called the call is redirected to the MySQL Client, the problem is that…
Bruno
  • 11
  • 2
0
votes
1 answer

Too many concurrently fired triggers (increase MaxNoOfFiredTriggers) from NDBCLUSTER

I'm making batch operations with MySQL Cluster NDB: insertion of 10000 or 5000 rows and removal in a single transaction. Insert works fine, but removal fails with an exception: java.sql.SQLException: Got temporary error 221 'Too many concurrently…
divanov
  • 6,173
  • 3
  • 32
  • 51
1 2 3
…
13 14