This page was exported from GTUTO [ https://www.gtuto.com ] Export date:Fri Mar 29 14:40:39 2024 / +0000 GMT ___________________________________________________ Title: MariaDB notes --------------------------------------------------- après copie du contenu du répertoire mysql d'un serveur vers un autre pour corrigé les évolutions du format mysql_upgrade --force -uuser -ppassword Réplication slave my.cnf slave-parallel-threads=4 server-id = 03 relay-log-index = /home/mysql/mysql_log/slave-relay-bin.index relay-log = /home/mysql/mysql_log/slave-relay-bin replicate-do-db = base1 replicate-do-db = base2 replicate-do-db = base3 replicate-ignore-table = base1.table_pas_ok replicate-ignore-table = base2.table_pa_ok slave-skip-errors = 1236,1146,1032 master show master status; -> noter file et pos exmaster1-bin.030648, 50302757 slave STOP SLAVE; change master to master_host='hostname', master_user='user_copy', master_password='user_pass', master_port=3306, master_log_file='master1-bin.030648', master_log_pos=50302757, master_connect_retry=10; START SLAVE; --------------------------------------------------- Images: --------------------------------------------------- --------------------------------------------------- Post date: 2020-02-16 22:48:58 Post date GMT: 2020-02-16 22:48:58 Post modified date: 2020-02-19 21:54:04 Post modified date GMT: 2020-02-19 21:54:04 ____________________________________________________________________________________________ Export of Post and Page as text file has been powered by [ Universal Post Manager ] plugin from www.gconverters.com