Solved

Timeout error on starting MySQL after adding Master for replication

Posted on 2008-10-27
9
777 Views
Last Modified: 2013-12-16
Hi All

I am trying to setup replication on my mysql server. I followed

http://www.howtoforge.com/mysql_database_replication

and added

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

To [mysqld]

After that I tried to restart mysql and I got the error below:

Timeout error occurred trying to start MySQL Daemon.

I am running CentOS 4.5.

Did I miss anything here ?

Thanks
0
Comment
Question by:http:// thevpn.guru
  • 4
  • 3
9 Comments
 
LVL 26

Expert Comment

by:ushastry
ID: 22813228
Can you please post the error log contents here...
Pls replace MySQlErrorLogFile.err with actual error log file(complete path).. error log should be n data dir

tail -n 100 MySQlErrorLogFile.err

BTW, Did you created schema named "exampledb" on master?
0
 
LVL 19

Author Comment

by:http:// thevpn.guru
ID: 22813343
tail -f  /var/log/mysqld.log

shows nothing

and yes the db exists on master
0
 
LVL 26

Expert Comment

by:ushastry
ID: 22813565
Pls check the error log... the log file which you shown seems to be general query log.
Error log should be created under data dir & has .err extension.. by default file naming is something host_name.err

Pls check my.cnf if it has an entry for the error log.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 19

Author Comment

by:http:// thevpn.guru
ID: 22813577
I checked no error log entries in my.cnf the only log entry is under [mysql_safe] if I want to add it under which section should i add it ?
0
 
LVL 26

Expert Comment

by:ushastry
ID: 22813710
should be under [mysqld]

mysqld_safe reads all options from the [mysqld], [server], and [mysqld_safe] sections in option files. For example, if you specify a [mysqld] section like this, mysqld_safe will find and use the --log-error option:

[mysqld]
log-error=/var/lib/mysqld.err
0
 
LVL 19

Author Comment

by:http:// thevpn.guru
ID: 22819879
Hi I did add

log-error=/var/log/mysqld.err

When I did the restart  I got
/usr/libexec/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)
081028  9:01:16 [ERROR] Aborting

I created that file however now it just says :

Timeout error occurred trying to start MySQL Daemon.
Starting MySQL:                                            [FAILED]

That is all I get even the error file is not throwing any error.
0
 
LVL 26

Accepted Solution

by:
ushastry earned 500 total points
ID: 22819906
From below error it seems some permission error..

/usr/libexec/mysqld: File '/var/log/mysql/mysql-bin.index' not found (Errcode: 13)

shell> perror 13
OS error code  13:  Permission denied

Can you please check whether or not mysql:mysql has writes on

/var/lib/mysql

MySQL keeps track of binary log index in mysql-bin.index..

Why Im asking you the error log file is bcoz mysql stores all the errors in it which are very useful in debugging and resolving most of the errors..
0
 
LVL 7

Expert Comment

by:macker-
ID: 22837152
The principal problem is where you're trying to write the file to.

log-bin = /var/log/mysql/mysql-bin.log

You're trying to write the binary log to /var/log/mysql/.  /var/log/mysql is meant for log output from syslog and similar, while binary logs are actual mysql datafiles for the database.

Try changing your log-bin line to:

log-bin = /var/lib/mysql/mysql-bin

Next make sure that whatever db follows 'binlog-do-db=' does actually exist.  So if you want to replicate the database named 'test', you'd have:

binlog-do-db=test


You should also refer to the excellent MySQL documentation on replication, found at:

http://dev.mysql.com/doc/refman/5.0/en/replication-implementation.html
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Linux VM 6 90
awk to variable in bash 2 43
bash file 10 37
Upgrade BIOS / EUFI at Scale 4 36
Little introduction about CP: CP is a command on linux that use to copy files and folder from one location to another location. Example usage of CP as follow: cp /myfoder /pathto/destination/folder/ cp abc.tar.gz /pathto/destination/folder/ab…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

803 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