| List: | Replication | « Previous MessageNext Message » | |
| From: | Edson Noboru Yamada | Date: | March 23 2008 10:19pm |
| Subject: | innodb replication | ||
| View as plain text | |||
Hi, guys I´m going to set up a innodb database replication, and I have some doubts about the backing up the master database step. Normally, I do a "FLUSH TABLES WITH READ LOCK", backup the data files (or use mysqldump), get the current log coordinates with "SHOW MASTER STATUS" and unlock the tables. Using exactly the same steps work for innodb databases? According to some texts, it seems not, but I haven´t found a clear cookbook. Just doing a "mysqldump --master-data --single-transaction" is enough to replace the above steps? Thank you.
| Thread | ||
|---|---|---|
| • innodb replication | Edson Noboru Yamada | 23 Mar |
| • Re: innodb replication | Marcus Bointon | 24 Mar |
| • Re: innodb replication | Ed W | 18 Apr |
| • Re: innodb replication | Marcus Bointon | 18 Apr |
| • Re: innodb replication | Ed W | 18 Apr |
| • Re: innodb replication | Marcus Bointon | 18 Apr |
| • RE: innodb replication | Rick James | 19 Apr |
| • Re: innodb replication | Eric Bergen | 20 Apr |
| • Re: innodb replication | Augusto Bott | 22 Apr |
| • Re: innodb replication | Mark Callaghan | 22 Apr |
| • Re: innodb replication | Augusto Bott | 22 Apr |
| • Re: innodb replication | Eric Bergen | 22 Apr |
| • Re: innodb replication | Augusto Bott | 23 Apr |
| • Re: innodb replication | Eric Bergen | 23 Apr |
| • RE: innodb replication | Rick James | 23 Apr |
| • Re: innodb replication | Marcus Bointon | 23 Apr |
| • Re: innodb replication | Jeremy Cole | 23 Apr |
| • RE: innodb replication | Rick James | 23 Apr |
| • Re: innodb replication | Jeremy Cole | 23 Apr |
| • RE: innodb replication | Rick James | 23 Apr |
| • Re: innodb replication | Marcus Bointon | 23 Apr |
| • Re: innodb replication | Eric Bergen | 24 Apr |
| • Re: innodb replication | Moon's Father | 21 May |
