Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


154 posts

Master Geek
+1 received by user: 8

Subscriber

Topic # 84758 7-Jun-2011 20:47
Send private message

I have been asked by my boss to setup a backup system for the computers at work. There are 2 P.O.S machines and the bosses office machine. 1 of the P.O.S machines runs the MYSQL database needed for the P.O.S.

My plan is to get another machine in with 2 drives in raid 1, put in the back office running as a headless server. Move the MYSQL database to it and have all the machines backup important data like Emails, documents etc (Daily?). Then really important data is then backed up offsite with CrashPlan (weekly?).

Anything else that you guys think I should do? Or anything that you would change?

Thanks

Create new topic
3935 posts

Uber Geek
+1 received by user: 493

Trusted

  Reply # 478737 7-Jun-2011 21:15
Send private message

Why not just implement a tape based system with tape offsiting? Sounds old school but still used.

Either that or look at something like Acronis Server to a central computer, but you still have the issue of offsiting.




Previously known as psycik

NextPVR/OpenHAB: 
Gigabyte AMD A8 Brix --> Samsung LA46A650D via HDMI, NextPVR,OpenHAB with Aeotech ZWave Controller
Media:Chromecast v2, ATV4, Roku3, Raspberry PI temperature Sensors and Bluetooth LE Sensors,HDHomeRun Dual
Windows 2012 
Host (Plex Server/Crashplan): 2x2TB, 2x3TB, 1x4TB using DriveBender, Samsung 850 evo 512 GB SSD, Hyper-V Server with 1xW10, 1xW2k8, 2xUbuntu 16.04 LTS, Crashplan, NextPVR channel for Plex,NextPVR Metadata Agent and Scanner for Plex




154 posts

Master Geek
+1 received by user: 8

Subscriber

  Reply # 478739 7-Jun-2011 21:21
Send private message

Cost is an issue and I don't want to make things complicated with Windows server. I was just going to use XP

3935 posts

Uber Geek
+1 received by user: 493

Trusted

  Reply # 478741 7-Jun-2011 21:24
Send private message

Then why not just look at a total cloud solution? How much data (once the initial is done) are you talking?




Previously known as psycik

NextPVR/OpenHAB: 
Gigabyte AMD A8 Brix --> Samsung LA46A650D via HDMI, NextPVR,OpenHAB with Aeotech ZWave Controller
Media:Chromecast v2, ATV4, Roku3, Raspberry PI temperature Sensors and Bluetooth LE Sensors,HDHomeRun Dual
Windows 2012 
Host (Plex Server/Crashplan): 2x2TB, 2x3TB, 1x4TB using DriveBender, Samsung 850 evo 512 GB SSD, Hyper-V Server with 1xW10, 1xW2k8, 2xUbuntu 16.04 LTS, Crashplan, NextPVR channel for Plex,NextPVR Metadata Agent and Scanner for Plex


1974 posts

Uber Geek
+1 received by user: 317

Lifetime subscriber

  Reply # 478744 7-Jun-2011 21:27
Send private message

Replicate the mysql to a SLAVE database. Use a linux flavor of your choice. Use rsync to copy any samba shares. Should work fine over an adsl connection. All up a dual core Atom would be $250 (mini-iTX and ram with case and PSU) + cost of two hard drives. About $350 + GST total.




Ross

 

Spark FibreMAX using Mikrotik CCR1009-8G-1S-1S+

 


Speed Test


2930 posts

Uber Geek
+1 received by user: 277


  Reply # 478784 7-Jun-2011 22:46
Send private message

This is how I would do it:

Purchase ShadowProtect Desktop Edition for the 3 workstations.
This should be around $125 +gst each.
Get your headless machine as you were going to do but I wouldn't worry about two HDDs in RAID1.
This machine wouldn't need to be very powerful at all, just needs to have a big enough hard drive to take the backups from the workstations.
I would also leave all your data as it is now so don't bother moving the SQL database if it is working fine now.
Get 3 portable USB HDDs for offsite backups, again big enough to hold the backups from the workstations.

Setup ShadowProtect on each of the 3 workstations to backup over the network to the headless machine.
ShadowProtect comes with a free version of a program, ImageManager, that can then be setup, on the headless machine, to mirror the workstation backups to the USB drives.

ShadowProtect does full image backups of the entire hard drive so all data, including SQL databases, and operating system are backed up. You can set it to backup regularly, as often as every 15 minutes if you like, and there are a few different ways of backing up. EG: A full backup once a week, say on a Sunday, then incremental backups during the week (as often as you like). It can then be set to keep a weeks backup set (Full backup and appropriate incrementals for the week) for as long you want, before it starts overwriting them, so that your backup drive doesn't get full.
And now because you are only doing incremental backups during the day/week the backups only take a few seconds normally and doesn't affect the use of the machine as it happens in the background.

On the headless machine, as soon as a backup is completed from a workstation, ImageManager will see the new backup file, verify it and then copy it to the currently attached USB drive automatically. It also monitors the USB drive so if you remove one and connect another one it will see that it doesn't have all the backup files and automatically update it with all the backup files that are missing from it.
You use the 3 USB HDDs in rotation so there is always one offsite, one connected to the headless machine and one in transit.

This backup solution works well because the backups are full system images so if one of the workstations dies you can do a full system restore to a new box (shadowprotect includes hardware independant restore) and be up and running again quickly. You can also browse the backup files to restore individual files or folders.
You also have a full backup set on a portable HDD to take offsite.





3395 posts

Uber Geek
+1 received by user: 397

Trusted

  Reply # 478787 7-Jun-2011 22:52
Send private message

TBH I would look to a cloud provider for your database and get redundancy in your internet connections (e.g. DSL + 2degrees USB dongle). Your own MySQL setup isn't going to beat them in terms of availability.







154 posts

Master Geek
+1 received by user: 8

Subscriber

  Reply # 478798 7-Jun-2011 23:27
Send private message

Unfortunately DSL is not fast enough for an offsite database due to the way program was designed. The boss wants a set and forget setup where he is not having to cart round disks and such, but looking at shadow protect it looks alot nicer than acronis. Will have to do some more looking before around.

Thanks for all your input guys!

2930 posts

Uber Geek
+1 received by user: 277


  Reply # 478810 7-Jun-2011 23:54
Send private message

Decal: Unfortunately DSL is not fast enough for an offsite database due to the way program was designed. The boss wants a set and forget setup where he is not having to cart round disks and such, but looking at shadow protect it looks alot nicer than acronis. Will have to do some more looking before around.

Thanks for all your input guys!


If the swapping a portable USB HDD is too much for the boss then ImageManager does have the option of uploading the incremental backup files to an FTP site as well.
You do however need to have ImageManager installed on the FTP server as well to manage the backup files.




3395 posts

Uber Geek
+1 received by user: 397

Trusted

  Reply # 478811 7-Jun-2011 23:57
Send private message

Decal: Unfortunately DSL is not fast enough for an offsite database due to the way program was designed. The boss wants a set and forget setup where he is not having to cart round disks and such, but looking at shadow protect it looks alot nicer than acronis. Will have to do some more looking before around.

Thanks for all your input guys!


Lol how much data gets returned in your queries?! Man sounds pretty odd for a POS database? 







154 posts

Master Geek
+1 received by user: 8

Subscriber

  Reply # 478868 8-Jun-2011 09:52
Send private message

Alot because it is also a customer management system. So when searching for customers and such it drags up photos and random crap attached to their file.

Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Microsoft Dynamics 365 Business Central launches
Posted 10-Jul-2018 10:40


Spark completes first milestone in voice platform upgrade
Posted 10-Jul-2018 09:36


Microsoft ices heated developers
Posted 6-Jul-2018 20:16


PB Technologies charged for its extended warranties and warned for bait advertising
Posted 3-Jul-2018 15:45


Almost 20,000 people claim credits from Spark
Posted 29-Jun-2018 10:40


Cove sells NZ's first insurance policy via chatbot
Posted 25-Jun-2018 10:04


N4L helping TAKA Trust bridge the digital divide for Lower Hutt students
Posted 18-Jun-2018 13:08


Winners Announced for 2018 CIO Awards
Posted 18-Jun-2018 13:03


Logitech Rally sets new standard for USB-connected video conference cameras
Posted 18-Jun-2018 09:27


Russell Stanners steps down as Vodafone NZ CEO
Posted 12-Jun-2018 09:13


Intergen recognised as 2018 Microsoft Country Partner of the Year for New Zealand
Posted 12-Jun-2018 08:00


Finalists Announced For Microsoft NZ Partner Awards
Posted 6-Jun-2018 15:12


Vocus Group and Vodafone announce joint venture to accelerate fibre innovation
Posted 5-Jun-2018 10:52


Kogan.com to launch Kogan Mobile in New Zealand
Posted 4-Jun-2018 14:34


Enable doubles fibre broadband speeds for its most popular wholesale service in Christchurch
Posted 2-Jun-2018 20:07



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.