The clustering tag has no wiki summary.
33
votes
5answers
2k views
Why can't RDBM's cluster the way NoSQL does?
One of the big plusses for nosql DBMS is that they can cluster more easily. Supposedly with NoSQL you can create hundreds of cheap machines that store different pieces of data and query it all at ...
6
votes
2answers
690 views
SQL Server 2012 Standard Edition - multiple instances and memory utilization
If we have multiple instances of a SQL Server 2012 Standard Edition (which has a 64 GB memory limit) on one server which has 192 GBs of RAM, do both instances only have access to the first 64 GBs of ...
6
votes
1answer
246 views
Executing Powershell SMO against a cluster with elevated privileges to update service accounts
I'm working on a Powershell script to update service accounts on named SQL instances in a failover cluster. I'm trying to use the SMO and WMI to update this so that I can update the service account ...
5
votes
2answers
103 views
New Cluster Testing - Best Practice
We've finished setup of a 4-node SQL Server 2005 cluster. We are using Windows 2008 R2 as the underlying OS.
We are looking for suggestions on a set of tests we could perform to test failover of the ...
5
votes
1answer
139 views
De-Cluster SQL Server 2012
Is there any way to 'de-cluster' an instance of SQL Server 2012 that was installed using the 'New SQL Server Cluster Installation' option? We are having issues with the failover portion of clustering ...
4
votes
2answers
675 views
Best Setup for Database Cluster
I need to set up a good database clustering solution for a system that I am putting into production. I was hoping to get some advice from the experts as I am a primarily a developer and not a database ...
4
votes
1answer
105 views
SQL Server Mirroring kicks in before cluster has time to fail over
I have two clusters each with two nodes configured in active/passive; the two clusters take part in a high-availability mirroring session using a separate server as the witness.
When a node fails in ...
4
votes
2answers
369 views
Manually moving SQL instance to another node causes immediate database mirror failover
I have a two-node SQL cluster (2008 R2).
Some of the databases within that SQL instance are mirrored to another server on a remote site, using the High safety with automatic failover. The mirroring ...
4
votes
1answer
208 views
SQL Server Agent fails to start in Failover cluter
The SQL server agent in a cluster (as a cluster resource) fails to start. I'm looking for error logs to give me a clue, but so far, all it says is: "failed to start". What could be the possible ...
4
votes
2answers
1k views
I cannot get SQL Server 2012 to install the database engine
SQL Server 2012 installation on a standard Windows 2008 R2 server. It refuses to install the database engine or sql replication.
During the installation I got no errors saying that it wasn't ...
4
votes
1answer
120 views
Storing logs on per day basis in PostgreSQL
Requirements here are to store historical logs.
For the sake of simplicity I'll assume this sample scenario where we are selling some products on our website and we need to keep records of sales of ...
4
votes
1answer
3k views
MySQL high availability, failover and replication with Latency
We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of ...
4
votes
2answers
3k views
Help solving a Clustering Issue: [sqsrvres] ODBC sqldriverconnect failed
I have a 2 node cluster (NODE-A & NODE-B) with 2 SQL instances spread between them. INST1 prefers NODE-A, INST2 prefers NODE-B. INST1 started generating errors then, failed over to NODE-B. ...
4
votes
1answer
227 views
Continuing failovers on production server
At least a few times a day, my main production server has recently begun failing over. Only, the quorum doesn't move to the other node.
I ran the validation report, and got a lot of info I don't ...
4
votes
1answer
808 views
Setting up MySQL Cluster on Two Systems
I am attempting to setup a MySQL Cluster.
I have the folllowing setup
one management node
two data nodes
another machine on which two more nodes reside
Below is the config.ini file:
[ndbd ...
3
votes
3answers
2k views
Port number change
We are planning on setting a static port for SQL Server 2005/2008 failover clustering. Any guide on what port to choose/select for 4 nodes of each cluster?(Active/Active)
I am also thinking some ...
3
votes
3answers
2k views
How? SQL Cluster with multiple active nodes (not failover)
I'm building a new SQL 2008 R2 (Enterprise) Cluster that is backed by an EqualLogic iSCSI SAN. Instead of building a failover cluster (which I have done), I would instead like to setup several nodes ...
3
votes
1answer
49 views
What is the safest way to run SSIS on Multiple Named SQL Server Instances?
I have an Active/Active SQL Server 2008 R2 cluster. There are two named instances on each node and no default instance.
I need to deploy SSIS packages to the different instances. To do this, I ...
3
votes
1answer
89 views
Does mongodb automatically move small non-partitoned databases to spread read load?
I have a few hundred small databases, each between 0.2GB and 4.0GB in size. These are sitting on a sharded mongodb environment with 10 or so shards.
At any one time, only a very small subset of these ...
3
votes
1answer
146 views
SQL Server Clustering for HA combined with Log Shipping for DR
Has anyone implemented SQL Server log shipping in a clustered environment? Are there any issues or things to consider when implementing this scenario?
3
votes
1answer
282 views
Migrating Sql Cluster Installation To New Drive
We are migrating from an old SAN to a new SAN and need to migrate our Sql instance to new LUNs. We are able to migrate the data without any problem, but the Sql instance itself is clustered ...
3
votes
1answer
100 views
SQL Server 2008 Cluster Across Two VMWARE Hosts
Vmware ESX 5 from a Vcenter
Two Windows 2008 R2 VMs
I am attempting to setup Failover Clustering using two VMs from within a Vcenter. Each virtual machine resides on a seperate physical host ...
3
votes
1answer
105 views
Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2?
[Cross post from StackOverflow]
Brent Ozar published this webcast (slides, video with free registration) entitled "Real-Life SQL Server 2012: AlwaysOn Lessons Learned", in which he repeatedly states, ...
3
votes
2answers
656 views
Advantages of using PgBouncer vs HAProxy?
Are there any advantages for using one over the other? I'm only looking at options to hide the actual IP address of the master and slave servers from my processes, and not having to restart them if ...
3
votes
1answer
119 views
MySQL licensing
I have looked at a few questions posted in stackoverflow
http://stackoverflow.com/questions/225987/can-someone-explain-mysqls-license-and-what-it-means-to-closed-source-developme
...
3
votes
1answer
331 views
Mirroring partner timeout - Not working the way advertised?
I'm testing a 2 node windows failover cluster with mirroring in high safety mode and automatic failover. My mirror is a standalone server as is the witness. All instances are 2008 R2 RTM Enterprise ...
3
votes
1answer
119 views
Distribute MySQL in different cities?
We have our main MySQL server in city A. We have the bulk of our customer service staff in city B. The staff are complaining that the connection is too slow to the server. The options are:
Have them ...
3
votes
0answers
840 views
Event 4104, MSDTC Client 2
I have an Active/Active Sql 2008 R2 cluster that I monitor with Idera Sql Diagnostic Manager. It just started reporting that one of the instances does not have DTC or Sql Server Agent installed.
I've ...
2
votes
5answers
1k views
Setting up a Redundant Sql Server 2008 Configuration While Retaining High Performance and Minimal Downtime
We have a situation where we are moving to a new hosting facility and are attempting to configure our new database environment. However, none of us are formal DBA's so a lot of what we are doing is ...
2
votes
2answers
1k 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?
2
votes
1answer
188 views
SQL Server cluster questions please
We have SQL Server 2008 R2 cluster active/active/active (a, b, c) and three instances run on this environment.
We did a test on one of the instances, and failover test.
Manual failover from node c ...
2
votes
2answers
820 views
How to sync two MySQL high load tables with 10M rows?
I have two identical MySQL innodb table with 10M rows each. One is used at backend while other at application end. Thus, either of them loaded. I need to synchronize them in a way which is fast and ...
2
votes
2answers
230 views
Can I implement clustering with just 2 servers and one NAS?
I have the following architecture, it consists in only 2 servers, connected to a NAS.
I'm having trouble in implementing clustering because I can't have a domain controller in any of them (if I do ...
2
votes
1answer
70 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
155 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
139 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
445 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
2k views
2
votes
1answer
136 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
2answers
111 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
144 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
209 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
214 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
162 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
130 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
73 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
1answer
150 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
3answers
443 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
390 views
Syncing two (or more) PostgreSQL 9.1 clusters
This question assumes the use of PostgreSQL 9.1.
Say I have two PostgreSQL database clusters. Each cluster contains three PostgreSQL servers. A master, a slave synced via synchronous replication and ...
1
vote
1answer
70 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.
