High-availability technologies mask the effects of hardware or software failure, so that perceived downtime for users and applications is minimized.

learn more… | top users | synonyms

1
vote
1answer
1k views

PgPool 2 with HA Proxy

So, I'm looking to add high availability to a postgresql server. I've looked into some tutorials on the web but, haven't been able to find exactly what I'm looking for. E.g.: PostgreSQL ...
1
vote
1answer
38 views

SQL Cluster, AlwaysOn AG, or Something Else? [closed]

I really needs some help with Setting up SQL servers. We are re-configuring our network and have no clue how to resolve our SQL issue. My Network Admin. wants an "Active/Active" with shared storage ...
0
votes
1answer
15 views

When you use a replica to backup from so you don't have to turn off the master, is this considered High Availablity?

I read somewhere that MySQL can have a master / slave setup in which the master database can continue to run live and in production while the slave database can be turned off to snatch a backup. And ...
3
votes
3answers
179 views

Replication with FileStream

I need to setup database replication (for high availability) on a database that uses FileStream. This is on SQL Server 2012 Standard Edition, so Always On or Peer-to-Peer replication is not an option. ...
0
votes
0answers
21 views

Is Automatic failover is possible in pgpool?

I have setup the 2 PostgreSQL 9.4 severs with master-slave(Hot standby streaming replication).Is this possible in pgpool-II 3.4 to configure,where it works for automatic failover(network or hardware ...
0
votes
1answer
75 views

Setting up MariaDB Spider HA

I try to setup High Availability using Spider Engine and MariaDB 10.0.14, but I a m not sure what configuration to use to make it work as expected. What I want is: Accessing a remote table using ...
10
votes
5answers
7k views

SQL Server equivalent to functionality of Oracle RAC? [closed]

I did some Googling and couldn't find an answer to this question more recent than a few years ago, so I thought I'd ask. Oracle's RAC feature offers load-balancing for both read and write ...
1
vote
1answer
606 views

Removing Secondary Replica from SQL Availability Group Causs Large Log File

Due to an unforeseen hardware error, I had to take our secondary replicas down for maintenance. This was really due to a storage issue and, it was decided at a higher level, to purchase a new storage ...
0
votes
0answers
29 views

Fencing a failed application node to isolate it from SQL Server

I have a multi-node server application that is backed by SQL Server 2012, often in a clustered or AlwaysOn AG/FCI HA configuration. My application monitors the health of the application nodes (not the ...
1
vote
1answer
26 views

Syncing Uncontained Objects with AlwaysOn Availability Groups

In setting up our HA environment (AlwaysOn AG), I came across the add-in ssms_2012_ag_addin_setup.exe that I got from SQLSkills. ...
2
votes
2answers
274 views

Change SQL Server 2000 from Active/Active to Active/Passive

I know it's cringe-worthy to use this term, but I have a SQL Server 2000 cluster with one clusetered instance running on it with multiple resources running on one of the two servers in the cluster all ...
2
votes
1answer
124 views

Restoring a SQL Server 2012 database in high availability

I have a database which is in always-on high availability mode synchronized with another database on a different instance. How can I restore from a .bak file into the primary database using T-SQL? ...
0
votes
0answers
28 views

Need a High available for Database : HA clustering vs failover with mysql utilities

I intend to setup a high available for database system, I have 2 solutions here : Set up a HA clustering with heartbeat and share storage for 2 nodes as master(to storage the configuration and data ...
2
votes
2answers
228 views

Listener pointing to incorrect AlwaysOn Availability Group

All, Thanks in advance I have two instances of SQL Server 2012 SP1 on a three node WSFC with a HAdr group on each instance with a corresponding listener. Instance 1's listener points to Instance 1, ...
3
votes
1answer
95 views

Effects of turning the transaction safety OFF

I am considering to turn off the transaction safety to maximize the performance. Before that i am interested in finding the current status of transaction safety. Is there any command that we can get ...
0
votes
0answers
15 views

How to configure Mysql database for highavailability and failover? [duplicate]

I have a web application written in java with Mysql database. I want to ensure high availability of my database server, hence i have configured master-slave replication mode. All my reads goes to ...
1
vote
1answer
38 views

Dual site active-active highly available database

I have an application that is being run on two separate sites. Ideally they would share a database, because each application needs to see what the other is writing to the database. However, the sites ...
1
vote
1answer
65 views

SQL Server AlwaysOn to run updates and schema changes in 24/7 environment

First of all i have to say that this question comes from a software engineer-perspective. Unfortunately we have no DBA so we need to administer our own databases. We have SQL Server 2012 Enterprise ...
1
vote
1answer
126 views

Does “Synchronous-Commit Availability Mode” ensure consistency between Replicas?

If one refers to the MSDN documentation, on Synchronous-Commit Availability Mode, you may read: Under synchronous-commit availability mode (synchronous-commit mode), after being joined to an ...
13
votes
2answers
3k views

What is the modern way to partition PostgreSQL across machines, when the data is “naturally partitionable”

After several years of dwelling into the "NoSQL" space, now I have a problem that is quite "relational" in its nature. Today I see data stores with quite different eyes than before. Things like Riak ...
0
votes
0answers
38 views

migrate standalone postgresql database cluster to high availability cluster

We have tested one setup of postgres HA with repmgr and pgpool. It is working fine and now we have to migrate our existing database to the HA setup. We have two approaches, Make the HA master as ...
1
vote
3answers
213 views

HA - MySQL Master Master replication - Duplicate entry errors

I am running Percona MySQL 5.5.39 on two masters with keepalived monitoring a VIP which will failover to the standby master if the primary master goes dark. While testing the fault tolerance of my ...
4
votes
0answers
116 views

AlwaysOn Availability Group error after Windows Update in environment without a failover cluster

Our SQL Server service was down this morning which brought down some of our websites. When I went to check the Windows Event Viewer I saw the following errors: Script level upgrade for database ...
1
vote
1answer
24 views

How to make distributor highly available in Always On Configuration

We have clients requested us to configure Always on with Replication. Microsoft does not support it. "The distributor should not be a host for any of the current (or intended) replicas of the ...
1
vote
2answers
603 views

Within a RHEL 6.3 + High Reliability Add-on, how do I add DB2 (v9.7) into a service group to have the service controlled by the cluster?

I have a cluster of machines running RHEL 6.3 with the High Reliability Add-on. I have configured a Clustered Logical Volume Manager (CLVM) file system for DB2, which is working correctly. Our DBA's ...
2
votes
1answer
57 views

Effects of renaming FC and using its original name for AG network name

We have a Failover Cluster, named MainSQL consisting of MainSQL01 and MailSQL02 which are default named instances and we can connect to whichever is the active node with just simply MainSQL. If we ...
0
votes
1answer
54 views

SQL database disaster recovery in a second datacenter using storage

I have the following: Data Center (1) has a set of two Microsoft SQL Server databases. They are clustered using MSCS and shared NetApp storage FAS3250 system. This provides me with local fail-over / ...
1
vote
1answer
47 views

What happens on the primary when log cannot be restored on the secondary on Log Shipping

I would like to setup a log shipping but I have a concern as to what would happen if the restore operation on the secondary would fail for some reason. I want the primary database keep working no ...
0
votes
0answers
70 views

how to change the backend order in pgpool

I want to change the backends order in pgpool. I want to keep my master host always as the first backend. I have been configure the failover command: NEW_MASTER_INFO=($(PcpNodeInfo ...
0
votes
0answers
37 views

when install pgpool is also needed install hearbeat and watchdog

I am trying to get the PostgreSQL services High Availability (HA) and then I am using pgpool-II. When I install and configure pgpool, the WATCHDOG section seems to doesn't works, then I have a ...
0
votes
1answer
29 views

Altering table on SQL Server 2012 AON High Availability Databases [duplicate]

In a production site, the current configuration I am using is three SQL Server 2012 servers, with some databases configured with AON High Availability. I understand that between the AON High ...
1
vote
0answers
53 views

how to get pgpool2 HA

I am using pgpool2 and PostgreSQL to get a HA of postgresql service. I have been working in this: .-----. .--------. | | W | DB | | PGP ...
0
votes
1answer
74 views

How the xlogs files travels form Master to Slave

I have some doubts about how the workflow proccess in PostgreSQL replication using archiving logs. If I have this configuration in Master postgresql.conf: archive_command = 'test ! -f ...
1
vote
3answers
65 views

How can I sync databases to a secondary server for read-only usage?

I want to sync databases to a secondary server that will be used read-only for SQL Server Reporting Services. These syncs can be done once or twice nightly and mid morning; synced database sizes ...
1
vote
2answers
120 views

What Current Continuous SQL Server Backup Solutions Are there?

With Mirroring being deprecated in SQL Server 2012 and up along with AlwaysON Availability Groups costing $7k per core, I am wonder what options are there for constant reliable backups with a somewhat ...
2
votes
3answers
223 views

How to check history of primary node in AlwaysOn HA environment?

How do I see history of failovers of the primary node in cluster? I'm trying to figure out at what point secondary node started to act as primary. We are running Windows Server 2012 with SQL Server ...
0
votes
0answers
155 views

Configuring multiple listeners on SQL Server 2012 through High Availability

We have configured two SQL servers on Azure and they are in HA. There are about 10 databases and we wanted to have two critical ones on one dedicated HA group. The listener worked fine until we ...
2
votes
0answers
121 views

AlwaysOn FCI + HA Setup Question

I am planning to create FCI + HA solution in the same datacenter, but running into some problems. I'd really appreciate if someone can provide some guidance. Here is the current configuration (All ...
3
votes
1answer
177 views

timeline 2 of the primary does not match recovery target timeline 1

I want to create a configuration with postgresql and pgpool to get height availability (HA). I want to do this: .-----. .--------. | | W | DB | | APP ...
2
votes
3answers
398 views

Standard Edition High Availability without Shared Storage

I'm a software dev with little experience managing SQL Server so please bear with me. We are developing a piece of software that needs to be highly available, with a significant degree of resilience. ...
2
votes
1answer
198 views

Failover Cluster Diagnostic Logs

I know there must be a simple answer to this question, but I cannot find it anywhere. Our SQL 2012 FCI have SQLDIAG .XEL files in their MSSQL\LOG folder. In some instances, these files are often ...
1
vote
2answers
386 views

Avoiding MySQL Fabric to become a single point of failure

I managed to install and configure MySQL Fabric that manages multiple MySQL Server nodes. It works very well since I tested it by connecting to the Master node directly and played with the data ...
1
vote
1answer
254 views

MHA configuration problem with MariaDB10

I am using MHA (MySQL Master High Availability) over a MySQL/MariaDB master-slaves pool. Here is my setup : master1(10.0.0.1:3306) (current master) MySQL 5.1 (log-bin:enabled) ...
1
vote
1answer
119 views

Db2 high availability Instance configuration db2haicu fails

Hi I Configured db2 HADR between two servers and the servers are running in HADR Primary and Standby are syncing up I tried to configure the instance configuration utility db2haicu on both the ...
0
votes
1answer
308 views

MongoDB: Manual failover and failback between two datacenters?

This is about MongoDB and datacenter failover and failback. We're thinking about using two datacenters and this MongoDB replica set: DC1-M1 prio 1, votes 1 (datacenter 1, member 1) DC1-M2 prio 1, ...
2
votes
1answer
138 views

AlwaysOn AG and Cross-Database/Server Transactions

We're about to move from SQL Server 2008 R2 Standard to SQL Server 2012 Enterprise and are reviewing or HA as part of process. Right now we use DPM and log shipping every 15 mins. Our MS partner is ...
3
votes
2answers
1k views

SQL Server Database Mirroring is going to die. How can I guarantee high availability now?

The Database Mirroring feature of SQL Server is going to die: This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan ...
2
votes
1answer
706 views

Failover Cluster and AlwaysOn Availability Groups across Data Centers

We have two 3 node clusters in separate data centers, let's call them ClusterP and ClusterS. ClusterP is our primary and ClusterS is our secondary for disaster recovery. Each cluster has multiple ...
1
vote
0answers
33 views

Windows Clustering 2008 R2

I'm trying to build a Windows cluster with 3 nodes, 2 Active and 1 Passive, And If I have to build in a way like N1 Active - N3 Passive will be refer as "cluster network 1" and N2 Active and N3 ...
0
votes
0answers
152 views

High Availability in PostgreSQL with automated failover

I am currently working on designing an architecture for High Availability in PostgreSQL for a database of approximately 5TB in size. Also, I would like to re-direct my reads to a slave node(preferably ...