Solved

MySQL Database Mirroring

Posted on 2011-09-07
6
301 Views
Last Modified: 2012-08-13
I have several MySQL databases residing on a webserver that I would like to mirror/copy to duplicate databases on our local internal server. We already have a secure tunnel and access to the server but I really need to know how to automate the copying/mirroring of the data.
0
Comment
Question by:whittinga2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 5

Expert Comment

by:Didier Vally
ID: 36495527
0
 

Author Comment

by:whittinga2
ID: 36501163
0
 
LVL 3

Assisted Solution

by:woepwobin
woepwobin earned 250 total points
ID: 36501626
Set up mysql database replication: http://dev.mysql.com/doc/refman/5.0/en/replication.html.

Follow the steps on http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html, 5.1.1.1 through 5.1.1.5, and then 5.1.1.10.
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 
LVL 6

Accepted Solution

by:
mohansahu earned 250 total points
ID: 36501870
Hi,

Plz check the check the below link for to Set Up Database Replication In MySQL  in detail.

http://www.howtoforge.com/mysql_database_replication

MS
0
 

Author Closing Comment

by:whittinga2
ID: 36501916
Thank you to you both. I have read both of these documents previously and I was hoping for something a little easier. Appreciate your help.
0
 
LVL 3

Expert Comment

by:woepwobin
ID: 36501938
If you need any help with the individual steps just ask.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question