[lvincent]

okay. thank you so much for the information. well, as of now we don't have an option for synchronization aside from SJA. but i'll try to find an alternative way though.

do you have any idea which might be helpful to us regarding the synchronization of our setup using SJA?

[lvincent]

yes, i do have a local copy of the database in each terminal. it's the only idea i have think of, or if you have any suggestions much better. that idea of this is because, what if the server bugs down, then the local database will be used. and since we have a local database, the only tool that i think that is more reliable is SJA. but were still looking for alternative ways aside frm having a local copy of the database.

i don't really know if having a local database and running SJA is the best option for now but so far it's our only option.

larry 🙂

[lvincent]

thanks for ideas guys but i'm currently running linux and our setup is RH9 and Mysql 5.0.2.. And with regards to the 'rows that will be skip?', how often will it happen? this is not really a good thing for me because we are creating a POS system and at the same time and inventory system for a department store. can sja manage to handle around 25 terminals or even more? all of these will be synch..

would you recommend cron? i haven't tried using this one but i will try and give it a shot, since then it is my only option.

thanks

larry 🙂

[lvincent]

hello guys,

i'm running mysql on RH9. and using sqlyog for data synchronization but i have a problem during ./sja job file, an error occured like this: 'Lost connection to MySQL server during queryCould not connect to TARGET MySQL server'

any idea what should be done? any help is appreciated. thanks in advance.

larry 🙂

[Author]

Posts