Solved

MySQL Database Mirroring

Posted on 2011-09-07
6
299 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
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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
understanding output of mysql version 2 66
Currency in SQL? 2 31
mysql db 3 69
java mysql insert application 14 29
More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

828 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