Do you need two servers for database replication?

I

Ilya Beloborodov2015-10-28 18:38:09

MySQL

Ilya Beloborodov, 2015-10-28 18:38:09

I so understood, replication of a DB on a normal hosting cannot be configured? Does this require at least two mysql servers?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

V

Viktor Kulikov, 2015-10-28
@kowap

This is the essence of replication.
Ensure fault tolerance and data consistency in case of failure of one database server.

V

Vlad Zhivotnev, 2015-10-28
@inkvizitor68sl

If "common hosting" means shared-hosting, then you can't do it at all. Very few hosters will do replication to the left server (well, they usually have their own to make backups).
If there is vps/vds/dedicated, then replication can be done on the same server (2 configs with different ports and master dir). About that "it is silly to do replication on one server" - it is very disputable. Replicas are made for various reasons. Back up from it, do not make heavy read requests to the master, and so on.

H

hostwell, 2015-10-28
@hostwell

Replication requires at least two servers for load balancing. Otherwise, why then do balancing at all.