MIS Systems Thread, Fresh Install Onto New Server - tips/gotchas/guides in Technical; One of my summer jobs (lucky me) is moving FacilityCMIS and ePortal onto a new virtual 2k8R2 server from the ...
15th July 2013, 11:41 AM #1
Fresh Install Onto New Server - tips/gotchas/guides
One of my summer jobs (lucky me) is moving FacilityCMIS and ePortal onto a new virtual 2k8R2 server from the creaking heap of crap that it currently sits on. FirstLine has no guides on installing from scratch, conveniently, and support didn't have any either when I asked...
So: is it just a case of going through as if it's an upgrade? Install SQL Server, configure IIS as per the guide, then install Facility & ePortal and import data from the existing server? As well as copy over various XML files etc.
Any gotchas I should be aware of? Anything in particular I need to test to destruction?
We don't use behaviour, DocStore or SMS, just Facility & ePortal (inc. API). No LEA support. I've done upgrades for the last three years so I'm familiar with that process, but this is the first time I've started from fresh.
16th July 2013, 11:17 AM #2
The SQL has some gotchas on how it should be setup, there certainly used to be a guide on Firstline for how that should be setup as I have seen it before so unless it has been pulled it does exist.
16th July 2013, 11:24 AM #3
Apparently it's been pulled then rubbish! Cue conspiracy theories about it being to push people towards consultancy...
I asked specifically about any requirements with the SQL Server installation and just got told "SQL Server is not one of our products so I don't believe we have a guide for it, however if you have specific issues we can support you with that. Also there is SQL Server help on the Internet in abundance."
Don't suppose you can remember what needs doing with SQL can you?
16th July 2013, 11:30 AM #4
@michael2k6 will probably remember Hopefully he will see this poke I know he actually wrote that document
Thanks to john from:
sonofsanta (16th July 2013)
16th July 2013, 01:12 PM #5
Sounds crap if you pay for support and they can't even tell you how to migrate to a new server!
16th July 2013, 02:13 PM #6
Will need to do this really as well, if there documation that work be great! I'm guessing there not supporting SQL2012 and Server 2012 yet?
16th July 2013, 02:14 PM #7
2008R2 on both counts: Facility suite technical specification March 2013.pdf
Originally Posted by pritchardavid
16th July 2013, 02:45 PM #8
It is a paid for service to re-install the SQL to ensure it is done correctly as if its not it can leave you in a very big mess. The document used to have a very large health warning on it that your support contract would not cover you if SQL was not setup right if it was not the SQL install done by them.
Originally Posted by twin--turbo
16th July 2013, 03:10 PM #9
I wasn't even told that though
Originally Posted by john
16th July 2013, 03:34 PM #10
Ahh, well you can pay (well could when it was Serco) for them to come and re-install your SQL and migrate your Facility DB to your new SQL that has been setup by them and thus no risk of them ever turning round saying you have re-done your SQL wrong thus that is why you have lost all your data. I am sure it has plenty of ££££ in the figure they quote
Originally Posted by sonofsanta
It wasn't that hard or messy tbh mainly common sense just a few things to check they are set right and boxes ticked and that was it, open CMIS, let it make a new DB and then do a full restore of your DB to it then bin the test / fake one you made and all worked well for us.
16th July 2013, 03:45 PM #11
Found the guide on creating a new database in SQL 2005. Brilliant! thinks I.
Sorry! The file does not exist.
There is, at least, a guide on creating a standalone system with SQL Express 2008 - that should be pretty close to the truth, I think...
Last edited by sonofsanta; 16th July 2013 at 03:48 PM.
16th July 2013, 05:04 PM #12
There are a few rules to follow when creating a new database in SQL. It's changed slightly since the last recommended document which John's right in saying I did write. I'm up to speed on the new bits though so I'll if you both PM me your email addresses i'll send you instructions on Thursday when I'm back at work.
I used to be the guy who you'd get migrating if if you paid for consultancy, so I can tell you a few of the bits to watch out for too.
I can also divulge that they do still offer migration as a paid for service. They can do that remotely or on site but there's quite a big price difference. They have a few new guys on support so they may not be up to speed with that yet.
I'll give you a few tips now though so you can get building your boxes -
Once thing to consider which i'll mention now is please, please don't put your database files in a virtual drive on a SAN full of other virtual drives, you'll kill it. Bear in mind it uses tempdb a lot too so make sure that you set the default install path in 2008R2 for data files to go to a non SAN disk. You find that the DB runs better on disks physically attached to the host, but if you've something like an EMC SAN which is running several RAIDS, people tend to put the O/S on a mirrored RAID and the DB on a RAID 5 array. I'd keep them on their own disks if you can though, a RAID 5 attached directly to the host works best. Make sure you're using SAS 10 / 15k too, don't use SATA.
Also bear in mind that tomcat will only use one core, and dataserver will use a core (and a maximum of 2gb RAM each as they're only 32bit services), then if possible have 2 for the O/S too. So 6gb RAM for ePortal box is plenty. If you stick SQL on the same box, try and give it 6 - 8 cores, if you're putting SQL on a different box, give it 4 cores or more. If SQL is on the same box, try and give it 8gb RAM upwards, if it's on a separate one, give ePortal 6gb and SQL 6gb upwards.
Last edited by michael2k6; 16th July 2013 at 05:06 PM.
Thanks to michael2k6 from:
sonofsanta (16th July 2013)
16th July 2013, 05:10 PM #13
Thanks Michael. I'll PM you my email momentarily.
Originally Posted by michael2k6
Storage was going to be on the SAN RAID6 array - I think I have a couple of spare slots on the SAN though so I'll create a new SAS15k RAID1 there - not enough slots for a RAID5. I can't do directly attached storage as HyperV runs in a failover cluster. It'll all run on one virtual server, I was going to go with 4 cores and 8-16GB RAM (dynamic allocation).
16th July 2013, 05:19 PM #14
Sounds OK to me. Bear in mind that during peak assessment times etc you might want to keep an eye on the cores assigned and (I don't know HyperV all that well) potentially assign extra processor to it dynamically? I'd recommend you run nearer to the 16gb mark -the recommended spec is 8cores and 8gb RAM as a minimum - dependant on how many students you have, datasets in the database and staff accessing it, whether you've got Behaviour Management installed and how heavily you use it for assessments - if you're a school with 800 kids and no behaviour management, 4 cores and 8gb will be fine, but if you've got 1600 kids and use all of the above heavily, you might need to assign it more. Obviously if it's on something currently really outdated and poorly spec'd, the only way is up
Thanks to michael2k6 from:
sonofsanta (16th July 2013)
16th July 2013, 05:30 PM #15
1200 kids, no behaviour management at all, just registers & assessments. About 70 staff concurrent on ePortal, half a dozen on FacilityCMIS. 98% of the time the server will run with the 16GB (if it asks for it), I only set the range so that everything can run on one server if needs be but when everything is hunky dory and running across both physical servers, the VMs can stretch their legs.
Current server: Xeon 5050 DP - hyper-threaded dual core @ 3GHz from 2006 with 4GB RAM on x86 Server 2003. With not enough space to install Windows Updates anymore. It was underspec at the time Facility was installed on it (it started out as the SIMS server before the school switched, under a previous NM). The only way is up
By Andie in forum Wireless Networks
Last Post: 9th April 2008, 12:39 PM
By Geoff in forum Thin Client and Virtual Machines
Last Post: 24th May 2007, 09:57 AM
By woody in forum Learning Network Manager
Last Post: 1st February 2007, 12:29 PM
By wesleyw in forum MIS Systems
Last Post: 22nd January 2007, 10:34 AM
By Kyle in forum How do you do....it?
Last Post: 20th January 2006, 10:08 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread