linux:databases:mysql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
linux:databases:mysql [2017/11/22 01:09] tkilla |
linux:databases:mysql [2017/11/22 01:10] (current) tkilla |
||
|---|---|---|---|
| Line 94: | Line 94: | ||
| interesting parameters for replication: | interesting parameters for replication: | ||
| - | --lock-tables - READ LOCK (no writes) for currently dumped database: ensures consitent dump | + | --lock-tables - READ LOCK (no writes) for currently dumped database: ensures consitent dump instead of |
| - | | + | --single-transaction |
| - | --single-transaction | + | |
| - | | + | |
| will give you an exact point-in-time snapshot of the data | will give you an exact point-in-time snapshot of the data | ||
| --single-transaction produces a checkpoint that allows the dump to capture all data prior to the | --single-transaction produces a checkpoint that allows the dump to capture all data prior to the | ||
linux/databases/mysql.1511309387.txt.gz · Last modified: 2017/11/22 01:09 by tkilla
