Thats correct. It was a read consistency problem, not so smart of me ;-)
Thank you anyway.
2011/10/27 Jonathan Ellis jbel...@gmail.com
(I see that you did start a new thread and solved it with Jake's help.)
On Thu, Oct 27, 2011 at 11:23 AM, Jonathan Ellis jbel...@gmail.com
wrote:
Ha. On
Is it true that you can also just get the same results as when you pick a
UTF8 key with this content:
keyA:keyB
Of should you really use the composite keys? If so, what is the big
advantage of composite over combined utf-8 keys?
Robin
2011/12/21 Sylvain Lebresne sylv...@datastax.com
On Tue,
I would suggest you to create a CF with a single row (or multiple for
historical data) with a date as key (utf8, e.g. 2011-12-22) and multiple
columns for every user's score. The column (utf8) would then be the score +
something unique of the user (e.g. hex representation of the TimeUUID). The
As a starter I also fully agree with this suggestion. You could submit it
as feature request to the Cassandra JIRA.
2011/12/12 Stephen Pope stephen.p...@quest.com
I’d like to second this. I’ve been working with Cassandra for a good
while now, but when I first started little things like this
You might consider a hybrid solution with a transactional db for all data
that should be ACID complient and Cassandra for the huge amounts of data
you want to store.
2011/12/27 Radim Kolar h...@sendmail.cz
makes me feel disappointed about consistency in Cassandra, but I wonder is
there is a
@Aaron: Small side question, when do columns with a past TTL get removed?
On a repair, (minor) compaction, or .. ? Does it have a performance drop if
that's happening?
2012/1/2 aaron morton aa...@thelastpickle.com
Even if you had compaction enforcing a limit on the number of columns in a
row,
Hi there,
I'm running a cassandra 0.8.6 cluster with 2 nodes (in 2 DC's), RF = 2.
Actual data on the nodes is only 1GB. Disk latency 1ms. Disk throughput ~
0.4MB/s. OS load always below 1 (on a 8 core machine with 16GB ram).
When I'm running my writes against the cluster with cl = ONE all reads
As I posted this I noticed that the other node's CPU is running high on
some other cronjobs (every couple of minutes to 60% usage). Is the lack of
more CPU cycles a problem in this case?
Robin
2012/1/5 R. Verlangen ro...@us2.nl
CPU is idle ( 10% usage). Disk reads occasionally blocks over 32
?
2012/1/5 R. Verlangen ro...@us2.nl
As I posted this I noticed that the other node's CPU is running high on
some other cronjobs (every couple of minutes to 60% usage). Is the lack of
more CPU cycles a problem in this case?
Robin
2012/1/5 R. Verlangen ro...@us2.nl
CPU is idle ( 10% usage
it
can't act as a coordinator fast enough.
2012/1/5 R. Verlangen ro...@us2.nl
I'm also reading with CL = ONE
2012/1/5 Philippe watche...@gmail.com
Depending on the CL you're reading at it will yes : if the CL requires
that the slow node create a digest of the data and send
which would validate my hypothesis.
2012/1/5 R. Verlangen ro...@us2.nl
It does not appear to affect the response time, certainly not in a
positive way.
2012/1/5 Philippe watche...@gmail.com
What if you shutdown the cassandra service on the slow node, does that
improve your read
Try this:
create keyspace testkeyspace;
update keyspace testkeyspace with placement_strategy =
'org.apache.cassandra.locator.SimpleStrategy' and strategy_options =
{replication_factor:3};
Good luck!
2012/1/6 Sajith Kariyawasam saj...@gmail.com
Hi all,
I tried creating a keyspace with the
You might consider:
- installing DataStax OpsCenter ( http://www.datastax.com/products/opscenter
)
- starting the repair in a linux screen (so you can attach to the screen
from another location)
I prefer the OpsCener.
2012/1/6 Maxim Potekhin potek...@bnl.gov
Suppose I start a repair on one or
My suggestion is simple: don't use any deprecated stuff out there. In
practically any case there is a good reason why it's deprecated.
I've seen a couple of composite-column vs supercolumn discussions in the
past weeks here: I think a little bit of searching will get you around.
Cheers
2012/1/7
the output, with additional timestamps if
needed,
to a log file -- which I can access remotely. I just thought there would
be some status
command by chance, to tell me what maintenance the node is doing. Too bad
there is not!
Maxim
On 1/6/2012 5:40 PM, R. Verlangen wrote:
You might consider
A null response is most of the times an exception, try to take a look at
the Cassandra logs to find out what causes the problem.
2012/1/9 cbert...@libero.it cbert...@libero.it
I was just trying it but ... in 0.7 CLI there is no show schema command.
When I connect with 1.0 CLI to my 0.7
I also have this problem. My data on nodes grows to roughly 30GB. After a
restart only 5GB remains. Is a factor 6 common for Cassandra?
2012/1/18 aaron morton aa...@thelastpickle.com
Good idea Jeremiah, are you using compression Michael ?
Scanning through the CF stats this jumps out…
:58 PM, Michael Vaknine wrote:
I did restart the cluster and now it is normal 5GB.
** **
*From:* R. Verlangen [mailto:ro...@us2.nl]
*Sent:* Wednesday, January 18, 2012 11:32 AM
*To:* user@cassandra.apache.org
*Subject:* Re: nodetool ring question
** **
I also have this problem. My
A couple of days ago I came across Countandra ( http://countandra.org/ ).
It seems that it might be a solution for you.
Gr. Robin
2012/1/20 Tamar Fraenkel ta...@tok-media.com
**
Hi!
I am a newbie to Cassandra and seeking some advice regarding the data
model I should use to best address
If you would like to index your rows in an index-row, you could also
choose for indexing the index-rows. This will scale up for any needs and
create a tree structure.
2012/1/24 aaron morton aa...@thelastpickle.com
Nothing I can thin of other than making the keys uniform.
Having a single index
Pick a custom loglevel and redirect them with the /etc/syslog.conf ?
2012/1/24 ruslan usifov ruslan.usi...@gmail.com
Hello
I try to log thrift log message (this need to us for solve communicate
problem between Cassandra daemon and php client ), so in
log4j-server.properties i write follow
Hi there,
I'm currently running a 2-node cluster for some small projects that might
need to scale-up in the future: that's why we chose Cassandra. The actual
problem is that one of the node's harddrive usage keeps growing.
For example:
- after a fresh restart ~ 10GB
- after a couple of days
Ok thank you for your feedback. I'll add these tasks to our daily cassandra
maintenance cronjob. Hopefully this will keep things under controll.
2012/1/25 Karl Hiramoto k...@hiramoto.org
On 01/25/12 16:09, R. Verlangen wrote:
Hi there,
I'm currently running a 2-node cluster for some small
Thanks for reminding. I'm going to start with adding the cleanup compact
to the chain of maintenance tasks. In my opinion java should determine
itselfs when to start a GC: doesn't feel natural to do this manually.
2012/1/25 Karl Hiramoto k...@hiramoto.org
On 01/25/12 19:18, R. Verlangen wrote
cassandra every X days?
On 01/25/12 19:18, R. Verlangen wrote:
Ok thank you for your feedback. I'll add these tasks to our daily
cassandra maintenance cronjob. Hopefully this will keep things under
controll.
I forgot to mention that we found that Forcing a GC also cleans up some
space
approach would
be to upgrade to 1.0.
Hope that helps.
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 26/01/2012, at 9:51 AM, R. Verlangen wrote:
In his message he explains that it's for Forcing a GC . GC stands for
garbage
A table is called a column family in Cassandra.
From the CLI you can just create one by typing:
create column family MyApplication;
-- Forwarded message --
From: anandbab...@polarisft.com
Date: Fri, Jan 27, 2012 at 2:36 PM
Subject: How to create a table in Cassandra
To:
Ok, seems that it's clear what I should do next ;-)
2012/1/28 aaron morton aa...@thelastpickle.com
There are no blockers to upgrading to 1.0.X.
A
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 28/01/2012, at 7:48 AM, R. Verlangen wrote
You might run it from a VM?
2012/1/30 Ertio Lew ertio...@gmail.com
On Mon, Jan 30, 2012 at 7:16 AM, Frisch, Michael
michael.fri...@nuance.com wrote:
OpsCenter?
http://www.datastax.com/products/opscenter
- Mike
I have tried Sebastien's phpmyAdmin For
, at 4:14 AM, Maxim Potekhin wrote:
Sorry if this has been covered, I was concentrating solely on 0.8x --
can I just d/l 1.0.x and continue using same data on same cluster?
Maxim
On 1/28/2012 7:53 AM, R. Verlangen wrote:
Ok, seems that it's clear what I should do next ;-)
2012/1/28
if you have changed the tokens at any point finally
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 31/01/2012, at 11:56 PM, R. Verlangen wrote:
After running 3 days on Cassandra 1.0.7 it seems the problem has been
solved. One weird
Developer
@aaronmorton
http://www.thelastpickle.com
On 2/02/2012, at 9:55 PM, R. Verlangen wrote:
Yes, I already did a repair and cleanup. Currently my ring looks like this:
Address DC RackStatus State Load
OwnsToken
***.89datacenter1 rack1 Up
It will have a performance penalty, so it would be better to spread the
compactions over a period of time. But Cassandra will still take care of
any reads/writes (within the given timeout).
2012/2/3 myreasoner myreaso...@gmail.com
If every node in the cluster is running major compaction, would
I also made something like this a while ago. I decided to go for the
2-rows-solution: by doing that you don't have the need for super columns.
Cassandra is really good at reading, so this should not be an issue.
Cheers!
2012/2/4 Yiming Sun yiming@gmail.com
Thanks Andrey and Chris. It
I just kept both row keys the same. This was very trivial for fetching them
both. When you have A, you can fetch B, and vice versa.
2012/2/4 Yiming Sun yiming@gmail.com
Interesting idea, R.V. But what did you do with the row keys?
On Sat, Feb 4, 2012 at 2:29 PM, R. Verlangen ro...@us2
Yiming, I am using 2 CF's. Performance wise this should not be an issue. I
use it for small files data store. My 2 CF's are:
FilesMeta
FilesData
2012/2/5 Yiming Sun yiming@gmail.com
Interesting idea, Jim. Is there a reason you don't you use
metadata:{accountId} instead? For performance
You might consider writing some kind of php script that runs nodetool
ring and parse the output?
2012/2/6 Tamil selvan R.S tamil.3...@gmail.com
Hi,
What is the best way to know the cluster status via php?
Currently we are trying to connect to individual cassandra instance with
a specified
Do you allow both outbound as inbound traffic? You might also try allowing
both TCP as UDP.
2012/2/6 Roshan codeva...@gmail.com
Yes, If the firewall is disable it works.
--
View this message in context:
This is because of the warm up of Cassandra as it starts. On a start it
will start fetching the rows that were cached: this will have to be loaded
from the disk, as there is nothing in the cache yet. You can read more
about this at http://wiki.apache.org/cassandra/LargeDataSetConsiderations
I also noticed that, Cassandra appears to perform better under a continues
load.
Are you sure the rows you're quering are actually in the cache?
2012/2/13 Franc Carter franc.car...@sirca.org.au
2012/2/13 R. Verlangen ro...@us2.nl
This is because of the warm up of Cassandra as it starts
Setting to may cause you less headaches as you won't have to deal
with tombstones
You won't have to deal with tombstones manually, the Thrift API will take
care of this. Deleting an empty column value will always be better; with
one exception, when empty does actually mean something else
One option might be to maintain an index containing the keys of the rows.
The index would then have the same TTL as the row itself so when you
iterate over the index columns you'll find exactly the same results.
Although I'm not really sure whether this is the best option.
Another might be to use
Are you planning to insert rows with keys that existed before?
If that's true, there will be no tombstones (as far as I understand
Cassandra).
It that's not, then you will get tombstones that might slow down the reads
because they have to be skipped until the next compaction.
2012/2/14 Todd
I'm familiar to this in PHPCassa, but with Hector it would be something
like this:
Query you CF with a range.setStart(lastColName) and
range.setFinish(StringUtils.byte() where the lastColName is the name
of the column from the previous read.
You can continue this until you run out of results.
Of course you should set your limit to 100 or something like that, not
Integer.MAX_VALUE ;-)
2012/2/14 R. Verlangen ro...@us2.nl
I'm familiar to this in PHPCassa, but with Hector it would be something
like this:
Query you CF with a range.setStart(lastColName) and
range.setFinish
I'm not sure about your first 2 questions. The third might be an exception:
check your Cassandra logs.
About the like-thing: there's no such query possibiliy in Cassandra / CQL.
You can take a look at Hadoop / Hive to tackle those problems.
2012/2/16 Roshan codeva...@gmail.com
Hi
I am using
Things you should know:
- Thrift has a limit on the amount of data it will accept / send, you can
configure this in Cassandra: 64MB's should still work find (1)
- Rows should not become huge: this will make perfect load balancing
impossible in your cluster
- A single row should fit on a disk
-
Hi there,
As the subject states: Is it possible to set a replication factor per
column family?
Could not find anything of recent releases. I'm running Cassandra 1.0.7 and
I think it should be possible on a per CF basis instead of the whole
keyspace.
With kind regards,
Robin
baked in.
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 16/02/2012, at 9:54 PM, R. Verlangen wrote:
Hi there,
As the subject states: Is it possible to set a replication factor per
column family?
Could not find anything of recent
Ok, that's clear, thank you for your time!
2012/2/16 aaron morton aa...@thelastpickle.com
yes.
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 16/02/2012, at 10:15 PM, R. Verlangen wrote:
Hmm ok. This means if I want to have a CF with RF
You might want to check your Cassandra logs, they contain important
information that might lead you to the actual cause of the problems.
2012/2/18 Aditya Gupta ady...@gmail.com
Thanks! But what about the 100% cpu consumption that is causing the server
to hang?
On Sat, Feb 18, 2012 at 6:19
You can leave the end key empty.
1) Start with startkey =
2) Next iteration start with startkey = last key of the previous batch
3) Keep on going until you ran out of results
2012/2/22 Rafael Almeida almeida...@yahoo.com
From: Franc Carter
I would suggest you chunk them down into small pieces (~ 10-50MB) and just
fetch all the parts you need. A problem might be that if fetching one
fails, the whole blob is useless.
2012/2/22 Rafael Almeida almeida...@yahoo.com
Keep them where?
--
*From:* Mohit
Hi there,
I'm currently busy with the technical design of a new project. Of course it
will depend on your needs, but is it weird to combine Cassandra with a SQL
language like MySQL?
In my usecase it would be nice because we have some tables/CF's with lots
and lots of data that does not really
/delete information in a good
data model library and only use that library to access your data. This is
good practice anyway but when you add the extra complication of multiple
databases that may reference one another it's an absolute must.
On Sun, Feb 26, 2012 at 8:06 AM, R. Verlangen ro...@us2.nl
For querying purposes it would be better to use readable strings because
you can really get information out of that.
TimeUUID is just a unique value based on time; but not only the time.
2012/2/28 Tamar Fraenkel ta...@tok-media.com
Hi!
I have a column family where I use rows as time buckets.
Hi there,
I'm currently in a really weird situation.
- Nodetool ring says node X is joining (this already takes 12 hours, with
no activity)
- When I try to remove the token, it says: Exception in thread main
java.lang.UnsupportedOperationException: Token not found.
- Removetoken status = No token
/03/2012, at 9:11 PM, R. Verlangen wrote:
Hi there,
I'm currently in a really weird situation.
- Nodetool ring says node X is joining (this already takes 12 hours, with
no activity)
- When I try to remove the token, it says: Exception in thread main
java.lang.UnsupportedOperationException
@Brandon: Thank you for the information. I'll do that next time.
@Igor: Any ways to find out whether that is the current state? And if so,
how to solve it?
2012/3/7 i...@4friends.od.ua
Maybe it wait for verification compaction on other node?
-Original Message-
From: R. Verlangen
-
From: R. Verlangen ro...@us2.nl
To: user@cassandra.apache.org
Sent: Wed, 07 Mar 2012 23:09
Subject: Re: Node joining / unknown
@Brandon: Thank you for the information. I'll do that next time.
@Igor: Any ways to find out whether that is the current state? And if so,
how to solve it?
2012/3/7 i
Hi Drew,
One other disadvantage is the lack of consistency level and
replication. Both ware part of the high availability / redundancy. So you
would really need to backup your single-node-cluster to some other
external location.
Good luck!
2012/3/15 Drew Kutcharian d...@venarc.com
Hi,
We
.
On Thu, Mar 15, 2012 at 7:12 PM, R. Verlangen ro...@us2.nl wrote:
Hi Drew,
One other disadvantage is the lack of consistency level and
replication. Both ware part of the high availability / redundancy. So you
would really need to backup your single-node-cluster to some other
external
Check your log for messages about rebuilding indices: that might grow your
dataset some.
One thing is for sure: the data import removed all the crap that lasted in
the 0.8.1 cluster (duplicates, thombstones etc). The decrease is fairly
dramatic but not unlogical at all.
2012/3/16 Jeremiah Jordan
That's correct. If you run describe cluster normally you'll see something
like:
Cluster Information:
Snitch: org.apache.cassandra.locator.SimpleSnitch
Partitioner: org.apache.cassandra.dht.RandomPartitioner
Schema versions:
3a0f6a80-7140-11e1--511aec3785ff: [IP_OF_NODE,
If you want to modify a column family, just open the command line interface
(cassandra-cli), connect to a node (probably: connect localhost/9160;).
When you have to create your first keyspace type: create keyspace
MyKeyspace;
For modifying an existing keyspace type: use MyKeyspace;
If you need
You should use the full type names, e.g.
create column family MyColumnFamily with comparator=UTF8Type;
2012/3/26 puneet loya puneetl...@gmail.com
It is giving errors like Unable to find abstract-type class
'org.apache.cassandra.db.marshal.utf8'
and java.lang.RuntimeException:
,
'cobol': null
}
However, I'm still not sure yet how to accomplish this with Astyanax.
I've only figured out how to make composite columns with predefined column
names with it and not dynamic column names like this.
On Mon, Mar 26, 2012 at 9:08 AM, R. Verlangen ro...@us2.nl wrote
@Aaron: Very interesting article! Mentioned it on my Dutch blog.
2012/3/26 Mohit Anchlia mohitanch...@gmail.com
Thanks!
On Mon, Mar 26, 2012 at 10:53 AM, aaron morton aa...@thelastpickle.comwrote:
See the test's in the article.
The code I used for profiling is also available.
Cheers
Ben Coverston wrote earlier today: Use a version of the Java 6 runtime,
Cassandra hasn't been tested at all with the Java 7 runtime
So I think that might be a good way to start.
2012/3/26 Frank Hsueh frank.hs...@gmail.com
I think I have cassandra the server started
In another window:
use comparator='utf8' or not??
Please reply
On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen ro...@us2.nl wrote:
You should use the full type names, e.g.
create column family MyColumnFamily with comparator=UTF8Type;
2012/3/26 puneet loya puneetl...@gmail.com
It is giving errors like
That's true, but it does not sound like a real problem to me.. Maybe
someone else can shed some light upon this.
2012/3/27 samal samalgo...@gmail.com
On Tue, Mar 27, 2012 at 1:47 AM, R. Verlangen ro...@us2.nl wrote:
but any schema change will break it
How do you mean? You don't have
Thank you Maki, wasn't aware of that.
2012/3/27 Maki Watanabe watanabe.m...@gmail.com
auto_bootstrap has been removed from cassandra.yaml and always enabled
since 1.0.
fyi.
maki
2012/3/26 R. Verlangen ro...@us2.nl:
Yes, you can add nodes to a running cluster. It's very simple
You can just get a slice range with as start userId: and no end.
2012/3/27 Maciej Miklas mac.mik...@googlemail.com
multiget would require Order Preserving Partitioner, and this can lead to
unbalanced ring and hot spots.
Maybe you can use secondary index on itemtype - is must have small
*create column family MyCounterColumnFamily with
default_validation_class=CounterColumnType and
key_validation_class=UTF8Type and comparator=UTF8Type;*
There you go! Keys must be utf8, as well as the column names. Of course you
can change those validators.
Cheers!
2012/3/27 puneet loya
a column of type integer which increments with every
insert.
Am i goin the rite way??
please reply :)
On Tue, Mar 27, 2012 at 5:50 PM, R. Verlangen ro...@us2.nl wrote:
*create column family MyCounterColumnFamily with
default_validation_class=CounterColumnType and
key_validation_class
You can write your own script to parse the excel file (export as csv) and
import it with batch inserts.
Should be pretty easy if you have experience with those techniques.
2012/3/27 puneet loya puneetl...@gmail.com
I want to import files from excel to cassandra? Is it possible??
Any tool
Cassandra graveyard sounds like a lot of thombstones that will be
compacted during normal compact.
You can trigger that manually using the nodetool.
2012/3/28 Erik Forsberg forsb...@opera.com
Hi!
I was trying out the truncate command in cassandra-cli.
county',
'skill:java': '',
'skill:html': '',
'skill:javascript': ''
}
On Tue, Mar 27, 2012 at 12:04 AM, samal samalgo...@gmail.com wrote:
YEAH! agree, it only matter for time bucket data.
On Tue, Mar 27, 2012 at 12:31 PM, R. Verlangen ro...@us2.nl wrote:
That's true, but it does
, Mar 28, 2012 at 12:34 AM, R. Verlangen ro...@us2.nl wrote:
Yes, that is one of the possible solutions to your problem.
When you want to retrieve only the skills of a particular row just get
the columns with as start value skill:.
A suggestion to your example might be to use a ~ in stead
As far as I'm aware of that is not possible using the opscenter.
I recommend you use the cassandra-cli and perform an update column family
query.
2012/3/29 puneet loya puneetl...@gmail.com
I m currently using the the datastax opscenter.
How do we add column to the column families in
The best would to not use update / insert at all but set / put / save.
Cheers!
2012/3/29 Dinusha Dilrukshi sdddilruk...@gmail.com
What I want to tell was this driver does not use INSERT key word. Since
CQL support for using INSERT keyword and it is more generic key word used
to add new
Nick, would that also result in useless duplicates of the statistics?
2012/3/30 Nick Bailey n...@datastax.com
Unfortunately at the moment OpsCenter only really supports having one
instance per cluster. It may be possible to set up an instance in each
datacenter, however it has not been tested
Hi there,
I have a question about the nodetool snapshot.
Situation:
- 3 node cluster
- RF = 3
- fully consistent (not measured, but let's say it is)
Is it true that when I take a snaphot at only one of the 3 nodes this
contains all the data in the cluster (at least 1 replica)?
With kind
Ok, thank you.
2012/4/2 Rob Coli rc...@palominodb.com
On Mon, Apr 2, 2012 at 9:19 AM, R. Verlangen ro...@us2.nl wrote:
- 3 node cluster
- RF = 3
- fully consistent (not measured, but let's say it is)
Is it true that when I take a snaphot at only one of the 3 nodes this
contains all
Yes, I personally have configured it to perform a repair once a week, as
the GCGraceSeconds is at 10 days.
This is also what's in the manual
http://wiki.apache.org/cassandra/Operations#Repairing_missing_or_inconsistent_data
(point
2)
2012/4/11 ruslan usifov ruslan.usi...@gmail.com
Hello
I
have TTL,
all HH works, and you never delete your data.
On 04/11/2012 11:34 AM, ruslan usifov wrote:
Sorry fo my bad english, so QUORUM allow doesn't make repair regularity?
But form your anser it does not follow
2012/4/11 R. Verlangen ro...@us2.nl
Yes, I personally have configured
Are you sure this isn't read-repair?
http://wiki.apache.org/cassandra/ReadRepair
2012/4/11 Thibaut Britz thibaut.br...@trendiction.com
Also executing the same multiget rangeslice query over the same range
again will trigger the same writes again and again.
On Wed, Apr 11, 2012 at 5:41 PM,
It sounds like the commitlog has been replayed however I have really no
idea whether this could have happened. Anyone?
2012/4/13 Alain RODRIGUEZ arodr...@gmail.com
The commitlog_total_space_in_mb was not set, I set it to avoid having the
same problem in the future.
I am aware of the
Its recommended to disable swap entirely when you run Cassandra on a server.
2012/4/14 ruslan usifov ruslan.usi...@gmail.com
I forgot to say that system have 24GB of phis memory
2012/4/14 ruslan usifov ruslan.usi...@gmail.com
Hello
We have 6 node cluster (cassandra 0.8.10). On one node i
there
still about 3GB (on node with JAVA_HEAP=6GB free memory also 3GB) of free
memory but there JAVA_HEAP=5G, so this looks like some sysctl
(/proc/sys/vm???) ratio (about 10%(3 / 24 * 100)), i don't known which,
anybody can explain this situation
2012/4/14 R. Verlangen ro...@us2.nl
Its
PHPCassa does support binaries, so that should not be the problem.
2012/4/19 phuduc nguyen duc.ngu...@pearson.com
Well, I'm not sure exactly how you're passing a blob to the CLI. It would
be
helpful if you pasted your commands/code and maybe there is a simple
oversight.
With that said,
I read a while ago that a compaction would rebuild the index. You can
trigger this by running repair with the nodetool.
2012/4/24 mdione@orange.com
De : mdione@orange.com [mailto:mdione@orange.com]
[default@avatars] describe HBX_FILE;
ColumnFamily: HBX_FILE
Key
Hi there,
I'm working on a datamodel for a multi-website, multi-customer system.
Things we would like to do:
- search products (lucene / solr / solandra)
- multi-filter (e.g. categories)
- reviews
- voting
I can't really see how to do the filtering of the products by categories
and even things
@Aaron: Solr will probably be the solution to our problem. Thank you!
@Radim: We already have a Cassandra cluster, we do not want to add an extra
MongoDB cluster. At this moment the data would fit easily in SQL, but we
don't know how our platform grows and we want to be prepared for the future.
I struggled with this before and decided to use HAProxy which suits my
needs, you can read a little more about it at my personal blog:
http://www.robinverlangen.nl/index/view/4fa902c1596cb-44a627/how-to-solve-the-pain-of-stateless-php-with-cassandra.html
Good luck with it!
2012/5/14 Viktor
Hi there,
I'm using HAProxy for PHP projects to take care of this. It improved
connection pooling enormous on the client side: with preserving failover
capabilities. Maybe that is something for you to use in combination with
PHP.
Good luck!
2012/5/16 Piavlo lolitus...@gmail.com
Hi,
I'm
Yes, I'm aware of those issues however in our use case they don't cause any
problems.
But ... If there's something better out there I'm really curious: so I'll
keep up with this thread.
2012/5/16 Piavlo lolitus...@gmail.com
On 05/16/2012 01:24 PM, R. Verlangen wrote:
Hi there,
I'm using
Yes, it does. However there's no real answer what's the limit: it depends
on your hardware and cluster configuration.
You might even want to search the archives of this mailinglist, I remember
this has been asked before.
Cheers!
2012/5/21 Luís Ferreira zamith...@gmail.com
Hi,
Does the
/05/2012, at 6:58 PM, R. Verlangen wrote:
Yes, it does. However there's no real answer what's the limit: it depends
on your hardware and cluster configuration.
You might even want to search the archives of this mailinglist, I remember
this has been asked before.
Cheers!
2012/5/21 Luís
Hi Felipe,
There recently was a thread about (
http://www.mail-archive.com/user@cassandra.apache.org/msg22298.html ). The
answer in short: no. However you can build your own data model to support
it.
Cheers!
2012/5/24 Felipe Schmidt felipef...@gmail.com
Doe's Cassandra support data
1 - 100 of 111 matches
Mail list logo
