Jump to content

Small business - Shared storage & database

My family owns a small office based business and I'm the most tech savvy of us all.  They want me to setup something where they can all access the same customer information from their customer database and make changes and see other people's changes in real time.  I have almost zero knowledge about networking, so what should I be looking at to accomplish this?

CPU: i7 6850K RAM: 64GB 3200Mhz Mobo: EVGA Micro2 PSU: EVGA P2 850W GPU: EVGA 1080 Ti FE

Case: Fractal Design Node 804 Cooler: NH-D15S

 

Storage: Samsung 850 Pro 256GBSandisk Ultra II 960GB

 

OS: Windows 10 | Display: LG 34UM94 & Asus PG279Q

 

Link to comment
https://linustechtips.com/topic/24751-small-business-shared-storage-database/
Share on other sites

Link to post
Share on other sites

Depends on how the information is stored, personally i would setup a MySQL database and whip up a quick php site to view the data.

There are other ways to do this as well.

Something wrong with your connection ?

Run the damn cable :)

Link to post
Share on other sites

Depends on how the information is stored, personally i would setup a MySQL database and whip up a quick php site to view the data.

There are other ways to do this as well.

Yeah... I have no idea what any of that means. :c

CPU: i7 6850K RAM: 64GB 3200Mhz Mobo: EVGA Micro2 PSU: EVGA P2 850W GPU: EVGA 1080 Ti FE

Case: Fractal Design Node 804 Cooler: NH-D15S

 

Storage: Samsung 850 Pro 256GBSandisk Ultra II 960GB

 

OS: Windows 10 | Display: LG 34UM94 & Asus PG279Q

 

Link to post
Share on other sites

How are they editing the customer data? a program, spreadsheets?

 

Have a look at the Synology products I highly recommend them and have one personally. I praised it enough I got my mate to switch from a QNAP and we bought 2 Synology NAS' that we ship all over the place for work.

 

If its a program and each PC is using a central datasource you might be able to just map a location on a NAS, dump the datasource there and point the program there and your laughing. You may need to deal with the program company and they can help you collate your data :)

 

Hopefully that give you some direction but if its a small operation it shouldn't be too difficult.

 

Cheers,

DeeG

Link to post
Share on other sites

How are they editing the customer data? a program, spreadsheets?

 

Have a look at the Synology products I highly recommend them and have one personally. I praised it enough I got my mate to switch from a QNAP and we bought 2 Synology NAS' that we ship all over the place for work.

 

If its a program and each PC is using a central datasource you might be able to just map a location on a NAS, dump the datasource there and point the program there and your laughing. You may need to deal with the program company and they can help you collate your data :)

 

Hopefully that give you some direction but if its a small operation it shouldn't be too difficult.

 

Cheers,

DeeG

That would be a simple and good solution for a small company.

Current build: Antec P180, Asus P8Z68 Pro, Intel i5-2500k, Asus GTX 570 2GB, Patriot 16GB 1600MHz, Corsair HX 650W.

New build: http://linustechtips.com/main/topic/11270-video-editing-workstation-build/

Link to post
Share on other sites

If it is mostly just storage you are looking for then why dont you just have a 4 bay nas with some reliable hdd in it I suggest wd red 3tb drives and then hook the nas up to a gigabit switch and just run it all to the pc's that it is needed from

XYPHER AMD FX8350 @ 4.6Ghz ASUS SABERTOOTH 990FX R2.0 AMD RADEON HD 7970 @ 1140Mhz 16GB Corsair VENGEANCE 1600Mhz OCZ VERTEX 3 240GB SSD Corsair H100i 1TB SEAGATE BARRACUDA FRACTAL DESIGN DEFINE R4 CORSAIR K90 MADCATZ RAT 3 iiyama ProLite B2480HS 24"

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×