#1  
Old 22nd September 2007, 19:31
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
Default mysql replication

Hello i try to do a database replication as i described at:

http://www.howtoforge.com/mysql_database_replication


but when i type this to mycnf

log-bin = /var/log/mysql/mysql-bin.log
binlog-do-db=exampledb
server-id=1


the mysql doesnt start

Ofcourse i have the right values at these fields.
Any suggestion?
Thank you.
Reply With Quote
Sponsored Links
  #2  
Old 23rd September 2007, 19:15
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Do you see any error messages? Are there any errors in your logs?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 25th September 2007, 21:27
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
Default

i think that this is from log:


070922 19:10:25 [Note] /usr/libexec/mysqld: Normal shutdown

070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:25 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:10:27 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:10:27 mysqld ended

070922 19:10:28 mysqld started
/usr/libexec/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
070922 19:10:28 [ERROR] Aborting

070922 19:10:28 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:10:28 mysqld ended

070922 19:11:10 mysqld started
/usr/libexec/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 2)
070922 19:11:10 [ERROR] Aborting

070922 19:11:10 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:11:10 mysqld ended

070922 19:12:09 mysqld started
070922 19:12:09 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
070922 19:18:19 [Note] /usr/libexec/mysqld: Normal shutdown

070922 19:18:19 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:18:21 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:18:21 mysqld ended

070922 19:18:21 mysqld started
error: Found option without preceding group in config file: /etc/my.cnf at line: 15
Fatal error in defaults handling. Program aborted
070922 19:18:22 mysqld ended

070922 19:19:15 mysqld started
070922 19:19:15 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
070922 19:25:01 [Note] /usr/libexec/mysqld: Normal shutdown

070922 19:25:01 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:25:01 [ERROR] /usr/libexec/mysqld: Sort aborted
070922 19:25:03 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:25:03 mysqld ended

070922 19:25:04 mysqld started
/usr/libexec/mysqld: File '/var/log/mysqld.index' not found (Errcode: 13)
070922 19:25:04 [ERROR] Aborting

070922 19:25:04 [Note] /usr/libexec/mysqld: Shutdown complete

070922 19:25:04 mysqld ended

070922 19:25:57 mysqld started
070922 19:25:57 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
Reply With Quote
  #4  
Old 26th September 2007, 15:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

What's the output of
Code:
ls -l /var
and
Code:
ls -l /var/log
? I think it could be a permissions problem.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 26th September 2007, 16:29
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
Default

ok this is


Code:
Last login: Wed Sep 26 11:10:03 2007 from athedsl-258585.home.otenet.gr
[root@GTO003 ~]# ls -l /var
total 172
drwxr-xr-x  2 root root  4096 Jan 23  2007 account
drwxr-xr-x 11 root root  4096 Aug 20 19:04 cache
drwxr-xr-x  2 root root  4096 Aug 20 19:04 crash
drwxr-xr-x  2 root root  4096 Oct 29  2006 cvs
drwxr-xr-x  3 root root  4096 Aug 20 18:51 db
drwxr-xr-x  3 root root  4096 Aug 20 18:50 empty
drwxr-xr-x  2 root root  4096 Oct 11  2006 games
drwxr-xr-x 19 root root  4096 Aug 21 15:19 lib
drwxr-xr-x  2 root root  4096 Oct 11  2006 local
drwxrwxr-x  5 root lock  4096 Sep 26 05:10 lock
drwxr-xr-x  9 root root  4096 Sep 23 05:09 log
lrwxrwxrwx  1 root root    10 Aug 20 18:44 mail -> spool/mail
drwxr-x---  4 root named 4096 Aug 20 19:05 named
drwxr-xr-x  2 root root  4096 Oct 11  2006 nis
drwxr-xr-x  2 root root  4096 Oct 11  2006 opt
drwxr-xr-x  2 root root  4096 Oct 11  2006 preserve
drwxr-xr-x  2 root root  4096 Oct  1  2006 racoon
drwxr-xr-x 20 root root  4096 Sep 26 15:48 run
drwxr-xr-x 13 root root  4096 Aug 20 18:50 spool
drwxrwxrwt  2 root root  4096 Aug 21 18:05 tmp
drwxr-xr-x  6 root root  4096 Jun 26 16:11 www
drwxr-xr-x  3 root root  4096 May 10 15:33 yp
[root@GTO003 ~]# ls -l /var/log
total 38076
-rw-r----- 1 root  root      2219 Sep 19 23:21 acpid
-rw------- 1 root  root    101375 Aug 20 18:51 anaconda.log
-rw------- 1 root  root     26898 Aug 20 18:51 anaconda.syslog
-rw------- 1 root  root         0 Sep 23 05:09 boot.log
-rw------- 1 root  root         0 Sep 16 05:10 boot.log.1
-rw------- 1 root  root         0 Sep  9 05:09 boot.log.2
-rw------- 1 root  root         0 Sep  2 05:09 boot.log.3
-rw------- 1 root  root         0 Aug 26 05:09 boot.log.4
-rw------- 1 root  utmp  19238784 Sep 26 16:16 btmp
-rw------- 1 root  root    138223 Sep 26 16:20 cron
-rw------- 1 root  root    230473 Sep 23 05:08 cron.1
-rw------- 1 root  root    276878 Sep 16 05:10 cron.2
-rw------- 1 root  root    279695 Sep  9 05:08 cron.3
-rw------- 1 root  root    185262 Sep  2 05:08 cron.4
drwxr-xr-x 2 lp    sys       4096 Sep 23 05:09 cups
-rw-r--r-- 1 root  root     21376 Sep 19 23:18 dmesg
-rw------- 1 root  root       672 Aug 21 15:19 faillog
drwx------ 2 root  root      4096 Jun 26 16:11 httpd
-rw-r--r-- 1 root  root     22776 Sep 26 16:23 lastlog
drwxr-xr-x 2 root  root      4096 Aug 20 18:49 mail
-rw------- 1 root  root    304830 Sep 26 15:01 maillog
-rw------- 1 root  root    394856 Sep 23 05:09 maillog.1
-rw------- 1 root  root    338814 Sep 16 05:10 maillog.2
-rw------- 1 root  root    604735 Sep  9 05:09 maillog.3
-rw------- 1 root  root   1459745 Sep  2 05:09 maillog.4
-rw------- 1 root  root        47 Sep 23 05:09 messages
-rw------- 1 root  root    112630 Sep 19 22:57 messages.1
-rw------- 1 root  root    216010 Sep 14 17:50 messages.2
-rw------- 1 root  root        47 Sep  2 05:09 messages.3
-rw------- 1 root  root        47 Aug 26 05:09 messages.4
-rw-r----- 1 mysql mysql    25679 Sep 26 11:16 mysqld.log
drwx------ 2 root  root      4096 Dec  1  2006 ppp
drwxr-xr-x 2 root  root      4096 Aug 21 13:09 prelink
-rw-r--r-- 1 root  root     15022 Sep 26 05:12 rpmpkgs
-rw-r--r-- 1 root  root     15022 Sep 22 05:10 rpmpkgs.1
-rw-r--r-- 1 root  root     15022 Sep 15 05:10 rpmpkgs.2
-rw-r--r-- 1 root  root     15022 Sep  8 05:10 rpmpkgs.3
-rw-r--r-- 1 root  root     15022 Sep  1 05:50 rpmpkgs.4
drwx------ 2 root  root      4096 Jun  5 16:39 samba
-rw------- 1 root  root   1420814 Sep 26 16:23 secure
-rw------- 1 root  root   4264096 Sep 23 05:08 secure.1
-rw------- 1 root  root   2244942 Sep 16 03:56 secure.2
-rw------- 1 root  root   3002081 Sep  9 05:04 secure.3
-rw------- 1 root  root   3575088 Sep  2 03:10 secure.4
-rw------- 1 root  root         0 Sep 23 05:09 spooler
-rw------- 1 root  root         0 Sep 16 05:10 spooler.1
-rw------- 1 root  root         0 Sep  9 05:09 spooler.2
-rw------- 1 root  root         0 Sep  2 05:09 spooler.3
-rw------- 1 root  root         0 Aug 26 05:09 spooler.4
-rw------- 1 root  root         0 Aug 20 18:59 tallylog
drwxr-xr-x 2 root  root      4096 Jul 19  2006 vbox
-rw-rw-r-- 1 root  utmp     87936 Sep 26 16:23 wtmp
-rw-rw-r-- 1 root  utmp     38016 Aug 31 12:31 wtmp.1
-rw-r--r-- 1 root  root     12191 Aug 21 18:05 yum.log
[root@GTO003 ~]#
[root@GTO003 ~]#
Reply With Quote
  #6  
Old 27th September 2007, 16:01
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Please try this:
Code:
mkdir /var/log/mysql
touch /var/log/mysql/mysql-bin.log
chown -R mysql:mysql /var/log/mysql
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 28th September 2007, 19:36
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
Default

OK this was the problem so i set it up BUT i come along with another problem when all was set the slave just replicated what was in the binlog 000001 and stoped but as i see my master has created other 2 binlogs 000002 and 000003 this is ok?

Also at binlog 1 and 2 there is a stop and binolg hasn't thats why it
is 10 times bigger.

UPDATE:OK i see that master.info took the changes for the binlog but
it doesn't work.

Last edited by tera7; 28th September 2007 at 19:58.
Reply With Quote
  #8  
Old 29th September 2007, 12:36
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Please take a look at the logs on the slave. It should tell you if/what's wrong.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 29th September 2007, 19:14
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
Default

Ok first of all thank you for your time.
Now i start it again from the begining i have all set it good at master but although
it creates binlogs can not read it through phpmyadmin (at my previous set it was readable)the log file of mysql shows nothing.
At the slave i set as it has to be i also read other how to and a lot of things at mysql documentation.
But at the log file shows that
Code:
070929 20:31:02 [Note] /usr/libexec/mysqld: Normal shutdown

070929 20:31:02 [Note] Error reading relay log event: slave SQL thread was killed
070929 20:31:02 [Note] /usr/libexec/mysqld: Shutdown complete

070929 20:31:02  mysqld ended

070929 20:31:04  mysqld started
070929 20:31:04 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=used-relay-bin' to avoid this problem.
070929 20:31:04 [ERROR] Failed to open the relay log './GTO004-relay-bin.000001' (relay_log_pos 98)
070929 20:31:04 [ERROR] Could not find target log during relay log initialization
070929 20:31:04 [ERROR] Failed to initialize the master info structure
070929 20:31:04 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.27'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
070929 20:49:36 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.000001' at position 485, relay log './used-relay-bin.000001' position: 4
070929 20:49:36 [Note] Slave I/O thread: connected to master 'slave_user@85.17.184.15:3306',  replication started in log 'mysql-bin.000001' at position 485
070929 20:49:36 [ERROR] Error reading packet from server: Could not find first log file name in binary log index file ( server_errno=1236)
070929 20:49:36 [ERROR] Got fatal error 1236: 'Could not find first log file name in binary log index file' from master when reading data from binary log
070929 20:49:36 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000001', position 485

Now i try to solve it from here because i have a large database and its difficult
to start it from scratch.

Thank you again for your attention to my problem.
Reply With Quote
  #10  
Old 3rd October 2007, 15:04
tera7 tera7 is offline
Member
 
Join Date: Apr 2007
Posts: 44
Thanks: 0
Thanked 1 Time in 1 Post
 
Default

OK sudenly it seems that it is working i did'nt do something it just started to work THANK YOU for your help at this matter and many others that you have helped me .
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
mysql replication issues Jamesk5 Server Operation 8 23rd September 2006 14:40
MySQL Replication neil6179 Server Operation 1 12th September 2006 15:50
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 01:38.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.