Visit Jeremy's Blog.
Go Back > Forums > Other *NIX Forums > *BSD
User Name
*BSD This forum is for the discussion of all BSD variants.
FreeBSD, OpenBSD, NetBSD, etc.


  Search this Thread
Old 03-30-2007, 11:11 AM   #1
Registered: Apr 2005
Location: Ohio
Distribution: Slackware && freeBSD
Posts: 676

Rep: Reputation: 30
mysql replication

Hello and many thanks in advance for any help.

Learning how to set up 2 mysql servers in master/slave relationship which from all the documentation seems really easy, but for the life of me I can not get a simple binary log to appear and every time I do a show master status the query always returns empty.

relevant area of my.cnf

port            = 3306
socket          = /tmp/mysql.sock
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
server-id = 1
This machine is a 6.2 box with mysql51 installed from ports.

Many thanks for any help.
Old 04-03-2007, 09:23 PM   #2
Registered: Apr 2005
Location: Ohio
Distribution: Slackware && freeBSD
Posts: 676

Original Poster
Rep: Reputation: 30
Hello again,

Just wanted to post what I had done to cause my issue. My my.cnf wasn't under /var/db/mysql/ which is where the startup script is looking for it. Once I put things in order and, I changed the above log-bin option to just plain log-bin=mysql-bin, fixed a few errors all seems good. Hope this helps someone sometime.

Last edited by lord-fu; 04-03-2007 at 09:29 PM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Replication ACDII Linux - Server 5 12-18-2006 08:08 AM
mysql replication twistedpair Linux - General 7 06-23-2006 10:10 AM
Looking for suggestions on MySQL one-way replication Pcghost Linux - Software 1 01-25-2005 10:22 AM
Mysql replication pk21 Linux - Software 0 08-28-2003 05:00 AM
mysql replication cheng Linux - Software 1 08-22-2002 02:11 PM > Forums > Other *NIX Forums > *BSD

All times are GMT -5. The time now is 12:52 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration