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
data replication
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
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.
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.