So you want to migrate the users only? I assumed you wanted to
mirror the whole database...
For users only, I'm not sure. I'm cc'ing this back to the
openinteract-help list so someone more knowledgeable (Chris) can
clear that up.
-Andrew
>that would be the easy way, proovided that
>there are not other tables that I would have to update based on user ids and
>groups and other settings.
>Actually my question is at this level: to import the user from one set-up to
>another one (let's assume I have two OI sites siteA on machineA and siteB on
>machineB) do I have to take care of something else than just the sys_user
>sys_group tables?
>Do I have to update other tables too?
>
>thanks for helping,
>Adrian
>
>_____________________________________________________
>Adrian Arva
>Dolan DNA Learning Center
>phone (5196)
>http://www.dnalc.org/
>
>
>-----Original Message-----
>From: Andrew Hurst [mailto:hur...@ll...]
>Sent: Friday, October 31, 2003 6:12 PM
>To: Arva, Adrian; 'ope...@li...'
>Subject: Re: [Openinteract-help] sync-ing users on 2 machines
>
>
>
>
>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
|
