Stack Overflow
Stack Overflow

Questions tagged [database-cluster]

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

66 questions
2
votes
0 answers

ActiveRecord::ConnectionTimeoutError after switching DB cluster node

Environment I have a rails 3.2.x app load balanced between 2 webservers: web1 and web2. Each webserver points to a clustered IP for the mysql database. The database is 2 servers clustered (by rackspace). 1 database is active at a time until…
NoahP
  • 81
  • 5
2
votes
2 answers

MySql cluster "split brain" solution?

Before few days I was at some IT conference here in Belgrade. On Agenda was a topic about MySql, and clustering in MySql, and the guys from MySql said that they have the best solution for cluster split brain problem, does anyone know something…
vaske
  • 8,884
  • 10
  • 45
  • 68
2
votes
2 answers

Rails adapter solutions for MySQL Cluster (NDB)?

I'm setting up a high-availability environment for a customer. There are a pair of load-balanced hosts serving http requests to our Rails application, which is deployed in parallel on both hosts. Additionally, there are two MySQL hosts available. I…
RonU
  • 4,999
  • 3
  • 13
  • 13
2
votes
0 answers

How to share a Neo4j HA cluster with multiple Spring application?

I have a cluster of 4 Neo4j instance (v.1.9.3) with following initial_host: ha.initial_hosts=192.168.1.10:5001,192.168.1.10:5002,192.168.1.10:5003,192.168.1.10:5004 I am using this cluster for one of my spring app (using Spring-data-neo4j) for…
agpt
  • 4,887
  • 9
  • 45
  • 85
2
votes
0 answers

Performance of MySQL Cluster vs MySQL

I am working on a project for which the database is the major bottleneck. For a myriad of reasons, further optimization of the on a programming level is something we want to avoid as much as possible. We would like a solution to potentially increase…
user396404
  • 2,589
  • 7
  • 27
  • 41
1
vote
1 answer

Master/Slave Mysql Architecture vs Server/Read DB and Separate DB for writes only

What are the advantages and disadvantages for Master/Slave type mysql architectures vs load balancing web servers with read only db's in each using a separate server holding a mysql database just for the writes?
jason_hamiltonm
  • 38
  • 6
1
vote
2 answers

How to setup and connect my database to NodeJS application on digital ocean

I have managed to create a droplet on Digital-Ocean and managed to clone my Node JS app onto it. Locally , the app connects to MySQL database and I wanted to the same on the live version. Ignorantly, I attempted to create a Managed database cluster…
CliffTheCoder
  • 166
  • 10
1
vote
0 answers

Assigning virtual IP in repmgr

I have a postgres cluster made using repmgr. This is the requirement of the application that they should not have to change the IP in the application when the database switchover occurs. Is there a way to use virtual IP with repmgr which outside…
makhshif afiniti
  • 25
  • 6
1
vote
1 answer

BigQuery – Is there a limited number of rows a clustered field can scan through when applying WHERE shop IN (select shop from X)?

As an example: Say I've taken table_1; partitioned it by day and clustered it by shop and I've tried using the list of shop in table_2 (not clustered or partitional) to filter by from my clustered field in table_1. Then, when I query something…
Vond
  • 13
  • 2
1
vote
1 answer

PostgreSQL - Clustering never completes - long key?

I am having problems with clustering a table where the key consists of one char(23) field and two TimeStamp fields. The char(23) field contains Alpha-Numeric values. The clustering operation never finishes. I have let it run for 24 hours and it…
user731288
  • 11
  • 1
1
vote
1 answer

How do I find all the databases and related schemas on a Postgres cluster?

I want to list out all the databases and schemas within a Postgres cluster, how do I get that list? I have run below queries (I am using pgAdmin) SELECT * FROM pg_database; --This lists all the databases in the cluster SELECT distinct…
knightrider
  • 107
  • 2
  • 9
1
vote
1 answer

Why in cluster PSQL with 3 node one node - sync_state= sync and next node sync_state= async?

I want PostgreSQL Synchronous Streaming Database Replication Status = sync. I deployed PostgreSQL cluster with 3 node and write sync type - Synchronous. But when i check type SELECT * FROM pg_stat_replication; - i get first node -…
Kirill K
  • 187
  • 2
  • 16
1
vote
0 answers

MySQL slave database stopped replication."Last_Error: Error 'Unknown database 'sen'' on query. Default"

the master: the slave: Current Environment sen@ubuntu:~$ uname -a Linux ubuntu 4.2.0-16-generic #19-Ubuntu SMP Thu Oct 8 15:35:06 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux sen@ubuntu:~$ mysql -V mysql Ver 14.14 Distrib 5.5.32, for Linux (x86_64)…
senlinmu
  • 115
  • 1
  • 9
1
vote
1 answer

Can we have multiple Postgres XL cluster on the same system?

Whenever we create a Postgres XL cluster, the coordinators, datanodes and GTMs are identical to the same cluster isn't it? So is it possible to create another cluster on the same host using pgxc_ctl? Do I have to generate a different cluster…
Pragun
  • 1,015
  • 7
  • 17
1
vote
1 answer

How to add second node in NosDB opensource?

I am trying NosDB, created database cluster on single node, and than added second node in my database cluster, but I am failing with error message, "Add-Shard : Login 'asif_mehmood' does not exist". Steps I perforemd: Installed NosDb…
Asif Mehmood
  • 71
  • 8
1
2
3 4 5