Thinking about replication

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I am thinking about implementing replication. Basic question is what
kind of delay there would be to have the data replicated.  Not a
massive table, and all on the same net.

Furthere, can you specify priority for replication?

Posted using the interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL:
Visit Topic URL to contact author (reg. req'd).  Report abuse:

Re: Thinking about replication

steve wrote:
Quoted text here. Click to load it
I am using replication for a while now and have not noticed delays at
the moment. I use it for almost half a year now to replicate and backup
our master server which holds the PACS database (storage of medical
image data) of our hospital. My master and slaves are in the same net as

As far as I know there's nothing like setting priority. Replication is,
in short, done by copying the binary log file from the master to the
slave and executing the data in the log file there. The binary log file
can be seen as a compressed file with the SQL statements executed at the


A: Because it messes up the order in which people normally read text.
Q: Why is it such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?

Site Timeline