| List: | Replication | « Previous MessageNext Message » | |
| From: | Ed W | Date: | April 18 2008 9:27am |
| Subject: | Re: innodb replication | ||
| View as plain text | |||
Edson Noboru Yamada wrote: > 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? > > How would you put these two things together in the case of a server using mixed database table types for a clean backup that can be used to restart synchronisation? Ed W
| 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 |
