nixCraft Linux Forum

nixCraft

Linux / UNIX Tech Support Forum

Setting up MySQL replication

This is a discussion on Setting up MySQL replication within the Databases servers forums, part of the Mastering Servers category; Hi, Does anyone have experience setting up a MySQL replication setup? I want information and how to about setting up ...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 30-09-2009, 02:42 PM
Member
User
 
Join Date: Sep 2005
Posts: 30
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 0
charvi
Default Setting up MySQL replication

Hi,

Does anyone have experience setting up a MySQL replication setup? I want information and how to about setting up complete replication of a MySQL server. I've already 6-8 G data within database.
Reply With Quote
  #2 (permalink)  
Old 01-11-2009, 08:34 PM
Junior Member
User
 
Join Date: Oct 2009
OS: Ubuntu/RHEL
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
tjausti is on a distinguished road
Default

MySQL :: MySQL 5.0 Reference Manual :: 16.1.1 How to Set Up Replication

I have used the above guide to make this happen across 3 servers...

note it is an absolute PITA to get started but once its working it is very easy to maintain and recover....

the hardest part for me was getting a solid copy to start from since we are in a 24/7 environment....

very slick once you get it working....

Best of luck
Reply With Quote
  #3 (permalink)  
Old 14-11-2009, 02:42 PM
Junior Member
User
 
Join Date: Nov 2009
OS: Debian
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
eshav is on a distinguished road
Default

hey charvi,

i can help you with mysql replication setup
Reply With Quote
Reply

Tags
mysql , mysql ha , mysql replication , server , server replication


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
MYSQL master-master replication monitor shell script zafar466 Databases servers 4 08-05-2009 11:35 PM
DNS caching setting garora Domain Name Server 1 24-03-2009 08:02 PM
Tutorial: Setting up MySQL quotas for users (MyISAM) Nilesh Databases servers 0 26-01-2008 10:01 PM
mysql replication information myfoot Shell scripting 0 04-12-2007 02:24 AM
Cluster Replication zafar466 Getting started tutorials 0 26-05-2007 08:39 PM


All times are GMT +5.5. The time now is 03:05 AM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2010 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38