#1  
Old 6th April 2009, 01:52
Check Check is offline
Member
 
Join Date: Feb 2007
Posts: 76
Thanks: 4
Thanked 1 Time in 1 Post
Default Mysql Binary Log?

Hey all,

I'm asking this here because i view this community a little better than others.

1. Is it worth turning on Binary Logs for mysql and take the performance hit? Or would full backups say every 2 or 3 hours be a bad idea?
2. I know this differs for everyone but what is the "standard", or best practice frequency for binary logs.
3. Is this turned on by default with the ispconfig install? I read on http://dev.mysql.com/doc/refman/5.0/en/binary-log.html that mysql has to be started with a specific parameter in order to get the binary logs to work. So is this turned on by default, where do i check, where do i set this?

Basically I'm just looking for your general thoughts and experience as I'm only used to doing full mysqldumps. Currently the db I'm concerned with isn't large at all but obviously over time this will no longer be the case. I don't want to take to much of a performance hit, or have a pain to restore stuff, so in that sense full backups are easier. But at what size db are full backups frequently no longer a good option?


Thanks all.
Reply With Quote
Sponsored Links
  #2  
Old 6th April 2009, 09:45
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,500 Times in 4,329 Posts
Default

As far as know the purpose for binary logs is mainly replication, so I'am not sure if the can be used for backup purposes as well. Falko might be able to tell you more about it.

If you want to have some kind of real time backup all the time you should consider to run a master slave setup (binary logs with a mysql slave server) so you can use the slave as backup for disaster recovery.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 6th April 2009, 14:19
Check Check is offline
Member
 
Join Date: Feb 2007
Posts: 76
Thanks: 4
Thanked 1 Time in 1 Post
Default

Maybe i misunderstood the article, Ill wait to see what Falko says.

The master/slave is where I'm headed, but need to wait until my site is making a little more money. Hopefully i can move to 3.0 then as well...

Thanks till
Reply With Quote
  #4  
Old 6th April 2009, 14:23
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
 
Default

You need the binlog for replication only. But you can use replication to make database backups without interrupting MySQL: http://www.howtoforge.com/back_up_my..._interruptions
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
slow download through webserver problem snewp Technical 14 9th May 2008 05:25
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 09:11
Daily mail logrotation?! schmidse Installation/Configuration 4 21st January 2008 13:55
Outlook does not Authenticates aberrio Server Operation 30 1st November 2007 19:21
No ftp login for ispconfig-webuser agri Installation/Configuration 12 19th March 2007 10:06


All times are GMT +2. The time now is 23:18.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.