Help - Search - Members - Calendar
Full Version: Looking for debian help
The Planet Forums > General > The Lounge
FarCry
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
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
http://gborg.postgresql.org/project/erserv...projdisplay.php

Haven't tried it, know nothing about it, just recalled I'd seen they'd released it a few months back.

[Edit] this too http://gborg.postgresql.org/genpage?replic...cation_research
Hogie
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.