I set setcompactionthroughput 999 permanently and it doesn't change
anything. IO is still same. CPU is idle.
On Tue, Feb 17, 2015 at 1:15 AM, Roni Balthazar
wrote:
> Hi,
>
> You can run "nodetool compactionstats" to view statistics on compactions.
> Setting cold_reads_to_omit to 0.0 can help to
Hello all,
I have an existing cluster. When adding a new node, I saw that Opscenter saw
the node in an unknown cluster. In the yaml, the cluster name is the same. So i
have stopped the node and added it's ip address in the list of seeds. Now
Opscenter sees my node. But nodetool status now sees i
After some diagnostic ( we didn't set yet cold_reads_to_omit ). Compaction
are running but VERY slow with "idle" IO.
We had a lot of "Data files" in Cassandra. In DC_A it is about ~12
(only xxx-Data.db) in DC_B has only ~4000.
I don't know if this change anything but:
1) in DC_A avg size of D
Hi Bogdan
In nodetool status:
* UJ: means your node is Up and Joining
* UN: means your node is Up and in Normal state
UN in nodetool is good ;-)
On 17/02/2015 13:56, Batranut Bogdan wrote:
Hello all,
I have an existing cluster. When adding a new node, I saw that
Opscenter saw the node in
HI,
Yes... I had the same issue and setting cold_reads_to_omit to 0.0 was
the solution...
The number of SSTables decreased from many thousands to a number below
a hundred and the SSTables are now much bigger with several gigabytes
(most of them).
Cheers,
Roni Balthazar
On Tue, Feb 17, 2015 at
It would be around April of this year. I asked the same thing in
cassaandra-dev irc channel sometime back. This is by no means an official
release date or month, just a guesstimate.
Cheers,
Ajaya
On Wed, Feb 11, 2015 at 6:49 PM, Ernesto Reinaldo Barreiro <
reier...@gmail.com> wrote:
> Thanks for
Thanks for your answer!
On Tue, Feb 17, 2015 at 2:24 PM, Ajaya Agrawal wrote:
> It would be around April of this year. I asked the same thing in
> cassaandra-dev irc channel sometime back. This is by no means an official
> release date or month, just a guesstimate.
>
> Cheers,
> Ajaya
>
> On Wed
Hello,
I know that UN is good, but what troubles me is the addition of the own node's
ip in it's yaml seeds section.
On Tuesday, February 17, 2015 3:40 PM, Reynald Bourtembourg
wrote:
Hi Bogdan
In nodetool status:
- UJ: means your node is Up and Joining
- UN: means yo
Hi,
I have a two node cluster running on openstack cloud. One of the node is also
running Opscenter, while both are running datastax-agents.
How can I use browser on my Windows machine to connect to this instance of
opscenter? Specifically, I want to ask, which ports should I open in default
s
What snitch are you using? You may need to do some work on your topology file
(or rackdc) to make sure you have the topology you want. Also, it is possible
you may need to restart OpsCenter agents and/or your browser to see the nodes
represented properly in OpsCenter.
Sean Durity – Cassandra A
On Fri, Feb 13, 2015 at 7:45 PM, Jason Wee wrote:
> I trigger user defined compaction to big sstables (big as in the size per
> sstable reach more than 50GB, some 100GB). Occasionally, after user defined
> compaction, I see some sstables remain, even after 12 hours elapsed.
>
That is unexpected.
The Cassandra team is pleased to announce the release of Apache Cassandra
version 2.1.3.
This release contains over 100 fixes for 2.1 so anyone on 2.1.X should
upgrade to this ASAP.
Apache Cassandra is a fully distributed database. It is the right choice
when you need scalability and high availa
Full table scans are not the best use case for Cassandra. Without some kind of
pagination, the node taking the request (the coordinator node) will try to
assemble the data from all nodes to return to the client. With a dataset of any
decent size, it will overwhelm the single node.
Pagination is
You can start from here:
http://www.datastax.com/docs/1.1/references/firewall_ref
By default ops site is hosted at port .
On Tue, Feb 17, 2015 at 12:38 PM, Syed, Basit B. (NSN - FI/Espoo) <
basit.b.s...@nsn.com> wrote:
> Hi,
> I have a two node cluster running on openstack cloud. One of th
Hello,
I use SimpleSnitch. All the nodes are in the sane datacenter. Not sure if all
are in the same rack.
On Tuesday, February 17, 2015 8:53 PM, "sean_r_dur...@homedepot.com"
wrote:
#yiv3880239437 #yiv3880239437 -- _filtered #yiv3880239437
{font-family:Helvetica;panose-1:2 11 6 4
SimpleSnitch is not rack aware. You would want to choose seed nodes and then
not change them. Seed nodes apparently don’t bootstrap. All nodes need the same
seeds in the yaml file. Here is more info:
http://www.datastax.com/documentation/cassandra/2.0/cassandra/initialize/initializeSingleDS.html
> Seed nodes apparently don’t bootstrap
That's right, if a node has itself in its own seeds list, it assumes it's a
foundational member of the cluster, and it will join immediately with no
bootstrap.
If you've done this by accident, you should do nodetool decommission on
that node, and when it's
What's a good way to load some cassandra data (perhaps result of a cql query)
into Excel / Tableau? I see DSE has support, but that's not always an option.
Simba do an odbc connectory that currently doesn't support UDTs + collections
properly (and it's expensive). Is there a way to use Spark to
Hive can connect to Cassandra, so that means you can point Tableau to hive
using JDBC.
As long as you map Hive to cassandra, you should be able to query data just
like regular hive
On Tue, Feb 17, 2015 at 7:29 PM, Ashic Mahtab wrote:
> What's a good way to load some cassandra data (perhaps resu
On Tue, Feb 17, 2015 at 2:25 PM, wrote:
> SimpleSnitch is not rack aware. You would want to choose seed nodes and
> then not change them. Seed nodes apparently don’t bootstrap.
>
No one seems to know what a "seed node" actually *is*, but "seed nodes" can
in fact bootstrap. They just have to tem
Thanks, Peter.
Any pointers on getting that working? Also, don't think Tableau supports JDBC
(it does support ODBC). I've been able to start beeline (i.e. thriftserver) and
connect Tableau to it via the Simba ODBC connector for Spark. But no idea how
to let "it" (hive or spark) know where Cassa
21 matches
Mail list logo
