phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ash N <742...@gmail.com>
Subject Re: Sequences vs UUID's
Date Fri, 05 May 2017 07:15:53 GMT
Could any please help with guidance for the below or point me to any
documents?

Thanks


On May 3, 2017 1:01 AM, "Ash N" <742000@gmail.com> wrote:

John,

Thank you so much for responding.  Appreciate the link to ppt.  Something I
could not find. but read about snowflake
  I was looking for guidance on the sequence numbers vs UUID approach.

Could I use sequence numbers ?  are the gaps in the sequence numbers ever
back filled?
There is not much documentation on how it works.  If some one explains, I
will be more happy to update the documentation.


thanks again,
-ash

On Wed, May 3, 2017 at 12:51 AM, John Leach <jleach4@gmail.com> wrote:

> Ash,
>
> I built one a while back based on twitter’s snowflake algorithm.
>
> Here is a link to a presentation from twitter on it…
>
> https://www.slideshare.net/davegardnerisme/unique-id-generat
> ion-in-distributed-systems
>
> We used it as the primary key for the table when in essence there was not
> a primary key (just needed uniqueness).
>
> Good luck.
>
> Regards,
> John Leach
>
> On May 2, 2017, at 6:46 PM, Ash N <742000@gmail.com> wrote:
>
> Hello,
>
> Distributed web application.  Millions of users connecting to the site.
>
> we are receiving about 150,000 events/ sec through Kinesis Stream.
> We need to store these events in a phoenix table identified by an ID the
> primary for the table.
>
> what is the best way to accomplish this?
>
> Option 1
> I played with sequences and they seem to work well.  Although with lot of
> gaps.
> will the gaps be filled at all?  if not we will run out of IDs pretty soon.
>
> Option 2
> UUIDs.
>
> What is the best way to generate UUID's local or network?
>
> How are folks typically handling this situation?
>
> which route is recommended Sequences or UUIDs?
>
> thanks,
> -ash
>
>
>
>
>

Mime
View raw message