search

everycook / EveryCook

The worlds best recipe database
31 stars 7 forks source link

Food & Recipe Data Sync #65

Open everycook opened 12 years ago

everycook commented 12 years ago

We will do this using the replication feature of mysql. this will sync the ec DB from Master to Slave

everycook commented 12 years ago

tell me if you need open ports

everycook commented 11 years ago

current approach is to to use the binary log feature of mysql.

See: http://dev.mysql.com/doc/refman/5.1/de/binary-log.html for how to write it. a new log file is created on server restart. so if we restart daily we have daily logfiles.

then we can get those logfiles via rsync and import them using: http://dev.mysql.com/doc/refman/5.1/de/mysqlbinlog.html

If I undestood that right...

swerder commented 11 years ago

copy files (install.sh and main_yii_config.php) from Dropbox/DB/sync to machine. run commands from Dropbox/DB/sync/runInstall.txt

everycook commented 10 years ago

Enabled the --force option by default on my device. testing it...