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

2
votes
0answers
25 views

SQL AlwaysOn & System Center Configuration Manager TP 4 1601

Recently Microsoft released Technical Preview 4 for Configuration Manager (1601). Per TechNet, "Configuration Manager now supports using a SQL Server AlwaysOn availability groups to host the site ...
2
votes
1answer
41 views

How do you configure Postgres 9.4 for incremental backups and hot standby?

I want to set up Postgres to do incremental backups. I'm using PostgreSQL 9.4 on Windows with a database that weighs about 1GB and has a growing 10000 records each day. I understood that the steps ...
1
vote
1answer
26 views

MySQL: 3 servers on-site architecture

I have 3 servers with RHEL 6 OS and Percona server running in one of the servers in the same data centre, while the other 2 servers lie idle. Now I need to implement some kind of on-site redundancy ...
0
votes
2answers
32 views

Avoid user login Directly to AlwaysOn High Availability Primary

I have setup an AlwaysOn High Availability in Sql Server 2014. my IP addresses are according to this : 192.168.1.189 -- Listener 192.168.1.180 -- Replica 192.168.1.181 -- Primary Right now users ...
0
votes
0answers
46 views

Which pgpool “mode” for high availability & failover on Postgresql 9.3

I'm in the process of designing a HA setup for a web API & application that uses Postgresql 9.3. To satisfy availability & resiliency, we require: failover to a secondary database instance ...
0
votes
0answers
41 views

Simple/Easy PostgreSQL HA multi-master for high latency / unreliable network

I have an environment consisting of two servers running JBOSS and PostgreSQL. Each server writes to its own database and programmaticly synchronises some data to the other database. This causes ...
0
votes
1answer
48 views

Mysql only using 10% of cache [duplicate]

I have a dedicated Mysql server that only uses 1.1 GB out of 16 GB ram (picture link 1). I belive this leads to my Disk I/O utilization beeing at 75% peaks (picture link1). How can i configure sql ...
2
votes
1answer
53 views

Master-Master Replication with MySQL Cluster - Duplicate Writes in Both Directions

I have created 2 MySQL Clusters; each cluster is located in a separate geographic location. I have set these clusters up in a Master-Master, Geographic Replication fashion, so that data can be written ...
1
vote
1answer
69 views

Compare SQL Server high availability method

I want to provide high availability for my SQL Server. It is important that the service is back as soon as possible, more than making sure that data isn't lost. My SQL Server 2008 R2 is running on a ...
1
vote
1answer
48 views

MySQL Cluster - Management Node Redundancy

I am trying to design a fully redundant MySQL Cluster implementation for a service provider's network. Nodes within this cluster will be geographically separated between towns in the state that the ...
1
vote
1answer
50 views

SQL SERVER 2014 Standard - High Availability Listener solution

The company has SQL Server 2014 Standard licenses and we're standing the servers up in a VMware environment. My initial plan is to create 2 instances on each DB server and run Instance1 on SQL1 as ...
1
vote
1answer
106 views

Promoting warm standby to master with Postgresql 9.4 using streaming replication

I've currently got 2 database servers running Centos 6 and Postgresql 9.4 (identical clones on the same network). They are set up as a primary and a backup created using pg_basebackup from the ...
0
votes
0answers
169 views

pgpoolAdmin for pgpool-II 3.4 : superuser: unknown (Connection error)

I cannot start/stop/reload my nodes through pgpoolAdmin and it says "superuser: unknown" even though I'm logged with the postgres account. What could be the cause? pgpool.conf is identical to another ...
1
vote
0answers
48 views

How can we plan for a High Availability/Disaster Recovery setup in Postgresql 9.3? [closed]

I am working for mission critical project. We are planning for High Availability. At any point of time irrespective of the failure (network, hw, or db) one db server should be available for the ...
1
vote
0answers
45 views

IP from a different subnet is registered even after node and resource were removed

We run two SQL server at primary site in AlwaysOn High Availability Group on subnet 10.10.0.0/24 A third SQL server is running on secondary site in a different subnet 10.10.1.0/24 We have had third ...
3
votes
1answer
60 views

SQL Server - Company wants HA for single instance with 1 userDB - sanity check and questions

I am new to SQL Server (2 months) and learning at a gov company (europe). The job is to make a HA solution for this 1 productive instance (1 database). Following is given SQL Server 2012 Windows ...
5
votes
0answers
65 views

Low performance, high availability, replicated key/value store with audit trail

I'm looking for a database system with fairly specific specs. I've looked most of the major relational databases and NoSQL products out there and did not find one that even remotely satisfied my ...
2
votes
1answer
117 views

Rename Availability Group and AG script

I have two questions for you guys. I really appreciate your help. 1.- Is there a way to rename an Availability Group? 2.- Is there a way to get the T-SQL statements in order to re create a ...
0
votes
0answers
19 views

Create db2 alert for automatic failover

We have two servers in automated failover HADR (TSA installed and haicu configured). How can we create an alert that fires when a failover happens i.e. when the primary server goes down and the ...
0
votes
0answers
16 views

HA options for Standard SQL2008

Running SQL 2008 standard with our pants down, no mirror (shut off due to performance hits) shipping logs but that is not going to be good enough. I want an HA option that works. With dual node ...
1
vote
1answer
112 views

AlwaysOn Manual failback not working correctly

I've set up a small fail over cluster using AlwaysOn in SQL Server 2014 and Windows 2012R2. The cluster (SQL-CLUSTER-DEMO) just contains 2 SQL nodes (SQL-01 [Primary] & SQL-02 [Secondary]) and a ...
0
votes
0answers
37 views

Why does my SQL Server HAG fail from PRIMARY to RESOLVING and back again?

I recently noticed our SQL Server High Availability Groups failed from the PRIMARY to the RESOLVING state, and then from RESOLVING to the PRIMARY state, without failing to the SECONDARY state. Does ...
1
vote
1answer
56 views

Manual sql failover machine with replication

I hope this is the correct place to ask this question. We recently experienced one of our virtual machines being offline for 3 days due to issues in the data center hosting it. This quickly brought us ...
0
votes
1answer
79 views

Galera and in-memory

i've got a question about Galera cluster + mysql/mariadb and RAM. Basically, mysql cluster needs to run in-memory (https://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-basics.html). But we have a 3 ...
1
vote
0answers
23 views

Oracle DataGuard [closed]

Maximum performance and Maximum Availability modes has only difference right? Former is async mode and the latter is sync mode wherein it waits for acknowledgement for up to a time and after that it ...
1
vote
2answers
115 views

SQL Server 2012 and DBM

Why would MSFT would deprecate mirroring from 2012.. I understand alwaysON will replace it but then SE users are left with nothing..no alwaysON or dbm from future releases.. Just analyzing from end ...
0
votes
0answers
60 views

Problem Setting up MariaDB Spider HA

I have problem setting MariaDB with Spider for partitioning and HA.My environment consists of: Spider Proxy - 10.64.20.207 Backend1 - 10.64.20.208 Backend2 - 10.64.20.209 First I am creating user ...
0
votes
1answer
211 views

Where to look for Agent history in Replication?

In SQL server 2008R2 replication configuration, "agent history cleanup distribution" job by default runs every 10 minutes and deletes any historical data older the 48hrs. If I increase the retention ...
0
votes
1answer
120 views

Restart the active node services without failover [closed]

On a 2 node cluster configuration, How to restart the SQL services on the Active node without failing over on to another node?
1
vote
2answers
116 views

Where is Connection String Located as it relates to Availability Group Listeners?

I am trying to teach myself about Availability Group Listeners and see that I need to update a "Connection String." I know that I have a connection string in my web.config file on the Web server, but ...
1
vote
1answer
132 views

LSCopy job fails on SQL Server 2005 - Insufficient space

I'm having some trouble getting my LSCopy job of Log-Shipping on my SQL Server 2005 server, to work. The LSBackup job is configured so the backup is made locally (D: drive) The LSCopy job is ...
2
votes
0answers
37 views

Alwayson cannot fail over using tsql

I have an Alwayson test environment with the following settings. My test goals are as follows: When SqlNod1 is primary instance, I want SqlNod2 to answer read-only queries. When SqlNod2 is primary ...
0
votes
0answers
305 views

Couldn't setup postgresql cluster with heartbeat pgsql ra

I'm trying to install postgresql cluster with the following configuration: 2 virtual hosts with RHEL 6.6 x64: postgresql 9.1 with hot standby replication pacemaker 1.1.12 resource-agents 3.9.6 I ...
3
votes
1answer
546 views

Reporting services - High availability setup - SQL server 2012

I need some guidance on best practices and setup for SSRS. I have a SQLServer 2012 setup with data source on 1 instance and SSRS on a separate server. There is a need to setup HA and I understand what ...
0
votes
2answers
44 views

High Availability using SQL Server 2012 requires how many licenses [closed]

For on premise solution, is it possible to implement high availability for SQL Server 2012 using a single license, or, one needs to buy extra licenses? Also, for high availability with SQL Server, ...
0
votes
0answers
34 views

Can two databases share one data folder?

I'm planning to install a database (same configuration) on two separate machines, PC1 and PC2. PC1 is the main database while PC2 is the backup.. Is it possible that they can have the same datadir in ...
1
vote
1answer
283 views

Need help achieving HAProxy active/passive configuration for mysql

I'm using HAProxy for mysql database backends. The database had to be master-slave. The goal is to point all mysql clients at the proxy and for all requests to go to mysql server #1 and only go to ...
1
vote
1answer
524 views

Restoring a Database in an Availability Group

I located an extremely helpful process outlined in the thread below, but needed some clarification. This may be a silly question, but I'm a bit new to Availability Groups. In the steps outlined in the ...
2
votes
1answer
506 views

postgresql 9.4 + BDR Fails [closed]

I'm trying to get postgresql 9.4 and BDR working. Following this tutorial: https://wiki.postgresql.org/wiki/BDR_Quick_Start Actually, my sysadmin provided me with a package to test with. He's taken ...
1
vote
2answers
93 views

Maintain Up-To-Date Copy of Very Large Table if Clustering/Partitioning/Moving Operation Needs to be Killed/Rollback

I've appended the following information in a previous post but I asked the 'why' instead of the 'how'. So here's the question... SQL Server 2014, CU6. 4.5 TB database, Simple recovery. The most ...
1
vote
1answer
54 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
0answers
223 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
23 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 ...
0
votes
0answers
51 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
227 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. ...
0
votes
0answers
44 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 ...
3
votes
2answers
326 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 ...
3
votes
1answer
125 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 ...
1
vote
1answer
333 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 ...
1
vote
1answer
90 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 ...