Page 1 of 1

data replication

Posted: Mon Apr 30, 2001 1:25 pm
by MiniMe
I need to be able to keep Texis Databases sync'd between two servers.. What is the best method to do this.. My database has 15 million rows and is about 9 gigabytes.

data replication

Posted: Thu May 15, 2003 1:36 pm
by parker0
John, could you explain how to "have the application explicitly update both servers at the same time?" Is this a function of webinator?

data replication

Posted: Thu May 15, 2003 2:17 pm
by mark
One way...
Where you do
<sql "insert ... values(counter,$Url,$Text)">
you would also do
<strfmt "id=%U&Url=%U&Text=%U" $id $Url $Text>
<submit url=http://othermachine/texis/replicator.txt method=POST data=$ret content-type="application/x-www-form-urlencoded">
Similarly for updates and deletes.

Replication is not built into Webinator.