Re: Barman equivalent for Cassandra?

There is a community delivered tool named Medusa that may have what you're looking for as well - https://cassandra.tools/medusa Jonathan Lacefield e. jlacefi...@datastax.com w. www.datastax.com schedule a meeting on my calendar <https://calendar.google.com/calendar?

Re: Adding new node to cluster

: datastax_logo.png] Jonathan Lacefield Solution Architect | (404) 822 3487 | jlacefi...@datastax.com [image: linkedin.png] http://www.linkedin.com/in/jlacefield/ [image: facebook.png] https://www.facebook.com/datastax [image: twitter.png] https://twitter.com/datastax [image: g+.png] https

Re: Re: Dynamic Columns

this problem. Or, rethink the design approach and leverage CQL. Please let the mailing list know the direction you choose. Jonathan [image: datastax_logo.png] Jonathan Lacefield Solution Architect | (404) 822 3487 | jlacefi...@datastax.com [image: linkedin.png] http://www.linkedin.com/in/jlacefield

Re: Dynamic Columns

Hello, Have you looked at solving this challenge with clustering columns? Also, please describe the problem set details for more specific advice from this group. Starting new projects on Thrift isn't the recommended approach. Jonathan [image: datastax_logo.png] Jonathan Lacefield

Re: Dynamic Columns

in the archives for a similar discussion topic. Believe this item was asked a few months ago as well. [image: datastax_logo.png] Jonathan Lacefield Solution Architect | (404) 822 3487 | jlacefi...@datastax.com [image: linkedin.png] http://www.linkedin.com/in/jlacefield/ [image: facebook.png] https

Re: High read latency after data volume increased

There's likely 2 things occurring 1) the cfhistograms error is due to https://issues.apache.org/jira/browse/CASSANDRA-8028 Which is resolved in 2.1.3. Looks like voting is under way for 2.1.3. As rcoli mentioned, you are running the latest open source of C* which should be treated as beta until

Re: 100% CPU utilization, ParNew and never completing compactions

you think you have a lot of tombstones in that one particular table? [1] https://issues.apache.org/jira/browse/CASSANDRA-8447 [2] https://issues.apache.org/jira/browse/CASSANDRA-8485 Jonathan [image: datastax_logo.png] Jonathan Lacefield Solution Architect | (404) 822 3487 | jlacefi

Re: Better option to load data to cassandra

Here's another post which is pretty comprehensive for this topic. http://informationsurvival.blogspot.com/2014/02/cassandra-cql3-integration.html [image: datastax_logo.png] Jonathan Lacefield Solution Architect | (404) 822 3487 | jlacefi...@datastax.com [image: linkedin.png] http

Re: Load balancing in C* Cluster

/drivers/introduction/introArchOverview_c.html [2] https://github.com/Netflix/astyanax Thanks, Jonathan [image: datastax_logo.png] Jonathan Lacefield Solution Architect | (404) 822 3487 | jlacefi...@datastax.com [image: linkedin.png] http://www.linkedin.com/in/jlacefield/ [image: facebook.png

Re: Wide Rows - Data Model Design

Hello, Yes, this is a wide row table design. The first col is your Partition Key. The remaining 2 cols are clustering cols. You will receive ordered result sets based on client_name, record_date when running that query. Jonathan [image: datastax_logo.png] Jonathan Lacefield Solution

Re: horizontal query scaling issues follow on

/ -- Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/cassandrasummit14

Re: keyspace with hundreds of columnfamilies

Hello There is overhead for memory with each col family. This type of configuration could cause heap issues. What is driving the requirement for so many Cfs? On Jul 2, 2014, at 4:14 AM, tommaso barbugli tbarbu...@gmail.com wrote: Hi, Are there any known issues, shortcomings about

Re: restarting node makes cpu load of the entire cluster to raise

with this one. It may take some hands-on investigation or maybe someone else in the community has experienced this issue and can provide feedback. Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com

Re: restarting node makes cpu load of the entire cluster to raise

Hello Have you checked the log file to see what's happening during startup ? What caused the rolling restart? Did you preform an upgrade or change a config? On Jun 18, 2014, at 5:40 AM, Alain RODRIGUEZ arodr...@gmail.com wrote: Hi guys Using 1.2.11, when I try to rolling restart the

Re: Configuring all nodes as seeds

/ops_replace_seed_node.html Take this into consideration, coupled with the fact that nodes will require replacing along the way, when determining the right number of seeds to use per cluster. Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http

Re: restarting node makes cpu load of the entire cluster to raise

or drain before stopping and starting Cassandra. This will flush memtables and clear your log segments. Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/cassandrasummit14 On Wed, Jun 18, 2014 at 8:05 AM, Alain RODRIGUEZ

Re: Cannot query secondary index

with your load. You have such a special use case for this functionality that the little, in frequent, performance hit outweighs the complexity of implementing options 1 and 3. Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield

Re: Cannot query secondary index

Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/cassandrasummit14 On Mon, Jun 9, 2014 at 5:18 PM, Redmumba redmu...@gmail.com wrote: I have a table with a timestamp column on it; however, when I try to query based

Re: Cannot query secondary index

Hello, Will you please describe the use case and what you are trying to model. What are some questions/queries that you would like to serve via Cassandra. This will help the community help you a little better. Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http

Re: Query first 1 columns for each partitioning keys in CQL?

Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/cassandrasummit14 On Fri, May 16, 2014 at 12:23 AM, Matope Ono matope@gmail.com wrote: Hi, I'm modeling some queries in CQL3. I'd like to query first 1 columns for each

Re: cassandra snapshots

configurations which could have been set for your cluster. http://www.datastax.com/documentation/cassandra/2.0/cassandra/configuration/configCassandra_yaml_r.html Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/cassandrasummit14

Re: row caching for frequently updated column

the ability to preheat key and page cache, but I don't believe this is possible for row cache. Hope that helps. Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/cassandrasummit14 On Mon, Apr 28, 2014

Re: How safe is nodetool move in 1.2 ?

Assuming you have enough nodes not undergoing move to meet your CL requirements, then yes, your cluster will still accept reads and writes. However, it's always good to test this before doing it in production to ensure your cluster and app will function as designed. Jonathan Lacefield Solutions

Re: List and Cancel running queries

No. This is not possible today On Apr 11, 2014, at 1:19 AM, Richard Jennings richardjenni...@gmail.com wrote: Is it possible to list all running queries on a Cassandra cluster ? Is it possible to cancel a running query on a Cassandra cluster? Regards

Re: Point in Time Recovery

Hello, Have you tried the procedure documented here: http://www.datastax.com/documentation/cassandra/1.2/cassandra/configuration/configLogArchive_t.html Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http

Re: Apache cassandra not joining cluster ring

Hello The nodetool status that you mentioned, was that executed on the 4th node itself? Also What does netstat display? Are the correct ports listening on that node? Per opscenter, What version of opscenter are you using? Are you able to manually start the agents on the nodes

Re: Per-keyspace partitioners?

Hello, Partitioner is per cluster. We have seen users create separate clusters for items like this, but that's an edge case. Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/cassandrasummit14 On Wed

Re: Auto-Bootstrap not Auto-Bootstrapping?

Hello Not sure I follow the auto bootstrap question, but seeds are only used on startup. Also, what do you mean by convert the node to a seed node? You could simply add the 4th node IP address to the seed list of the other nodes in the .yaml file. Hope that helps Jonathan On Apr 7,

Re: Question about how compaction and partition keys interact

advantage to your query access times. Hope that helps and if not, maybe someone else can provide the answer to your specific question regarding the impacts of your model on compaction. Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com

Re: Question about how compaction and partition keys interact

consider partitioning simply on customer and using date and type as clustering keys? Hope that helps. Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services/training/virtual

Re: need help with Cassandra 1.2 Full GCing -- output of jmap histogram

Sorry to hear about the frustration. How often are you deleting data/what are you setting for ttl on cols? Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services/training/virtual-training

Re: No output.log is ever generated

. Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services/training/virtual-training On Mon, Mar 24, 2014 at 8:26 AM, user 01 user...@gmail.com wrote: Hints please, anyone ? On Mon

Re: Relation between Atomic Batches and Consistency Level

for execution Hope this helps. I believe this is the best i can do for you at the moment. Thanks, Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services/training/virtual-training On Mon, Mar 17

Re: How to extract information from commit log?

versions of partitions. Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services/training/virtual-training On Tue, Mar 18, 2014 at 2:25 PM, Han,Meng meng...@ufl.edu wrote: Hi

Re: Relation between Atomic Batches and Consistency Level

records contained in the batch, you will read results of partially updated batches. Taking this into account for your second question, you should expect that your read CL will preform as it would for any individual row mutation. Hope this helps. Jonathan Jonathan Lacefield Solutions Architect

Re: Multi-site Active-Active replication - Preparing Sites - Cluster Name and Snitch

actually. 4) Yes, all Keyspaces should be updated as a part of this process. Hope that helps. Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services/training/virtual-training On Sun, Mar 16

Re: Relation between Atomic Batches and Consistency Level

that helps. Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services/training/virtual-training On Mon, Mar 17, 2014 at 1:38 PM, Drew Kutcharian d...@venarc.com wrote: Hi

Re: DSE Hadoop support for provisioning hardware

Hello, Not sure this question is appropriate for the Open Source C* users group. If you would like, please email me directly to discuss DataStax specific items. Thanks, Jonathan jlacefi...@datastax.om Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com

Re: need help with Cassandra 1.2 Full GCing -- output of jmap histogram

be running into this with the older version of Cassandra: https://issues.apache.org/jira/browse/CASSANDRA-6541 Hope this helps. Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services

Re: Backup/Restore in Cassandra

documentation for backup and restore - http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_backup_restore_c.html Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer

Re: replication_factor: ?

a 3 node cluster with an RF 2, then 2 copies of data would exist on each node., i.e. you would have 2 copies of data in your cluster. Hope that helps. Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer

Re: read one -- internal behavior

message to [ip address]' for each of the replicas. On Fri, Mar 7, 2014 at 5:44 PM, Jonathan Lacefield jlacefi...@datastax.comwrote: B is the answer On Mar 7, 2014, at 7:35 PM, James Lyons james.ly...@gmail.com wrote: I'm wondering about the following scenario. Consider a cluster of nodes

Re: Cassandra nodetool status result after restoring snapshot

using Opscenter? A quick comparison of cfstats between clusters may help you analyze your situation and help you pinpoint if you are missing any data for a particular keyspace, etc as well. Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com

Re: Cassandra Version History

Hello, Check out the full version list here: https://issues.apache.org/jira/browse/CASSANDRA?selectedTab=com.atlassian.jira.plugin.system.project:versions-panelsubset=-1 Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http

Re: Worse perf after Row Caching version 1.2.5:

Hello, Please paste the output of cfhistograms for these tables. Also, what does your environment look like, number of nodes, disk drive configs, memory, C* version, etc. Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield

Re: Help me on Cassandra Data Modelling

combination in every Tag partition, i.e. if a tag combination has 2 parts, then you will have 2 rows Hope this helps. Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services/training/virtual

Re: GC eden filled instantly (any size). Dropping messages.

are the result of the Data Model or access patterns based on the results of CFHistograms 3) What does tpstats look like? Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/what-we-offer/products-services

Re: Tracking word frequencies

reads with Cassanda. This can be done through tuning, data modeling, and/or scaling. Please post a cfhistograms for this table as well as provide some details on the specific queries you are running. Thanks, Jonathan Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http