Solved

mysql replication

Posted on 2013-06-20
3
497 Views
Last Modified: 2013-06-20
My mysql server on Centos 6.0 was stopped one month ago and I need to enable it again.

I try to follow the document below. However, there is no information marked in bind-address, log_bin, binlog_do_db in the my.cnf. Any idea as I suppose they should be there. If there is no entry in binlog_do_db, how does it know which database to replicate ?

Do I refer a wrong document ? Tks

https://www.digitalocean.com/community/articles/how-to-set-up-master-slave-replication-in-mysql
0
Comment
Question by:AXISHK
3 Comments
 
LVL 25

Assisted Solution

by:Tomas Helgi Johannsson
Tomas Helgi Johannsson earned 100 total points
ID: 39264142
Hi!

Here is another good tutorial on how to setup Mysql Replication on  Ubuntu (can be use for other distros as well )

http://www.howtoforge.com/how-to-set-up-database-replication-in-mysql-on-ubuntu-9.10
and another interesting blog here
http://aciddrop.com/2008/01/10/step-by-step-how-to-setup-mysql-database-replication/



Regards,
   Tomas Helgi
0
 
LVL 26

Assisted Solution

by:Zberteoc
Zberteoc earned 100 total points
ID: 39264275
Q: Was this server replicated before?

If yes, where is the cnf file with replication settings?
If not then you will have to set up the replication from scratch as per documentation. Even if it was replicated before you should overview the cnf file and update it with the new settings.
0
 
LVL 24

Accepted Solution

by:
johanntagle earned 300 total points
ID: 39264292
bind-address - this parameter tells mysql to listen/be accessible only via the specified address.  if not defined, it means MySQL will be accessible via any/all of the IP addresses associated with the server

log_bin - you need to set this one on the master in order for binary logging to happen.  Binary logs are what's needed to enable replication.  If you just put log-bin without any parameter it will write the binary logs to your data directory.  But normally, I would place it on a separate folder (on a separate physical disk, for both performance and data safety).

binlog_do_db - this specifies which database(s) to log to the binary log, meaning what can be replicated to slaves.  Not having this parameter means you include changes to all databases to the log.

Hope this helps

Johann
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

816 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now