The clustering tag has no wiki summary.
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 ...
1
vote
1answer
126 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
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 ...
1
vote
1answer
292 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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
1
vote
1answer
75 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
1
vote
0answers
18 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 ...
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 ...
1
vote
0answers
121 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 ...
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 ...
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 ...
0
votes
1answer
579 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 ...
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 ...
0
votes
1answer
96 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
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 ...
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 ...
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
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 ...
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 ...
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. ...
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
0answers
49 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 ...
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 ...
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
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 ...
