Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

mysql replication

Posted on 2013-06-20
3
Medium Priority
?
503 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 26

Assisted Solution

by:Tomas Helgi Johannsson
Tomas Helgi Johannsson earned 400 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 27

Assisted Solution

by:Zberteoc
Zberteoc earned 400 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 1200 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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month10 days, 4 hours left to enroll

926 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