Re: Replication question: How to make a slave a master?

Are you trying to promote a slave as a new master and replace current master or create intermediate slave? If it is the latter all you need to do is to: 1. Stop the slave 2. Add "log_slave_updates = 1" in the slave's config file 3. Copy the slave files to the new slave(s) 4. Start your intermedia

Re: Replication question: How to make a slave a master?

* stop mysqld * rm -f mysql-relay-bin* * rm -f master.info * rm -f relay-log.info * start mysqld so, and now your slave is no longer any slave to make sure you are binary-identical with the new master stop the new master, remove all it's BINLOGS, not its relay-logs, stop the new salve, rsync the

RE: Replication question: How to make a slave a master?

It's the sequence that is tricky. 1. STOP SLAVE 2. CHANGE MASTER 3. START SLAVE Do it wrong, and you miss or duplicate replication stuff that happens between #1 and #2. Could you please lay out the precise steps, so that I can understand how un-tricky it can be. > -Original Message- > Fr

Re: Replication question: How to make a slave a master?

what would be tricky? remove all relay-logs, remove master.info adn that was it done this many times in the last years and it takes 30 seconds if you are fast enough to type the slave-commands Am 24.08.2012 23:35, schrieb Rick James: > Pointing the other slave to the new master is a bit tricky. >

RE: Replication question: How to make a slave a master?

Pointing the other slave to the new master is a bit tricky. > -Original Message- > From: Reindl Harald [mailto:h.rei...@thelounge.net] > Sent: Friday, August 24, 2012 8:29 AM > To: mysql@lists.mysql.com > Subject: Re: Replication question: How to make a slave a master? > > > > Am 24.08.

Re: Replication question: How to make a slave a master?

Am 24.08.2012 17:25, schrieb Richard Reina: > I have a couple of mysql database slaves and would like to make one of them > be a master as well so that I can set another machine to replicate from it. > Can anyone tell me how I should go about it or know of any howtos for this > specific task? ad

Replication question: How to make a slave a master?

I have a couple of mysql database slaves and would like to make one of them be a master as well so that I can set another machine to replicate from it. Can anyone tell me how I should go about it or know of any howtos for this specific task? Thanks, Richard

Re: Machine Learning

I have not as yet created the visual or really mapped anything out yet, it has been a somewhat oddly long working strectch for me this last week, so I will have some time to myself on Sunday of this week to work solely on this effort.   garotconk...@yahoo.com

RE: Machine Learning

we'll need a user-friendly architecture diagram with a hopefully one to one mapping to DBSchema Table Elements..(run the napkin thru a scanner and publish it) once the Table Elements are defined then we'll need to populate Tables with columns..determine Primary Keys with Foreign keys..get the r

RE: Machine Learning

Hi Garot, How is the visual diagram coming along ? I'd be good to have a good idea of core system specifics so that DB design can be tailored to that ... of course, knowing that things will change as the concept evolves. Thanks, Justin -Original Message- From: Garot Conklin [mailto:ga