Hello Wolfgang, > 2) If i deactivate the units and later activate them the changes made in > this time are lost? (i refer to all the changes, client and master in a > IN/OUT, if i only have out i know i can "send content to client") > > => Yes. You have to do your changes while the application is not running. But > if you change the application tables, shouldn't the application be stopped > anyway?
If i not manually deactivate the units but i have a power failure and i have to reboot a server involved in the replication, do i have to manually activate the sync or it will be activated on reboot if i launch the messageserver and syncservice automatically, i can lost many data if i have to activate this manually after hardware/so failure. > 3) I would like to use sequence numbers in the structure (i have the > possibility to use natural keys but any times with multiple columns, not > too much practical), i have tried but when i create the sequence in the > master it is not replicated in the client so i can not use the sequence > in inserts into the client, can i use sequence numbers? what if about > collision, the numbers that in my design can have a collision are > meaningless because i haver other unique columns so i have no problem in > automatically change them in the two databases if i have collision but i > don't know if i can do it an how. > > => Sequences are not replicated. Only the numeric values generated by them in > a table. So collision can occur for these values. > You should combine the sequence values with some kind of database > identifier. > You have to define the sequence on every client. Ok i will try to design this way. Regards, Miguel Angel. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
