Auto number for big data
Assuming you're using a 64 bit system, an INT(eger), 2^64  =   18,446,744,073,709,551,616, so if you have an insert every nanosecond, your system will run out of numbers after approximately 600 years - I wouldn't worry too much! :-)