Good all the time of the day gentlemen

Actually, I have no idea that there is SQL replication or SQL replication (how to?). Google help is understandable, but can anyone give an example of what it is in the words of an amateur?

Here to take database queries is one thing, there is an import of export tables. Is replication something else? Please explain this theoretically.

  • one
    And how were you looking? The first links fully reveal the whole point, do you read laziness? habrahabr.ru/post/56702 - lampa
  • @lampa, I read it on a barbara, the article is good. But sometimes you need something very short and capacious. It's like in boo-accounting, that not everyone will immediately remember what a debit with a credit is, but if you say: Debit -> us, Credit -> We, then understanding happens more quickly. - sergey
  • but the rake on which comes every who said the word replication. miracles do not happen - zb '18


2 answers 2

Replication (eng. Replication) - a mechanism for synchronizing the contents of several copies of an object (for example, the contents of a database). Replication is a process that means copying data from one source to another (or to many others) and vice versa. When replicating, changes made in one copy of an object can be distributed to other copies.

Replication is done automatically, you do not need to manually export, then import.

  • Instead of a thousand words damn. Thank. Finally it came. In my language, this synchronization is more likely)) - sergey
  • Well, yes, you can say so) - thunder

This is synchronization between multiple servers, i.e. in theory, for example, there is a server with a site database, which is visited by 5,000 visitors a minute and the server slows down noticeably, then you need to have one and the same database on 2 servers so that visitors can share 2500 per server, so that visitors receive one and the same information from different servers must be synchronized; this synchronization itself is called replication

  • Thank you, but I'm sorry, I can not stick 2 accept. From @ thunder'a already learned that this is - sergey
  • Well, how to use replication is another question) this applies, by the way, not only in the database, Load-balancing is also often used for sites in terms of code .... - thunder