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

Does the order of columns that I partition a BigQuery table by affect its performance?

If I want to partition my BigQuery table by a date (post_date) and an integer column(user_id in integers), both are which frequently used in where/joins/groupby, does the order that I create my partition table matter? E.g PARTITION BY…
Aihiang
  • 1
  • 1
0
votes
0 answers

Enable SSL on MS SQL database server(clustered)

I am using MS SQL server 2019 as a database server and i have enabled SSL on SQL server. I am connecting this SQL server using Java application. So, Java application is client in my case. I have also enabled SSL on client side. I am able to connect…
ashish gupta
  • 117
  • 1
  • 11
0
votes
1 answer

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. Contents of file repmgr.conf on master are as…
makhshif afiniti
  • 25
  • 6
0
votes
1 answer

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 our use cases, we require that in switchover the…
makhshif afiniti
  • 25
  • 6
0
votes
1 answer

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 Database and get the following exception. Caused by:…
HarshaXsoad
  • 658
  • 8
  • 25
0
votes
0 answers

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 to find any documentation that has made high…
tayeen
  • 3
  • 1
0
votes
1 answer

How does Apache Ignite synchronize in cluster mode?

This information eluded me when searching through the documentation. How does Apache Ignite, if used in cluster mode, synchronize between nodes when these nodes become inactive and active again? Assume the following scenario: I have 2 nodes. Node A…
PentaKon
  • 3,359
  • 3
  • 32
  • 64
0
votes
1 answer

Galera Cluster with db write enabled for disconnected node

We have 5 islands where we have Galera nodes. There are frequent internet disconnections on Islands. When a node get disconnected its tables get locked for read and write. But it sync and becomes available when the internet resume. In MariaDB…
Asad Mahmand
  • 1
0
votes
1 answer

Current_Timestamp in Trigger with Statement Based Replication

We currently use a trigger on our MySQL database that sets a "last-modified" timestamp to CURRENT_TIMESTAMP. It is called on update. We also need to use statement based reproduction for the cluster. Is there a way to modify the trigger so that the…
Urr4
  • 421
  • 5
  • 17
0
votes
2 answers

Make CouchDB use the open ports

The CouchDB Clustering Setup Reference indicates that if you need to limit the range of ephemeral ports used by CouchDB clusters you need to modify the sys.config to add {inet_dist_listen_min, xxxx} and {inet_dist_listen_max, xxxx} entries such…
FrankCoder
  • 121
  • 6
0
votes
1 answer

Percona XtraDB Cluster (PXC) node / instance without data (for quorum)

I need to build 2 nodes of PXC between 2 data centers. In these 2 data centers, there is a public node (more important) and a private node (offline sometimes due to network issue). If there are only 2 nodes and when a node becoming offline, whole…
Sars
  • 503
  • 4
  • 10
0
votes
2 answers

Redis pre GET event

How can i override method GET or write a new function which will execute on server side returns another key value if searched key not exists? Example: if key "word_1 word_2 word_3 word_4" not exists search this key "word_1 word_2 word_3", if key…
Ramin Darvishov
  • 1,024
  • 1
  • 13
  • 24
0
votes
1 answer

MS SQL Server Mirroring / Clustering / Replication

I have a client that requires a web page for registration. This web page will show up as soon as a customer joins the wifi of the venue. All registration information will be pushed to a MS SQL Server. The point here is that this client has two…
Martin Garcia
  • 335
  • 5
  • 14
0
votes
0 answers

MongoDB replica set - many iops on secondary node

I have in production from 1 year one MongoDB cluster in replica-set. From few days one slave node exceeded the maximum IOPS capacity of disk: Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await…
Daniel Bellantuono
  • 1
0
votes
1 answer

IBM Worklight 6.2 Server Deployement error: DB2 Instance not found on server

Environment: IBM Worklight 6.2, IBM Liberty 8.5.5.1, IBM DB2 10.5 & Windows 2008 standard Edition. For the High Availability of DB instance[WLDBINST], the following Architecture I have followed. 2 Windows Clustered Machines with IBM DB2 binary…
Karikalan
  • 253
  • 2
  • 15
1 2 3
4
5