The high-availability tag has no wiki summary.
8
votes
1answer
239 views
What is the modern way to partition PostgreSQL across machines, when the data is “naturally partitionable”
After several years of dwelling into the "NoSQL" space, now I have a problem that is quite "relational" in its nature.
Today I see data stores with quite different eyes than before. Things like Riak ...
7
votes
4answers
2k views
SQL Server equivalent to functionality of Oracle RAC?
I did some Googling and couldn't find an answer to this question more recent than a few years ago, so I thought I'd ask. Oracle's RAC feature offers load-balancing for both read and write ...
6
votes
1answer
189 views
Recovery time effects of AlwaysOn
We did different kinds of basic Tests and AlwaysOn passed in many tests. We finally did a heavy write test for AlwaysOn and it gave surprising results.
The actual Test details are here, the goal is ...
5
votes
2answers
267 views
High Availability for postgresql
I'm new in PostgreSQL database. Recently our developer needed to do some upgrades in our systems.
Because of that we are planning to implement some method in order to implement database failover.
...
5
votes
1answer
461 views
Do schema changes “break” SQL Server 2012 AlwaysOn or are they handled transparently?
My organization is planning to adopt SQL Server 2012 AlwaysOn and I am trying to understand what impact (if any) it will have on our application upgrade process.
We release application updates on an ...
4
votes
1answer
341 views
SQL Server 2012 - Always On
I am in the process of setting up always on high availability clusters for the first time. Can anyone explain to me from the networking perspective after configuring the group and testing to make sure ...
4
votes
1answer
221 views
Mirroring and Availability Groups in SQL2012
I've been looking at the new features of SQL 2012, and how it can help my current situation.
Currently we're on SQL 2008R2, and replicate two OLTP servers' databases to a single reporting server via ...
4
votes
1answer
372 views
Transaction Log Truncation with Copy Only
I have a database backup job set to use full backup with the Copy only option on once daily. The copy only is on because from what I have read that is the only way to backup a database that is ...
3
votes
2answers
156 views
SQL Server replication for off site copy
We have our Primary SQL Servers in-house (15 primary servers at the moment (500 databases approx overall), most of the servers have hex core processors).
These are mirrored to other backup servers in ...
3
votes
1answer
305 views
Robust Mysql failover using free tools
I am looking for a free solution to set up Mysql in an active/passive configuration, in order to provide high-availability. In particular, a Bugzilla installation, and MediaWiki needs to stay alive ...
3
votes
2answers
211 views
Is MySQL Clustering a viable option for a DB expecting 5TB of data in 5 years?
We plan to implement MySQL Clustering.The database should support 5 years of data and expected data/year is 1TB.
When we created a test enviornment with the DB size as 200GB, NDB Cluster took more ...
3
votes
1answer
363 views
AG and SQL Backups
I am using always on in sql 2012 and have an AG setup. I would like to know if i were to backup the primary database and restore it would that be allowed without taking the cluster down etc.
...
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
2answers
313 views
MySQL cluster - how many hosts are needed for full HA?
I need some clarification on MySQL-Cluster (NDB) setup
I want to achieve full HA but I'm low on server budget and can't afford to rent a dozen of servers for simple solution that I'm working on.
...
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
159 views
Which database?
We have to launch a new service in my company with a big database.
And I currently don't have that much knowledge.
We did a small preview of the service and our biggest table had more than 2 100 000 ...
2
votes
1answer
130 views
Is it possible to automate the configuration of dataguard broker?
We deploy a number of oracle databases every year and a good percentage of them require a dataguard configuration.
I've developed a script which is able to perform the database synchronization very ...
2
votes
1answer
223 views
Configured MySQL replication but its not working
I have configured MySQL master and slave replication setup on 5.5.x.
But for some reason data is not getting replicated properly. What might be the reason?
At Master:
/etc/my.cnf
[mysqld]
...
2
votes
1answer
42 views
Optimize UNION query in MYSQL
I have a problem with a UNION query in MySQL. We have 10 millions players on our website and we would like to select players with a multi-criterias system. For exemple, selecting US people, men, > 35 ...
2
votes
0answers
177 views
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled
I have two SQL Server instances in an availability group. They are not mirrored.
I'm trying to connect to the AG using the MS JDBC drivers (4.0) with a connection string including ...
1
vote
1answer
429 views
MySQL Replication and High Availability
I know this might not be a very good question to be asked in this site, but I really need some helps/hints to be directed to the right path.
I want to have failover strategy for 2 MySQL servers which ...
1
vote
2answers
188 views
Oracle symmetrical one-way replication for cheap HA: unfashionable or technically unfeasible?
We have two smallish unrelated databases on two big Oracle Enterprise servers. Instead of buying more licenses and servers for high-availability replicas, can we replicate database B to server A and ...
1
vote
2answers
641 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
1k views
JBoss don't fail over MySQL slave using datasource
I'm trying to set up an high available MySQL cluster, using a Master / Slave configuration. I want to the slave become master (e.g. not read-only but writeable) if the first node come down (like in ...
1
vote
1answer
165 views
SQL Server 2012 AlwaysOn cannot connect using the Listener IP
I have setup a Windows network in an Amazon in a VPC. I have setup two SQL servers and configured Always On. Everything works OK, except that I cannot connect to the SQL Server using the AAG Listener ...
1
vote
1answer
300 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
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
0answers
25 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
22 views
DPM and AlwaysOn - Can they work
How does AlwaysOn tie into DPM for SQL Server 2012? Can we use one or the other for High Availability ? Can they work together or must they be used separately. Thanks
1
vote
0answers
44 views
dropping and adding subscription only picking up new article on some subscribers
I have used the following script to drop aand re-add a table from a subscription so I could move replace the ntext fields with nvarchar(max) columns. the script worked fine, but when I ran the ...
1
vote
0answers
272 views
SQL Server Database Mirroring : strange client application behavior upon failover
I am putting a HA SQL server environment up based on three SQL Server 2008R2 machines and database mirroring.
I'll name them :
principal.company.intra
mirror.company.intra
witness.company.intra
...
1
vote
0answers
21 views
JBoss/Alfresco cannot write on slave after failover [duplicate]
Possible Duplicate:
JBoss don't fail over MySQL slave using datasource
I'm trying to set up an high available MySQL "cluster", using a Master / Slave Replication configuration. I want ...
0
votes
3answers
137 views
How do I enable READ-only (passive) mode in a particular RDBMS?
As most of you have noticed all StackExchange sites have been under maintenance/recovery a few days ago so they switched on READ-only mode. From their blog I know they used to use MS SQL Server 2008, ...
0
votes
1answer
24 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
130 views
AlwaysOn SQL Server setup questions
I just have a few questions regarding the setup of Always On HA, and Clusters. When you setup an AG, and it gets to setting up your IP address for the cluster how can i switch from using DHCP to a ...
0
votes
2answers
79 views
SQL Server sync databases between enterprise - web edition
We have an enterprise version of sql server 2012. we need to synchronize its data to a web edition database. what would be the best option t do this ? further to add on to this we need to provide ...
0
votes
0answers
18 views
Table partionning problem
I need your help for a partionning problem. We are using a "log_event" table which log a lot of events sent by our players (subscription, connection, play, share, etc...). We insert 5,000 row / s in ...
0
votes
0answers
124 views
Oracle Data Guard Fast-Start Failover Questions
Here is the setup in question:
Fast-Start Failover: ENABLED
Threshold: 30 seconds
Target: dbabc
Observer: (none)
Lag Limit: 30 seconds (not in use)
Shutdown Primary: FALSE
...
0
votes
0answers
304 views
JBoss / Alfresco : No operations allowed after connection closed
I'm trying to set up an high available MySQL "cluster", using a Master / Slave Replication configuration.
I want to the slave become master (e.g. not read-only but writeable) if the first node come ...
