On Wed, Jun 28, 2000 at 03:37:28PM -0400, Jeffrey A Schoolcraft wrote:
> Questions:
>
> 1. If I want to make a master/slave replication environment, and possibly
> use the second box as an emergency "hot swap" back up, should I install the
> same MySQL version that is on my live DB box?
It's not critical, but it might reduce the number of things that could
go wrong.
> 2. If I want to do the replication, is there a fast and effective way to
> get MySQL to rotate it's update log? I would be in heaven if there was some
> type of config command I could give it to rotate the log like every 15
> minutes or so. If there is such a command, will it lock the database so I
> don't lose transactions?
No, you'd just need a cron job to call mysqladmin flush-logs
every 15 minutes.
> 3. Has anyone tried the briefly mentioned but not very documented built in
> replication support that was supposed to be added in version 3.23.15? If
> so, how does it work and is it as effective as say Sybase replication.
>
> I ask the last question not as an insult but if it provides almost realtime
> replication then it might be worth some down time getting a newer version
> running on my live box and not dealing with the update log (for replication)
You're smart to ask for info before diving in. This mailing
list has had several threads about it, so you might want to scan
through it. But right now there are still some glitches in the
new replication code, and I wouldn't use it on a production
system. If you could use it on your test system and run it
through its paces, reporting any problems you find will make sure
that those problems are fixed early.
Yes, it does handle almost-realtime replication. When the slave
starts up, it slurps up all of the master's updates that it
doesn't have yet. Then it just waits for the master to feed
it new info, and it updates as quickly as it can. If it is
powered similarly to the master, and you have a relatively quick
connection between the two, it should be almost immediate.
Tim
--
Tim Smith < tim@stripped > :MySQL Development Team: Boone, NC USA.
