When a SQL Anywhere 11.0.1 database is participating as the middle level tier in a three-level replication/synchronization structure, and synchronization with the top level is being performed via MobiLink for upload and Replication Server for download, and replication with the bottom level is being performed by SQL Remote, do the two clients dbremote.exe and dbmlsync.exe play nice with respect to the delete_old_logs option on the middle level database? In other words, will they each preserve log files needed by the other? asked 13 Jul '11, 11:22 Breck Carter |
Yes. Logs are only deleted when no subscription (dbremote nor dbmlsync) nor dbltm requires the log. answered 13 Jul '11, 11:37 RussC_FromSAP |
Well, I had used v8 in a three-tier setup (with MobiLink against a MS SQL Server and with SQL Remote against ASA 8 remotes) for years. Option delete_old_logs was (and is) set to "delay". Never had issues with this option. Note that in our case, the ML log truncation point was always higher than the SQL Remote truncation offset so in practise it was SQL Remote's part to delete old logs. Since some time, the MS SQL consolidated could be omitted, and now the system is a simple two-tier setup. Much easier when it comes to schema updates:) answered 13 Jul '11, 11:36 Volker Barth |
Nice tags, BTW:)