MySQL Forums
Forum List  »  Replication

Mysql binlog replication
Posted by: Indika Dias
Date: July 15, 2016 03:45AM

Hi ,
My master and slave servers in version 5.5.46-0ubuntu0.14.04.2

1. show master status;
doesn't show any binary log .
Though I can't start the replication.Please help me.

cnf file

[mysqld]

server-id = 1
log-bin = /var/lib/mysql/log-bin
#expire_logs_days = 10
#max_binlog_size = 100M
binlog_do_db = abc

Error file

Version: '5.5.46-0ubuntu0.14.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
160715 12:55:34 [Note] /usr/sbin/mysqld: Normal shutdown

160715 12:55:34 [Note] Event Scheduler: Purging the queue. 0 events
160715 12:55:34 InnoDB: Starting shutdown...
160715 12:55:35 InnoDB: Shutdown completed; log sequence number 355635026
160715 12:55:35 [Note] /usr/sbin/mysqld: Shutdown complete

160715 12:55:36 mysqld_safe mysqld from pid file /var/lib/mysql/ActiveApp.pid ended
160715 12:55:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
Warning: World-writable config file '/etc/mysql/my.cnf' is ignored
160715 12:55:36 [Note] /usr/sbin/mysqld (mysqld 5.5.46-0ubuntu0.14.04.2) starting as process 31940 ...
160715 12:55:36 [Note] Plugin 'FEDERATED' is disabled.
160715 12:55:36 InnoDB: The InnoDB memory heap is disabled
160715 12:55:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160715 12:55:36 InnoDB: Compressed tables use zlib 1.2.8
160715 12:55:36 InnoDB: Using Linux native AIO
160715 12:55:36 InnoDB: Initializing buffer pool, size = 128.0M
160715 12:55:36 InnoDB: Completed initialization of buffer pool
160715 12:55:36 InnoDB: highest supported file format is Barracuda.
160715 12:55:36 InnoDB: Waiting for the background threads to start
160715 12:55:37 InnoDB: 5.5.46 started; log sequence number 355635026
160715 12:55:37 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
160715 12:55:37 [Note] - '0.0.0.0' resolves to '0.0.0.0';
160715 12:55:37 [Note] Server socket created on IP: '0.0.0.0'.
160715 12:55:37 [Note] Event Scheduler: Loaded 0 events
160715 12:55:37 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.46-0ubuntu0.14.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql binlog replication
1635
July 15, 2016 03:45AM
600
July 19, 2016 10:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.