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
There are a couple of different approaches you can take depending on your application architecture. You could either create triggers that will copy the data that is being changed into temporary tables to by synchronized with the other server(s), or you could have the application explicitly update both servers at the same time.
John Turnbull
Thunderstone Software
Thunderstone Software
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.