Use database-cluster for questions related to running a group of databases as a cluster, which helps prevent the existence of a single point of failure in case a database server fails or is compromised.
References
Questions tagged [database-cluster]
66 questions
1
vote
1 answer
Connect to and work with a RethinkDB cluster
I can't seem to find a lot of documentation on how the clusters in RethinkDB actually work.
In Cassandra I connect to a cluster by defining one or more hosts, so in case one of them is down, or even has been removed, I still can connect to the…
peter
- 11,751
- 6
- 52
- 89
1
vote
2 answers
Cassandra Clustering Order vs OPP
I'm studying through Cassandra and ran into the concept of OPP (which is highly discouraged) and Clustering Key
http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/create_table_r.html
They seem to do the same job i.e. order rows in a…
touchaponk
- 364
- 2
- 16
1
vote
1 answer
What is the defined behavior of a 3-node Galera cluster after one node dies?
I've been reading the documentation for Galera cluster: http://galeracluster.com/documentation-webpages/genindex.html
I keep seeing the recommendation (or, in some places, an explicit restriction) that a minimum cluster is 3 nodes.
My question is,…
Ovesh
- 4,831
- 9
- 49
- 69
1
vote
3 answers
Tool to create mongodb sharded cluster
I need a tool to manage a cluster of mongodbs. With an increasing number of machines, it is hard to maintain each machine without a tool.
More details:
The database grows around 50 MB per day, so they are approximately 1.5 GB per month. The mongodb…
user2860815
- 13
- 4
1
vote
1 answer
log4j logging to DB (in a cluster)
I have a Java application which runs on two machines in a cluster and they both log to one MySQL database. Everything works fine, but I would like to have an additional field in the database which represents the IP where the requests is coming…
Nussmischung
- 31
- 8
1
vote
1 answer
mysql MyISAM vs NDB storege engine for heavy reads
Does NDB support join queries ? I know that NDB is faster then MyISAM and NDB run on memory, but with respect to replication, fail over, wide acceptance of both storage engines I am not sure.
Shamis Shukoor
- 2,427
- 4
- 26
- 33
1
vote
1 answer
Synchronizing two SQL Server Instances
I have two network segments and both are connected using the internet, say one as corporate server and another as remote production. I have an Intranet application running in both environments using the single SQL instance, everything works fine.…
dotnet_Profiler
- 55
- 4
1
vote
2 answers
Load balancing MySQL ndbcluster
I have successfully setup ndbcluster version 7.1.26.
This contains 2 data nodes[NDBD], 2 mysql [MYSQLD] nodes and one management [MGMD] node.
Replication works successfully.
My Web application is deployed in JBoss-5.0.1 and using JNDI for connection…
Ajay Bhojak
- 1,161
- 9
- 17
1
vote
1 answer
Foreign Keys with MySQL.Cluster (NDB)
Since version 7.3 MySQL Cluster should be capable of foreign key constraints. But here is what happens:
DROP TABLE IF EXISTS t2;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
id INT PRIMARY KEY
) ENGINE='InnoDB';
CREATE TABLE t2 (
id INT PRIMARY…
Jens
- 1,952
- 1
- 12
- 29
1
vote
4 answers
Add Analysis Services to a clustered SQL Server 2008 instance
I have an existing multi-instance SQL 2008 cluster, and I'm trying to add Analysis Services to an existing instance. I start the installation, pick "Add features", configure SSAS, and then on the final pre-installation check, I fail the "Existing…
SqlRyan
- 30,939
- 32
- 109
- 190
0
votes
1 answer
Partitioning DB tables in MySQL
What is the best strategy to make a clustered MySQL deployment in which some tables of the DB are placed on one node and some other tables are placed on another node while acting as a single coherent DB from the application's perspective?
Let's say…
nemo
- 485
- 3
- 15
0
votes
3 answers
Multiple "Default" instances in SQL Server cluster? (AKA multiple clustered instances without requiring an instance name to connect)
I'm setting up multiple SQL instances on an active/active cluster, and on our existing SQL Cluster, the cluster name is SQLCLUSTER, but we access the instances as SQLCLUSTERINST1\Instance1, SQLCLUSTERINST2\Instance2, etc. Since each instance has its…
SqlRyan
- 30,939
- 32
- 109
- 190
0
votes
0 answers
How to setup a new MySQL database that updates itself automatically from an MySQL database?
I'm sorry if this has already been addressed, and due to lack of my knowledge me not being able to distinguish the differences in what I am about to ask.
I am working with a huge database that is very busy throughout the day (multiple queries every…
0
votes
0 answers
Can data be lost in a PostgreSql cluster?
I am studying databse clustering and have some missunderstanding with data storage and possible data lose. Let's say I have a master/slave PostgreSql cluster.
Will they have the same disk storage shared with all data or each node gonna have it's…
Kirill Leonov
- 13
- 3
0
votes
0 answers
MySQL Cluster Replication
I am using docker-compose to create MySQL cluster (NDB). After cluster gets created, I am unable to see data replication when querying through other mysql API node.
For example,
this is my configuration:
ndb_mgm> show
Connected to Management Server…
Ishan
- 13
- 5