How to add a new DC to cluster in Cassandra 2.x

2014-01-21 Thread Lu, Boying
Hi, All, I'm new to Cassandra. I want to know how to add a DC to existing Cassandra cluster (all running Cassandra 2.x). I found a related document at http://www.datastax.com/docs/1.1/cluster_management Is it still valid for Cassandra 2.x? Thanks Boying

RE: How to add a new DC to cluster in Cassandra 2.x

2014-01-23 Thread Lu, Boying
Thanks a lot :) From: Robert Coli [mailto:rc...@eventbrite.com] Sent: 2014年1月24日 4:54 To: user@cassandra.apache.org Subject: Re: How to add a new DC to cluster in Cassandra 2.x On Tue, Jan 21, 2014 at 7:16 AM, Tupshin Harper tups...@tupshin.commailto:tups...@tupshin.com wrote: This should be

A question to OutboundTcpConnection.expireMessages()

2014-01-27 Thread Lu, Boying
Hi, All, When I read the codes of OutboundTcpConnection.expireMessages(), I found the following snippet in a loop: if (qm.timestamp = System.currentTimeMillis() - qm.message.getTimeout()) return; My understanding is that this method is to remove all the expired messages

How to paginate through all columns in a row?

2014-02-27 Thread Lu, Boying
Hi, All, I'm using Netflix/Astyanax as a java cassandra client to access Cassandra DB. I need to paginate through all columns in a row and I found the document at https://github.com/Netflix/astyanax/wiki/Reading-Data about how to do that. But my requirement is a little different. I don't want

RE: How to paginate through all columns in a row?

2014-03-03 Thread Lu, Boying
this is a bit different but I hope this shows you the general idea. T# On Thu, Feb 27, 2014 at 11:36 AM, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: Hi, All, I’m using Netflix/Astyanax as a java cassandra client to access Cassandra DB. I need to paginate through all columns in a row

How to paginate all columns in a row

2014-03-04 Thread Lu, Boying
Hi, All, I need to paginate all columns in a row. but can not to use RowQuery.autoPaginate() method to do this due to some requirements. All columns are composite column and I need to get next 'page' by a separated query. Here is my pseudo codes (page size =3): ColumListC result =

How many DCs can Cassandra support?

2014-03-06 Thread Lu, Boying
Hi, All, Does anyone know how many Datacenters Cassandra supports? Thanks Boying

How to use CompositeRangeBuilder to query multiple components in a column?

2014-03-09 Thread Lu, Boying
Hi, experts, I need to query all columns of a row in a column family that meet some conditions (see below). The column is composite column and has following format: component1component2compoment3... where componentN has String type. What I want to do is to find out all columns that meet

How many Data centers can Cassandra support?

2014-03-09 Thread Lu, Boying
Hi, experts, Since the Cassandra 2.x supports DB that across multiple DCs, my question is how many DCs can Cassandra support in practice? Thanks Boying

RE: How many Data centers can Cassandra support?

2014-03-10 Thread Lu, Boying
:26 AM, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: Hi, experts, Since the Cassandra 2.x supports DB that across multiple DCs, my question is how many DCs can Cassandra support in practice? Thanks Boying

Can the seeds list be changed at runtime?

2014-04-28 Thread Lu, Boying
Hi, All, I wonder if I can change the seeds list at runtime. i.e. without change the yaml file and restart DB service? Thanks Boying

Some questions to adding a new datacenter into cassandra cluster.

2014-04-30 Thread Lu, Boying
Hi, All, I need to add a Cassandra (running on a three nodes) fresh installed in a datacenter say DC3 to existing Cassandra datacenters say DC1 and DC2. I read the document about it at http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_add_dc_to_cluster_t.html But I

Query returns incomplete result

2014-05-15 Thread Lu, Boying
Hi, All, I use the astyanax 1.56.48 + Cassandra 2.0.6 in my test codes and do some query like this: query = keyspace.prepareQuery(..).getKey(...) .autoPaginate(true) .withColumnRange(new RangeBuilder().setLimit(pageSize).build()); ColumnListIndexColumnName result; result=

How to disconnect a data center with Astyanax

2014-07-15 Thread Lu, Boying
Hi, All, I need to remove a Cassandra data center from a set of connected Cassandra data centers (I use Cassandra 2.0.7). I found a related document at http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_decomission_dc_t.html But I need to do these in my Java programs.

How to prevent writing to a Keyspace?

2014-07-17 Thread Lu, Boying
Hi, All, I need to make a Cassandra keyspace to be read-only. Does anyone know how to do that? Thanks Boying

RE: How to prevent writing to a Keyspace?

2014-07-20 Thread Lu, Boying
? Boying From: Vivek Mishra [mailto:mishra.v...@gmail.com] Sent: 2014年7月17日 18:35 To: user@cassandra.apache.org Subject: Re: How to prevent writing to a Keyspace? Think about managing it via authorization and authentication support On Thu, Jul 17, 2014 at 4:00 PM, Lu, Boying boying

RE: How to prevent writing to a Keyspace?

2014-07-21 Thread Lu, Boying
. That way user cannot modify data in specific keyspace or column family. http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/grant_r.html -Vivek On Mon, Jul 21, 2014 at 7:57 AM, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: Thanks a lot ☺ But I think authorization

A question about using 'update keyspace with strategyoptions' command

2014-08-05 Thread Lu, Boying
Hi, All, I want to run 'update keyspace with strategy_options={dc1:3, dc2:3}' from cassandra-cli to update the strategy options of some keyspace in a multi-DC environment. When the command returns successfully, does it mean that the strategy options have been updated successfully or I need to

RE: A question about using 'update keyspace with strategyoptions' command

2014-08-05 Thread Lu, Boying
To: user Subject: Re: A question about using 'update keyspace with strategyoptions' command Try the show keyspaces command and look for Options under each keyspace. Thanks Rahul On Tue, Aug 5, 2014 at 2:01 PM, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: Hi, All, I want to run

RE: A question about using 'update keyspace with strategyoptions' command

2014-08-05 Thread Lu, Boying
Changing the strategy options, and in particular the replication factor, does not perform any data replication by itself. You need to run a repair to ensure data is replicated following the new replication. On Tue, Aug 5, 2014 at 10:52 AM, Lu, Boying boying...@emc.commailto:boying...@emc.com

RE: A question about using 'update keyspace with strategyoptions' command

2014-08-05 Thread Lu, Boying
...@datastax.com wrote: On Tue, Aug 5, 2014 at 11:40 AM, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: What I want to know is “are the strategy changed ?’ after the ‘udpate keyspace with strategy_options…’ command returns successfully Like all schema changes, not necessarily on all nodes

How to prevent the removed DC comes back automactically?

2014-08-13 Thread Lu, Boying
Hi, All, We are using Cassandra 2.0.7 in a multi DCs environments. If a connected DC is powered off, we use the 'nodetool removenode' command to remove it from the connected DCs. But we found that once the disconnected DC is powered on, it will connect to other DCs automatically. How can we

RE: How to prevent the removed DC comes back automactically?

2014-08-14 Thread Lu, Boying
: http://www.datastax.com/documentation/cassandra/1.2/cassandra/configuration/configCassandra_yaml_r.html -- artur On 14/08/14 06:48, Lu, Boying wrote: Hi, All, We are using Cassandra 2.0.7 in a multi DCs environments. If a connected DC is powered off, we use the ‘nodetool removenode’ command

A question to nodetool removenode command

2014-08-14 Thread Lu, Boying
Hi, All, We have a Cassandra 2.0.7 running in three connected DCs, say DC1, DC2 and DC3. DC3 is powered off, so we run 'nodetool removenode' command on DC1 to remove all nodes of DC3. Do we need to run the same command on DC2? Thanks Boying

RE: A question to nodetool removenode command

2014-08-14 Thread Lu, Boying
then remove all nodes in DC3 via nodetool removenode from a node in DC1, all nodes in both DC1 and DC2 will be informed of the nodes removal so no need to run it from a node in DC2. Mark On Thu, Aug 14, 2014 at 10:20 AM, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: Hi, All, We have

How to setup Cassandra client-to-node encryption

2014-09-26 Thread Lu, Boying
Hi, All, I use the following configuration (in yaml file) to enable the client-to-node encryption: client_encryption_options: enabled: true keystore: path-to-keystore-file keystore_password: some-password truststore: path-to-truststore-file truststore_password: some-password But

RE: How to setup Cassandra client-to-node encryption

2014-09-26 Thread Lu, Boying
-download-432124.html Bulat On Sep 26, 2014, at 7:58, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: Hi, All, I use the following configuration (in yaml file) to enable the client-to-node encryption: client_encryption_options: enabled: true keystore: path-to-keystore-file

How to enable client-to-node encrypt communcation?

2014-09-27 Thread Lu, Boying
Hi, All, I want to enable client-to-node encrypt communication, I read some related documents. I need to set the following changes in the server side (in yaml): client_encryption_opitons: enabled : true keystore: conf/.keystore keystore_password: some-password truststore:

How to enable client-to-node encrypt communication with Astyanax cassandra client

2014-10-08 Thread Lu, Boying
Hi, All, I'm trying to enable client-to-node encrypt communication in Cassandra (2.0.7) with Astyanax client library (version=1.56.48) I found the links about how to enable this feature: http://www.datastax.com/documentation/cassandra/2.0/cassandra/security/secureSSLClientToNode_t.html But this

A questiion to adding a new data center

2014-11-20 Thread Lu, Boying
Hi, all, I read the document about how to adding a new data center to existing clusters posted at http://www.datastax.com/documentation/cassandra/2.0/cassandra/operations/ops_add_dc_to_cluster_t.html But I have a question: Are all those steps executed only at the new adding cluster or on

RE: A questiion to adding a new data center

2014-11-23 Thread Lu, Boying
Step 6 - New DC Step 7 - New DC Step 8 - New DC Mark On 21 November 2014 03:27, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: Hi, all, I read the document about how to adding a new data center to existing clusters posted at http://www.datastax.com/documentation/cassandra/2.0

RE: A question to adding a new data center

2014-11-27 Thread Lu, Boying
or on the new datacenter: Step 1 - Current DC Step 2 - New DC Step 3 - Depending on the snitch you may need to make changes on both the current and new DCs Step 4 - Client config Step 5 - Client config Step 6 - New DC Step 7 - New DC Step 8 - New DC Mark On 21 November 2014 03:27, Lu, Boying boying

RE: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-02-02 Thread Lu, Boying
. References: How cqlsh picks up ssl optionshttps://github.com/apache/cassandra/blob/cassandra-2.1/pylib/cqlshlib/sslhandling.py Example cqlshrc filehttps://github.com/apache/cassandra/blob/cassandra-2.1/conf/cqlshrc.sample Adam Holmberg On Wed, Jan 28, 2015 at 1:08 AM, Lu, Boying boying

RE: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-02-04 Thread Lu, Boying
:15 AM, Lu, Boying boying...@emc.commailto:boying...@emc.com wrote: Hi, Holmberg, I tried your suggestion and run the following command: keytool –exportcert –keystore path-to-my-keystore-file –storepass my-keystore-password –storetype JKS –file path-to-outptfile and I got following error: keytool

FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-01-27 Thread Lu, Boying
Hi, All, Does anyone know the answer? Thanks a lot Boying From: Lu, Boying Sent: 2015年1月6日 11:21 To: user@cassandra.apache.org Subject: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled Hi, All, I turned on the dbclient_encryption_options like

RE: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-02-02 Thread Lu, Boying
. References: How cqlsh picks up ssl optionshttps://github.com/apache/cassandra/blob/cassandra-2.1/pylib/cqlshlib/sslhandling.py Example cqlshrc filehttps://github.com/apache/cassandra/blob/cassandra-2.1/conf/cqlshrc.sample Adam Holmberg On Wed, Jan 28, 2015 at 1:08 AM, Lu, Boying boying

How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-01-05 Thread Lu, Boying
Hi, All, I turned on the dbclient_encryption_options like this: client_encryption_options: enabled: true keystore: path-to-my-keystore-file keystore_password: my-keystore-password truststore: path-to-my-truststore-file truststore_password: my-truststore-password ... I can use following

Is there any roadmap of Cassandra 3.0?

2015-06-23 Thread Lu, Boying
Hi, All, Does anyone know the roadmap of Cassandra 3.0? Thanks Boying

RE: Is there any roadmap of Cassandra 3.0?

2015-06-23 Thread Lu, Boying
Thanks a lot :) From: Yoshi Kimoto [mailto:yy.kim...@gmail.com] Sent: 2015年6月24日 12:12 To: user@cassandra.apache.org Subject: Re: Is there any roadmap of Cassandra 3.0? Looking for this? Or something else? http://planetcassandra.org/blog/cassandra-2-2-3-0-and-beyond/ On 2015/06/24 12:42, Lu

which astyanax version to use?

2015-11-09 Thread Lu, Boying
Hi, All, We plan to upgrade Cassandra from 2.0.17 to 2.1.11 (the latest stable release recommended to be used in the product environment) in our product. Currently we are using Astyanax 1.56.49 as Java client, I found there are many new Astyanax at https://github.com/Netflix/astyanax/releases

any update about CASSANDRA-10420

2015-10-16 Thread Lu, Boying
Hi, All, Can anyone give some suggestions about the https://issues.apache.org/jira/browse/CASSANDRA-10420 ? We are waiting for a solution of it. Thanks Boying

How to get the peer's IP address when writing failed

2015-08-26 Thread Lu, Boying
Hi, All, We have an Cassandra environment with two connected DCs and our consistency level of writing operation is EACH_QUORUM. So if one DC is down, the write will be failed and we get TokenRangeOfflineException on the client side (we use netfilix java client libraries). We want to give more

Does Cassandra 2.2.1 works with Java 7?

2015-09-28 Thread Lu, Boying
Hi, All, The latest stable release of Cassandra is 2.2.1 and I notice the following line in the "Requirements" section of README.asc comes with the source codes: Java >=1.7 (OpenJDK and Oracle JVMS have been tested) Does this mean that Cassandra 2.2.1 (binary release) can work with Java 7?

Questions to StorageServiceMBean.forceRepaireRangeAsync()

2015-11-30 Thread Lu, Boying
Hi, All, We plan to upgrade Cassandra from 2.0.17 to the latest release 2.2.3 in our product. We use: /** * Same as forceRepairAsync, but handles a specified range */ public int forceRepairRangeAsync(String beginToken, String endToken, final String keyspaceName, boolean isSequential,

How to remove 'compact storage' attribute?

2016-06-07 Thread Lu, Boying
Hi, All, Since the Astyanax client has been EOL, we are considering to migrate to Datastax java client in our product. One thing I notice is that the CFs created by Astyanax have 'compact storage' attribute which prevent us from using some new features provided by CQL such as secondary index.

RE: How to remove 'compact storage' attribute?

2016-06-12 Thread Lu, Boying
://issues.apache.org/jira/browse/CASSANDRA-10857 Note that secondary indexes don't scale. Be aware of their limitations. If you want to change the data model of a CF, a Spark job can do the trick. Best, Romain Le Mardi 7 juin 2016 10h51, "Lu, Boying" <boying...@emc.com<mailto:boying...@emc.com

a question to Stratio's Cassandra Lucene Index

2016-05-31 Thread Lu, Boying
Hi, All, We are considering to support more flexible searching on data in the Cassandra DB (used in our product). For example, full-text search and query data based on different columns. After some investigating, I found

RE: A question to 'paging' support in DataStax java driver

2016-05-09 Thread Lu, Boying
but then we'll need to update the binary protocol. Just create a JIRA and ask for this feature On Tue, May 10, 2016 at 5:00 AM, Lu, Boying <boying...@emc.com<mailto:boying...@emc.com>> wrote: Thanks very much. I understand that the data needs to be read from the DB to get the next

A question to 'paging' support in DataStax java driver

2016-05-09 Thread Lu, Boying
dHi, All, We are considering to use DataStax java driver in our codes. One important feature provided by the driver we want to use is 'paging'. But according to the https://datastax.github.io/java-driver/3.0.0/manual/paging/, it seems that we can't jump between pages. Is it possible to just

RE: A question to 'paging' support in DataStax java driver

2016-05-09 Thread Lu, Boying
d the paging states for page 1, 2 and 3. Since there are concurrent inserts on the cluster at the same time, when you re-use the paging state 2 for example, you may not get the same results as the previous read. And it is inevitable in an eventual consistent distributed DB world On Mon, May 9, 2

RE: A question to updatesstables

2016-08-18 Thread Lu, Boying
月18日 18:44 To: user@cassandra.apache.org Subject: Re: A question to updatesstables Replies inline Carlos Alonso | Software Engineer | @calonso<https://twitter.com/calonso> On 18 August 2016 at 11:56, Lu, Boying <boying...@emc.com<mailto:boying...@emc.com>> wrote: Hi, All,

RE: A question to updatesstables

2016-08-19 Thread Lu, Boying
2016 11h32, "Lu, Boying" <boying...@emc.com<mailto:boying...@emc.com>> a écrit : Here is the error message in our log file: java.lang.RuntimeException: Incompatible SSTable found. Current version ka is unable to read file: /data/db/1/data/StorageOS/RemoteD

RE: A question to updatesstables

2016-08-19 Thread Lu, Boying
have one time seen an issue with commit log archiving preventing a startup during upgrade. Usually there is something else broken and the version mismatch is a false signal. Regards, Ryan Svihla On Aug 18, 2016, at 10:18 PM, Lu, Boying <boying...@emc.com<mailto:boying...@emc.com>> w

A question to sstable2json

2016-09-07 Thread Lu, Boying
Hi, All, We use Cassandra 2.1.11 in our product and I tried its sstable2json to dump some sstable file like this: sstable2json full-path-to-sstable-file (e.g. xxx-Data.db). But I got an assert error at "assert initialized || keyspaceName.equals(SYSTEM_KS);" (Keyspace.java:97). The

A question to updatesstables

2016-08-18 Thread Lu, Boying
Hi, All, We use Cassandra in our product. I our early release we use Cassandra 1.2.10 whose SSTable is 'ic' format. We upgrade Cassandra to 2.0.10 in our product release. But the Cassandra server failed to start due to the incompatible SSTable format and the log message told us to use 'nodetool

Some questions to updating and tombstone

2016-11-14 Thread Lu, Boying
Hi, All, Will the Cassandra generates a new tombstone when updating a column by using CQL update statement? And is there any way to get the number of tombstones of a column family since we want to void generating too many tombstones within gc_grace_period? Thanks Boying

RE: Some questions to updating and tombstone

2016-11-15 Thread Lu, Boying
Thanks a lot for your help. We are using STCS strategy and not using TTL Is there any API that we can use to query the current number of tombstones in a CF? From: Anuj Wadehra [mailto:anujw_2...@yahoo.co.in] Sent: 2016年11月14日 22:20 To: user@cassandra.apache.org Subject: Re: Some questions to

RE: Some questions to updating and tombstone

2016-11-17 Thread Lu, Boying
m,scope=,type=ColumnFamily Max/Count/99thPercentile/Mean 2016-11-15 10:05 GMT+01:00 Lu, Boying <boying...@dell.com<mailto:boying...@dell.com>>: Thanks a lot for your help. We are using STCS strategy and not using TTL Is there any API that we can use to query the current number