[PHP] Re: Synchronizing autonumber fields
hi there, this is typical app for db repliction mechanism. it depnds of the size off your project. have a look here: http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html if this is oversized for u do a dump of each table without the auto_increment fields. if u read in these tables the main database then does use its own record id. to identifie these records use a subsidairy finegerprint field. another way would be not to use a ai field for identifying the record, use a timestamp field to have an unique index on the tables. it is very unlikeley that two records are written at the same time in the various subsidaries. a timestamp field is a breakdown to the milisecond. however there is still a chance of 1 to some billion, that two records have the same key. just some possibilities cheers ralph ralph_def...@yahoo.de Leidago !Noabeb leid...@googlemail.com wrote in message news:5bcf496e0908110004w94d29c2j4b01806822ca0...@mail.gmail.com... Hi I have the following tables setup in MYSQL: Region 1 Region 2 HQ Tbl1 with autonumbered (PK) Tbl1 with autonumbered (PK) Tbl1 autonumbered-PK To explain the above. Basically there are two regions that collect information and then at the end of each month they have to send the information to HQ. This is fine, but the problem comes when the information (the data in the tables) is submitted to HQ. All three tables have the same names and the same structure. We want to synchronize the information sent by the regions into one table at HQ. How can we do this without having the duplicate number problem? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Synchronizing autonumber fields
On Tue, 11 Aug 2009 10:04:52 +0300, Leidago !Noabeb leid...@googlemail.com wrote: Hi I have the following tables setup in MYSQL: Region 1 Region 2 HQ Tbl1 with autonumbered (PK) Tbl1 with autonumbered (PK) Tbl1 autonumbered-PK To explain the above. Basically there are two regions that collect information and then at the end of each month they have to send the information to HQ. This is fine, but the problem comes when the information (the data in the tables) is submitted to HQ. All three tables have the same names and the same structure. We want to synchronize the information sent by the regions into one table at HQ. How can we do this without having the duplicate number problem? Thanks You can change system, so it will increment not by one, but by 2: then Region 1 with have numbers: 1, 3 ,5 , 7 , etc Region 2: 2, 4 ,6, 8 etc then they are going to be easily mixed together. As a bonus - it will be easy to see from where this record came. Only problem - you can do it only on server level, not table level http://forums.mysql.com/read.php?10,269379,269436#msg-269436 -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php