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.)

193 questions
3
votes
0 answers

Mysql Error 1192 while importing from mysqldump backup

We are trying to clone Mysql Cluster (ClusterDB) database on same instance by taking backup with Mysqldump and then restoring it with mysql as following: mysqldump -u masterdb1 -p --single-transaction db_master_1 > db_master_1_bk.sql mysql -u…
user2782164
  • 31
  • 1
3
votes
2 answers

is it possible to have MySQL Active-Active Clustering with DRBD?

we use MySQL 5.6 InnoDB engine for our database purpose. currently we have a single instance of it , but as our application is growing , we want to have our database in cluster mode. now what we have done till now : We tried MySQL NDB cluster 7.3.1…
Chetan Sharma
  • 173
  • 1
  • 2
  • 16
2
votes
1 answer

MySQL：Cannot create cluster Got Error：The server is not configured properly to be an active member of the group

I want to create a MySQL cluster (InnoDB) so I create three AWS EC2 Instances (CentOS 7). When I run var cluster = dba.createCluster('testCluster'); I got a Error below： A new InnoDB cluster will be created on instance…
Rukeith
  • 415
  • 3
  • 14
2
votes
1 answer

MySQL Cluster Auto Installer Error: DLL Load Failed: The specified module could not be found

I am trying to install MySQL cluster. I installed mysql cluster gpl auto installer on windows with msi installer. mysql-cluster-gpl-7.5.7-winx64 I installed 3 ubuntu servers to use as nodes. I allow remote ssh connection permission for ubuntu…
Cagatay
  • 21
  • 1
2
votes
0 answers

Installing mysql cluster on Ubuntu

Mysql supposedly provides an APT repository for installing mysql cluster https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/#repo-qg-apt-cluster-install My understanding is that in order to use this repository I need to install the…
user1259388
  • 73
  • 1
  • 2
  • 6
2
votes
2 answers

MySQL Server has gone away Error constantly appearing with haProxy

I'm getting this message quite often. I looked through a couple of solutions so far, but haven't found anything to solve this issue. But first here's my setup: I using an PHP7 Environment which is split up into different elements for Scalability…
Chris West
  • 699
  • 9
  • 34
2
votes
0 answers

How to replace an existing MySQL installation into a MySQL cluster?

If I have a database created in MySQL RDBMS, which is being used for running a website. After sometime, I notice that there is a potential increase in traffic and therefore I need more servers to hold the data. So I think of clustering as one of the…
Vijay Kumar
  • 694
  • 6
  • 12
2
votes
1 answer

How to create hibernate configuration file for mysqlcluster?

Need Hibernate configuration (hibernate.cfg.xml) file for mysql cluster. [Hibernate] Auto Generate POJO Classes and *.hbm.xml files. I am able to access Mysql Database using following configuration. And i am also able to access MYSQL NDB Cluster…
Vinayak Maradkar
  • 21
  • 5
2
votes
0 answers

MySQL Cluster: The table is full

I have understanding wih MySQL Cluster. I have one table: 38 fields total 22 fields are described as 22 indexes (field type: int) Other fields double and bigint values The table doesn't have defined Primary Key My Environment (10 nodes): data…
vladimir-user5480135
  • 51
  • 4
2
votes
0 answers

mysql-cluser ndb_restore issue

I've been trying with intermittent success to restore my ndb_backups to a new cluster. We have a 6 NDB node cluster with 3 API nodes. When I run an ndb_restore, usually the first 2 or 3 node backups get pulled in without issue. But the 4th and 5th…
99454
  • 21
  • 1
2
votes
0 answers

MySQL NDBcluster 7.3 limitation on Table Joining in a single SQL statement

I am a novice user of Mysql database and recently my company is evaluating MySQL Cluster for its shared nothing architecture and synchronised replication. However my colleagues informed me that the MySQL clusters will have limitation on the number…
Seng Zhe
  • 593
  • 1
  • 10
  • 19
2
votes
0 answers

HAProxy and Mysql Cluster Topology

I've installed mysql cluster with 2 data node,2 sqlnode and one management server on different hosts.In addition I've 3 different app instances. Now I want to install haproxy in front of mysql cluster but not sure about topology.I searched on google…
ahmetemirercin
  • 19
  • 4
2
votes
0 answers

Are random primary keys a pitfall for MySQL Cluster?

I understand that the InnoDB engine relies heavily on primary keys for its storage mechanisms (index layouts, etc), and that it is consequently a bad idea to use a non-sequential primary key (say a random 15 digit integer), because it will cause…
Elwinar
  • 7,862
  • 27
  • 35
2
votes
1 answer

how to use c3p0 with node failover test

We have setup MySQL NDB Cluster with three nodes and here is the details of Setup. Node1 - MultithreadedDataNode1, SQLNode1 Node2 - MultithreadedDataNode2, SQLNode2 Node3 - Management Node we are testing a few failover scenarios to ensure that the…
Patel Parimal
  • 207
  • 2
  • 14
2
votes
1 answer

Load balancing via MySQL JDBC driver (Connector/J)

I have been exploring MySQL JDBC driver and understand that it is able to do load balancing with this url ("jdbc:mysql:loadbalance://"). I looked into the documentation and it seems that only random and best response time methods are used for load…
Tay Wen Bin
  • 111
  • 2
  • 10
1
2
3
…
12 13