mysql replication

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
Who is Participating?
johanntagleConnect With a Mentor Commented:
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

Tomas Helgi JohannssonConnect With a Mentor Commented:

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

   Tomas Helgi
ZberteocConnect With a Mentor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.