views:

40

answers:

0

Hi all,

I am currently having two databases that contains same data on two servers. One is a VPS and other one is a reseller account. So, what I want to do is,

  1. Import updated rows in few tables from reseller's database and export them to vps's database via PHP. I can add a 'lastupdate' field to database1 and update it's value when any change has been made.

  2. Import selected tables completely from reseller's db

As I am unable to use MySQL Replication on the reseller account, I am looking for run the above PHP via a cron.

Reason for asking this question:

  1. I am developing an advertising/publishing script.
  2. I am using the reseller's database as front-end database. So, advertisers and publishers are creating/editing on this database.
  3. I am using the vps's database as back-end database. So, it needs to contains most recent data.
  4. I am using backend database to run some high number of queries. (display ads, create real-time logs etc.)
  5. As these two are on different servers, it doesn't matter whether the back-end server is down or etc.
  6. And also it's easy to make changed to front-end or back-end as one is up.

Any help?

Thank you, pnm123