The Ultimate Guide to High Availability with MariaDB

RESET SLAVE

Stai visualizzando una vecchia versione di questo article. Visualizza la versione più recente. 
RESET SLAVE

RESET SLAVE fa dimenticare allo slave la sua posizione nella replica, registrata nel log binario del master. Essa è progettata per ottenere un avvio pulito: elimina i file master.info e relay-log.info, tutti i file del relay log, e crea un nuovo file del relay log. Per usare RESET SLAVE, i thread di replica dello slave non devono essere attivi (si usi STOP SLAVE se necessario).

  • Note*: All relay log files are deleted, even if they have not been completely executed by the slave SQL thread. (This is a condition likely to exist on a replication slave if you have issued a STOP SLAVE statement or if the slave is highly loaded.)

Connection information stored in the master.info file is immediately reset using any values specified in the corresponding startup options. This information includes values such as master host, master port, master user, and master password. If the slave SQL thread was in the middle of replicating temporary tables when it was stopped, and RESET SLAVE is issued, these replicated temporary tables are deleted on the slave.

Commenti

Sto caricando i commenti......
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.