SQL Anywhere Mobile - A new Configuration setup- Suggestions and Advice required

Author

A new Configuration setup- Suggestions and Advice required

Maggie

2005-04-05, 8:06 pm

HI ,

Would like to know , if the following configuration will
work ,and is it reliable?? Pls suggest and advice us on the
best setup.

1. We have a Mobilink server synchronising from an Oracle
database acting as a Centralised server .
2. Clients connect through a WAN connection to this Mobilink
server for Synchronising from a client application that runs
on an ASA database .
3. This type of synchronisation took more than 3 hours for
the first time synchronisation through WAN , whereas
through LAN , it is only a 3 minutes sync.
4. Hence we have decided to add more servers( wil call them
Host machines) at each bases(locations where the client
could connect through LAN) , that could be used for
synchronisation.

To implement this , we have thought of the following setup :

The Centralised Oracle - Mobilink server will be modified as
Mobilinkserver talks to ASA inturn talks to Oracle -
Mobilink -> ASA -> Oracle.

All Host machines will have a ASA - network server and
Mobilink server installed which will synchronise data from
the Centralised server periodically using a scheduler -
Using WAN connection .
THe host machine here acts as a Client and a server. Is it
possible ??

The Client machines will inturn Synchronise with the Host
machine (ASA)through a LAN .

Expecting a reply at the earliest.

Thanks
Maggie

Greg Fenton

2005-04-05, 8:06 pm

Maggie wrote:
>
> The Centralised Oracle - Mobilink server will be modified as
> Mobilinkserver talks to ASA inturn talks to Oracle -
> Mobilink -> ASA -> Oracle.
>

I'm unclear as to the description of these "host machines".

Are you saying that in each of the remote locations that you will have
an ASA "consolidated" for the remote machines to synchronize to and that
the ASA "consolidated" will periodically synchronize to the Oracle
consolidated?

ASA <-> ML <-> ASA <-> ML <-> Oracle

where the first three nodes (ASA, ML, ASA) are in the remote office and
the last two (ML, Oracle) are in the enterprise consolidated?

If so, then this three-tier system will work just fine. As always there
are some things to keep in mind with respect to data partitioning and
distributed schemas...but these are the same problems you have with a
simple two-tier system.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Maggie

2005-04-06, 7:02 am

HI,
Thanks for the response.
what u said is exactly correct. That is our plan since in
the HTTP network synchronization taking 3 hrs to get
complete the sync. process. In that we have an another issue
also. Say for example.
Enterprice Server ( Oracle ) will be at the Head Office. All
the Sub Station will have that ASA Host server which will
get synchronizaed in the Schedular basis with Oracle Server.
This ASA will act as Synchronizing server for that station.
if one End User is getting synchronized with Base1 today.
tomorrow he will at say Base2. he go there and synchronize
with the Base2 server. Like this they will keep on roaming
around the base and change the server like day basis. they
will come again to the same server for some other day for
the synchronizing. So, I want to know what will happen if
the Client1 will synchronizing with different ASA ( HOST)
Server.
Kindly give me an idea to solve this issue.
Cheers,
Maggie

> Maggie wrote:
>
> I'm unclear as to the description of these "host
> machines".
>
> Are you saying that in each of the remote locations that
> you will have an ASA "consolidated" for the remote
> machines to synchronize to and that the ASA
> "consolidated" will periodically synchronize to the Oracle
> consolidated?
>
> ASA <-> ML <-> ASA <-> ML <-> Oracle
>
>
> where the first three nodes (ASA, ML, ASA) are in the
> remote office and the last two (ML, Oracle) are in the
> enterprise consolidated?
>
> If so, then this three-tier system will work just fine. As
> always there are some things to keep in mind with respect
> to data partitioning and distributed schemas...but these
> are the same problems you have with a simple two-tier
> system.
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

David Fishburn

2005-04-13, 9:24 am

Maggie wrote in news:42537434.5ee6.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

I am afraid your posting is not clear enough.

Perhaps you could re-explain with a sample.
Something along these lines:

Ora1 Ora2
\ /
\ /
\ /
ASA

Insert (pk=100) at Ora1, syncs to ASA.
Insert (pk=101) at Ora2, syncs to ASA.

Now I want pk=101 to show up at Ora1, the following day.

The better your example and description, hopefully the better our
response.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Greg Fenton

2005-04-14, 9:24 am

David Fishburn wrote:
>
> Ora1 Ora2
> \ /
> \ /
> \ /
> ASA
>
>

I believe the picture is more like:

OraCons
/ \
/ \
baseASA1 baseASA2
/\ /\
/ \ / \
fieldASA1 fieldASA2 fieldASA1 fieldASA2

where fieldASA* are remotes that roam between different baseASA's.

Is this right Maggie?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Maggie

2005-04-19, 9:24 am

Yes. Exactly What Greg said is correct.
Pls tell me the solution for this.
> David Fishburn wrote:
>
>
> I believe the picture is more like:
>
> OraCons
> / \
> / \
> baseASA1 baseASA2
> /\ /\
> / \ / \
> fieldASA1 fieldASA2 fieldASA1 fieldASA2
>
>
> where fieldASA* are remotes that roam between different
> baseASA's.
>
> Is this right Maggie?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/

David Fishburn

2005-05-05, 1:24 pm

Maggie wrote in news:42650a50.630a.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

M> Yes. Exactly What Greg said is correct.
M>>
M>> I believe the picture is more like:
M>>
M>> OraCons
M>> / \
M>> / \
M>> baseASA1 baseASA2
M>> /\ /\
M>> / \ / \
M>> fieldASA1 fieldASA2 fieldASA1 fieldASA2
M>>
M>>
M>> where fieldASA* are remotes that roam between different
M>> baseASA's.

Okay, now we have a picture, tell us:
1. Where you perform the inserts.
2. When you run dbmlsync (at which database connection to which ML
server).
3. The results you see.
4. The results you wanted to see.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Maggie

2005-05-09, 3:24 am

Hi,
Thanks for the response.

1. Where you perform the inserts.

From Field to Base initial upload insert should happen. then
it should be uploaded to OraCons. to distribute to all of
the Base Server.

2. When you run dbmlsync (at which database connection to
which ML server).

First Field Box will request for a Sync to Base Server in
which the DBMLSYNC is a Schedular process with OraCons
Server.
This Field Box will sync. with different Base Server for the
different days.( i.e. the nearer base server).

3. The results you see.

We have tried that sync. setup is working now. but
previously when we tried changing the sync. process with
two different Servers ( Database and Mobilink server). Some
time after it was thrown error like progress offset value in
the consolidated in ............. and in the remote is
.............. coz of this sync. get failed. now i could't
stimulate that. when will it throw this error?

4. The results you wanted to see.
All Field,BAse and Consolidate oracle server should be in a
sync. that's is the end result we want to work it out.
Thanks in Advance.
with regds,
Maggie

> Maggie wrote in news:42650a50.630a.1681692777@sybase.com
> of sybase.public.sqlanywhere.mobilink:
>
> M> Yes. Exactly What Greg said is correct.
> M>>
> M>> I believe the picture is more like:
> M>>
> M>> OraCons
> M>> / \
> M>> / \
> M>> baseASA1 baseASA2
> M>> /\ /\
> M>> / \ / \
> M>> fieldASA1 fieldASA2 fieldASA1 fieldASA2
> M>>
> M>>
> M>> where fieldASA* are remotes that roam between
> different M>> baseASA's.
>
> Okay, now we have a picture, tell us:
> 1. Where you perform the inserts.
> 2. When you run dbmlsync (at which database connection to
> which ML
> server).
> 3. The results you see.
> 4. The results you wanted to see.
>
> --
> David Fishburn
> Certified ASA Developer Version 8
> iAnywhere Solutions - Sybase
> Professional Services
> Please only post to the newsgroup
> Please ALWAYS include version and MORE importantly BUILD
> number with EACH post (dbeng9 -v).
>
> EBFs and Maintenance Releases
> http://downloads.sybase.com/swx/sdmain.stm
>
> Developer Community / Whitepapers
> http://www.ianywhere.com/developer
>
> CaseXpress - to report bugs
> http://casexpress.sybase.com
>
> CodeXchange - Free samples
>
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]
>

David Fishburn

2005-05-20, 3:24 am

Maggie wrote in news:427ef23d.7201.1681692777@sybase.com
of sybase.public.sqlanywhere.mobilink:

M> 1. Where you perform the inserts.
M>
M> From Field to Base initial upload insert should happen. then
M> it should be uploaded to OraCons. to distribute to all of
M> the Base Server.

Yes, that is standard behaviour for 3 tiered syncs.

M> 2. When you run dbmlsync (at which database connection to
M> which ML server).
M>
M>
M> First Field Box will request for a Sync to Base Server in
M> which the DBMLSYNC is a Schedular process with OraCons
M> Server.
M> This Field Box will sync. with different Base Server for the
M> different days.( i.e. the nearer base server).

This is an issue. The remote should sync with the *same* Base Server
each time. Any changes uploaded, will eventually make it over to the
other Base Servers (as in 1. above).

You can also use SIS (Server Initiated Sync) to get synchronization to
happen more frequently when required. For example, Base1 will sync to
OraCons, SIS will then tell Base2 new data has arrived an it must sync
right away. This will move the data around very quickly.

M> 3. The results you see.
M>
M> We have tried that sync. setup is working now. but
M> previously when we tried changing the sync. process with
M> two different Servers ( Database and Mobilink server). Some
M> time after it was thrown error like progress offset value in
M> the consolidated in ............. and in the remote is
M> ............. coz of this sync. get failed. now i could't
M> stimulate that. when will it throw this error?

Yes, hence my comment in 2. This can get extremely tricky. Usually
simplier is the way to go.

M> 4. The results you wanted to see.
M> All Field,BAse and Consolidate oracle server should be in a
M> sync. that's is the end result we want to work it out.

And that will work easily if the remotes all sync to 1 assigned Base
Server.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links