We're always looking to better understand our customers and how they use UIM. For this poll, we'd like to better understand what database you've deployed for your instance of UIM. Please select from one of the choices below:
I'm on SQL 2012 with availability groups. I would've gone for 2014 had it been supported at the time.
We're currently debating our database plans for an 8.x upgrade project. Plan is for SQL 2014 (just as the newest supported version at this time...although not sure if 8.4 will add support for 2016 by any chance) and we're debating cluster versus AOAG 2-replica configuration that would allow for offloading of the backups and read-only queries to the second replica while leaving the primary one available for writes.
I'm separately reaching out to CA to get their 'official' response to whether AOAG is supported (not for monitoring but for the actual UIM database) but happened to notice your comment
that you've been using availability groups with SQL 2012 for your UIM database. Have you had any issues with that? Any insights you've gained as we consider whether AOAG would be viable?
It's been perfect for me, no issues at all. Basically it shouldn't matter to the application whether its a "normal" SQL server or AG, and this has been my experience as well. When I do a failover from one node to another, data_engine may complain about inserts for a very short period of a time, likely well under a minute. I'm running my nodes in synchronous commit mode and the secondary node is only a 'cold spare', meaning you can't even read from it. This way you only need to pay licensing for the active node.
That's great to hear Jon. Thanks for the reply!
I also got word back from a CA architect that AOAG should not be an issue and will be supported for 2012 or 2014 (although there admittedly has not been extensive testing done with it on their side).
UIM customers - please provide your feedback to this poll. Thanks!
Windows 2012 R2 + MSSQL 2012
UIM Server: Windows 2008R2DB: Opensuse 13.2 with "mysql Ver 15.1 Distrib 10.0.22-MariaDB, for Linux (x86_64)"
On Oracle 12. Not recommended if you expect things to work as designed.
Retrieving data ...