Re: Practical limit on number of column families

2016-03-01 Thread Brian Sam-Bodden
Eric, Is the keyspace as a multitenancy solution as bad as the many tables pattern? Is the memory overhead of keyspaces as heavy as that of tables? Cheers, Brian On Tuesday, March 1, 2016, Eric Stevens wrote: > It's definitely not true for every use case of a large number of tables, > but for

Re: issue in starting cassandra service on mac--plz help

2015-08-22 Thread Brian Sam-Bodden
How did you install Cassandra and what JVM sre you using? On Saturday, August 22, 2015, Gop Krr wrote: > Hi Guys, > Have you seen this issue before? > > Exception in thread "main" java.lang.NoClassDefFoundError: > com/google/inject/AbstractModule > > at java.lang.ClassLoader.defineClass1(Native

Re: Cassandra crashes daily; nothing on the log

2015-06-06 Thread Brian Sam-Bodden
Berk, 1 GB is not enough to run C*, the minimum memory we use on Digital Ocean is 4GB. Cheers, Brian http://integrallis.com On Sat, Jun 6, 2015 at 10:50 AM, wrote: > Hi all, > > I've installed Cassandra on a test server hosted on Digital Ocean. The > server has 1GB RAM, and is running a sing

Re: Is 2.1.5 ready for upgrade?

2015-04-21 Thread Brian Sam-Bodden
Robert, Can you elaborate more please? Cheers, Brian On Tuesday, April 21, 2015, Robert Coli wrote: > On Tue, Apr 21, 2015 at 2:25 PM, Dikang Gu > wrote: > >> We have some issues with streaming in 2.1.2. We find that there are a lot >> of patches in 2.1.5. Is it ready for upgrade? >> > > I per

Re: how to make unique constraints in cassandra

2015-02-28 Thread Brian Sam-Bodden
s correctly is immutable databases or > temporal databases. I would strongly advise against using a key that is a > compound of name+phone+address. If the system needs to perform updates, the > key needs to be immutable so that queries won't fail. > > On Sat, Feb 28, 2015 at 10

Re: how to make unique constraints in cassandra

2015-02-28 Thread Brian Sam-Bodden
As far as I know there is no such thing. You could make that value a single PK for the table therefore guaranteeing uniqueness and check on insert with `IF NOT EXISTS` to prevent dups. Of course that works just for one value, if you have multiple values a compound PK will still let dups in for a gi

Re: Using Cassandra for geospacial search

2015-01-26 Thread Brian Sam-Bodden
ing Cassandra triggers is generally a fairly dangerous proposition, and > generally not recommended.It's probably a better idea to load your > search data with a separate process. > > On Mon, Jan 26, 2015 at 11:42 AM, Brian Sam-Bodden < > bsbod...@integrallis.com>

Re: Using Cassandra for geospacial search

2015-01-26 Thread Brian Sam-Bodden
I did an little experiment with a Geohash/Geocells https://github.com/integrallis/geomodel (a poor port of a Python Geohash librairy) and using Cassandra in a demo using public schools data here https://github.com/integrallis/geomodel-cassandra-demo My conclusions is that you can use the Geohash n

Re: Cassandra schema migrator

2014-12-05 Thread Brian Sam-Bodden
There is also https://github.com/hsgubert/cassandra_migrations On Fri, Dec 5, 2014 at 7:49 AM, Ben Hood <0x6e6...@gmail.com> wrote: > On Tue, Nov 25, 2014 at 12:49 PM, Phil Wise > wrote: > > https://github.com/advancedtelematic/cql-migrate > > Great to see these tools out there! > > Just to add