Hopefully this post won't be too long
I've been in data processing for a number of years running on a windows system, and working with perl and MySQL to get the job done.
I'm now part of a team who have bought a company and have been asked to investigate how we setup a new Data Processing Department in the new business.
After reading a few bits, I like the sound of LAMP (Linux, Apache, MySQL and PHP), as we will be integrating heavily into web interfaces for data capture, etc. We will also be dealing with graphics libraries for variable printing services.
My Questions:
1. Does LAMP seem like a good solution? if not what might a better alternative be in terms a software suite?
2. I'm drawn towards SUSE linux, is there any reason why a different 'flavour' might be better?
3. I'm Looking at a mirrored server setup so as to avoid down time when installing new software, maintenance, etc. - Is this a waste of time?
4. I could do with a good up to date spec on server hardware - this isn't a big company and so the ceiling for 1 server box will be about £2000 (sterling).
5. Any other tips on putting this together from scratch?
P.S I'm only just now learning UNIX
Cheers