How can I disable the Slave Server permanently?

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

How can I disable the Slave Server permanently?

Postby muratyilmaz.dev » Mon Aug 22, 2022 3:39 am

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
Murat Yılmaz / Software Developer - agola.net - Turkey
ViciBox v.9.0.3 | Version: 2.14b0.5 | SVN Version: 3346 | DB Schema Version: 1615 | Build: 200630-2117 | Cloud-Cluster
muratyilmaz.dev
 
Posts: 17
Joined: Sun Feb 16, 2020 4:24 am
Location: Turkey

Re: How can I disable the Slave Server permanently?

Postby Vince-0 » Wed Aug 24, 2022 3:52 am

Remove the slave reporting options from system settings.
Vince-0
 
Posts: 272
Joined: Fri Mar 02, 2012 4:27 pm
Location: South Africa

Re: How can I disable the Slave Server permanently?

Postby carpenox » Mon Aug 29, 2022 12:37 pm

go into mysql and "stop slave;"
Alma Linux 9.4 | SVN Version: 3889 | DB Schema Version: 1721 | Asterisk 18.21.1 | PHP8
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WA: +19549477572
GC: https://join.skype.com/ujkQ7i5lV78O | DC: https://discord.gg/DVktk6smbh
carpenox
 
Posts: 2420
Joined: Wed Apr 08, 2020 2:02 am
Location: St Petersburg, FL

Re: How can I disable the Slave Server permanently?

Postby muratyilmaz.dev » Fri Sep 09, 2022 4:34 pm

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?
Murat Yılmaz / Software Developer - agola.net - Turkey
ViciBox v.9.0.3 | Version: 2.14b0.5 | SVN Version: 3346 | DB Schema Version: 1615 | Build: 200630-2117 | Cloud-Cluster
muratyilmaz.dev
 
Posts: 17
Joined: Sun Feb 16, 2020 4:24 am
Location: Turkey


Return to Support

Who is online

Users browsing this forum: No registered users and 36 guests

cron