FarCry
Oct 19 2004, 12:10 AM
Im looking for a way that i can replicate the database (PostgreSQL/MySQL) across to a remote system, this would also need to include core system configs as well as apache and the web docs. Im not much of a debian guru so i have no idea.
Is there a way to perhaps update changes immediately?
klaude
Oct 19 2004, 08:28 AM
You can use rsync to keep your web docs and configs the same across your servers. Rsync won't work well for database data. For that I'd use a dedicated db server.
mmentior
Oct 19 2004, 08:40 AM
Hogie
Oct 19 2004, 08:42 AM
mysql has built in replication you can setup to replicate all the data to another server in real time. Another thing is the mysqldump command line tool. You can have it make snapshots of all the databases into a .sql file, and just gzip it then rsync.