Добрый день! Помогите пожалуйста!
Необходимо сделать репликацию БД MASTER-SLAVE на сателит. Столкнулся с проблемой - не работают (создаются) бинарные логи.
uname -a
FreeBSD 10.3-RELEASE FreeBSD 10.3-RELEASE #0: Mon Dec 10 02:00:43 EET 2018
pkg info mysql56-server
mysql56-server-5.6.41_2
Name : mysql56-server
Version : 5.6.41_2
Installed on : Sun Dec 9 11:22:33 2018 EET
Origin : databases/mysql56-server
Architecture : FreeBSD:10:amd64
Prefix : /usr/local
Categories : databases ipv6
Licenses : GPLv2
Maintainer : mmokhi@FreeBSD.org
Comment : Multithreaded SQL database (server)
Options :
ARCHIVE : off
BLACKHOLE : off
EXAMPLE : off
FEDERATED : off
INNOBASE : off
PARTITION : off
PERFSCHEMA : off
PERFSCHM : on
Annotations :
FreeBSD_version: 1004000
cpe : cpe:2.3:a:mysql:mysql:5.6.41:::::freebsd10:x64:2
repo_type : binary
repository : FreeBSD
Flat size : 81.9MiB
Description :
MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server.
cat /etc/my.cnf
[mysqld]
#skip-networking
character-set-server=utf8
init-connect="SET NAMES utf8"
query_cache_size=64M
long_query_time=5
slow_query_log=1
slow_query_log_file=/var/db/mysql/slow.log
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
skip-external-locking
low-priority-updates
myisam-recover=backup,force
log-bin=mysql-bin
server-id=1
expire_logs_days = 2
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
ls -l /var/db/
drwx------ 7 mysql mysql 512 2 июн 09:52 mysql
drwxr-x--- 2 mysql mysql 512 20 окт 2018 mysql_secure
drwxr-x--- 2 mysql mysql 512 20 окт 2018 mysql_tmpdir
/usr/local/etc/rc.d/mysql-server restart
Stopping mysql.
Waiting for PIDS: 92055.
Starting mysql.
ps -ax | grep mysql
93606 - Is 0:00,01 /bin/sh /usr/local/bin/mysqld_safe --basedir=/usr/local --datadir=/var/db/mysql --pid-file=/var/db/mysql/xxx01.pid --user=mysql
93723 - S 0:21,19 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --plugin-dir=/usr/local/lib/mysql/plugin --user=mysql --log-error=xxx01.err
94380 0 S+ 0:00,00 grep mysql
mysql>
mysql> show master status;
Empty set (0.00 sec)
mysql> show binary logs;
ERROR 1381 (HY000): You are not using binary logging
Подскажите куда копать?
