Re: Log application Queries

2018-06-05 Thread Luigi Tagliamonte
I implemented an audit query handler that archives the queries in ES here: https://github.com/ltagliamonte/cassandra-audit PRs are welcome! On Mon, May 28, 2018 at 1:55 AM, Horia Mocioi wrote: > Hello, > > Another way to do it would be to create your own QueryHandler: > >- create a class tha

Re: inexistent columns familes

2018-04-17 Thread Luigi Tagliamonte
got it thanks! will have to tackle this in another way. Thank you. Regards L. On Tue, Apr 17, 2018 at 1:58 PM, Jeff Jirsa wrote: > I imagine 3.0.16 has THIS bug, but it has far fewer other real bugs. > > > > On Tue, Apr 17, 2018 at 1:56 PM, Luigi Tagliamonte < > luigi.ta

Re: inexistent columns familes

2018-04-17 Thread Luigi Tagliamonte
ry. It's not great, but it's not going to > cause you any problems. > > That said: 3.0.11 may cause you problems, you should strongly consider > 3.0.16 instead. > > On Tue, Apr 17, 2018 at 1:47 PM, Luigi Tagliamonte < > luigi.tagliamont...@gmail.com> wrote: >

inexistent columns familes

2018-04-17 Thread Luigi Tagliamonte
Hello everybody, i'm having a problem with a brand new cassandra:3.0.11 node. The following tables belonging to the system keyspace: - schema_aggregates - schema_columnfamilies - schema_columns - schema_functions - schema_keyspaces - schema_triggers - schema_usertypes get initialised on disk: *

Re: [Question] Automated cluster cleanup

2017-04-27 Thread Luigi Tagliamonte
and it has included remote code execution > vulns. So ensure you lock down JMX thoroughly (password/username auth, > certification auth, fw rules etc). > > For the other most common management, repairs, check out Cassandra reaper > https://github.com/thelastpickle/cassandra-reaper. >

[Question] Automated cluster cleanup

2017-04-27 Thread Luigi Tagliamonte
Hello Cassandra users, my cluster is getting bigger and I was looking into automating some tedious operations like the node cleanup after adding a new node to the cluster. I gave a quick search and I didn't find any good available option, so I decided to look into the JMX interface (In the storage

restore cassandra snapshots on a smaller cluster

2016-05-17 Thread Luigi Tagliamonte
Hi everyone, i'm wondering if it is possible to restore all the snapshots of a cluster (10 nodes) in a smaller cluster (3 nodes)? If yes how to do it? -- Luigi --- “The only way to get smarter is by playing a smarter opponent.”

Re: Cassandra Cleanup and disk space

2015-11-26 Thread Luigi Tagliamonte
tware Engineer | @calonso <https://twitter.com/calonso> > > On 26 November 2015 at 08:55, Luigi Tagliamonte wrote: > >> Hi Everyone, >> I'd like to understand what cleanup does on a running cluster when there >> is no cluster topology change, i did a test and i

Cassandra Cleanup and disk space

2015-11-26 Thread Luigi Tagliamonte
Hi Everyone, I'd like to understand what cleanup does on a running cluster when there is no cluster topology change, i did a test and i saw the cluster disk space shrink of 200GB. I'm using cassandra 2.1.9. -- Luigi --- “The only way to get smarter is by playing a smarter opponent.”

Re: Re : Data restore to a new cluster

2015-10-29 Thread Luigi Tagliamonte
+1 also interested about an official documentation about this. On Mon, Oct 26, 2015 at 5:12 PM, sai krishnam raju potturi < pskraj...@gmail.com> wrote: > hi; >we are working on a data backup and restore procedure to a new cluster. > We are following the datastax documentation. It mentions a

Re: What is your backup strategy for Cassandra?

2015-09-24 Thread Luigi Tagliamonte
Since I'm running on AWS we wrote a script that for each column performs a snapshot and sync it on S3, and at the end of the script i'm also grabbing the node tokens and store them on S3. In case of restore i will use this procedure