67 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
-1
votes
1
answer
47
views
Application fails on non-primary MongoDB cluster [closed]
Mission: I am attempting to add Mongo Cluster support to our ASP.NET application.
Environment/Setup: ASP.NET application running locally with a local Mongo 7.X database. Setup is replicated on two ...
0
votes
1
answer
196
views
Combining Mariadb Galera Cluster with a stand-alone database
I am setting up a MariaDB Galera cluster along several servers so that they can have access to synchronized data. However, one of the servers is hosting an independent WordPress website which needs ...
1
vote
0
answers
264
views
TimescaleDB multinode cluster & replication factor
I have been working on timescaleDB multi-node concept, In my case I have an access node, and four data node. When I created the distributed hyper table I have set replication factor to four.
adding ...
0
votes
1
answer
2k
views
ERROR: [dn3]: SSL connection has been closed unexpectedly
I have been working on the timescaleDB multinode clustering concept. When I go to add a data node, I run the add_data_node query in the access node at that time I got an error like SSL Connection has ...
1
vote
1
answer
908
views
Multi-Node in TimeScaleDB
I have been trying to run the TimeScaleDB in cluster mode. Totally I have four nodes(service) one is for the access node, and another three are for the data node. The access node stores the chunks in ...
0
votes
1
answer
281
views
Unioned table costs more to query in BigQuery than individual tables?
BigQuery cost scenarios
When I query a large unioned table - partitioned by date field and clustered by a clientkey field - for a specific client's data it appears to process more data than if I just ...
0
votes
1
answer
1k
views
How to use master & slave nodes in Laravel
We're having 2 nodes for reading and 1 for writing. How can I set in my code the connection to these 2 reading nodes and on every page load to choose randomly between both (I don't know if it must be ...
0
votes
0
answers
246
views
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 ...
1
vote
2
answers
2k
views
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, ...
2
votes
1
answer
2k
views
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 ...
0
votes
1
answer
1k
views
Automatic failover not happening in repmgr
I have a postgres active/standby cluster of 2 nodes, I have used repmgr for creating the cluster. The issue is, automatic failover is not happening when I stop the postgres services on master node. ...
0
votes
1
answer
597
views
Possibility of changing IP of a node after failover/switchover
I have 2 servers running postgresql database as Master-slave. Application connects to master normally and when the switchover occurs, we need to change IP in application to connect to slave. In one of ...
1
vote
1
answer
147
views
GridDB Bad Connection Exception
My application runs a sampling query periodically and it was working fine without any issue for around 30 hours. Then suddenly it gave the following error.
Java client is unable to access the ...
1
vote
1
answer
218
views
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 ...
0
votes
0
answers
177
views
PostgreSQL 9.3.5 'Active-Active' mode for Windows Server 2012 R2
I want 2 PostgreSQL Databases (running in Windows Server) to be on 'active-active' mode. Currently they are in 'Hot Standby Mode' (one of them is 'Master' and the other one is 'Slave'). I can't seem ...