The high-availability tag has no wiki summary.
2
votes
1answer
34 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
173 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
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
43 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
271 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
...
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
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
123 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 ...