I need help with db replication.
This is my current set up and environment:
1 Main Mysql server machine, quad processor with a gig of ram. I'm running
RH Linux 6.1 and I'm getting about 100,000 transactions (actual changes to
the database a day). I'm also getting about 10-50x that in queries to the
database.
Proposed environment:
Same as above plus a second slave (mirror) db box, probably some dual proc
512mb ram running rh linux 6.1 or 6.2.
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?
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?
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)
Direct Emails are welcome as replies to jschoolc@stripped
Jeffrey Schoolcraft
