R
R
Ruslan Bergutov2015-05-06 07:22:49
MySQL
Ruslan Bergutov, 2015-05-06 07:22:49

Any options for syncing sql between 2 local and 1 remote computers?

Actually there are three computers, one of them at work, two at home, all three have Apache, are there any ways to synchronize databases between them?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
D
Dmitry Entelis, 2015-05-06
@DmitriyEntelis

I didn’t quite understand what Apache has to do with it, if we are talking about sql synchronization, but you would start with why you need it. Because in general, without hellish hemorrhoids, the answer is no .
If only the framework needs to be synchronized - any framework migration manager, I personally like https://phinx.org/ but there are many alternatives.
If you need to transfer "work in a day" one-time, you can make a simple script with mysqldump and transfer it.
Any solution with multi-master replication works quite disgustingly, imposes serious restrictions on requests and requires a stable connection between servers.

V
Vadim Shandrinov, 2015-05-06
@suguby

If you need to synchronize the database structure with your hands, then use mysqlworkbench.org.
If you need to sync data, then simply upload mysqldump to the cloud and restore it manually from there.
If you need everything online, then replication, but that's another story.
Specify - how many grams to hang - what do you need?
UPD. Climbed into your profile - if django, then you do migrations there and roll. You can use Fabric to synch data. But that's all for a manual update.

S
ShamblerR, 2015-05-13
@ShamblerR

put the usual phpmyamin - "replication"

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question