The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
46 views

Need scalable database solution for very big automated data entry database

I've been working on MySQL database in simple web applications for a long time and i now have a project which should maintain about 1,000 up to 10,000 query per minute (it is some logging database ...
2
votes
1answer
21 views

Simultaneous money withdrawls from a distributed/replicated database

Lets say I have $10 in my bank account. The database is replicated in North America and Asia. At the exact same time I do a withdrawl of $10 in N. America and in Asia, meaning that my withdraw would ...
0
votes
1answer
81 views

Setting up my first SQL Server cluster

I've been working with SQL Server for about 6 years and have completed a couple of certification exams so I consider myself reasonably knowledgeable. I am however, about to spec and build my first ...
1
vote
1answer
67 views

Complete Failover Cluster Failure SQL Server 2012

We have experienced a full cluster failure on our 3 node cluster running SQL Server 2008 R2 with 7 SQL Server instances. It started when we rebooted one of the nodes and it returned an error: Node ...
0
votes
0answers
6 views

What is the preferred mode of replication for a MySQL Cluster?

Reading about MySQL Cluster, I'd like to know about what are the preferred models of replication. I understand that it supports asynchronous replication out of the box, but I'm not sure of how it ...
3
votes
1answer
91 views

Can you upgrade a single SQL Server 2008 Failover Cluster Instance to SQL Server 2012?

Or do you have to upgrade every FCI on the Failover Cluster? The documentation doesn't seem to be clear. We have a 7 instances on a 3 node cluster. We want to upgrade only one of the instances from ...
0
votes
0answers
69 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 ...
3
votes
1answer
57 views

How can I achieve clustering of rows without the exclusive lock and logging overhead of the `cluster` command?

The CLUSTER command on a big table can take a long time, and blocks both reads and writes to the table while it runs. I don't need the data in my table to be strictly sorted in index order, I just ...
2
votes
1answer
167 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
39 views

Failover cluster connection issue

I'm trying to run SQL Server Failover cluster in Azure. I have NODE1 and NODE2 in a cluster and another SERVER in the same network trying to connect to the database server using the instance from ...
2
votes
0answers
129 views

Problems with clustered DTC server 2008 R2

I had a working clustred DTC, but due to a disk migration, i had to delete the service and recreate it. Thats how the problem started. When i recreate the service, it comes online perfectly. But when ...
0
votes
1answer
75 views

Failover Cluster - Add Witness Disk?

I'm trying to build SQL Server 2012 Cluster on top of Windows Cluster 2008R2. Can anyone please suggest.. do we need quorum disk in setting up SQL cluster 2012 on top of windows cluster 2008r2
3
votes
1answer
81 views

Multi-Site clustering on Windows 2012 for SQL Server 2012

I am hoping someone can point me in the right direction here. We are trying to do a proof of concept for a 3 node multi-site cluster on Windows Server 2012 R2 for our SQL Server environment. There ...
1
vote
1answer
73 views

Min no. of replicas to set up SQL Server Always ON over a Failover Cluster on a Windows Cluster

AO: Always ON FCI: Failover Cluster Instance WSFC: Windows Server Failover Cluster I'm scratching the surface of AO. I currently have one SQL 2012 FCI on a WSFC. Which means one Active node at a ...
2
votes
0answers
119 views

MS SQL Server 2012 Failover Cluster connection issue

I was about to give up with this but I'll give it a go here if anyone can help. I've set up a fail-over cluster SQL Server with 2 SQL nodes, Domain controller and file witness. All seems to work ...
0
votes
2answers
65 views

MongoDB Synchronizing multiple Shards

I've got the following layout Picture Cluster RZ West is my first data center A and RZ Ost my second data center B. As you can see one secondary database of each cluster is available in the other ...
0
votes
0answers
32 views

Is there a way to synchronise 2 postgresql server that may be deconnected and modified?

I would like to know if there is a way to use a cluster / replication mecanism that can manager deconnection and modification while deconnected. Say I have server A and B, they see each over, cluster ...
0
votes
0answers
31 views

Migrating a SQL NetName Between Clusters

Instance A is a default SQL Server 2005 instance on a two-node Windows 2003 cluster. Instance B is a default SQL Server 2012 instance on a two-node Windows 2008 R2 cluster. The application team is ...
3
votes
1answer
185 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 ...
1
vote
0answers
90 views

MariaDB Galera Cluster

I have two mariadb servers in cluster that is working galera and xtradb. it is my primary server configuration: [mysqld] datadir=/var/lib/mysql query_cache_size=0 binlog_format=ROW ...
0
votes
1answer
73 views

SQL Server: multiple failover cluster instances with disjoint storage

This is for SQL Server 2012. I currently have two datacenters that have separate SANs. I'm using failover cluster instances (FCIs) for server redundancy, and then AlwaysOn Availability Groups (AGs) ...
0
votes
1answer
94 views

How to update SQL Server 2005 clustered instances?

We have a 3 node cluster with an instance running on each. Windows 2003 R2 32bit (16GB) / SQL Server 2005 I want to bring them all up to build 9.00.5266 (SP 4 + CU3) (1 Node is already updated) The ...
1
vote
0answers
261 views

SQL Server Configuration Manager 2012 - TCP/IP, unable to set IP All = No

I have a 4-node SQL Server 2012 SP1 cluster, and under Network Configuration -> TCP/IP -> Protocol (tab), I am able to switch Listen All from Yes to No. However, when I hit OK (or Apply), I get the ...
1
vote
0answers
156 views

Postgres database zero down time production deployment

I need some idea about how I can deploy a financial application in production environment using PostgreSQL DB with zero down time. I have two servers in Master-Slave design. Currently I am giving ...
1
vote
1answer
48 views

Master-master database replication on 5 servers

My current project requires immediate replication between 5 databases. Servers are physically distributed across the globe. Currently we use Redis with one master server installed on another 6th ...
1
vote
0answers
29 views

Data mirroring suggestions

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to ...
1
vote
0answers
483 views

High availability PostgreSQL 9.3 server on Windows

I'm trying to set up PostgreSQL 9.3 server in HA mode on 2 Windows servers. Final solution should be deployed to Microsoft azure network, so there are few limitations. Since Microsoft is doing ...
1
vote
0answers
32 views

Upgrade/migrate a Microsoft Cluster

We currently have active/active windows 2008 cluster hosting 2 instances of SQL 2008 R2. We have a new hardware for windows 2012 clustering. We want to use this new hardware to upgrade the ...
2
votes
0answers
97 views

How to use Blob Storage as shared storage in a Windows Azure Failover Cluster?

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster composed on ...
3
votes
1answer
139 views

Active/ Active SQL Server Clustering on AWS

I need to design and implement a highly available SQL Server 2012 clustering on Amazon AWS. In the white paper presented by Amazon, they provided an example of Active/ Passive SQL Cluster. Do you know ...
1
vote
0answers
262 views

Error installing Clustering with SQL Server 2012 on Windows Server 2012

We are installing SQL Server 2012 on Windows Server 2012 and trying to accomplish clustering. We've setup all the core functionality on the servers: advanced cluster preparation on all nodes and ...
0
votes
0answers
118 views

SQL instance names not shown in drop-down list when trying to remove cluster node

I was installing SQL Server 2008 R2 on a single-node cluster and accidentally installed into the wrong shared disk on the SAN. But when I tried to use the 'Remove node' from the installation centre ...
1
vote
1answer
181 views

Improper removal of SQL Server cluster

A node was evicted from a windows cluster without first uninstalling the sql first. When the node was put back, an error was produced when we tried to failover. It was reporting a missing dll. Feels ...
0
votes
0answers
32 views

where to find out sql server config file?

I try to install SQL Server 2008 R2 cluster. One time is failed. One time is success. The reason is because inputs during different. Where is the config file to save the inputs from installation, like ...
15
votes
4answers
3k views

Clustering vs. transactional replication vs. availability groups

Assuming you need to make sure your application that relies on SQL Server 2012 as its database backend is available around the clock, even if one server machine fails. As a developer and not a DBA, I ...
3
votes
3answers
148 views

Is it possible to setup failover clustering between a 32 bit instance and a 64 bit instance?

I am attempting to setup a couple of virtual machines in my lab for testing failover clustering on SQL Server 2008 and Windows Server 2008. One of the hosts I have is not capable of running a 64 bit ...
3
votes
1answer
761 views

SQL Server cluster not available after failure of the “main” server

I aksed this question on stackoverflow, but was asked to repost here so here it is: I have a database that I'm setting up in a clustered environment. It'll be two servers with a shared storage. ...
2
votes
2answers
673 views

SQL Server 2008 upgrade to SQL Server 2012 on a cluster

I have a Windows 2008R2 2 node cluster with SQL Server 2008 clustered. How do I prevent the cluster from failing over while I am applying the SQL Server 2012 to the alternate node first? Any pointers ...
2
votes
1answer
556 views

TempDB on Solid State Drives on SQL Server Cluster

Can solid state drives be used for the TempDB on a SQL Server failover cluster if they are local drive on both machines? It is supported in 2012 but our cluster is a SQL 2005. The application that it ...
1
vote
1answer
480 views

Is MSDTC required for SQL Server 2012 Fail Over Cluster?

I am making a 2 node SQL Server 2012 Fail Over Cluster, do I need to install MSDTC also? If yes then can both be installed on single shared disk?
1
vote
2answers
119 views

Single disk for Data, System, User, Temp and Backup when installing Fail Over Cluster?

I have a Windows cluster with two nodes. I am trying to make Fail Over Cluster using SQL Server 2012. On both nodes there is 2 TB storage available which I can access as: ...
0
votes
2answers
177 views

Experience with Scalearc sharding?

Does anyone have experience with Scalearc sharding and it's ability to scale ? Does Scalearc needs to have the whole data in memory or does it behave well with disk storage ? I'm thinking to big ...
1
vote
2answers
238 views

Understanding disk requirement to make fail over cluster

Please take a look at the following screenshot. I am trying to make SQL Server 2012 Fail Over Cluster using two nodes. As you know we need to have a shared SAN which will be used by both nodes to ...
4
votes
2answers
2k views

Understanding two NICs requirement for SQL fail over cluster

I am trying to make an SQL Server 2013 fail over cluster. I have two DB machines. I understand that both machines need 2 NICs each. In my organization the IP scheme assigned is something like ...
1
vote
1answer
168 views

RBS and Fail Over Cluster with SQL Server 2012

I am trying to install one SQL Server 2012 cluster with two nodes. I will also be enabling Remote Blob Storage (RBS) on server so I was wondering if I need to take something in account while ...
0
votes
0answers
201 views

Create a high availability cluster configuration PostgreSQL for Windows

I want a server to be replicated, here is the scenario: When my primary server goes down or fail I want the secondary or the standby server to take over, I'm using Windows 7 for the primary server, ...
0
votes
1answer
148 views

Clients require instance name to connect to clustered instance

We have a clustered instance, say Instance1, assigned its own virtual network name and IP, via Failover Cluster Manager. This instance is configured to listen on port 1433 in SQL Server network ...
1
vote
0answers
291 views

How to shut down clustered SQL Server 2008 R2 with NOWAIT?

Is it possible to shutdown with nowait on a clustered instance? I want to delay recovery to when the instance starts, and I want to shut down as quickly as possible without issuing checkpoints to my ...
-2
votes
1answer
264 views

SQL Server 2008 component is cluster-aware? [closed]

Which SQL Server 2008 components are cluster-aware? Notification Services Tuning Advisor Full Text Search Reporting Services Integration Service
1
vote
1answer
2k views

MariaDB Galera Cluster Replication error, no state received?

I have a very minimal, fresh out of the box setup for MariaDB with Galera clustering. My master node of the cluster is able to run, and is reporting that there is only one node attached to the ...