Re: Example Data Modelling

Hi Carlos, Columns in primary key like EmpID can't be static. But remind that EmpID as in the partition key is not duplicated. -- Jérôme Mainaud jer...@mainaud.com 2015-07-07 16:02 GMT+02:00 Carlos Alonso i...@mrcalonso.com: Hi Jerome, Good point!! Really a nice usage of static columns

Re: Example Data Modelling

. When you insert a new month entry you just fill non static columns. The table can be queried the same way as the original one. Cheers -- Jérôme Mainaud jer...@mainaud.com 2015-07-07 11:51 GMT+02:00 Rory Bramwell, DevOp Services rory.bramw...@devopservices.com: Hi, I've been following

Re: Upgrading to SSD

Hello, Maybe you should call « nodetool drain » just before stoping the node. As it flush the memtables, the commitlog will be empty and so easier to move. https://docs.datastax.com/en/cassandra/2.0/cassandra/tools/toolsDrain.html -- Jérôme Mainaud jer...@mainaud.com 2016-04-26 8:44 GMT+02

Re: Why simple replication strategy for system_auth ?

a table that metadata was stored in a different way. -- Jérôme Mainaud jer...@mainaud.com 2016-05-13 12:13 GMT+02:00 Sam Tunnicliffe <s...@beobal.com>: > LocalStrategy means that data is not replicated in the usual way and > remains local to each node. Where it is used, replicati

Why simple replication strategy for system_auth ?

. Do you think that changing the strategy to LocalStrategy would work or have undesirable side effects ? Thank you. -- Jérôme Mainaud jer...@mainaud.com

New node block in autobootstrap

should investigate first ? What would you do to unlock the situation ? Context: The cluster consists of two DC, each with 15 nodes. Average load is around 3 TB per node. The joining node froze a little after 2 TB. Thank you for your help. Cheers, -- Jérôme Mainaud jer...@mainaud.com

Re: nodetool repair with -pr and -dc

Hi Romain, Thank you for your answer, I will open a ticket soon. Best -- Jérôme Mainaud jer...@mainaud.com 2016-08-19 12:16 GMT+02:00 Romain Hardouin <romainh...@yahoo.fr>: > Hi Jérôme, > > The code in 2.2.6 allows -local and -pr: > https://github.com/apache/cassandra/blob/

full and incremental repair consistency

have handled this ? Thank you, -- Jérôme Mainaud jer...@mainaud.com

Re: nodetool repair with -pr and -dc

, it should have been accepted. Did anyone meet this error before ? Thanks -- Jérôme Mainaud jer...@mainaud.com 2016-08-12 1:14 GMT+02:00 kurt Greaves <k...@instaclustr.com>: > -D does not do what you think it does. I've quoted the relevant > documentation from the README: &g

Re: full and incremental repair consistency

ak sstable file immutability, so I wonder how it is stored. -- Jérôme Mainaud jer...@mainaud.com 2016-08-19 15:02 GMT+02:00 Paulo Motta <pauloricard...@gmail.com>: > Running repair with -local flag does not mark sstables as repaired, since > you can't guarantee data in other DCs

Re: full and incremental repair consistency

> - Either way, with or without the flag will actually be equivalent when > none of the sstables are marked as repaired (this will change after the > first inc repair). > So, if I well understand, the repair -full -local command resets the flag of sstables previously repaired. So even if I had

Re: New node block in autobootstrap

the slow safe way. Maybe I could have used it. -- Jérôme Mainaud jer...@mainaud.com 2016-08-15 20:51 GMT+02:00 Paulo Motta <pauloricard...@gmail.com>: > What version are you in? This seems like a typical case were there was a > problem with streaming (hanging, etc), do you

LCS Increasing the sstable size

sstable size lead to any problem I don't see ? Do you have any advice about this ? Thank you. -- Jérôme Mainaud jer...@mainaud.com

Re: LCS Increasing the sstable size

size is 70 KB. So there should not be so many entries per file. Am I missing something ? -- Jérôme Mainaud jer...@mainaud.com 2016-08-31 13:28 GMT+02:00 DuyHai Doan <doanduy...@gmail.com>: > Some random thoughts > > 1) Are they using SSD ? > > 2) If using SSD, I remember th

Partition size estimation formula in 3.0

(values in partition) That is the clustering column values are no more repeated for each regular column in the row. Could anyone confirm me that new formula or am I missing something ? Thank you, -- Jérôme Mainaud jer...@mainaud.com

Check snapshot / sstable integrity

to remove the problematic tombstones. But my Op retains my arm and asks: "Are you sure that the snapshot is safe and will be restored before truncating data we have?" If this scenario is a theoretical, the question is good. How can I verify that a snapshot is clean? Thank you, -- Jérôme M

Re: Check snapshot / sstable integrity

because their backup system corrupted some file in the past and they think with their current backup process in mind. I will insist on the snapshot on truncate that already saved me, and that other checks should be done by the backup tool if any is used. Cheers, -- Jérôme Mainaud jer