| List: | Replication | « Previous MessageNext Message » | |
| From: | nhadie ramos | Date: | April 1 2012 4:54pm |
| Subject: | adding another slave | ||
| View as plain text | |||
Hi, I currently have a replication setup with master and 1 slave. i would like to add one more slave into the setup. is it possible if i lock the slave tables, show slave status and get Relay_Log_Pos and Relay_Master_Log_File. and create a snapshot. once done, use the created snapshot to the new slave and start replication with the values i got from the slave? Reason i would like to do this is because i don't want to lock tables on the master. TIA Regards, Ron
| Thread | ||
|---|---|---|
| • adding another slave | nhadie ramos | 1 Apr |
| • Re: adding another slave | a.smith | 1 Apr |
| • Re: adding another slave | Neil Armitage | 1 Apr |
| • Re: adding another slave | nhadie ramos | 1 Apr |
| • Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
| • RE: Seconds Behind Master increasing in slave | David Lerer | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Arthur Fuller | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Rick James | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Pankaj Joshi | 3 Apr |
| • Re: Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | nehal dattani | 2 Apr |
| • Re: Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
| • RE: Seconds Behind Master increasing in slave | Revathi Rangachari | 2 Apr |
