Re: Auto Increament

2010-03-25 Thread Ryan King
On Thu, Mar 25, 2010 at 5:57 AM, Jaepil Jeong wrote: > Hi there, > Thanks to all for reply. But I still have a question: > 1. When I using Twtiter via Tweetie which is iPhone application, I can see > the unique ID for each of users in their personal profile page. It seems > like incremental number

Re: Auto Increament

2010-03-25 Thread Tatu Saloranta
On Thu, Mar 25, 2010 at 9:20 AM, Benjamin Black wrote: > Cassandra is not being used to generate the Twitter identifiers. > Twitter, like most places using Cassandra, has more than one database > system in production. > > UUIDs are not at risk of conflicts with billions of rows. Exactly: UUIDs we

Re: Auto Increament

2010-03-25 Thread Benjamin Black
Cassandra is not being used to generate the Twitter identifiers. Twitter, like most places using Cassandra, has more than one database system in production. UUIDs are not at risk of conflicts with billions of rows. b On Thu, Mar 25, 2010 at 5:57 AM, Jaepil Jeong wrote: > Hi there, > Thanks to

Re: Auto Increament

2010-03-25 Thread Jaepil Jeong
Hi there, Thanks to all for reply. But I still have a question: 1. When I using Twtiter via Tweetie which is iPhone application, I can see the unique ID for each of users in their personal profile page. It seems like incremental number. As far as I know, Twitter using Cassandra for its back-end.

Re: Auto Increament

2010-03-24 Thread Muhammed Nasrullah
You replace it with an UUID. In a true scalable distributed system, you should not have an auto_increment. If you are writing to 10 nodes simultaneously, it becomes near impossible to keep a single incrementing value being used by the entire system without causing a lot of write contention. This i

Re: Auto Increament

2010-03-24 Thread Jesus Ibanez
- Where do you get the last inserted column from? - The first result of using get_slice method of thrift, would be the super column with highest value in the name, becouse the configuration of the column family of type super says that the super columns will be decresent ordered (if Cassandra doesn'

Re: Auto Increament

2010-03-24 Thread Peter Chang
It seems that this scheme would suffer under a race condition. On Wed, Mar 24, 2010 at 11:00 AM, Jesus Ibanez wrote: > You can generate UUIDs based on time with http://jug.safehaus.org/ if you > use Java. And its easy to use, just have to insert one line: > UUID uuid = UUIDGenerator.getInstance()

Re: Auto Increament

2010-03-24 Thread Erik Holstad
On Wed, Mar 24, 2010 at 11:00 AM, Jesus Ibanez wrote: > You can generate UUIDs based on time with http://jug.safehaus.org/ if you > use Java. And its easy to use, just have to insert one line: > UUID uuid = UUIDGenerator.getInstance().generateTimeBasedUUID(); > > Maybe a solution to your cuestion:

Re: Auto Increament

2010-03-24 Thread Jesus Ibanez
You can generate UUIDs based on time with http://jug.safehaus.org/ if you use Java. And its easy to use, just have to insert one line: UUID uuid = UUIDGenerator.getInstance().generateTimeBasedUUID(); Maybe a solution to your cuestion: To "replace" the autoincrement of MySQL, you can create a colu

Re: Auto Increament

2010-03-24 Thread Sylvain Lebresne
On Wed, Mar 24, 2010 at 6:22 PM, Jeremy Dunck wrote: > http://en.wikipedia.org/wiki/Uuid > ? Yes sorry, I have copied the link from what google returned me, but it was not the right link apparently. > > On Wed, Mar 24, 2010 at 11:57 AM, Jaepil Jeong wrote: >> Hi there, >> >> I just started rese

Re: Auto Increament

2010-03-24 Thread Sylvain Lebresne
> How can I replace the "auto increament" attribute in MySQL > with Cassandra? You can't. Not easily at least. > If I can't, how can I generate an ID which is globally > unique for each of columns? Check UUIDs: http://en.wikipedia.org/wiki/Universally_Unique_Identifier > > Thanks, > > Sent from

Re: Auto Increament

2010-03-24 Thread Jeremy Dunck
http://en.wikipedia.org/wiki/Uuid ? On Wed, Mar 24, 2010 at 11:57 AM, Jaepil Jeong wrote: > Hi there, > > I just started research about Cassandra to replace MySQL, and I have a > question: How can I replace the "auto increament" attribute in MySQL > with Cassandra? If I can't, how can I generate