On 22 Mar, Emiliano Heyns wrote:
> Correct. Henri mentioned some scripts a long while ago used for
> copying only specific sites. These could be useful to put up on
> the Midgard site but I don't know how specific to his situation
> they are.

Yes, we've been running partial replication from our
internal Web server to an external one regularly 
(every five minutes if the database has been modified)
since late October. The system works ok, but has some
setbacks that have made developing Repligard into usable
state a quite high priority for us.

The current system works so that we have a Perl script
on the internal server that runs mysqldump, and then
removes all internal content (based by location of the
DB entries in Midgard's tree structures) from the dump,
then checks whether it has changed from last replication.

If it has, it is then transferred to our external server,
where we have another script which monitors the arrivals
of new database dumps. We also have two different Midgard
databases running there, of which one is being used by
Apache at a time.

When a dump arrives, the script copies it over the Midgard
database which isn't being used, and restarts Apache with
Midgard using that database instead.

This is messy, but it works. The main problem is that every
once in the while, the Apache fails to get the MySQL 
interface opened, and then our site is down. Of course,
this all goes into the "don't try this at home" department.

>> About when will these tools be available?
> 
> The plans for this utility (repligard) were discussed briefly on
> midgard-dev: http://marc.theaimsgroup.com/?t=95261805700001&w=2&r=1

At the moment, most of one-way Repligard works and is
available from the CVS. However, I'm quite sure that 
the CVS version isn't now in a compilable shape, and 
so getting Repligard to work right now will require 
some C programming experience.

By what we've been discussing on midgard-dev, we
hope to have the third beta available sometime within
a month, and that should contain Repligard (as well
as some other nice additions, like the SiteGroups).

We have two servers at Stonesoft doing test Replication
with a 25MB Midgard database and some Apache load, and
we'll be looking at the results with Jukka tomorrow. 
If  things have worked nicely, we'll move the system 
into production soon. I'll let you know about our 
experiences.

> Emile

/Bergie

-- 
-- Henri Bergius -- +358 40 525 1334 -- [EMAIL PROTECTED] --
               http://www.iki.fi/Henri.Bergius


--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org

To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]

Reply via email to