For any website just starting out, the load initially is minimal & grows
with a slow pace initially. People usually start with their MySQL based
sites with a single server(***that too a VPS not a dedicated server)
running as both app server as well as DB server & usually get too far with
this setu
Hi All,
We have just installed 3 nodes in QA with DSE version 3.1, I can see in JMX
that the version installed is 3.1.1 to be precise. When our application start
we see this error message from the java-datastax driver 1.0.2 :
No rpc_address found for host /X.X.X.3 in node3/X.X.X.3's peers syst
We have 700.000 rows.
I've indexed "salary","age" and "gender" attrs.
Take about 20 minutes.
2013/8/27 Alain RODRIGUEZ
> Can you send us the result of a "describe columnfamily users" ?
>
> How many rows are presents in this table ?
>
> Do you have indexes defined ?
>
> What is a "long time" exa
Hi Takenori,
I can't tell for sure without knowing what kind of data you have and how
much you have.You can use the random partitioner and use the concept of
metadata row that stores the row key, as for example like below
{metadata_row}: key1 | key2 | key3
key1:column1 | column2
When you do the
On 2013-08-27, at 6:04 AM, Aklin_81 wrote:
> For any website just starting out, the load initially is minimal & grows with
> a slow pace initially. People usually start with their MySQL based sites
> with a single server(***that too a VPS not a dedicated server) running as
> both app server
I agree. I ran into a issue where I ran a single instance and the server was
shut down (without stopping cassandra) and for some reason I lost the database
schema. I was back up quickly only because I had scripts to create the schema
and a backup of the data to load once the schema was created.
On Tue, Aug 27, 2013 at 3:04 AM, Aklin_81 wrote:
> But so far what I have seen, it's something very different with Cassandra.
> People usually recommend starting out with atleast a 3 node cluster, (on
> dedicated servers) with lots & lots of RAM. 4GB or 8GB RAM is what they
> suggest to start wit
On Fri, Aug 23, 2013 at 5:53 AM, Sávio Teles wrote:
> I need to perform range query efficiently.
>
...
> This query takes a long time to run. Any ideas to perform it efficiently?
>
Use a database that is designed for efficient range queries? ;D
=Rob
>
> Use a database that is designed for efficient range queries? ;D
>
Is there no way to do this with Cassandra? Like using Hive, Sorl...
2013/8/27 Robert Coli
> On Fri, Aug 23, 2013 at 5:53 AM, Sávio Teles
> wrote:
>
>> I need to perform range query efficiently.
>>
> ...
>
>> This query take
For such queries, looks like you may create a composite key as
(user_id,age, salary).
Too much indexing always kills(irrespective of RDBMS or NoSQL). Remember
every search request on secondary indexes will be passed on each node in
ring.
-Vivek
On Tue, Aug 27, 2013 at 11:11 PM, Sávio Teles
wrote
Vivek, using a composite key, how would be the query?
2013/8/27 Vivek Mishra
> For such queries, looks like you may create a composite key as
> (user_id,age, salary).
>
> Too much indexing always kills(irrespective of RDBMS or NoSQL). Remember
> every search request on secondary indexes will be
I had a 4 node cluster running C* 1.2.4. I am testing some client code for
adding/removing nodes to/from the cluster. I decommissioned 3 nodes. I only
have one node now; however, the system.peers table still has rows for two
of the nodes that were decommissioned. nodetool status only reports the on
Forgot to mention before, the host_id column is null for one of the rows.
Running nodetool removenode on the other one failed. StorageService threw
an exception because it could not find the host id (of the decommissioned
node with the non-null host_id in system.peers).
On Tuesday, August 27, 2013
Hi Manoj,
Thanks for your advise.
More or less, basically we do the same. As you pointed out, we now face
with many cases that can not be solved by data modeling, and which are
reaching to 100 millions of columns.
We can split them down to multiple pieces of metadata rows, but that will
bring mo
If you are comfortable with the Cassandra data model, you understand how a
QUORUM read and write work at various replication factors and you think that
the growth of your dataset will somewhat fast as Rob mentioned. Go for it!
Just remember to always benchmark performance and test what happens w
Hi,
I am trying to setup a two node Cassandra cluster
Able to start the first node, but not seeing the following exception while
starting the second node
ERROR 17:31:34,315 Exception encountered during startup
java.lang.IllegalStateException: Unable to contact any seeds!
at
org.apache.ca
You would need to configure rpc_address also with hostname/ips on both the
nodes.
Naresh
On Wed, Aug 28, 2013 at 10:15 AM, Dinesh wrote:
> Hi,
>
> I am trying to setup a two node Cassandra cluster
>
> Able to start the first node, but not seeing the following exception while
> starting the seco
Just saw that you already have data populated, so i guess modifying for
composite key may not work for you.
-Vivek
On Tue, Aug 27, 2013 at 11:55 PM, Sávio Teles
wrote:
> Vivek, using a composite key, how would be the query?
>
>
> 2013/8/27 Vivek Mishra
>
>> For such queries, looks like you may
In my case rpc_address in both the nodes is set to 0.0.0.0 which means it
listens on all interfaces. it has a larger scope (to listen on all
localhost, ipv4, hostnames, ipv6 addresses) than providing just the
hostname/ipv4 addresses
anyway I initially checked that, but it's the same exception I go
hi all:
Regards
Still i can resolve this issue. .
does anybody have this issue or try to test this simple example?
i am stumped I can not find a solution working.
I appreciate any comment or help
2013/8/22 Miguel Angel Martin junquera
> hi all:
>
>
>
>
> I,m testing the new CqlStorag
20 matches
Mail list logo
