Multi user or NAS question (1 Viewer)

kingdoz

Registered User.
Local time
Today, 04:42
Joined
Dec 2, 2008
Messages
29
Hi all,
Recently we have had a second user, so I put the database as a whole on a mapped drive on sbs 2011. Of course the first power cut crash and the database got corrupted so yes, splitting FO and BE now. I just kept together for ease of changes and edits but I will keep it split from now on as learned my lesson. I have Only 2 users and Data is around 50mb so not a big deal to give seperate front ends.

My main questions is, would a basic cheap NAS for around £200 with one enclosed and a 512gb ssd drive be suitable to host the backend access database or is it best to leave on the old sbs server? Or perhaps a seperate drive attached to the usb of the server? Unfortunately our server is so old it can sometimes run real slow, it’s only still in use as it does the dns and for Remote Desktop access, so I would prefer to run the back end database on a newer device with faster drive perhaps on ssd drive on a Nas of some sort as we have a very fast cat 7 network here?
many thanks
 

Minty

AWF VIP
Local time
Today, 04:42
Joined
Jul 26, 2013
Messages
10,380
Provided you NAS box is configured as a "dumb" file server it should work fine.
Just avoid using it's advanced "helpful file sharing" apps if it has any inbuilt, as they can cause issues.

More NAS related discussions here
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Yesterday, 22:42
Joined
Feb 28, 2001
Messages
27,383
The U.S. Navy provided several NAS drives to the office where I worked. As long as the NAS drives are configured to be indistinguishable from mapped network drives, you are good. If they are configured to act like Cloud drives, don't go there. The answer is NO - because of the protocols used by "vanilla" network drives vs. Cloud drives. They ARE different.
 

amorosik

Member
Local time
Today, 05:42
Joined
Apr 18, 2020
Messages
397
Hi all,
Recently we have had a second user, so I put the database as a whole on a mapped drive on sbs 2011. Of course the first power cut crash and the database got corrupted so yes, splitting FO and BE now. I just kept together for ease of changes and edits but I will keep it split from now on as learned my lesson. I have Only 2 users and Data is around 50mb so not a big deal to give seperate front ends.

My main questions is, would a basic cheap NAS for around £200 with one enclosed and a 512gb ssd drive be suitable to host the backend access database or is it best to leave on the old sbs server? Or perhaps a seperate drive attached to the usb of the server? Unfortunately our server is so old it can sometimes run real slow, it’s only still in use as it does the dns and for Remote Desktop access, so I would prefer to run the back end database on a newer device with faster drive perhaps on ssd drive on a Nas of some sort as we have a very fast cat 7 network here?
many thanks

With DS220+ and a few megabyte of additional ram, you can installa virtual machine (also Windows) on a nas
If you install a Windows operating system on voirtual machine, you have a machine that can maintain your db
But the above is not the solution to your problem
THE way is to change from file-share to client-server system, then user interface on workstation and a db server on a separate system in lan (Microsoft Sql Server, Oracle, Ibm Db2, MySql, Postgresql, ecc..)
 

DickyP

Member
Local time
Today, 04:42
Joined
Apr 2, 2024
Messages
82
Pat Hartman said:
Not really easier to change anything that isn't trivial when your app isn't split.
Actually this is a good thing! It forces you to have a proper documented, tested release process with proper change control in place.

amorosik said:
separate system in lan (Microsoft Sql Server, Oracle, Ibm Db2, MySql, Postgresql, ecc..)

From the sound of Kingdoz's problem MySQL is probably the best bet unless his organization has other systems in use. It is probably the simplest, cheapest and easiest route: however, this advice is based on incomplete information and may be wrong/irrelevant/inappropriate. I installed and run it on my NAS and it was simplicity itself.
 
Last edited:

Users who are viewing this thread

Top Bottom