Page 1 of 1

How can I disable the Slave Server permanently?

PostPosted: Mon Aug 22, 2022 3:39 am
by muratyilmaz.dev
I have a cluster structure as below.

I don't want to use Slave Server anymore.
How can I permanently disable the Slave Server without breaking the build?

(Then I want to stop any unnecessary running services on the Slave Server. For example mysql)

Thank you.

DBMaster
DBSlave + Web Server
Phone Server 1
Phone Server 2

Re: How can I disable the Slave Server permanently?

PostPosted: Wed Aug 24, 2022 3:52 am
by Vince-0
Remove the slave reporting options from system settings.

Re: How can I disable the Slave Server permanently?

PostPosted: Mon Aug 29, 2022 12:37 pm
by carpenox
go into mysql and "stop slave;"

Re: How can I disable the Slave Server permanently?

PostPosted: Fri Sep 09, 2022 4:34 pm
by muratyilmaz.dev
carpenox wrote:go into mysql and "stop slave;"


Replication returned error 1236 due to power supply interruption.
I already stopped the slave server.
but it seems like you have to tell the master.
Because master logs continue to work.

/var/lib/mysql/mysql-bin.000653 -- 1024.1 MB -- 6.09.2022
/var/lib/mysql/mysql-bin.000654 -- 1024.1 MB -- 7.09.2022
/var/lib/mysql/mysql-bin.000655 -- 1024.1 MB -- 8.09.2022
/var/lib/mysql/mysql-bin.000656 -- 1024.1 MB -- 9.09.2022

How do I completely stop replication?