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

Reply
Page 2 of 3 1 2 3
 
Thread Tools Display Modes
  #11  
Old 07-11-2008, 12:23 AM
Mars12343 Mars12343 is offline
 
Join Date: Feb 2008
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Anyone have an answer for me?
Reply With Quote
  #12  
Old 07-11-2008, 12:31 AM
R1lover's Avatar
R1lover R1lover is offline
 
Join Date: Apr 2006
Location: Northern Ca
Posts: 428
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Mars12343 View Post
Anyone have an answer for me?
Yes we both posted the info above, you will need to be able to read the links in order to see.
Reply With Quote
  #13  
Old 07-12-2008, 05:48 AM
Mars12343 Mars12343 is offline
 
Join Date: Feb 2008
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I did read it and i didnt see an answer in there...

And with the built in slave function is that the same as mysql replication just built into vb?
Reply With Quote
  #14  
Old 07-12-2008, 05:51 AM
R1lover's Avatar
R1lover R1lover is offline
 
Join Date: Apr 2006
Location: Northern Ca
Posts: 428
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
The answer is this...

You can use replication in mysql, mysql is the database software. In order to do what you are asking that is the answer, you need to learn about mysql and use the replication feature of it. The link above gives you a full how too on it.

--------------- Added [DATE]1215845564[/DATE] at [TIME]1215845564[/TIME] ---------------

Here are the links again in case you missed it.

18.1.1. How to Set Up Replication

[+/-]

18.1.1.1. Creating a User for Replication
18.1.1.2. Setting the Replication Master Configuration
18.1.1.3. Setting the Replication Slave Configuration
18.1.1.4. Obtaining the Master Replication Information
18.1.1.5. Creating a Data Snapshot Using mysqldump
18.1.1.6. Creating a Data Snapshot Using Raw Data Files
18.1.1.7. Setting Up Replication with New Master and Slaves
18.1.1.8. Setting Up Replication with Existing Data
18.1.1.9. Introducing Additional Slaves to an Existing Replication Environment
18.1.1.10. Setting the Master Configuration on the Slave
Reply With Quote
  #15  
Old 07-14-2008, 06:28 AM
Mars12343 Mars12343 is offline
 
Join Date: Feb 2008
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I was referring to the slave database option in the config.php is it basically the same thing as a mysql replication?
Reply With Quote
  #16  
Old 07-14-2008, 06:53 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
You need to setup MySQL replication (or rather, have synchronised MySQL servers), to use the slave database function.
Reply With Quote
  #17  
Old 07-14-2008, 05:29 PM
Mars12343 Mars12343 is offline
 
Join Date: Feb 2008
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
So i just turn my forum offline do a sql dump import it to the new server and add the slave db info to my config.php then turn my forum back on and im done?
Reply With Quote
  #18  
Old 07-14-2008, 05:57 PM
R1lover's Avatar
R1lover R1lover is offline
 
Join Date: Apr 2006
Location: Northern Ca
Posts: 428
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It seems you are in way over your head with this idea, I would recommend you hiring someone to take care of this for you.
Reply With Quote
  #19  
Old 07-14-2008, 09:54 PM
Mars12343 Mars12343 is offline
 
Join Date: Feb 2008
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Mars12343 View Post
So i just turn my forum offline do a sql dump import it to the new server and add the slave db info to my config.php then turn my forum back on and im done?
Anyone?
Reply With Quote
  #20  
Old 07-15-2008, 09:38 AM
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Location: Melbourne, Australia
Posts: 15,047
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
No, you cannot simply do that - your data will eventually be out-of-date.
Reply With Quote
Reply
Page 2 of 3 1 2 3

« Previous Thread | Next Thread »

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 01:36 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08013 seconds
  • Memory Usage 2,251KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete