Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I used this guide to make replication between my two db servers :

But, when I updated a row on master server it will be available in slave instantly. It should be asynchronous , isn't it? What I am missing?

Thank You

share|improve this question

migrated from Apr 1 '13 at 0:05

This question came from our site for professional and enthusiast programmers.

Are you trying to say that currently, replication is slow? I don't really get what the question is. – thejh Mar 31 '13 at 20:33
No, on the contrary it's very fast. – ecabuk Mar 31 '13 at 20:36
up vote 3 down vote accepted

Async and Slow are not the same thing. If you start putting real load on the replication stream, you will start to see delays, but not with a single test command.

share|improve this answer
servers are in separate places and master's upload speed is ~75kb/sec – ecabuk Mar 31 '13 at 20:37
@ecabuk And how big were the records you inserted? When you're just sending fifty bytes or so from time to time, your upload bandwidth doesn't matter. – thejh Mar 31 '13 at 20:42
sorry for previous comment, I pressed the enter by mistake. servers are in separate places and master's upload speed is ~75kb/sec. As far as i know, first of all, 16mb xlog file should be upload to slave, after that transections available on slave. But it will happening in 1 sec. – ecabuk Mar 31 '13 at 20:45
Quote: 'In SR, XLOG records in partially-filled XLOG file are shipped too, implementing record-based log-shipping.' - so streaming replication is exactly that: The stream of updates is transported from master to slave. – Eugen Rieck Mar 31 '13 at 20:50

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.