مطالب مرتبط با «how can it be chords» در Stack Exchange | نویسنده: رضا رضوی
How can I stop master from starting itself as a slave (in addition to master) on reboot?
In a simple MySQL replication Master-Slave configuration I have a problem where Master tries to coect to itself as a slave on reboot. So when I restart MySQL on Master, I see errors related to the same server trying to replicate to itself and I have to manually run mysql -e "STOP SLAVE;" every time I restart MySQL. How can I disable slave on master for good? Here's the relevant portion of my.cnf: ## Logging binlog_format = mixed log_bin = /var/log/mysql/mysql-bin.log sync_binlog = 1 pid_file = /var/run/mysqld/mysqld.pid log_error = /var/log/mysql/error.log #general_log = 0 #general_log_file = /var/log/mysql/general.log slow_query_log = 1 slow_query_log_file = /var/log/mysql/slow.log long_que...
ادامه مطلب
