Re: [Openinteract-help] sync-ing users on 2 machines

[Andrew H. <hur...@ll...>]

Assuming you're using mysql, why not just nightly run a mysqldump job 
to update the standby server?

(on standby server)
$ mysqldump -u backup_user -h prod_host -p prod_database > backup_db.sql
$ mysql -u backup_user -h backup_host -p backup_database < backup-db.sql

You could even run that hourly, but I'm not sure of the affect of 
that on site performance.  I'm sure it depends on the size of the 
database.

Or you could use mysql replication, which I think slashdot uses to good effect.

Or you could use Oracle, which provides standby functionality out of 
the box for 8i and up.

I think the first would be best for most small to mid-size sites.

-Andrew


At 3:54 PM -0500 10/31/03, Arva, Adrian wrote:
>Hi,
>
>I have to systems, based on OI1, set up and the second one should act as
>standby server.
>But that means I would need to be able to mirror the users I have in first
>system to the second one.
>I let users register, so on a daily basis I would have to mirror their data
>from the live site to the standby one but
>I am worried that it won't be enough to just simply sync the sys_user
>tables.
>
>Thanks for your inputs,
>Adrian
>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: SF.net Giveback Program.
>Does SourceForge.net help you be more productive?  Does it
>help you create better code?   SHARE THE LOVE, and help us help
>YOU!  Click Here: http://sourceforge.net/donate/
>_______________________________________________
>openinteract-help mailing list
>ope...@li...
>https://lists.sourceforge.net/lists/listinfo/openinteract-help