The clustering tag has no wiki summary.
0
votes
0answers
14 views
PowerPivot doesn't install in SharePoint mode on an Active/Passive Cluster
We a provisioning a new SQL Failover Cluster. We have successfully configured the SQL instance, and have moved on to configuration of the PowerPivot for SharePoint instance. We run the configuration ...
0
votes
1answer
16 views
Oracle DB 11gR2 netca installation failing
I am getting below error when I run netca from command line
cmd: /u01/app/oracle/product/11.2.0/db_1/bin/netca /silent /responsefile=/oracle_binaries/database/response/netca.rsp
[main] [ 2013-05-17 ...
0
votes
1answer
24 views
How to install and configure Postgres-XC in windows?
Can anybody suggest me any resources of the complete installation procedure of postgres-XC in windows. I've installed postgresql-9.2 in my windows and can use it. Now I need to know the installation ...
0
votes
1answer
23 views
Should we always prefer clustering over a master-slave configuration if the goal is high-availability?
Given: I have two virtual machines on a SAN that I can use to host RavenDB.
Question: If my goal is high-availability, then should I always prefer clustering over a master-slave configuration?
From ...
3
votes
1answer
48 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 ...
0
votes
0answers
48 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: ...
0
votes
0answers
17 views
Can i use XAMMP mysql server with Percona Xtradb cluster?
I just wanted to know if I can use a normal MySQL server (XAMPP) as part of the cluster on my EC2 Server running Percona XtraDB Cluster.
Can I just change the my.cnf config file on XAMPP with the ...
0
votes
0answers
21 views
ERROR while doing coalesce partition Mysql Cluster
My table contains 3299000 rows. My Mysql Cluster contains 2 storage nodes with NoOfReplicas=2. By default it contains 2 partitions and after that i added 3 partitions more one by one using command ...
1
vote
1answer
44 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 ...
0
votes
1answer
37 views
Redo Logs Mysql Cluster
The mysql cluster has 4 directories namely D8 D9 D10 D11 for redo logfiles.
But while inserting into table only one redo directory is used.
I ran following command to get redo information "all dump ...
3
votes
1answer
94 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 ...
1
vote
0answers
23 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 ...
0
votes
0answers
24 views
After optimize table statement my data usage increased Mysql Cluster
I deleted 500000 rows in my mysql cluster table having 12468000 rows and then i tried to OPTIMIZE TABLE so that all the freed up data memory can be used by another table also, but after optimizing ...
0
votes
0answers
18 views
Re-use disk data extents after delete Mysql Cluster
In my mysql cluster i have 1 million rows and my disk data tables are using all the disk usage available to them ;i.e; free extents are 0 . Now i deleted 50K rows from ap_perf_tbl but still it show ...
0
votes
0answers
20 views
Why data usage increases when deleting rows Mysql Cluster?
My mysql cluster data nodes data usage increased to 95%. Then i tried to delete 500000 rows and my data usage of nodes started increasing initially and reached to 99% and above and TABLE FULL error is ...
0
votes
0answers
53 views
Cannot start SQL Server service on SQL Server cluster
I have a SQL Server 2008 cluster with 2 nodes. I rebooted both machines and now I CANNOT start the SQL Server service from:
Node1 or
Node2 or
ClusterSQL (the cluster SQL Server)
I am getting an ...
1
vote
1answer
53 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 ...
2
votes
1answer
182 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 ...
0
votes
1answer
63 views
SQL Server weird issue with indexes and query planner
We had a bunch of crashes and restorations a few days ago and following those, the SQL Server DB has been acting strangely. We know that there were some issues with the failover clusters due to which ...
4
votes
2answers
350 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 ...
0
votes
2answers
67 views
Multiple database servers for performance vs failover
If I have two database servers, and I am looking for maximum performance vs high-availability, what configuration would be best?
Assuming the architecture is two load-balanced web/app servers in ...
0
votes
1answer
88 views
Load balancing after clustering is failed in SQL Server cluster
This is what I have been asked today on my interview for a SQL Server DBA position:
It is an active - active cluster configuration. The primary node is in NY and the other node is in Rio. The NY ...
1
vote
0answers
120 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) ...
1
vote
1answer
87 views
Set up AlwaysOn in virtual environment: How to add nodes to domain? [closed]
On a beefy server, I have a few Virtual Machines (VMs) running. On one of those, I have Domain Controller (DC) with a domain name (ex:SQL.AD.COM) running successfully. Now, I need to add the other VMs ...
3
votes
1answer
103 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, ...
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 ...
4
votes
1answer
118 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 ...
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 ...
1
vote
1answer
125 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?
2
votes
1answer
154 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 ...
4
votes
1answer
221 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 ...
1
vote
0answers
31 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 ...
1
vote
1answer
149 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.
3
votes
2answers
650 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 ...
6
votes
1answer
244 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 ...
0
votes
1answer
95 views
What are the naming rules for named instances on a cluster?
I am planning to install two SQL Server 2008 instances on an active/passive cluster. Each instance is supporting the same application, but the DBs will be supporting specific geographic locations. I'd ...
0
votes
0answers
365 views
Which is more scalable, Oracle RAC or MySQL Cluster? [closed]
I'm looking for information about both products and your experience would be a big help. I'm aware that Oracle RAC and MySQL Cluster uses different architecture and that Oracle RAC has single point of ...
3
votes
1answer
118 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
...
1
vote
1answer
82 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 ...
0
votes
1answer
440 views
How many IP numbers are there for a SQL server active active cluster setup also a active passive setup?
How many IP numbers are required for a SQL server active/ active cluster setup also what in the case of an active/ passive setup?
Correct me if I am wrong
2 for private network
2 for public network ...
1
vote
2answers
625 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 ...
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
2answers
110 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 ...
4
votes
1answer
803 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 ...
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 ...
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
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
1answer
207 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 ...
1
vote
1answer
299 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 ...
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 ...
