Here's what's worked well for us the last few years: Load Balanced (Big IP) Mid Tier servers (Windows/Apache/Tomcat) Load Balanced AR Server (Windows) in a Server Group configuration Clustered Database servers (Windows active/passive cluster) RAID 10 SAN for database files
This works really well. Obviously you'll pay a price for RAID 10 on a SAN. Hopefully you already have a SAN you can hop onto. The database servers don't scale out in SQL Server since it's strictly active/passive with Windows clustering, so get big boxes. You can scale out easily at the AR Server and Mid Tier layers by just adding more boxes. The only BMC costs would be additional AR Server licenses. All other ARS licenses can be shared within a server group. Chad Hall (501) 342-2650 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Craig Carter Sent: Tuesday, December 16, 2008 3:51 PM To: [email protected] Subject: Q: Cluster/Failover/Load Balancer Recommendations I'm looking for some feedback from real users who have configured real systems that work! We're looking to upgrade our current architecture for redundancy and to support increased load. I've read/heard DSO is not the answer. I'm headed to the BMC site now for whatever I can find but would like to solicit input from anyone with similar configurations: SQL Server 2005/2008 Windows Server 2003/2008 ARS v7.0.1/v7.1 What we are looking for is a setup where we have at least two database servers that are either clustered or load balanced with perhaps the database stored on a separate large RAID device. Primary motivation is to prevent downtime but also would like to ensure performance is maximized. Additionally, what are the ARS license ramifications to the different options? Any input is appreciated. Regards, //SIGNED// Craig Carter Software Engineer, RSP ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" *************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. **************************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
