Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2008, 10:47 PM
toprak toprak is offline
 
Join Date: Dec 2006
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Backup system: I'm sick of this help

Guys My forum post database is freezes every 15 20 days. Optimize - repair database do their job but suddenly some day it stops and I have to use the backup to bring everything back. I'm looking for a backup software for centos 4.6. with cpanel. Cpanel has a backup system but
I would like to take a backup at 6:00am. cpanel doesn't have the timing any ideas... I'm tallking about 2gb database 100000 users 1.1 gb post database thanks..
Reply With Quote
  #2  
Old 01-28-2008, 11:56 PM
nexialys
Guest
 
Posts: n/a
Default

instead of paying for a software, i would suggest to evaluate a new host with a better service...
Reply With Quote
  #3  
Old 01-29-2008, 12:37 AM
toprak toprak is offline
 
Join Date: Dec 2006
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Him dedicated server own by me.. There is no host..I don't want to pay for software. I just don't know linux. There should be a way to backup we just don't know..
Reply With Quote
  #4  
Old 01-29-2008, 01:16 AM
Kaelon's Avatar
Kaelon Kaelon is offline
 
Join Date: Jan 2002
Posts: 405
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by toprak View Post
Him dedicated server own by me.. There is no host..I don't want to pay for software. I just don't know linux. There should be a way to backup we just don't know..
We had a single dedicated server for years, with a database that is over 4 gigs in size (2.5 gig post table), and there was never any problem. If you're having problems, I suggest that it isa processor/memory issue which should be rectified. Ensure that your dedicated server has at least 2 Gigs of RAM, preferrably 4 Gigs; look into making sure that your processor is multi-core or dual-unit. Such a configuration can comfortably hold up to 1500 concurrent users, provided your MySQL is configured properly, without any serious risk of error.

You should also ensure that your PHP, MySQL, and Apache versions are up to date. Unfortunately, if you're not an experienced Linux administrator, these can be daunting tasks. Get a Linux administrator - even if it's just on a per-instance, or per-contract basis - to upgrade your OS, Apache, PHP, and MySQL. These can all serve as bottle-necks and error-producers.

Eventually, there will come a time when no matter how much you optimize your system, you will need to expand to have multiple servers to handle a single forum. Usually, a 2-forum system supports up to 3,000 concurrent connections fairly comfortably, but it all depends on the server architecture and configuration. Many admins prefer having 3-4 servers on any forum that has more than 2,000 concurrent connections at peak, and understandably, because at that point, the principal load is no longer on MySQL, but on httpd.
Reply With Quote
  #5  
Old 01-29-2008, 10:42 PM
toprak toprak is offline
 
Join Date: Dec 2006
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

kaelon. you said 2-3 servers. how this think works example: I would like to setup a mysql server to my home with cable internet. Why: Can I have double copy of my database like this ??
I don't care it can run from the main server what i care is i have the same database in my house server so I can fix it up easily and install back to server...and backup 4 times a day

How this 2-3 server thing works can you give me overview please thank you for your smart comments.
Reply With Quote
Reply


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


All times are GMT. The time now is 12:34 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04543 seconds
  • Memory Usage 2,190KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (4)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete