php - Need best solution to insert data to remote database -


i developing php application using sql database , both application , database hosted on same server(on client server).

we want keep track of tables of database , purpose had created same tables in our side @ different server(vendor server).

what best way insert rows @ remote side tables rows inserted client database tables?

note: rows inserted may 50000 or 50 @ time.

options in front of me:

1) use 2 connections , insert rows in both database , take time have insert rows in large numbers.

2) using curl request remote database , insert data after rows inserted in local database

use mysql built in master/slave setup keep databases in sync each other

http://dev.mysql.com/doc/refman/5.0/en/replication.html


Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -