Re: [midgard-user] An alternate means of staging a midgard site?

[Vincent]

pp wrote:
Vincent <[EMAIL PROTECTED]> wrote:


Hello,
I was wondering if anyone has looked into using mysql's db replication
feature as an alternative means of staging a midgard site. What I was 
thinking having the "live" midgard db acting as a slave database server
to the development one.  Manual updates could be done with
SLAVE START|STOP commands on the mysql slave server.


This will replicate all DB , while repligard may replicate some part of DB.


actually you can limit replication to a database or table in mysql 4.0x 
with the following options.

replicate-do-table=db_name.table_name # limit to table(s)
replicate-do-db=database_name # limit to database(s)




The only problem 
would be blob files 

maybe these could be handled with an rsync?

That's why repligard is good :)


and the cache (if used).


It is not repligard related. Well..... using MASTER|SLAVE feature
for cache table will make Your site very unstable IMHO.

I'm still not convinced it's crazy yet.





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]