I'm currently working on an AutoStore warehouse system and I've received some answers from the vendor regarding high availability (HA) and hardware requirements. I want to ensure that I'm on the right track with my approach. Based on the vendor's feedback, I understand that we need to set up several servers including SQL Server, application servers, and a backup server, but I'm looking for some advice on our HA strategy. I'm considering using multiple physical hosts with virtual machine-level HA to avoid relying on a single point of failure. Also, I'm trying to determine what level of performance I should aim for regarding CPU, RAM, and storage. Any suggestions would be greatly appreciated!
2 Answers
It looks like you're off to a solid start! For your SQL HA, definitely consider using an availability group. You might need to invest a bit in licensing, but it could save you a lot of headaches later. Also, make sure to work closely with a hardware vendor for proper specs; your company requires 24/7 uptime, and it's essential everything is configured correctly to support that. A recommendation: use at least 25G NICs and team them across two physical NICs per host. This would ensure solid performance and reliability.
Glad to see you're taking the initiative here! Just a heads-up regarding the HA comments from your vendor: make sure you're clear on how they handle TCP session interruptions during failovers. It's a known risk and could freeze AutoStore if not handled correctly. Testing your setup is crucial, so simulate some failovers if you can. Also, don’t overlook the need for regular updates on your servers; you'll want to keep everything secure and functioning well.
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures