Jump to content


Photo

Mirroring 2 databases


  • Please log in to reply
1 reply to this topic

#1 Geelwortel

Geelwortel
  • Members
  • Pip
  • Newbie
  • 3 posts
  • LocationJohannesburg, South Africa

Posted 10 September 2003 - 09:47 AM

Hi All

On my site I have a form where web users capture a CV and send it to my DB. My consultants go and prosess that CV and do alot to that CV and then look for work for those people. To minimize the load on my DB/Server I want a server for my Web users and a server for my Consultants.These servers will be dedicated DB Servers. Where my problem starts is how do I get these 2 DB\'s to automatically update each other every +- 30mins to 60mins.

Any help will be much appreciated.

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 10 September 2003 - 02:21 PM

if the mirrored is only used for SELECT statements, you can setup a service (windows) or a cronjob (unix) that runs every X minutes and copies the database over.

if they are both being updated, i can only guess to use mysqldump because i believe it ignores duplicates. let me know what you find.
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users