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.




148 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
3567 posts

Uber Geek
+1 received by user: 387

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




148 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

 
 
 
 


3567 posts

Uber Geek
+1 received by user: 387

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


1775 posts

Uber Geek
+1 received by user: 253

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


2796 posts

Uber Geek
+1 received by user: 229


  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.





3373 posts

Uber Geek
+1 received by user: 385

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.







148 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!

2796 posts

Uber Geek
+1 received by user: 229


  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.




3373 posts

Uber Geek
+1 received by user: 385

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? 







148 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 »

Propel launch Disney Star Wars Laser Battle Drones
Posted 19-Nov-2017 21:26


UFB killer app: Speed
Posted 17-Nov-2017 17:01


The case for RSS — MacSparky
Posted 13-Nov-2017 14:35


WordPress and Indieweb: Take control of your online presence — 6:30 GridAKL Nov 30
Posted 11-Nov-2017 13:43


Chorus reveals technology upgrade for schools, students
Posted 10-Nov-2017 10:28


Vodafone says Internet of Things (IoT) crucial for digital transformation
Posted 10-Nov-2017 10:06


Police and Facebook launch AMBER Alerts system in NZ
Posted 9-Nov-2017 10:49


Amazon debuts Fire TV Stick Basic Edition in over 100 new countries
Posted 8-Nov-2017 05:34


Vodafone VoIP transition to start this month
Posted 7-Nov-2017 12:33


Spark enhances IoT network capability
Posted 7-Nov-2017 11:33


Vocus NZ sale and broadband competition
Posted 6-Nov-2017 14:36


Hawaiki reaches key milestone in landmark deep-sea fibre project
Posted 4-Nov-2017 13:53


Countdown launches new proximity online shopping app
Posted 4-Nov-2017 13:50


Nokia 3310 to be available through Spark New Zealand
Posted 4-Nov-2017 13:31


Nest launches in New Zealand
Posted 4-Nov-2017 12:31



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.