The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
26 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 ...
2
votes
1answer
287 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 ...
2
votes
2answers
880 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
298 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
511 views

Moving DBs (including System DBs) to new LUNs on a single node cluster

We have a single node cluster (SQL2K8 R2) currently utilizing storage on our old SAN. We'd like to migrate to storage on the new SAN without rebuilding or moving the user DB. The infrastructure ...
2
votes
1answer
349 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
812 views

How many database licenses do we need for setting 2 servers (nodes) into a cluster?

Suppose we have a server that has only 1 CPU with 1 core, so we need 1 Oracle database license for installing a database into it. Now, if we would need to add a second server, combine them into ...
2
votes
1answer
176 views

sql server active active configuration with same database names

I have a SQL Server 2008 Enterprice in a clustered environment and in active-active mode. By active-active mode i mean that both instances are active and serving requests to their databases. ...
2
votes
1answer
728 views

ODBC Connection As Clustered Resource

First step in a long process of creating a Linked Server to an Informix database on a Sql 2008 (Win 2003 x64) cluster. I was wondering how to go about creating an ODBC connection as a clustered ...
2
votes
1answer
4k views

What operating systems are certified for Oracle 11gr2 RAC?

How can this information be found?
2
votes
1answer
164 views

How important is the build number on a SQL Cluster

I did not actually perform this install, nor am I responsible for fixing issues on this particular cluster. I just happen to be checking it and found some things that puzzle me. My point in this is ...
2
votes
1answer
58 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
126 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 ...
2
votes
1answer
3k views

Problem adding a new node to a SQL Server 2012 Failover Cluster

I tried to add a new node to SQL Server (2012 Standard) Failover, that is already installed on another node in Windows2012 Failover Cluster I have an issue with non editable field wiht input for SQL ...
2
votes
2answers
174 views

Teaching Slony replication to select slave nodes

There is a system with up to 256 nodes in db cluster. We need to replicate some data from one of them across to all others. But for every row to replicate there is a list of nodes where it must be ...
2
votes
1answer
253 views

Cluster communication - SQL Server Failover Cluster

I am running a lab enviornment on my laptop two node SQL 2008 R2 running on windows 2008 R2 clustered Vms Based on my understanding a) Public Network or all Communication network I see checkbox ...
2
votes
1answer
292 views

Redesigning a multi-instance MySQL server for performance and resiliency

I've got a single MySQL server which currently runs N separate MySQL instances on, which are rapidly growing beyond the capabilities of that box. Is it possible to have an active-active MySQL ...
2
votes
1answer
478 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
1answer
227 views

SQL Server Cluster Failover Making DB Inconsistency Error

I encountered the following DB tables inconsistency error whenever I do a cluster 'move' over from Server-A to Server-B and then do a DBCC CHECKDB on the database in Server-B: SQL Server detected ...
2
votes
1answer
57 views

Does it make sense to run a cluster of database servers in docker containers?

I'm currently looking into setting up a database cluster (MySQL Galera or Percona) but I have only 2 machines. However, according to many sources I've read (This article from the Mariadb KB), the ...
2
votes
1answer
297 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 ...
2
votes
0answers
219 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 ...
2
votes
0answers
110 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 ...
2
votes
1answer
826 views

SQL Cluster Resources Disappear After Removing Disk Resource

In the process of removing an usused disk resource from cluster, I would follow these steps: 1) remove dependencies on the disks by the SQL Server resource, 2) take the disk resource offline, 3) ...
2
votes
1answer
270 views

Move DTC from one node to another in Windows 2003 R2 Clustering

I have a Windows 2003 R2 two node cluster that is running MSDTC as part of the Cluster Group. Is it possible for me to change the current MSDTC owner without moving the entire Cluster Group to the ...
2
votes
0answers
102 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 ...
1
vote
3answers
659 views

Best architecture solution for heavy data mining system, that can run on cloud

We are currently hosting our MySQL database on a dedicated server with lots of memory and processors. We would like to push it to a different architecture that would allow us to scale it easily, ...
1
vote
1answer
463 views

Experience using ScaleArc in test or production?

Has anyone had any experience using ScaleArc? My CTO has asked my thoughts on it, and I have seen no information out there regarding real-world experiences.
1
vote
1answer
555 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
264 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 ...
1
vote
2answers
129 views

Is it possible to remove a database server from a cluster resource, but keep it running on the node

I was wondering if anyone knew whether it was possible to delete the cluster resource, but keep all of the disks and sql instance running on the node instead? So if I was to delete the cluster ...
1
vote
1answer
90 views

Can I install an additional oracle database on one node of an oracle cluster (RAC)?

Let's say I have a two-node Oracle RAC environment. Can I install an additional Oracle database on one of the node? Thanks.
1
vote
2answers
129 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: ...
1
vote
1answer
116 views

Data usage increases initially when reorganize partition mysql cluster

In my MySQL cluster, the data usage of 4 data nodes is approximately 77%. I added a new data node online, and attempted to reorganize partition to redistribute data among all data nodes. But before ...
1
vote
1answer
627 views

What is the difference between Oracle clusterware and Real Application Clusters?

What is the difference between Oracle clusterware and Real Application Clusters? If we have 2 servers and want to join them into a cluster why there are two separate software products?
1
vote
2answers
3k 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
699 views

uninstalling SSRS and SSIS from clustered SQL Server 2008 R2 SP1

Due to the security recommendation, i will need to uninstall the unused SSRS and SSIS component from a production cluster SQL Server 2008 R2 SP1, so what is the caveats and what do I require to do to ...
1
vote
1answer
164 views

MySQL CLuster SETUP

Good day! About MySQL Cluster, is it possible to set it up on only two machines? Is it advisable? We currently have MySQL replication setup on our two databases, and we would like to implement R/W ...
1
vote
2answers
576 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 ...
1
vote
1answer
45 views

Linked Server and MSDTC on cluster

I'm trying to set up a linked server between two instances we have on our network. I've done this many times before without an issue, but this time I repeatedly get the following error: OLE DB ...
1
vote
1answer
99 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 ...
1
vote
1answer
53 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
1answer
236 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 ...
1
vote
1answer
215 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 ...
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 ...
1
vote
1answer
939 views

Is it bad to assign specific processors to SQL Server 2008 R2 cluster instances?

I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the ...
1
vote
1answer
148 views

MySQL Cluster Steps To Recover Data If Catstrophic Failure Occurs

I want to know if a catstrophic failure occurs (like a power outage), and all nodes in MySQL Cluster are shutdown in cluster then data will be lost even though a backup was taken? Or it possible that ...
1
vote
1answer
514 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
5k views

Unable to telnet to port 1433 in SQL Server clustered instance?

Situation: I believe that multiple port 1433 can be implemented as long as the IP address are all unique. I’ve created SQL Server 2008 R2 SP1 clustered virtual instance on top of my Windows Server ...
1
vote
1answer
117 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 ...