Results 1 to 15 of 15
Thread: R1Soft Mysql Module Necessary?
-
04-21-2011, 02:16 PM #1WHT Addict
- Join Date
- Jul 2007
- Posts
- 123
R1Soft Mysql Module Necessary?
We're running R1soft without the Mysql Module as our host is telling us it is not necessary. We've got a couple of databases on a dedicated server and was wondering if not having the module might be an issue if we ever need to do a full metal restore or similar ..... any feedback appreciated!
-
04-21-2011, 02:46 PM #2Aspiring Evangelist
- Join Date
- Dec 2006
- Posts
- 398
If you're using MySQL and want the ability to restore databases then it is necessary. It ensures that the MySQL data is in a consistent, restorable state. Otherwise, you could end up with corruption when you attempt to restore.
-
04-21-2011, 02:47 PM #3WHT Addict
- Join Date
- Jul 2007
- Posts
- 123
Hmmmmm..... will touch base with host and ask why they're telling us it is not necessary ....
-
04-21-2011, 03:25 PM #4Web Hosting Master
- Join Date
- Nov 2006
- Location
- Pune, India
- Posts
- 1,428
See if it is worth the extra cost. It's easier and cheaper to do a mysqldump and automate it using a cron.
█ LeapSwitch Networks Pvt. Ltd. - Managed VPS / Dedicated Servers India
█ CloudJiffy PaaS - Wordpress Cluster Hosting
█ Shared, Reseller, VPS, Dedicated Servers, Colocation
█ AS132335 - India - USA - Germany - Spain - Portugal - Ukraine
-
04-21-2011, 03:30 PM #5WHT Addict
- Join Date
- Jul 2007
- Posts
- 123
We are already doing cron mysqldumps and other backups as well, but our host specifically told us full metal restore was possible without module, which may not be accurate, so we wanted to know ahead of time before we attempt a restore and find out we (may) have gotten unsound advice.
-
04-21-2011, 03:35 PM #6Web Hosting Master
- Join Date
- Nov 2006
- Location
- Pune, India
- Posts
- 1,428
I have personally done many restores (account level, not full) without the module, and it hasn't caused any problems.
From what I have read, if a mysql database is being written to during the R1soft backup, the backup may get corrupted as the database is not locked. So, it is recommended to have the MySQL plugin, but if you just have a couple of databases you can restore the dumps within no time.
Though we use R1Soft, we do not rely on it completely, and use cPanel backups + own mysql dumping scripts, to create backups.█ LeapSwitch Networks Pvt. Ltd. - Managed VPS / Dedicated Servers India
█ CloudJiffy PaaS - Wordpress Cluster Hosting
█ Shared, Reseller, VPS, Dedicated Servers, Colocation
█ AS132335 - India - USA - Germany - Spain - Portugal - Ukraine
-
04-21-2011, 03:51 PM #7Problem Solver
- Join Date
- Mar 2003
- Location
- California USA
- Posts
- 13,681
Your not going to be able to do a innodb restore unless your using innodb_per_file in your mysql config (which will require a dump and reimport of all databases if you try to convert to it).
Steven Ciaburri | Industry's Best Server Management - Rack911.com
Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance
-
04-21-2011, 04:12 PM #8Engineer
- Join Date
- Jan 2005
- Location
- Scotland, UK
- Posts
- 2,681
You can run without the mysql addon, much the same way you take the risk when doing with straight rsyncs on the datadir. Its' not recommended but it should be fine in most cases. There is always the possibility of corruption but in most cases mySQL will repair/rollback just fine , the only one that wouldn't is if you were using myisam compressed tables and were unlucky enough for the database to drop off right at a specific time which is extremely unlikely and so unlikely that it's not really worth considering for most cases.
What you are really paying for is simplicity, being able to restore individual tables, being able to restore to different names/databases, mixing innodb+myisam engines as the agent will essentially restore , start another instance, dump and then import to your main instance. This would normally require time (and does if there are bugs with the addon, which do happen although not so much in newer versions) so if you say it takes you 30-60 minutes for a individual table restore once per year of manual work versus clicking a button at what? $50/year ? You make the choiceServer Management - AdminGeekZ.com
Infrastructure Management, Web Application Performance, mySQL DBA. System Automation.
WordPress/Magento Performance, Apache to Nginx Conversion, Varnish Implimentation, DDoS Protection, Custom Nginx Modules
Check our wordpress varnish plugin. Contact us for quote: sales@admingeekz.com
-
04-21-2011, 05:30 PM #9Randy
- Join Date
- Aug 2006
- Location
- Ashburn VA, San Diego CA
- Posts
- 4,615
You can get away with mysqldumps done at the same frequency as the backup task (but not simultaniously!!). A drawback is that it's more difficult to restore individual tables/db's... no point and click interface, ect.
Fast Serv Networks, LLC | AS29889 | DDOS Protected | Managed Cloud, Streaming, Dedicated Servers, Colo by-the-U
Since 2003 - Ashburn VA + San Diego CA Datacenters
-
12-13-2011, 03:36 PM #10Disabled
- Join Date
- Jun 2005
- Posts
- 3,455
As far as I know its for being able to restore individual databases and tables which leads me to my next question.
Without the module corruption is possible but do you guys talk about the restored database being corrupted or the whole MYSQL server and all databases on it becoming corrupt?
And how would you do a single database restore manually without the module, if you lets say try it regardless of corruption.
I think this points are not clear on this thread.
As for bare metal restore its not needed.
-
12-14-2011, 01:28 AM #11Web Hosting Master
- Join Date
- Mar 2004
- Posts
- 551
The module is unnecessary. If you're using InnoDB, then your backups via mysqldump should be read-consistent. The backup file produced by mysqldump is basically human-readable so you can always manually fix any corruption, though I've never seen it actually occur.
-
12-14-2011, 02:01 AM #12Disabled
- Join Date
- Jun 2005
- Posts
- 3,455
-
12-14-2011, 05:44 AM #13Premium Member
- Join Date
- Dec 2010
- Location
- Schiedam, The Netherlands
- Posts
- 172
I would recommend enabling mysql bin logs, it's the easiest and fastest way to backup the database and allows you to restore right down to the second.
R1Soft makes backups of the bin logs just fine, so the module isn't needed.Snel.com Self-managed hosting provider
Cloud VPS ★ Dedicated Servers ★ Colocation★
██ Send an email to sales@snel.com. Call us at +31 88 3 088 099.
-
12-14-2011, 03:07 PM #14Web Hosting Master
- Join Date
- Jun 2009
- Location
- UK: Oxford
- Posts
- 1,259
Whats wrong with setting up MySQL replication on 2 or more boxes?
The newest versions of MySQL support this functionality now, and pretty awesome for backups, data flow simulation and play-back.█ Garbott Ltd - Exceptional web development, hosting & consultancy services
-
12-15-2011, 05:19 AM #15Disabled
- Join Date
- Nov 2004
- Location
- England
- Posts
- 513
I don't use the R1soft MySQL module - I found mysqldump simpler, faster and more reliable for busier MySQL systems. The backup is placed in the home directory, which is then backed up by the backup run.
Similar Threads
-
PHP/MySQL Analytics Module
By denoxis in forum Programming DiscussionReplies: 1Last Post: 04-16-2010, 01:43 PM -
Hosts with MySQL PDO Module?
By bigdavestar in forum Web HostingReplies: 0Last Post: 09-01-2006, 07:41 AM -
Python mysql module
By sliff2000 in forum Hosting Security and TechnologyReplies: 1Last Post: 11-04-2003, 06:42 AM -
The Perl module DBD::mysql....NEED HELP!
By sir_han in forum Hosting Security and TechnologyReplies: 3Last Post: 08-06-2003, 06:15 PM -
Help installing a Perl / MySQL module
By DSD in forum Hosting Software and Control PanelsReplies: 0Last Post: 02-16-2003, 07:16 PM