You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Tim Dunphy <bl...@gmail.com> on 2012/03/29 19:53:16 UTC
cassandra gui
hey all,
I have a new cassandra node that I've setup so that I can get better
acquainted with this technology. Thus far I've been using the
cassandra-cli and it'd been a fun experience so far. However I know
that there are a few cassandra gui's out there and I was just
wondering which ones you've used that you've had a good experience
with and can recommend?
So far I've heard of (but not used) DataStax OpsCenter as well as the
Apollo gui and I think there may be others. Ideally what I'd like to
be able to do is both manage nodes and enter data into the keystores
using a graphical user interface.
Thanks
tim
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
AW: cassandra gui
Posted by "Markus Wiesenbacher | Codefreun.de" <mw...@codefreun.de>.
Inside the webapp (f.g. webapps/apollo/WEB-INF/classes) you can find apollo.properties with the property max.number.row.keys and the default 100. Please try to change this to a higher integer. But as far as I can see it is not used for the columns …
Von: Markus Wiesenbacher | Codefreun.de [mailto:mw@codefreun.de]
Gesendet: Freitag, 30. März 2012 22:10
An: user@cassandra.apache.org
Betreff: Re: cassandra gui
Let me check that ....
Von meinem iPhone gesendet
Am 30.03.2012 um 21:46 schrieb Mohit Anchlia <mo...@gmail.com>:
On Fri, Mar 30, 2012 at 8:05 AM, Markus Wiesenbacher | Codefreun.de <mw...@codefreun.de> wrote:
If you do search without a key I just read the first 100 row-keys and return them. I am using Thrift at the moment to select the keys (subject to change) and I haven´t found a way to do paging with this API. I think, searching for a specific key is the most efficient way to get to your data, instead of paging through it.
I was referring to columns, if a row-key has more than 100 columns then there is no way to look at columns that falls outside of it
Von: Mohit Anchlia [mailto:mohitanchlia@gmail.com]
Gesendet: Freitag, 30. März 2012 16:57
An: user@cassandra.apache.org
Betreff: Re: cassandra gui
On Thu, Mar 29, 2012 at 10:08 PM, Markus Wiesenbacher | Codefreun.de <mw...@codefreun.de> wrote:
Hi,
yes you can insert data into cassandra with apollo, just try the demo
center: http://www.codefreun.de/apolloUI/
You can login by just press the login-button (autologin) and play around
with it.
More info: http://codefreun.de/en/apollo-en
If you miss any feature, please let me know!
Best regards
Markus
Seems like apollo doesn't provide paging feature when columns > 100. Is that going to change?
-----Ursprüngliche Nachricht-----
Von: Tim Dunphy [mailto:bluethundr@gmail.com]
Gesendet: Donnerstag, 29. März 2012 21:07
An: user@cassandra.apache.org
Betreff: Re: cassandra gui
Cool guys, thanks. I'll certainly give it a try now that my cassandra setup
is functioning well. But what about the Apollo gui for Cassandra. Has anyone
else had any experience with that and maybe know if it supports entering
data into the cluster?
tx!
On Thu, Mar 29, 2012 at 2:33 PM, Nick Bailey <ni...@datastax.com> wrote:
> Just so you know. OpsCenter is a good tool for managing your cluster
> and viewing data in your keyspaces/columnfamilies (data besides string
> data currently doesn't display an extremely user friendly way, it will
> display hex). Currently you can not insert data to your cluster using
> the OpsCenter gui though. That is planned for some point in the future
> hopefully, but it is hard to say when it will be added.
>
> On Thu, Mar 29, 2012 at 1:25 PM, Mucklow, Blaine (GE Energy)
> <Bl...@ge.com> wrote:
>> Datastax OpsCenter really is pretty awesome. I haven't tried
>> anything else, but have had no issues with opscenter.
>>
>> On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
>>
>>>hey all,
>>>
>>> I have a new cassandra node that I've setup so that I can get better
>>>acquainted with this technology. Thus far I've been using the
>>>cassandra-cli and it'd been a fun experience so far. However I know
>>>that there are a few cassandra gui's out there and I was just
>>>wondering which ones you've used that you've had a good experience
>>>with and can recommend?
>>>
>>> So far I've heard of (but not used) DataStax OpsCenter as well as
>>>the Apollo gui and I think there may be others. Ideally what I'd like
>>>to be able to do is both manage nodes and enter data into the
>>>keystores using a graphical user interface.
>>>
>>>Thanks
>>>tim
>>>--
>>>GPG me!!
>>>
>>>gpg --keyserver pool.sks-keyservers.net <http://pool.sks-keyservers.net/> --recv-keys F186197B
>>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net <http://pool.sks-keyservers.net/> --recv-keys F186197B
Re: cassandra gui
Posted by "Markus Wiesenbacher | Codefreun.de" <mw...@codefreun.de>.
Let me check that ....
Von meinem iPhone gesendet
Am 30.03.2012 um 21:46 schrieb Mohit Anchlia <mo...@gmail.com>:
>
>
> On Fri, Mar 30, 2012 at 8:05 AM, Markus Wiesenbacher | Codefreun.de <mw...@codefreun.de> wrote:
> If you do search without a key I just read the first 100 row-keys and return them. I am using Thrift at the moment to select the keys (subject to change) and I haven´t found a way to do paging with this API. I think, searching for a specific key is the most efficient way to get to your data, instead of paging through it.
>
>
>
> I was referring to columns, if a row-key has more than 100 columns then there is no way to look at columns that falls outside of it
>
>
>
>
> Von: Mohit Anchlia [mailto:mohitanchlia@gmail.com]
> Gesendet: Freitag, 30. März 2012 16:57
>
>
> An: user@cassandra.apache.org
> Betreff: Re: cassandra gui
>
>
> On Thu, Mar 29, 2012 at 10:08 PM, Markus Wiesenbacher | Codefreun.de <mw...@codefreun.de> wrote:
>
> Hi,
>
> yes you can insert data into cassandra with apollo, just try the demo
> center: http://www.codefreun.de/apolloUI/
>
> You can login by just press the login-button (autologin) and play around
> with it.
>
> More info: http://codefreun.de/en/apollo-en
>
> If you miss any feature, please let me know!
>
> Best regards
> Markus
>
>
> Seems like apollo doesn't provide paging feature when columns > 100. Is that going to change?
>
> -----Ursprüngliche Nachricht-----
> Von: Tim Dunphy [mailto:bluethundr@gmail.com]
> Gesendet: Donnerstag, 29. März 2012 21:07
> An: user@cassandra.apache.org
> Betreff: Re: cassandra gui
>
>
> Cool guys, thanks. I'll certainly give it a try now that my cassandra setup
> is functioning well. But what about the Apollo gui for Cassandra. Has anyone
> else had any experience with that and maybe know if it supports entering
> data into the cluster?
>
> tx!
>
>
> On Thu, Mar 29, 2012 at 2:33 PM, Nick Bailey <ni...@datastax.com> wrote:
> > Just so you know. OpsCenter is a good tool for managing your cluster
> > and viewing data in your keyspaces/columnfamilies (data besides string
> > data currently doesn't display an extremely user friendly way, it will
> > display hex). Currently you can not insert data to your cluster using
> > the OpsCenter gui though. That is planned for some point in the future
> > hopefully, but it is hard to say when it will be added.
> >
> > On Thu, Mar 29, 2012 at 1:25 PM, Mucklow, Blaine (GE Energy)
> > <Bl...@ge.com> wrote:
> >> Datastax OpsCenter really is pretty awesome. I haven't tried
> >> anything else, but have had no issues with opscenter.
> >>
> >> On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
> >>
> >>>hey all,
> >>>
> >>> I have a new cassandra node that I've setup so that I can get better
> >>>acquainted with this technology. Thus far I've been using the
> >>>cassandra-cli and it'd been a fun experience so far. However I know
> >>>that there are a few cassandra gui's out there and I was just
> >>>wondering which ones you've used that you've had a good experience
> >>>with and can recommend?
> >>>
> >>> So far I've heard of (but not used) DataStax OpsCenter as well as
> >>>the Apollo gui and I think there may be others. Ideally what I'd like
> >>>to be able to do is both manage nodes and enter data into the
> >>>keystores using a graphical user interface.
> >>>
> >>>Thanks
> >>>tim
> >>>--
> >>>GPG me!!
> >>>
> >>>gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
> >>
>
>
>
> --
> GPG me!!
>
> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>
>
>
>
Re: cassandra gui
Posted by Mohit Anchlia <mo...@gmail.com>.
On Fri, Mar 30, 2012 at 8:05 AM, Markus Wiesenbacher | Codefreun.de <
mw@codefreun.de> wrote:
> If you do search without a key I just read the first 100 row-keys and
> return them. I am using Thrift at the moment to select the keys (subject to
> change) and I haven´t found a way to do paging with this API. I think,
> searching for a specific key is the most efficient way to get to your data,
> instead of paging through it.****
>
> **
>
> I was referring to columns, if a row-key has more than 100 columns then
> there is no way to look at columns that falls outside of it
>
> **
>
> *Von:* Mohit Anchlia [mailto:mohitanchlia@gmail.com]
> *Gesendet:* Freitag, 30. März 2012 16:57
>
> *An:* user@cassandra.apache.org
> *Betreff:* Re: cassandra gui****
>
> ** **
>
> On Thu, Mar 29, 2012 at 10:08 PM, Markus Wiesenbacher | Codefreun.de <
> mw@codefreun.de> wrote:****
>
> Hi,
>
> yes you can insert data into cassandra with apollo, just try the demo
> center: http://www.codefreun.de/apolloUI/
>
> You can login by just press the login-button (autologin) and play around
> with it.
>
> More info: http://codefreun.de/en/apollo-en
>
> If you miss any feature, please let me know!
>
> Best regards
> Markus
>
> ****
>
> Seems like apollo doesn't provide paging feature when columns > 100. Is
> that going to change?****
>
> -----Ursprüngliche Nachricht-----
> Von: Tim Dunphy [mailto:bluethundr@gmail.com]
> Gesendet: Donnerstag, 29. März 2012 21:07
> An: user@cassandra.apache.org
> Betreff: Re: cassandra gui****
>
>
> Cool guys, thanks. I'll certainly give it a try now that my cassandra setup
> is functioning well. But what about the Apollo gui for Cassandra. Has
> anyone
> else had any experience with that and maybe know if it supports entering
> data into the cluster?
>
> tx!
>
>
> On Thu, Mar 29, 2012 at 2:33 PM, Nick Bailey <ni...@datastax.com> wrote:
> > Just so you know. OpsCenter is a good tool for managing your cluster
> > and viewing data in your keyspaces/columnfamilies (data besides string
> > data currently doesn't display an extremely user friendly way, it will
> > display hex). Currently you can not insert data to your cluster using
> > the OpsCenter gui though. That is planned for some point in the future
> > hopefully, but it is hard to say when it will be added.
> >
> > On Thu, Mar 29, 2012 at 1:25 PM, Mucklow, Blaine (GE Energy)
> > <Bl...@ge.com> wrote:
> >> Datastax OpsCenter really is pretty awesome. I haven't tried
> >> anything else, but have had no issues with opscenter.
> >>
> >> On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
> >>
> >>>hey all,
> >>>
> >>> I have a new cassandra node that I've setup so that I can get better
> >>>acquainted with this technology. Thus far I've been using the
> >>>cassandra-cli and it'd been a fun experience so far. However I know
> >>>that there are a few cassandra gui's out there and I was just
> >>>wondering which ones you've used that you've had a good experience
> >>>with and can recommend?
> >>>
> >>> So far I've heard of (but not used) DataStax OpsCenter as well as
> >>>the Apollo gui and I think there may be others. Ideally what I'd like
> >>>to be able to do is both manage nodes and enter data into the
> >>>keystores using a graphical user interface.
> >>>
> >>>Thanks
> >>>tim
> >>>--
> >>>GPG me!!
> >>>
> >>>gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
> >>
>
>
>
> --
> GPG me!!
>
> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B****
>
> ** **
>
AW: cassandra gui
Posted by "Markus Wiesenbacher | Codefreun.de" <mw...@codefreun.de>.
If you do search without a key I just read the first 100 row-keys and return
them. I am using Thrift at the moment to select the keys (subject to change)
and I haven´t found a way to do paging with this API. I think, searching for
a specific key is the most efficient way to get to your data, instead of
paging through it.
Von: Mohit Anchlia [mailto:mohitanchlia@gmail.com]
Gesendet: Freitag, 30. März 2012 16:57
An: user@cassandra.apache.org
Betreff: Re: cassandra gui
On Thu, Mar 29, 2012 at 10:08 PM, Markus Wiesenbacher | Codefreun.de
<mw...@codefreun.de> wrote:
Hi,
yes you can insert data into cassandra with apollo, just try the demo
center: http://www.codefreun.de/apolloUI/
You can login by just press the login-button (autologin) and play around
with it.
More info: http://codefreun.de/en/apollo-en
If you miss any feature, please let me know!
Best regards
Markus
Seems like apollo doesn't provide paging feature when columns > 100. Is that
going to change?
-----Ursprüngliche Nachricht-----
Von: Tim Dunphy [mailto:bluethundr@gmail.com]
Gesendet: Donnerstag, 29. März 2012 21:07
An: user@cassandra.apache.org
Betreff: Re: cassandra gui
Cool guys, thanks. I'll certainly give it a try now that my cassandra setup
is functioning well. But what about the Apollo gui for Cassandra. Has anyone
else had any experience with that and maybe know if it supports entering
data into the cluster?
tx!
On Thu, Mar 29, 2012 at 2:33 PM, Nick Bailey <ni...@datastax.com> wrote:
> Just so you know. OpsCenter is a good tool for managing your cluster
> and viewing data in your keyspaces/columnfamilies (data besides string
> data currently doesn't display an extremely user friendly way, it will
> display hex). Currently you can not insert data to your cluster using
> the OpsCenter gui though. That is planned for some point in the future
> hopefully, but it is hard to say when it will be added.
>
> On Thu, Mar 29, 2012 at 1:25 PM, Mucklow, Blaine (GE Energy)
> <Bl...@ge.com> wrote:
>> Datastax OpsCenter really is pretty awesome. I haven't tried
>> anything else, but have had no issues with opscenter.
>>
>> On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
>>
>>>hey all,
>>>
>>> I have a new cassandra node that I've setup so that I can get better
>>>acquainted with this technology. Thus far I've been using the
>>>cassandra-cli and it'd been a fun experience so far. However I know
>>>that there are a few cassandra gui's out there and I was just
>>>wondering which ones you've used that you've had a good experience
>>>with and can recommend?
>>>
>>> So far I've heard of (but not used) DataStax OpsCenter as well as
>>>the Apollo gui and I think there may be others. Ideally what I'd like
>>>to be able to do is both manage nodes and enter data into the
>>>keystores using a graphical user interface.
>>>
>>>Thanks
>>>tim
>>>--
>>>GPG me!!
>>>
>>>gpg --keyserver pool.sks-keyservers.net <http://pool.sks-keyservers.net/>
--recv-keys F186197B
>>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net <http://pool.sks-keyservers.net/>
--recv-keys F186197B
Re: cassandra gui
Posted by Mohit Anchlia <mo...@gmail.com>.
On Thu, Mar 29, 2012 at 10:08 PM, Markus Wiesenbacher | Codefreun.de <
mw@codefreun.de> wrote:
> Hi,
>
> yes you can insert data into cassandra with apollo, just try the demo
> center: http://www.codefreun.de/apolloUI/
>
> You can login by just press the login-button (autologin) and play around
> with it.
>
> More info: http://codefreun.de/en/apollo-en
>
> If you miss any feature, please let me know!
>
> Best regards
> Markus
>
>
> Seems like apollo doesn't provide paging feature when columns > 100. Is
that going to change?
-----Ursprüngliche Nachricht-----
> Von: Tim Dunphy [mailto:bluethundr@gmail.com]
> Gesendet: Donnerstag, 29. März 2012 21:07
> An: user@cassandra.apache.org
> Betreff: Re: cassandra gui
>
> Cool guys, thanks. I'll certainly give it a try now that my cassandra setup
> is functioning well. But what about the Apollo gui for Cassandra. Has
> anyone
> else had any experience with that and maybe know if it supports entering
> data into the cluster?
>
> tx!
>
>
> On Thu, Mar 29, 2012 at 2:33 PM, Nick Bailey <ni...@datastax.com> wrote:
> > Just so you know. OpsCenter is a good tool for managing your cluster
> > and viewing data in your keyspaces/columnfamilies (data besides string
> > data currently doesn't display an extremely user friendly way, it will
> > display hex). Currently you can not insert data to your cluster using
> > the OpsCenter gui though. That is planned for some point in the future
> > hopefully, but it is hard to say when it will be added.
> >
> > On Thu, Mar 29, 2012 at 1:25 PM, Mucklow, Blaine (GE Energy)
> > <Bl...@ge.com> wrote:
> >> Datastax OpsCenter really is pretty awesome. I haven't tried
> >> anything else, but have had no issues with opscenter.
> >>
> >> On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
> >>
> >>>hey all,
> >>>
> >>> I have a new cassandra node that I've setup so that I can get better
> >>>acquainted with this technology. Thus far I've been using the
> >>>cassandra-cli and it'd been a fun experience so far. However I know
> >>>that there are a few cassandra gui's out there and I was just
> >>>wondering which ones you've used that you've had a good experience
> >>>with and can recommend?
> >>>
> >>> So far I've heard of (but not used) DataStax OpsCenter as well as
> >>>the Apollo gui and I think there may be others. Ideally what I'd like
> >>>to be able to do is both manage nodes and enter data into the
> >>>keystores using a graphical user interface.
> >>>
> >>>Thanks
> >>>tim
> >>>--
> >>>GPG me!!
> >>>
> >>>gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
> >>
>
>
>
> --
> GPG me!!
>
> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>
>
AW: cassandra gui
Posted by "Markus Wiesenbacher | Codefreun.de" <mw...@codefreun.de>.
Hi,
yes you can insert data into cassandra with apollo, just try the demo
center: http://www.codefreun.de/apolloUI/
You can login by just press the login-button (autologin) and play around
with it.
More info: http://codefreun.de/en/apollo-en
If you miss any feature, please let me know!
Best regards
Markus
-----Ursprüngliche Nachricht-----
Von: Tim Dunphy [mailto:bluethundr@gmail.com]
Gesendet: Donnerstag, 29. März 2012 21:07
An: user@cassandra.apache.org
Betreff: Re: cassandra gui
Cool guys, thanks. I'll certainly give it a try now that my cassandra setup
is functioning well. But what about the Apollo gui for Cassandra. Has anyone
else had any experience with that and maybe know if it supports entering
data into the cluster?
tx!
On Thu, Mar 29, 2012 at 2:33 PM, Nick Bailey <ni...@datastax.com> wrote:
> Just so you know. OpsCenter is a good tool for managing your cluster
> and viewing data in your keyspaces/columnfamilies (data besides string
> data currently doesn't display an extremely user friendly way, it will
> display hex). Currently you can not insert data to your cluster using
> the OpsCenter gui though. That is planned for some point in the future
> hopefully, but it is hard to say when it will be added.
>
> On Thu, Mar 29, 2012 at 1:25 PM, Mucklow, Blaine (GE Energy)
> <Bl...@ge.com> wrote:
>> Datastax OpsCenter really is pretty awesome. I haven't tried
>> anything else, but have had no issues with opscenter.
>>
>> On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
>>
>>>hey all,
>>>
>>> I have a new cassandra node that I've setup so that I can get better
>>>acquainted with this technology. Thus far I've been using the
>>>cassandra-cli and it'd been a fun experience so far. However I know
>>>that there are a few cassandra gui's out there and I was just
>>>wondering which ones you've used that you've had a good experience
>>>with and can recommend?
>>>
>>> So far I've heard of (but not used) DataStax OpsCenter as well as
>>>the Apollo gui and I think there may be others. Ideally what I'd like
>>>to be able to do is both manage nodes and enter data into the
>>>keystores using a graphical user interface.
>>>
>>>Thanks
>>>tim
>>>--
>>>GPG me!!
>>>
>>>gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
Re: cassandra gui
Posted by Tim Dunphy <bl...@gmail.com>.
Cool guys, thanks. I'll certainly give it a try now that my cassandra
setup is functioning well. But what about the Apollo gui for
Cassandra. Has anyone else had any experience with that and maybe know
if it supports entering data into the cluster?
tx!
On Thu, Mar 29, 2012 at 2:33 PM, Nick Bailey <ni...@datastax.com> wrote:
> Just so you know. OpsCenter is a good tool for managing your cluster
> and viewing data in your keyspaces/columnfamilies (data besides string
> data currently doesn't display an extremely user friendly way, it will
> display hex). Currently you can not insert data to your cluster using
> the OpsCenter gui though. That is planned for some point in the future
> hopefully, but it is hard to say when it will be added.
>
> On Thu, Mar 29, 2012 at 1:25 PM, Mucklow, Blaine (GE Energy)
> <Bl...@ge.com> wrote:
>> Datastax OpsCenter really is pretty awesome. I haven't tried anything
>> else, but have had no issues with opscenter.
>>
>> On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
>>
>>>hey all,
>>>
>>> I have a new cassandra node that I've setup so that I can get better
>>>acquainted with this technology. Thus far I've been using the
>>>cassandra-cli and it'd been a fun experience so far. However I know
>>>that there are a few cassandra gui's out there and I was just
>>>wondering which ones you've used that you've had a good experience
>>>with and can recommend?
>>>
>>> So far I've heard of (but not used) DataStax OpsCenter as well as the
>>>Apollo gui and I think there may be others. Ideally what I'd like to
>>>be able to do is both manage nodes and enter data into the keystores
>>>using a graphical user interface.
>>>
>>>Thanks
>>>tim
>>>--
>>>GPG me!!
>>>
>>>gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
Re: cassandra gui
Posted by Nick Bailey <ni...@datastax.com>.
Just so you know. OpsCenter is a good tool for managing your cluster
and viewing data in your keyspaces/columnfamilies (data besides string
data currently doesn't display an extremely user friendly way, it will
display hex). Currently you can not insert data to your cluster using
the OpsCenter gui though. That is planned for some point in the future
hopefully, but it is hard to say when it will be added.
On Thu, Mar 29, 2012 at 1:25 PM, Mucklow, Blaine (GE Energy)
<Bl...@ge.com> wrote:
> Datastax OpsCenter really is pretty awesome. I haven't tried anything
> else, but have had no issues with opscenter.
>
> On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
>
>>hey all,
>>
>> I have a new cassandra node that I've setup so that I can get better
>>acquainted with this technology. Thus far I've been using the
>>cassandra-cli and it'd been a fun experience so far. However I know
>>that there are a few cassandra gui's out there and I was just
>>wondering which ones you've used that you've had a good experience
>>with and can recommend?
>>
>> So far I've heard of (but not used) DataStax OpsCenter as well as the
>>Apollo gui and I think there may be others. Ideally what I'd like to
>>be able to do is both manage nodes and enter data into the keystores
>>using a graphical user interface.
>>
>>Thanks
>>tim
>>--
>>GPG me!!
>>
>>gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>
Re: really bad select performance
Posted by Jonathan Ellis <jb...@gmail.com>.
Secondary indexes can generate a lot of random i/o. iostat -x can
confirm if that's your problem.
On Thu, Mar 29, 2012 at 5:52 PM, Chris Hart <ch...@remilon.com> wrote:
> Hi,
>
> I have the following cluster:
>
> 136112946768375385385349842972707284580
> <ip address> MountainViewRAC1 Up Normal 1.86 GB 20.00% 0
> <ip address> MountainViewRAC1 Up Normal 2.17 GB 33.33% 56713727820156410577229101238628035242
> <ip address> MountainViewRAC1 Up Normal 2.41 GB 33.33% 113427455640312821154458202477256070485
> <ip address> Rackspace RAC1 Up Normal 3.9 GB 13.33% 136112946768375385385349842972707284580
>
> The following query runs quickly on all nodes except 1 MountainView node:
>
> select * from Access_Log where row_loaded = 0 limit 1;
>
> There is a secondary index on row_loaded. The query usually doesn't complete (but sometimes does) on the bad node and returns very quickly on all other nodes. I've upping the rpc timeout to a full minute (rpc_timeout_in_ms: 60000) in the yaml, but it still often doesn't complete in a minute. It seems just as likely to complete and takes about the same amount of time whether the limit is 1, 100 or 1000.
>
>
> Thanks for any help,
> Chris
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com
Re: really bad select performance
Posted by David Leimbach <le...@gmail.com>.
But now when you set to 0 that index row will get very wide as it collects
everything completed. You may want to consider deleting the indexed column
for completed rows when done.
Cassandra is not a great queue to use with built in indexes. Yo cold write
your own index here and potentially do better.
On Thursday, April 5, 2012, Chris Hart wrote:
> Thanks for all the help everyone. The values were meant to be binary. I
> ended making the possible values between 0 and 50 instead of just 0 or 1.
> That way no single index row gets that wide. I now run queries for
> everything from 1 to 50 to get 'queued' items and set the value to 0 when
> I'm done (I will never query for row_loaded = 0). It's unfortunate
> Cassandra doesn't delegate the query execution to a node that had the index
> row on it, but rather tries to move the entire index row to the node that
> is queried.
>
> -Chris
>
> ----- Original Message -----
> From: "David Leimbach" <leimy2k@gmail.com <javascript:;>>
> To: user@cassandra.apache.org <javascript:;>
> Sent: Monday, April 2, 2012 8:51:46 AM
> Subject: Re: really bad select performance
>
>
> This is all very hypothetical, but I've been bitten by this before.
>
> Does row_loaded happen to be a binary or boolean value? If so the
> secondary index generated by Cassandra will have at most 2 rows, and
> they'll be REALLY wide if you have a lot of entries. Since Cassandra
> doesn't distribute columns over rows, those potentially very wide index
> rows, and their replicas, must live in SSTables in their entirety on the
> nodes that own them (and their replicas).
>
>
> Even though you limit 1, I'm not sure what "behind the scenes" things
> Cassandra does. I've received advice to avoid the built in secondary
> indexes in Cassandra for some of these reasons. Also if row_loaded is meant
> to implement some kind of queuing behavior, it could be the wrong problem
> space for Cassandra as a result of all of the above.
>
>
>
>
>
>
>
>
>
> On Sat, Mar 31, 2012 at 12:22 PM, aaron morton < aaron@thelastpickle.com<javascript:;>> wrote:
>
>
>
>
> Is there anything in the logs when you run the queries ?
>
>
> Try turning the logging up to DEBUG on the node that fails to return and
> see what happens. You will see it send messages to other nodes and do work
> itself.
>
> One thing to note, a query that uses secondary indexes runs on a node for
> each token range. So it will use more than CL number of nodes.
>
>
> Cheers
>
>
>
>
>
>
>
> -----------------
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
>
> On 30/03/2012, at 11:52 AM, Chris Hart wrote:
>
>
>
> Hi,
>
> I have the following cluster:
>
> 136112946768375385385349842972707284580
> <ip address> MountainViewRAC1 Up Normal 1.86 GB 20.00% 0
> <ip address> MountainViewRAC1 Up Normal 2.17 GB 33.33%
> 56713727820156410577229101238628035242
> <ip address> MountainViewRAC1 Up Normal 2.41 GB 33.33%
> 113427455640312821154458202477256070485
> <ip address> Rackspace RAC1 Up Normal 3.9 GB 13.33%
> 136112946768375385385349842972707284580
>
> The following query runs quickly on all nodes except 1 MountainView node:
>
> select * from Access_Log where row_loaded = 0 limit 1;
>
> There is a secondary index on row_loaded. The query usually doesn't
> complete (but sometimes does) on the bad node and returns very quickly on
> all other nodes. I've upping the rpc timeout to a full minute
> (rpc_timeout_in_ms: 60000) in the yaml, but it still often doesn't complete
> in a minute. It seems just as likely to complete and takes about the same
> amount of time whether the limit is 1, 100 or 1000.
>
>
> Thanks for any help,
> Chris
>
>
>
Re: really bad select performance
Posted by Chris Hart <ch...@remilon.com>.
Thanks for all the help everyone. The values were meant to be binary. I ended making the possible values between 0 and 50 instead of just 0 or 1. That way no single index row gets that wide. I now run queries for everything from 1 to 50 to get 'queued' items and set the value to 0 when I'm done (I will never query for row_loaded = 0). It's unfortunate Cassandra doesn't delegate the query execution to a node that had the index row on it, but rather tries to move the entire index row to the node that is queried.
-Chris
----- Original Message -----
From: "David Leimbach" <le...@gmail.com>
To: user@cassandra.apache.org
Sent: Monday, April 2, 2012 8:51:46 AM
Subject: Re: really bad select performance
This is all very hypothetical, but I've been bitten by this before.
Does row_loaded happen to be a binary or boolean value? If so the secondary index generated by Cassandra will have at most 2 rows, and they'll be REALLY wide if you have a lot of entries. Since Cassandra doesn't distribute columns over rows, those potentially very wide index rows, and their replicas, must live in SSTables in their entirety on the nodes that own them (and their replicas).
Even though you limit 1, I'm not sure what "behind the scenes" things Cassandra does. I've received advice to avoid the built in secondary indexes in Cassandra for some of these reasons. Also if row_loaded is meant to implement some kind of queuing behavior, it could be the wrong problem space for Cassandra as a result of all of the above.
On Sat, Mar 31, 2012 at 12:22 PM, aaron morton < aaron@thelastpickle.com > wrote:
Is there anything in the logs when you run the queries ?
Try turning the logging up to DEBUG on the node that fails to return and see what happens. You will see it send messages to other nodes and do work itself.
One thing to note, a query that uses secondary indexes runs on a node for each token range. So it will use more than CL number of nodes.
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 30/03/2012, at 11:52 AM, Chris Hart wrote:
Hi,
I have the following cluster:
136112946768375385385349842972707284580
<ip address> MountainViewRAC1 Up Normal 1.86 GB 20.00% 0
<ip address> MountainViewRAC1 Up Normal 2.17 GB 33.33% 56713727820156410577229101238628035242
<ip address> MountainViewRAC1 Up Normal 2.41 GB 33.33% 113427455640312821154458202477256070485
<ip address> Rackspace RAC1 Up Normal 3.9 GB 13.33% 136112946768375385385349842972707284580
The following query runs quickly on all nodes except 1 MountainView node:
select * from Access_Log where row_loaded = 0 limit 1;
There is a secondary index on row_loaded. The query usually doesn't complete (but sometimes does) on the bad node and returns very quickly on all other nodes. I've upping the rpc timeout to a full minute (rpc_timeout_in_ms: 60000) in the yaml, but it still often doesn't complete in a minute. It seems just as likely to complete and takes about the same amount of time whether the limit is 1, 100 or 1000.
Thanks for any help,
Chris
Re: really bad select performance
Posted by David Leimbach <le...@gmail.com>.
This is all very hypothetical, but I've been bitten by this before.
Does row_loaded happen to be a binary or boolean value? If so the
secondary index generated by Cassandra will have at most 2 rows, and
they'll be REALLY wide if you have a lot of entries. Since Cassandra
doesn't distribute columns over rows, those potentially very wide index
rows, and their replicas, must live in SSTables in their entirety on the
nodes that own them (and their replicas).
Even though you limit 1, I'm not sure what "behind the scenes" things
Cassandra does. I've received advice to avoid the built in secondary
indexes in Cassandra for some of these reasons. Also if row_loaded is
meant to implement some kind of queuing behavior, it could be the wrong
problem space for Cassandra as a result of all of the above.
On Sat, Mar 31, 2012 at 12:22 PM, aaron morton <aa...@thelastpickle.com>wrote:
> Is there anything in the logs when you run the queries ?
>
> Try turning the logging up to DEBUG on the node that fails to return and
> see what happens. You will see it send messages to other nodes and do work
> itself.
>
> One thing to note, a query that uses secondary indexes runs on a node for
> each token range. So it will use more than CL number of nodes.
>
> Cheers
>
> -----------------
> Aaron Morton
> Freelance Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 30/03/2012, at 11:52 AM, Chris Hart wrote:
>
> Hi,
>
> I have the following cluster:
>
> 136112946768375385385349842972707284580
> <ip address> MountainViewRAC1 Up Normal 1.86 GB
> 20.00% 0
> <ip address> MountainViewRAC1 Up Normal 2.17 GB
> 33.33% 56713727820156410577229101238628035242
> <ip address> MountainViewRAC1 Up Normal 2.41 GB
> 33.33% 113427455640312821154458202477256070485
> <ip address> Rackspace RAC1 Up Normal 3.9 GB
> 13.33% 136112946768375385385349842972707284580
>
> The following query runs quickly on all nodes except 1 MountainView node:
>
> select * from Access_Log where row_loaded = 0 limit 1;
>
> There is a secondary index on row_loaded. The query usually doesn't
> complete (but sometimes does) on the bad node and returns very quickly on
> all other nodes. I've upping the rpc timeout to a full minute
> (rpc_timeout_in_ms: 60000) in the yaml, but it still often doesn't complete
> in a minute. It seems just as likely to complete and takes about the same
> amount of time whether the limit is 1, 100 or 1000.
>
>
> Thanks for any help,
> Chris
>
>
>
Re: really bad select performance
Posted by aaron morton <aa...@thelastpickle.com>.
Is there anything in the logs when you run the queries ?
Try turning the logging up to DEBUG on the node that fails to return and see what happens. You will see it send messages to other nodes and do work itself.
One thing to note, a query that uses secondary indexes runs on a node for each token range. So it will use more than CL number of nodes.
Cheers
-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 30/03/2012, at 11:52 AM, Chris Hart wrote:
> Hi,
>
> I have the following cluster:
>
> 136112946768375385385349842972707284580
> <ip address> MountainViewRAC1 Up Normal 1.86 GB 20.00% 0
> <ip address> MountainViewRAC1 Up Normal 2.17 GB 33.33% 56713727820156410577229101238628035242
> <ip address> MountainViewRAC1 Up Normal 2.41 GB 33.33% 113427455640312821154458202477256070485
> <ip address> Rackspace RAC1 Up Normal 3.9 GB 13.33% 136112946768375385385349842972707284580
>
> The following query runs quickly on all nodes except 1 MountainView node:
>
> select * from Access_Log where row_loaded = 0 limit 1;
>
> There is a secondary index on row_loaded. The query usually doesn't complete (but sometimes does) on the bad node and returns very quickly on all other nodes. I've upping the rpc timeout to a full minute (rpc_timeout_in_ms: 60000) in the yaml, but it still often doesn't complete in a minute. It seems just as likely to complete and takes about the same amount of time whether the limit is 1, 100 or 1000.
>
>
> Thanks for any help,
> Chris
really bad select performance
Posted by Chris Hart <ch...@remilon.com>.
Hi,
I have the following cluster:
136112946768375385385349842972707284580
<ip address> MountainViewRAC1 Up Normal 1.86 GB 20.00% 0
<ip address> MountainViewRAC1 Up Normal 2.17 GB 33.33% 56713727820156410577229101238628035242
<ip address> MountainViewRAC1 Up Normal 2.41 GB 33.33% 113427455640312821154458202477256070485
<ip address> Rackspace RAC1 Up Normal 3.9 GB 13.33% 136112946768375385385349842972707284580
The following query runs quickly on all nodes except 1 MountainView node:
select * from Access_Log where row_loaded = 0 limit 1;
There is a secondary index on row_loaded. The query usually doesn't complete (but sometimes does) on the bad node and returns very quickly on all other nodes. I've upping the rpc timeout to a full minute (rpc_timeout_in_ms: 60000) in the yaml, but it still often doesn't complete in a minute. It seems just as likely to complete and takes about the same amount of time whether the limit is 1, 100 or 1000.
Thanks for any help,
Chris
Re: cassandra gui
Posted by "Mucklow, Blaine (GE Energy)" <Bl...@ge.com>.
Datastax OpsCenter really is pretty awesome. I haven't tried anything
else, but have had no issues with opscenter.
On 3/29/12 1:53 PM, "Tim Dunphy" <bl...@gmail.com> wrote:
>hey all,
>
> I have a new cassandra node that I've setup so that I can get better
>acquainted with this technology. Thus far I've been using the
>cassandra-cli and it'd been a fun experience so far. However I know
>that there are a few cassandra gui's out there and I was just
>wondering which ones you've used that you've had a good experience
>with and can recommend?
>
> So far I've heard of (but not used) DataStax OpsCenter as well as the
>Apollo gui and I think there may be others. Ideally what I'd like to
>be able to do is both manage nodes and enter data into the keystores
>using a graphical user interface.
>
>Thanks
>tim
>--
>GPG me!!
>
>gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B