database:mysql
 
Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
database:mysql [2019/04/02 13:52] – [Master-Master Replication] tmadedatabase:mysql [2019/06/06 14:41] (current) – [Restore] tmade
Line 14: Line 14:
  
 ==== Backup ==== ==== Backup ====
-Example backupscript to backup each database as a singe file:+Example backupscript to backup each database as a single file:
 <code> <code>
 #!/bin/bash #!/bin/bash
Line 94: Line 94:
 mysqldump --user=${USERNAME} --password --host=${DBHOST} --port=${PORT} --quick --triggers --routines --events --add-drop-database --single-transaction --master-data --hex-blob --databases $candidates | gzip > $BACKUPDIR/dump_`date +%d.%m.%y`.sql.gz mysqldump --user=${USERNAME} --password --host=${DBHOST} --port=${PORT} --quick --triggers --routines --events --add-drop-database --single-transaction --master-data --hex-blob --databases $candidates | gzip > $BACKUPDIR/dump_`date +%d.%m.%y`.sql.gz
 </code> </code>
 +
 +Check also: 
 +
 +https://www.percona.com/blog/2013/02/08/how-to-createrestore-a-slave-using-gtid-replication-in-mysql-5-6/
  
 ==== Restore ==== ==== Restore ====
  
-Ceate a file with following content and make it executable (chmod +x import_db.sh)+Create a file with following content and make it executable (chmod +x import_db.sh)
  
 <code> <code>
Line 381: Line 385:
   CHANGE MASTER TO MASTER_HOST="IP-Replication-Master", MASTER_PORT=3306, MASTER_USER="replication", MASTER_PASSWORD="secret", MASTER_AUTO_POSITION=1   CHANGE MASTER TO MASTER_HOST="IP-Replication-Master", MASTER_PORT=3306, MASTER_USER="replication", MASTER_PASSWORD="secret", MASTER_AUTO_POSITION=1
  
-as master and creadentials isn´t know yet.+as master and credentials aren´t know yet. 
 + 
 +See also on: 
 + 
 +https://www.percona.com/blog/2013/02/08/how-to-createrestore-a-slave-using-gtid-replication-in-mysql-5-6/
  
 Activate/ deactivate "MASTER_AUTO_POSITION": Activate/ deactivate "MASTER_AUTO_POSITION":
database/mysql.txt · Last modified: 2019/06/06 14:41 by tmade
 
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki