The failover tag has no wiki summary.
1
vote
0answers
18 views
Can't set up witness in Repmgr 2.0
I am trying to setup repmgr using the autofailover quick setup tutorial provided on Github Link
But I am kind of stuck on the witness section, when trying to create the witness with repmgr -d repmgr ...
0
votes
1answer
22 views
Should we always prefer clustering over a master-slave configuration if the goal is high-availability?
Given: I have two virtual machines on a SAN that I can use to host RavenDB.
Question: If my goal is high-availability, then should I always prefer clustering over a master-slave configuration?
From ...
6
votes
2answers
182 views
If I fail over one database, do the others that share the same mirror endpoint fail over as well?
We have two databases setup for mirroring on a single SQL Server instance: a test database and a production database. Both get mirrored to another server using the exact same endpoints.
If I go into ...
-3
votes
1answer
92 views
Difference between accessing SQL Server by instance name and cluster name [closed]
I have installed failover clustering feature on two servers with Windows Server 2012 and then I installed SQL Server 2012 on both of them. I also enabled SQL Server 2012 AlwaysOn feature.
Now I can ...
1
vote
0answers
26 views
Failover - automatic switching between servers in Postgresql 9.1
I'm pretty new to Postgresql 9.1 and failover replication. We have a simple master-slave setup, for failover replication, which our application (client) is connected to. On a failure of the master, ...
0
votes
0answers
37 views
MySQL failover - Master to Master Replication
My company is trying to implement a MySQL failover mechanism, to achieve higher availability in our webservices tier - we commercialize a SaaS solution. To that end we have some low-end VMs scattered ...
4
votes
1answer
164 views
What is actually happening when postgresql discovers the trigger file and promotes it self from slave to master?
I have a streaming replication setup between two postgres servers (master: server A, slave: server B). I'm wondering what's actually happening under the hood when I touch the trigger file and the ...
4
votes
1answer
145 views
Restore Database on Active Passive Failover Cluster
Well, I helped my boss's boss install 2 nodes of SQL Server 2008 on a Windows server 2008 failover cluster. I did this remotely and I don't have accesse to it.
(I run a active-active cluster on Server ...
0
votes
1answer
98 views
SQL Server Mirror failover on failing storage
Recently we had an issue with a sql server 2008 r2 HA mirror. I have tried to reproduce this in a lab environment and i came to the conclusion that i am missing something OR something is not possible.
...
4
votes
3answers
507 views
InnoDB Master-Master replication goes inconsistant after power failure tests
Afternoon gents,
I'm currently stress testing a Master-Master replication setup using InnoDB as database engine.
We're using this simple script for testing which we run in Linux CLI from a remote ...
2
votes
1answer
284 views
Safely promoting master to slave
Previously I've asked the similar question MySql Switching Masters During Failover with log-slave-updates.
Let's say this is our current replication
In addition, I have few application servers. ...
2
votes
1answer
559 views
SQL Server ODBC Mirror/Failover Partner
Background/Context
We are in the process of moving our SQL Server 2000 databases to a mirrored SQL Server 2008 R2 server with a witness and automatic failover. We have both .Net and Access ...
1
vote
1answer
232 views
PostgreSQL hot standby promotion, multiple hot standbys
I'm trying to work out failover and disaster recovery procedures for a
cluster of three servers. Streaming replication is being used with a high
wal_keep_segments, no log shipping is happening. I need ...
2
votes
0answers
73 views
Are there any best practices before moving SQL Server to another node (controlled failover)?
Let's say there are multiple jobs running on the SQL Server - we have index maintenance jobs, backups, replication, etc. We would like to perform a switchover using Failover Cluster Manager. Are there ...
0
votes
0answers
303 views
JBoss / Alfresco : No operations allowed after connection closed
I'm trying to set up an high available MySQL "cluster", using a Master / Slave Replication configuration.
I want to the slave become master (e.g. not read-only but writeable) if the first node come ...
2
votes
1answer
276 views
SQL Server 2005 - Map login to pre-existing user
The short of it is that we have several databases that are synchronized between two failover instances. The primary contains logins that are mapped to the users in the databases, and everything's ...
1
vote
0answers
21 views
JBoss/Alfresco cannot write on slave after failover [duplicate]
Possible Duplicate:
JBoss don't fail over MySQL slave using datasource
I'm trying to set up an high available MySQL "cluster", using a Master / Slave Replication configuration. I want ...
1
vote
1answer
981 views
JBoss don't fail over MySQL slave using datasource
I'm trying to set up an high available MySQL cluster, using a Master / Slave configuration. I want to the slave become master (e.g. not read-only but writeable) if the first node come down (like in ...
3
votes
1answer
95 views
PostgreSQL synchronized commit performance
I'm setting up a pair of PostgreSQL servers. Because cash is short I can only afford one high class server and some crapy backup box. If the expensive high end box should catch fire, operations can ...
2
votes
1answer
211 views
Dual management node for mysql clustering
I currently have mysql cluster setup and running.
Here is my current setup:
1 - management node
2 - data nodes
2 - mysql nodes
I wish to incorporate a failover for the management node. The ...
2
votes
2answers
1k views
What are the differences between Mirroring and Failover Clustering and when is each one recommended over the other?
What are the main differences between Mirroring and Failover Clustering?
What kind of problem each one solves and in what kind of scenarios is each one recommended over the other?
5
votes
1answer
1k views
PostgreSQL Failover - What tools should I use?
Here is the scenario:
There are two machines running CentOS 6.2 - machine0 and machine1
Both have PostgreSQL 9.1 installed.
One of them should be active, as a master system and through asynchronous ...
3
votes
2answers
576 views
Is this procedure to Failover to Logshipped secondary and Fail back again procedure correct?
I have a primary database in Amsterdam (AMDB), and a secondary in London (LNDB). I want to fail over from AMDB, to LNDB and then back again, without having to make another full backup (because the ...
2
votes
1answer
663 views
MySql Switching Masters During Failover with log-slave-updates
I am still pretty newbie to mysql. This question is regarding promoting slave with option --log-slave-updates to become a master.
The typical schema of promoting slave to master was described in ...
4
votes
1answer
1k views
PostgreSQL failover and replication
I'm evaluating PostgreSQL 9.1 and have few questions related to failover and replication details.
I have few test scenarios. First one with a Master server and few Slaves. In case Master crashes I ...
1
vote
2answers
350 views
Microsoft SQL 2008 Cluster with replication
i am in the process of setting upi a SQl Server 2008 64 bit Failover cluster.
A lot of the database queries that we are running during the days are db intensive and lock a lot of the tables while ...
3
votes
1answer
632 views
Database as a service (DbaaS) over dimensions--performance, scalability, & reliability?
MySql Database as a service:
Amazon
Xeround
Another eg. PostgreSQL Database-as-a-Service.
You can get the list of similar products here.
Does anyone have details on their performance, ...
4
votes
3answers
3k views
Automating failover in PostgreSQL 9.1
How does one setup two identical servers for automatic failover in PostgreSQL 9.1.
OS
Centos 5
PostgreSQL 9.1 compiled from source
The postgres user account exists on both machines and has a ...
