Saturday, August 3, 2013

UUID vs customer Primary Key

Hello,

I am developing an application for 5 different locations.

Each location will have it's own mysql server and application will manually copy each record to Master Server which is VPS.

Please suggest me best way to use Primary Key.
Option 1.
Location based Primary key e.g. Location 1 will have A001 Record and Location 2 will have B001
Option 2.
uuid. I am confused that UUID will be unique across all servers?

Thanks & Regards,
Sanjeev Divekar

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments: