Hello,
Is there any tool to test the integrity of a snapshot?
Suppose I have a snapshot based backup stored in an external low cost
storage system that I want to restore to a database after someone deleted
important data by mistake.
Before restoring the files, I will truncate the table to remove
Hi Jérôme,
About this concern:
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?"
Make sure to enable snapshot on truncate (cassandra.yaml) or do it
manually. This way if the restored dataset is worst than the curre
Hi,
Nodetool repair always list lots of data and never stays repaired. I think.
>
This might be the reason:
"incremental: true"
Incremental repairs is the default in your version. It marks data as being
repaired in order to only repair each data only once. It is a clever
feature, but with som
Hi Ajay, honestly I would try to fix the main issue:
Sometimes, the cassandra-process gets killed (reason unknown as of now).
As focusing on how to restart Apache Cassandra every minute sounds like a
wrong approach to me:
Adding this in cron would at least ensure that the maximum downtime is 5
Is there any metric or way to find out if any partition has grown beyond a
certain size or certain row count?
If a partition reaches a certain size or limit, I want to stop sending
further write requests to it. Is it possible?
Just a side note: increase system_auth keyspace replication factor if you're
using authentication.
Le Jeudi 12 janvier 2017 14h52, Alain RODRIGUEZ a
écrit :
Hi,
Nodetool repair always list lots of data and never stays repaired. I think.
This might be the reason:
"incremental: tru
My 2 cents,
As I mentioned earlier, we're not currently using snapshots - it's only the
> backups that are bothering me right now.
I believe backups folder is just the new name for the previously called
snapshots folder. But I can be completely wrong, I haven't played that much
with snapshots in
Thanks, Prasenjit, I appreciate the compliment ☺
Kunal, To add to Prasenjit’s comment, it doesn’t make sense to make backups
unless it is moved to secondary storage. This means that if you don’t plan to
move the backups to secondary storage, you should set incremental_backups:
false, and inst
snapshots are slightly different than backups.
In my explanation of the hardlinks created in the backups folder, notice that
compacted sstables, never end up in the backups folder.
On the other hand, a snapshot is meant to represent the data at a particular
moment in time. Thus, the snapshots d
Hi,
Does anyone know if there is a way to record in a log file the queries
total or partial execution time? I am interested in something similar to
the tracing option but on file.
Thanks
Best Regards
Salvatore
Hi Salvatore,
1. Cassandra offers tons of metrics through JMX to monitor performance on
keyspace and CF level
2. There is a config option to log slow queries, unfortunately JIRA is
currently down, so I can't find the ticket with more details
2017-01-12 19:21 GMT+01:00 D. Salvatore :
> Hi,
> Does
You're likely to benefit a lot more if you log query times from your
application, as you can customize the metadata that you add around logging
to increase its relevancy.
On Thu, Jan 12, 2017 at 10:24 AM Benjamin Roth
wrote:
> Hi Salvatore,
>
> 1. Cassandra offers tons of metrics through JMX to
We use QueryLogger which is baked in to the datastax java driver; gives you
basic query execution times (and bind params) in your logs, can be tweaked
using log levels.
On Thu, Jan 12, 2017 at 12:31 PM, Jonathan Haddad wrote:
> You're likely to benefit a lot more if you log query times from your
Hi Shalom,
I also got WriteTimeoutException in my destructive test like your test.
When did you drop a node?
A coordinator node sends a write request to all replicas.
When one of nodes was down while the request is executed, sometimes
WriteTimeOutException happens.
cf. http://www.datastax.com/de
14 matches
Mail list logo
