Re: Change primary key from int to bigint

2017-01-11 Thread Tom van der Woerdt
there a difference in performance? > > 2017-01-11 9:39 GMT+01:00 Tom van der Woerdt <tom.vanderwoe...@booking.com > >: > >> Hi Benjamin, >> >> bigint and int have incompatible serialization types, so that won't work. >> However, changing to 'varint' will work fine

Re: Change primary key from int to bigint

2017-01-11 Thread Tom van der Woerdt
Hi Benjamin, bigint and int have incompatible serialization types, so that won't work. However, changing to 'varint' will work fine. Hope that helps. Tom On Wed, Jan 11, 2017 at 9:21 AM, Benjamin Roth wrote: > Hi there, > > Does anyone know if there is a hack to

Re: Change primary key from int to bigint

2017-01-11 Thread Tom van der Woerdt
...@jaumo.com> wrote: > But it is safe to change non-primary-key columns from int to varint, right? > > 2017-01-11 10:09 GMT+01:00 Tom van der Woerdt < > tom.vanderwoe...@booking.com>: > >> Actually, come to think of it, there's a subtle serialization difference >

Re: Netty SSL memory leak

2017-05-31 Thread Tom van der Woerdt
Hi John, That's the bug I filed the ticket for, yup. I recommend updating to a newer Cassandra version (3.0.11 or newer), which fixes this issue (and many others). Tom On Wed, May 31, 2017 at 12:39 AM, John Sanda wrote: > I have Cassandra 3.0.9 cluster that is hitting

Unexpected rows in MV after upgrading to 3.0.15

2017-11-03 Thread Tom van der Woerdt
AND max_index_interval = 2048 AND memtable_flush_period_in_ms = 0 AND min_index_interval = 128 AND read_repair_chance = 0.0 AND speculative_retry = '99PERCENTILE'; Tom van der Woerdt Site Reliability Engineer Booking.com B.V. Vijzelstraat 66-80 Amsterdam 1017HL Netherlands

Re: [External] Maximum SSTable size

2018-06-27 Thread Tom van der Woerdt
able Size? > If there is not, does it go up to the maximum Operational System values? > > Thanks in advance, > Lucas Benevides > -- Tom van der Woerdt Site Reliability Engineer Booking.com B.V. Vijzelstraat 66-80 Amsterdam 1017HL Netherlands Direct +31207153426 [image: Booking.com]

Re: Meltdown/Spectre Linux patch - Performance impact on Cassandra?

2018-01-05 Thread Tom van der Woerdt
, and may not be reproducible for production workloads. If you have the infrastructure to test a variety of kernels, I'd be very interested to see your numbers. Thanks, Tom van der Woerdt Site Reliability Engineer Booking.com B.V. Vijzelstraat 66-80 Amsterdam 1017HL Netherlands Direct +31207153426

Re: Decommissioned nodes and FailureDetector

2018-01-19 Thread Tom van der Woerdt
f unreachable racks, so if you only care about nodes you should be able to get rid of most code here. Tom van der Woerdt Site Reliability Engineer Booking.com B.V. Vijzelstraat 66-80 Amsterdam 1017HL Netherlands [image: Booking.com] <http://www.booking.com/> The world's #1 accommodation

Re: [External] Is there any limit in the number of partitions that a table can have

2018-03-07 Thread Tom van der Woerdt
Hi Javier, When our users ask this question, I tend to answer "keep it above a billion". More partitions is better. I'm not aware of any actual limits on partition count. Practically it's almost always limited by the disk space in a server. Tom van der Woerdt Site Reliabilit

Re: [External] Re: Whch version is the best version to run now?

2018-03-05 Thread Tom van der Woerdt
the community wrt patches. This is why I'd recommend 3.11.x for new projects. Stay away from any of the 2.x series, they're going EOL soonish and the newer versions are very stable. Tom van der Woerdt Site Reliability Engineer Booking.com B.V. Vijzelstraat 66-80 Amsterdam 1017HL Netherlands [image

Re: Five Questions for Cassandra Users

2019-03-28 Thread Tom van der Woerdt
inly don't run our clusters manually Tom van der Woerdt Site Reliability Engineer Booking.com B.V. Vijzelstraat 66-80 Amsterdam 1017HL Netherlands [image: Booking.com] <https://www.booking.com/> Empowering people to experience the world since 1996 43 languages, 214+ offices worldwide,

Re: Running and Managing Large Cassandra Clusters

2020-10-28 Thread Tom van der Woerdt
in the automation. Scaling up or down takes a while, but it doesn't appear to be slower than any other cluster. Configuration wise it's no different than a 5-node cluster either. Pretty uneventful tbh. Tom van der Woerdt Senior Site Reliability Engineer Booking.com BV Vijzelstraat Amsterdam Netherlands 1017HL

Re: Running and Managing Large Cassandra Clusters

2020-10-28 Thread Tom van der Woerdt
the small clusters that wake you up ;-) Tom van der Woerdt Senior Site Reliability Engineer Booking.com BV Vijzelstraat Amsterdam Netherlands 1017HL [image: Booking.com] <https://www.booking.com/> Making it easier for everyone to experience the world since 1996 43 languages, 214+ offices wor

Re: Running and Managing Large Cassandra Clusters

2020-10-28 Thread Tom van der Woerdt
single-range repairs. Tom van der Woerdt Senior Site Reliability Engineer Booking.com BV Vijzelstraat Amsterdam Netherlands 1017HL [image: Booking.com] <https://www.booking.com/> Making it easier for everyone to experience the world since 1996 43 languages, 214+ offices worldwide, 141,000+