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
3
votes
0 answers

INITIAL_SIZE & AUTO_EXTEND in disk based mysql cluster

I'm trying to create a disk based table which is documented in this link. However, it's not clear choosing the size of INITIAL_SIZE field in LOG FILE GROUP and TABLESPACE. From the reading, I understand LOG FILE GROUP is necessary for…
aacanakin
  • 2,844
  • 4
  • 25
  • 42
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
  • 3
  • 16
2
votes
1 answer

Do AWS RDS cluster instances need to be the same size?

I have a 2 instance RDS Aurora cluster (one writer and one reader). Is there any reason my reader instances need to be the same size as the writer? Is there any problem creating a cluster with a db.r3.4xlarge (writer) and a db.r3.2xlarge…
Wes
  • 301
  • 4
  • 13
2
votes
2 answers

Can I implement synchronous and asynchronous replication with the MySQL cluster?

I want to do synchronous and asynchronous replication, synchronize for some databases, and asynchrony for others. Asynchronous I am doing it through MariaDB, through the traditional system that has replication. But I want to implement synchronous…
Garnica1999
  • 215
  • 2
  • 12
2
votes
0 answers

MariaDB Galera Cluster: SELECT ... FOR UPDATE why no locking?

Why is the record not locking between 2 nodes of MariaDB Galera Cluster 10.2.11? Node 1 Node 2 START TRANSACTION; SELECT * FROM table WHERE id = 1 FOR UPDATE; +----+------+ | id | info | +----+------+ | 1 |…
salam_akhin
  • 21
  • 3
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
  • 2
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
  • 741
  • 13
  • 36
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
  • 922
  • 7
  • 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
  • 301
  • 3
  • 7
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
  • 613
  • 1
  • 11
  • 21
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
  • 9,103
  • 32
  • 40
1
2
3
…
13 14