Solved

mysql replication

Posted on 2013-06-20
3
496 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

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…
A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

919 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

11 Experts available now in Live!

Get 1:1 Help Now