Hi All,
my configuration is:
- Debian 9
- DirectAdmin 1.60.4
- MariaDB 10.2.6
I've been trying for last 2 days to enable log_bin and create replication.
I added to my /etc/my.cnf
I restart mysql and always when I check mysql variables through "SHOW VARIABLES LIKE 'log_bin'" my log_bin value is "OFF".
I'm not sure if this section (I mean "[mysqld]") is even working.
I have only two my.cnf files:
/etc/my.cnf
/usr/local/directadmin/conf/my.cnf
Any ideas?
my configuration is:
- Debian 9
- DirectAdmin 1.60.4
- MariaDB 10.2.6
I've been trying for last 2 days to enable log_bin and create replication.
I added to my /etc/my.cnf
Code:
[mysqld]
bind-address = MY_SERVER_ADDRESS
server_id=1
log-basename=master
log-bin
binlog-format=row
binlog-do-db= MY_DB_NAME
I restart mysql and always when I check mysql variables through "SHOW VARIABLES LIKE 'log_bin'" my log_bin value is "OFF".
I'm not sure if this section (I mean "[mysqld]") is even working.
I have only two my.cnf files:
/etc/my.cnf
/usr/local/directadmin/conf/my.cnf
Any ideas?
Last edited: