The tag has no wiki summary.

learn more… | top users | synonyms

16
votes
0answers
345 views

Is there a complete list of Online operations for each SQL Server version?

As we are about to change some of the large tables in our 5TB database I found myself needing a list of the operations that can be performed online and the which require full locks to be held while ...
11
votes
1answer
1k 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 ...
8
votes
4answers
4k views

SQL Server equivalent to functionality of Oracle RAC?

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 ...
8
votes
2answers
381 views

High Availability for postgresql

I'm new in PostgreSQL database. Recently our developer needed to do some upgrades in our systems. Because of that we are planning to implement some method in order to implement database failover. ...
7
votes
2answers
394 views

Can Availability Groups replace transactional replication?

I've been looking at the new features of SQL Server 2012, and how it can help my current situation. Currently we're on SQL Server 2008 R2, and replicate two OLTP servers' databases to a single ...
6
votes
1answer
853 views

Do schema changes “break” SQL Server 2012 AlwaysOn or are they handled transparently?

My organization is planning to adopt SQL Server 2012 AlwaysOn and I am trying to understand what impact (if any) it will have on our application upgrade process. We release application updates on an ...
5
votes
1answer
380 views

Recovery time effects of Availability Groups

We did different kinds of basic Tests and AlwaysOn passed in many tests. We finally did a heavy write test for AlwaysOn and it gave surprising results. The actual Test details are here, the goal is ...
5
votes
2answers
527 views

Recommended distributor architecture for transactional replication?

We are planning to create a Transactional replication on 2 nodes of SQL Server 2008 R2, each node will be a publisher and a subscriber. What is the best practice in order to have this scenario done? ...
4
votes
1answer
477 views

SQL Server 2012 - Always On

I am in the process of setting up always on high availability clusters for the first time. Can anyone explain to me from the networking perspective after configuring the group and testing to make sure ...
4
votes
2answers
3k 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?
4
votes
2answers
537 views

SQL Server replication for off site copy

We have our Primary SQL Servers in-house (15 primary servers at the moment (500 databases approx overall), most of the servers have hex core processors). These are mirrored to other backup servers in ...
4
votes
1answer
575 views

Transaction Log Truncation with Copy Only

I have a database backup job set to use full backup with the Copy only option on once daily. The copy only is on because from what I have read that is the only way to backup a database that is ...
4
votes
2answers
316 views

Is MySQL Clustering a viable option for a DB expecting 5TB of data in 5 years?

We plan to implement MySQL Clustering.The database should support 5 years of data and expected data/year is 1TB. When we created a test enviornment with the DB size as 200GB, NDB Cluster took more ...
3
votes
1answer
167 views

Three Node Cluster that Allows For Two Failures

We are creating a three-node three-instance cluster with SQL 2008 R2 (not cutting edge, but that is what the application supports) and think it should be able to maintain quorum with two physical ...
3
votes
1answer
177 views

SQL Server DR, mirroring or virtualise and mirror

I have a client with a small business server 2008 Premium installation. This obviously includes SQL Server 2008 standard on a separate 2008 server. On the SQL we run several line of business ...
3
votes
1answer
1k views

MySQL Replication and High Availability

I know this might not be a very good question to be asked in this site, but I really need some helps/hints to be directed to the right path. I want to have failover strategy for 2 MySQL servers which ...
3
votes
2answers
310 views

Best high availability solution to avoid maintenance downtime?

We currently only have one production SQL Server 2008 server. Anytime we need to perform maintenance or install patches, it causes downtime as the server reboots. In addition, if the server ever ...
3
votes
1answer
511 views

Robust Mysql failover using free tools

I am looking for a free solution to set up Mysql in an active/passive configuration, in order to provide high-availability. In particular, a Bugzilla installation, and MediaWiki needs to stay alive ...
3
votes
1answer
366 views

PostgreSQL High Availability/Scalability using HAProxy and PGBouncer

I have multiple PostgreSQL servers for a web application. Typically one master and multiple slaves in hot standby mode (asynchronous streaming replication). I use PGBouncer for connection pooling: ...
3
votes
1answer
3k views

Do Availability Groups support Active/Passive?

I am looking into the licensing of SQL Server 2012 when using Availability Groups with 2 servers. It is not clear to me if Availability Groups are only available as Active/Active and not ...
3
votes
1answer
566 views

AG and SQL Backups

I am using always on in sql 2012 and have an AG setup. I would like to know if i were to backup the primary database and restore it would that be allowed without taking the cluster down etc. ...
3
votes
1answer
574 views

Configured MySQL replication but its not working

I have configured MySQL master and slave replication setup on 5.5.x. But for some reason data is not getting replicated properly. What might be the reason? At Master: /etc/my.cnf [mysqld] ...
3
votes
2answers
75 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 ...
3
votes
2answers
47 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. ...
3
votes
0answers
62 views

ENABLE_BROKER vs NORECOVERY

I have two nodes with MSSQL2012 which work with AlwaysOn High Availability After some crash I had to remove db from availability group on the one of the nodes. For restoration I've made backup ...
2
votes
2answers
825 views

MySQL cluster - how many hosts are needed for full HA?

I need some clarification on MySQL-Cluster (NDB) setup I want to achieve full HA but I'm low on server budget and can't afford to rent a dozen of servers for simple solution that I'm working on. ...
2
votes
2answers
989 views

SQL Server 2012 High Availability on VMware virtualization

We're going to host a large SQL Server 2012 under a VMware virtualization and we need it to be highly available. These are the three options I found supported, but couldn't find a lot of info and ...
2
votes
1answer
190 views

When changing startup parameters on a cluster, does each node have to be updated manually?

When moving a SQL 2005 instance to new disks on a two-node Windows 2003 cluster, I changed startup params on the active node to reflect the new paths for the master DB files and error logs. I ...
2
votes
1answer
251 views

AlwaysOn Availability Groups: Confusion with some concepts

In Sql Server 2012, I am trying to install Failover Clustering to configure AlwaysOn Availability Groups. When I run Cluster Validation test wizard, it comes back with a lot of errors. One of them ...
2
votes
1answer
172 views

Which database?

We have to launch a new service in my company with a big database. And I currently don't have that much knowledge. We did a small preview of the service and our biggest table had more than 2 100 000 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
258 views

Is it possible to automate the configuration of dataguard broker?

We deploy a number of oracle databases every year and a good percentage of them require a dataguard configuration. I've developed a script which is able to perform the database synchronization very ...
2
votes
0answers
511 views

SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled

I have two SQL Server instances in an availability group. They are not mirrored. I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
2
votes
0answers
386 views

SQL Server Database Mirroring : strange client application behavior upon failover

I am putting a HA SQL server environment up based on three SQL Server 2008 R2 machines and database mirroring. I'll name them : principal.company.intra mirror.company.intra witness.company.intra ...
1
vote
1answer
37 views

How Automatic Failover Works (AlwaysOn)

I'm going to use AlwaysOn technology on my servers, but it's some unclear points in the documentation: Automatic failover looks like Primary replica (A) unaccessable Secondary replica (B) becomes ...
1
vote
2answers
88 views

Multi-master + slaves replication in MySQL

I've been playing around with MySQL and tried to create replication topology according to the following picture. Slaves are used as read servers and Masters are used as both read and write servers. ...
1
vote
1answer
63 views

Heartbeat Options with MySQL and Possibilities

I would like to understand if the following scenarios are possible in Heartbeat in Linux. Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup ...
1
vote
1answer
273 views

Mitigating MySQL replication delay in single master/multiple slave setup

For a particular web application that requires high availability I am thinking of scaling out by setting-up MySQL replication with one "write" master and multiple "read" slaves (as explained here ...
1
vote
2answers
358 views

Oracle symmetrical one-way replication for cheap HA: unfashionable or technically unfeasible?

We have two smallish unrelated databases on two big Oracle Enterprise servers. Instead of buying more licenses and servers for high-availability replicas, can we replicate database B to server A and ...
1
vote
2answers
2k views

Creating High Availability Cluster with PostgreSQL

I am new to database design. I have a task to create a high-availability cluster. I Googled a lot, however I haven't found any good way to do this on PostgreSQL. Where should I start and what are ...
1
vote
1answer
24 views

Connecting to Active Active Cluster Services

I have a two node active active cluster setup as below: NODE 1 - SQLINST1 ( with DTC1 ) NODE 2 - SQLINST2 ( with DTC2 ) I wish to now have the application connect to SQLINST2 whenever ...
1
vote
1answer
191 views

SQL Server 2008-R2/2012 with Failover Cluster - minimizing downtime of program updates

I have SQL Server 2008-R2 with Failover Cluster like this. Planning to upgrade to SQL Server 2012. Problem - The downtime of my program updates (not Microsoft updates/patches). Both of my cluster ...
1
vote
1answer
697 views

MySQL: Alter Table on very active table gives “Waiting for table metadata lock”

At my work, we've recently upgraded to MySQL 5.5 and since then, have been bitten a few times by the new (and intended) behavior of metadata locking. Basically, whenever we run an ALTER TABLE ...
1
vote
1answer
64 views

How do I set up high availability at the instance level? [closed]

I have two database instances (Instance A, Instance B) of SQL Server, each one hosted on a separate VM using windows server 2012. Instance A has SQL Server 2008 R2, instance B has Sql server 2012. I'm ...
1
vote
1answer
259 views

SQL Server 2012 AlwaysOn cannot connect using the Listener IP

I have setup a Windows network in an Amazon in a VPC. I have setup two SQL servers and configured Always On. Everything works OK, except that I cannot connect to the SQL Server using the AAG Listener ...
1
vote
1answer
424 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 ...
1
vote
1answer
102 views

Rolling changes to production databases

We're currently using Clustering to do fail over for our SQL environment. There are two servers that use the same shared drive. The SQL database is on a shared drive. This provides OS and hardware ...
1
vote
0answers
89 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 ...
1
vote
1answer
345 views

PowerPivot doesn't install in SharePoint mode on an Active/Passive Cluster

We a provisioning a new SQL Failover Cluster. We have successfully configured the SQL instance, and have moved on to configuration of the PowerPivot for SharePoint instance. We run the configuration ...
1
vote
0answers
84 views

DPM and AlwaysOn - Can they work

How does AlwaysOn tie into DPM for SQL Server 2012? Can we use one or the other for High Availability ? Can they work together or must they be used separately. Thanks