search

enterprisemediawiki / meza

Setup an enterprise MediaWiki server with simple commands
MIT License
41 stars 27 forks source link

Create process for starting/stopping database replication #455

Open jamesmontalvo3 opened 7 years ago

jamesmontalvo3 commented 7 years ago

In order for slave databases to stay synced with master, slaves must be shut down properly. Create script to do so.

Refs:

jamesmontalvo3 commented 7 years ago

Shutdown:

sudo mysql -e"STOP SLAVE; FLUSH TABLES;"
sudo systemctl stop mariadb

Start up:

sudo mysql -e"START SLAVE;"