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
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
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
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
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?
add
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.2012
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.
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-
* 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
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
10 matches
Mail list logo