01-16-2013 09:41 AM
I just set up a pair of SQL 2012 servers that an AlwaysOn Availability Group to provide redundancy. While I notice that BES 5.0.4 supports SQL 2012, I can find no mention of Availability Groups.
I'd love to migrate our BES databases to the new system to take advantage of their high availability. Can anyone let me know if such a configuration would be supported?
I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700
01-16-2013 09:52 AM
It will be here once supported
Blackberry Enterprise Server compatibility chart
BESAdmin's, please make a signature with your BES environment info.
BES 5.0.4 and BES 10.2.2 with Exchange 2010 and SQL 2008
01-16-2013 10:43 AM
Thanks, that is a handy chart.
However, are you sure AG compatibility will show up there? For instance, the chart makes no mention of whether SQL failover clusters are supported or not. I would guess that it's just taken for granted that they are compatible. I am tempted to make the same assumption about Availability Groups. The fact that there is an AG involved is really pretty transparent to the application connecting to the database.
So, I guess what I'm asking is, are you certain that it would ever show up there? Or can I just assume it's supported until told otherwise? Is it even on RIM's radar to test?
01-22-2013 04:49 PM
I tested this out by making our BESMgmt database part of an Availability Group and performing a failover. Unfortunately, the failover is not seamless. The BES Admin Service site stops working, saying it lost its connection to the database. The issue can be resolved by restarting the "BlackBerry Administration Service – Application Server" service. After doing so (and waiting a minute or two), the site works again even with the db being run by the secondary SQL server.
At least we'll be able to restore functionality quickly if the primary SQL server fails.
I will try to look for some sort of SQL timeout setting for BES - perhaps a longer timeout would be enough to trick BES into thinking everything is still fine after a failover (which takes about three seconds). Or even better, RIM will soon provide an update that specifically supports Availability Groups!