A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.

learn more… | top users | synonyms

0
votes
2answers
281 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 ...
3
votes
1answer
200 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 ...
2
votes
1answer
683 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
1answer
1k 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) ...
0
votes
1answer
34 views

Cannot start MySQL Cluster Management Service

Could not determine which nodeid to use for this node. Specify it with --ndb-nodeid= on command line. This is what EventViewer is saying
-1
votes
1answer
67 views

what is the right way to restart a mariadb galera cluster?

I am trying to restart cluster. I have two problems in stopping cluster and starting cluster In stopping cluster, I follow the instruction ...
3
votes
0answers
2k 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
0answers
385 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
131 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
0answers
106 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
0answers
56 views

Prevent SQL Server failback after cluster aware updating

We have SQL Server 2012 in a two-node cluster with Windows Server 2012 (node and disk majority). Neither of the nodes are marked as preferred owner and the "Prevent Failback" option is selected. ...
1
vote
0answers
58 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 ...
1
vote
0answers
129 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 ...
1
vote
0answers
412 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
277 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
0answers
33 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
1k 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
43 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 ...
1
vote
0answers
376 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 ...
1
vote
0answers
364 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 ...
1
vote
0answers
147 views

Error in alter table reorganize partition for MySQL Cluster

My cluster contains 48 million rows and cluster contains 4 storage nodes . After that I add online storage node and executed alter table 'customer_tbl' reorganize partition. Some parameters of ...
1
vote
0answers
43 views

when can AG primary replica be a different host to WFC primary?

To set up an Availability Group with two servers, the servers both participate in a Windows Failover Cluster. I've seen cases after certain failover modes where the primary IP address in the cluster ...
0
votes
0answers
12 views

SQL nodes in MySQL Cluster

I running mysql cluster in windows 8.1 on 3 machines 2 mngmd 2 sql node 3 data nodes in the first machine I tried to connect MySQL server with localhost and tried to put my old database it ...
0
votes
0answers
18 views

Understanding flow control in MariaDB Galera Cluster?

I am not clear how node state changed. What is the different between node state: JOINED, SYNCED, DONOR/DESYNCED, CLOSED, DESTROYED. These are all state I see in log. I am using MariaDB Galera Cluster ...
0
votes
0answers
20 views

Migrate from Percona Cluster to MariaDB Cluster

We are at present running latest version (5.6) of Percona Cluster. Since 5.6 upgrade we are having major stability problems and all minor updates are getting worse. Is there any possibility of ...
0
votes
0answers
98 views

Cassandra cluster on Windows Machine

I am new to Cassandra, and have been trying to create a cluster using DevOps. When I add a node , I get the following error: Error provisioning cluster: Unable to SSH to some of the hosts ...
0
votes
0answers
73 views

Configuring multiple listeners on SQL Server 2012 through High Availability

We have configured two SQL servers on Azure and they are in HA. There are about 10 databases and we wanted to have two critical ones on one dedicated HA group. The listener worked fine until we ...
0
votes
0answers
11 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 ...
0
votes
0answers
131 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 ...
0
votes
0answers
48 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
34 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 ...
0
votes
0answers
171 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 ...
0
votes
0answers
33 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 ...
0
votes
0answers
209 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
0answers
187 views

How to setup a Postgres-xc streaming replication with master-slave(for HA)?

Can you guys please help me about how to make streaming replication with master-slave configuration using Postgres-xc to confirm an HA environment? Thanks
0
votes
0answers
317 views

PostgreSQL: Slave doesn't replicate the Master's data

I'm using PostgreSQL 9.2.3 on both computers, both of which run Win2008R2. I've setup streaming replication by following this guide: ...