The clustering tag has no wiki summary.
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 ...
6
votes
2answers
692 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 ...
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 ...
0
votes
1answer
582 views
Active/Passive to Active/Active
In layman terms, what does it mean to have "Active/Active"? What are the steps to achieve this configuration?
Edit:
We currently have an "Active/Passive" setup which isn't efficiently making use of ...
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.
...
1
vote
1answer
295 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 ...
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 ...
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 ...
3
votes
1answer
147 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?
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 ...
1
vote
1answer
2k 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 ...
2
votes
2answers
824 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 ...
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 ...
1
vote
1answer
145 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 ...
2
votes
1answer
210 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 ...
0
votes
1answer
122 views
memcached service stopped unexpectedly
I am working with
MySQL Cluster 7.2.4
memcached 1.6
I started memcached service with ndb-caching option:
memcached -E /usr/local/mysql/lib/ndb_engine.so -e ...
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
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
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?
1
vote
1answer
87 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 ...
0
votes
1answer
248 views
What are the parameters that are needed to be monitored for MYSQL Cluster
I am new to MySQL cluster. I had installed MySQL cluster successfully with 2 data nodes and 1 Management Node and 1 SQL node.
I want to know where and how exactly the core data is getting stored. ...
3
votes
1answer
283 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
0answers
842 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
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 ...
1
vote
2answers
351 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 ...
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
2k views
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
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 ...
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.
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 ...
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, ...
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 ...
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 ...
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 ...
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
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. ...
1
vote
1answer
77 views
SQL Server DB Restore Clustered to Single Node?
Can you restore a DB from a SQL Server 2005 Clustered Environment (Prod) to a single server (single node) (SQL Server 2005) in Dev/Sys?
Cheers,
Conor
