From user-return-62162-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Wed Sep 5 17:47:30 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 970D8180654 for ; Wed, 5 Sep 2018 17:47:29 +0200 (CEST) Received: (qmail 79204 invoked by uid 500); 5 Sep 2018 15:47:27 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 79194 invoked by uid 99); 5 Sep 2018 15:47:27 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Sep 2018 15:47:27 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 65D65CB0E8 for ; Wed, 5 Sep 2018 15:47:27 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.891 X-Spam-Level: * X-Spam-Status: No, score=1.891 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_PASS=-0.001, T_DKIMWL_WL_MED=-0.01] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 4FnJgaTeMwOq for ; Wed, 5 Sep 2018 15:47:26 +0000 (UTC) Received: from mail-it0-f42.google.com (mail-it0-f42.google.com [209.85.214.42]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 850E35F3EE for ; Wed, 5 Sep 2018 15:47:25 +0000 (UTC) Received: by mail-it0-f42.google.com with SMTP id e14-v6so10547741itf.1 for ; Wed, 05 Sep 2018 08:47:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=mZDwZCsslXBlE+rEFVP8UheY6cAewUJaKSbdGSYZ+Ks=; b=EbMUYHPWsczpR4recBHkpt7a5wpwhRSP1WABE8llCFn3vFBI7N2aS39l5KIVHIaG8Z qsMo1NBgJevNlUSXntQFpwx/dXNsEt/6x8M2z3flI2rs6dwcZCj+whIpuWA7IQ5yG7zk D1VKdXxc9HLzxuB9Pp5b7J/Nhwjj6B37VHjc3+16hCklIjHXqSrCmAXuhYXgrs2RjuBk eLl7bS203UeLVImAXgrWvzesOml/gVbzYLfYXjab04clf5aL0BTrOi1k5hmUGbHWj+DJ zuNK6oWW8dTW5D+avyCvwPyi2dhOTKgOlTuJSL2064XbLaDBkoLiok8OpAiPqs/1po+d VuAA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=mZDwZCsslXBlE+rEFVP8UheY6cAewUJaKSbdGSYZ+Ks=; b=jsmXXyxHVwjkyR8b7ShbVeg8P2RDwIhdWpS2Xv7X/osy+dHq6B5i+H8bVQTd3kOf/s mcwNjx8mffdPtz8COLIGIrgTceX45tKhXB7DcctZTW/ClIIWhyLOYyXEz78jPtzKT+n3 XEirzOWkq0bqE6Jo8L4Wf+OOme4xSvGZRGgO9wbdEYirPH9h/kx7IGeh+Czu+RBdCNAp z+Zib0XLsh2PvFKkKmecBDSNrgXXCn02ErzCu4SRRzoHh8NEo9va8HF3wZ7ir/gyc1nR 4itThdFnNGZdrsVnWeOggwSxLyrPkS+3PMvDTebUM4OlSuN1FPr0FvHD9sCAAO+FzJMP R44w== X-Gm-Message-State: APzg51AHCPdETkrtqJzo4MnwzAXV2fqexSiFNt10sRaFzZ6kgjCfeowY epvZQ0sp6ZYEWBuNiyBz8AaySCF2ip+JF6mDZY7VAPqT X-Google-Smtp-Source: ANB0VdaVrMARvBqJ4+OxP0HJWicYRHEjP+AzBU3ZLaCZbvQfdnuUAgTWVBep/3RewUl0Xfw+iWIA1L5OIcGMPSHNi4g= X-Received: by 2002:a02:e44:: with SMTP id 65-v6mr27503711jae.7.1536162443867; Wed, 05 Sep 2018 08:47:23 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Jeff Jirsa Date: Wed, 5 Sep 2018 08:47:11 -0700 Message-ID: Subject: Re: [EXTERNAL] Regarding migrating data from Oracle to Cassandra.migrate data from Oracle to Cassandra. To: cassandra Content-Type: multipart/alternative; boundary="000000000000c8b932057521b08c" --000000000000c8b932057521b08c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable All of Sean's points are good, a few more: - Apache Cassandra (free, open source, official) is usually sufficient. DSE may be faster, but really it's about whether or not you're willing to pay for support. If you're trying to stop paying Oracle, I suspect you'd probably not want to start paying someone else - try the free version first, and you can look for proprietary options after that. - http://shop.oreilly.com/product/0636920043041.do is relatively recent and mostly pretty good - Ask a lot of questions, use this list, but try things out first so people have a way to point you in the right direction. On Wed, Sep 5, 2018 at 7:58 AM Durity, Sean R wrote: > 3 starting points: > > - DO NOT migrate your tables as they are in Oracle to Cassandra. > In most cases, you need a different model for Cassandra > > - DO take the (free) DataStax Academy courses to learn much more > about Cassandra as you dive in. It is a systematic and bite-size approach > to learning all things Cassandra (and eventually, DataStax Enterprise, > should you go that way). However, open source Cassandra is fine as a data > platform. DSE gives you more options for data models, better administrati= on > and monitoring tools, support, etc. It all depends on what you need/want = to > build/can afford > > - Cluster sizing depends on your goals for the data platform. Do > you need lots of storage, lots of throughput, high availability, low > latency, workload separation, etc.? A couple guidelines =E2=80=93 use at = least 3 > nodes per data center (DC) and at least 2 DCs for availability. Use SSDs > for storage and keep node size 3 TB or less for reasonable administration= . > If six nodes are too many =E2=80=93 you probably don=E2=80=99t need Cassa= ndra. If you can > define what you need your data platform to deliver, then you can start a > sizing discussion. The good thing is, you can always scale (as long as th= e > data model is good). > > > > > > Sean Durity > > > > *From:* sha p > *Sent:* Wednesday, September 05, 2018 9:21 AM > *To:* user@cassandra.apache.org > *Subject:* [EXTERNAL] Regarding migrating data from Oracle to > Cassandra.migrate data from Oracle to Cassandra. > > > > > > Hi all , > > Me new to Cassandra , i was asked to migrate data from Oracle to Cassandr= a. > > Please help me giving your valuable guidance. > > 1) Can it be done using open source Cassandra. > > 2) Where should I start data model from? > > 3) I should use java, what kind of jar/libs/tools I need use ? > > 4) How I decide the size of cluster , please provide some sample > guidelines. > > 5) this should be in production , so what kind of things i should take > care for better support or debugging tomorrow? > > 6) Please provide some good books /links which can help me in this task. > > > > > > Thanks in advance. > > Highly appreciated your every amal help. > > > > Regards, > > Shyam > > > ------------------------------ > > The information in this Internet Email is confidential and may be legally > privileged. It is intended solely for the addressee. Access to this Email > by anyone else is unauthorized. If you are not the intended recipient, an= y > disclosure, copying, distribution or any action taken or omitted to be > taken in reliance on it, is prohibited and may be unlawful. When addresse= d > to our clients any opinions or advice contained in this Email are subject > to the terms and conditions expressed in any applicable governing The Hom= e > Depot terms of business or client engagement letter. The Home Depot > disclaims all responsibility and liability for the accuracy and content o= f > this attachment and for any damages or losses arising from any > inaccuracies, errors, viruses, e.g., worms, trojan horses, etc., or other > items of a destructive nature, which may be contained in this attachment > and shall not be liable for direct, indirect, consequential or special > damages in connection with this e-mail message or its attachment. > --000000000000c8b932057521b08c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
All of=C2=A0 Sean's points are good, = a few more:
- Apache Cassandra (free, open source, official) is usually= sufficient. DSE may be faster, but really it's about whether or not yo= u're willing to pay for support. If you're trying to stop paying Or= acle, I suspect you'd probably not want to start paying someone else - = try the free version first, and you can look for proprietary options after = that.=C2=A0
-=C2=A0http://shop.oreilly.com/product/0636920043041.do is rela= tively recent and mostly pretty good
- Ask a lot of questions, us= e this list, but try things out first so people have a way to point you in = the right direction.=C2=A0
=C2=A0


On Wed, Sep 5, 2018 at 7:5= 8 AM Durity, Sean R <SEAN= _R_DURITY@homedepot.com> wrote:

3 starting points:

<= span>-=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 DO NOT migrate your tables as th= ey are in Oracle to Cassandra. In most cases, you need a different model fo= r Cassandra

<= span>-=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 DO take the (free) DataStax Acad= emy courses to learn much more about Cassandra as you dive in. It is a syst= ematic and bite-size approach to learning all things Cassandra (and eventually, DataStax Enterprise, should you go t= hat way). However, open source Cassandra is fine as a data platform. DSE gi= ves you more options for data models, better administration and monitoring = tools, support, etc. It all depends on what you need/want to build/can afford

<= span>-=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Cluster sizing depends on your g= oals for the data platform. Do you need lots of storage, lots of throughput= , high availability, low latency, workload separation, etc.? A couple guidelines =E2=80=93 use at least 3 nodes per d= ata center (DC) and at least 2 DCs for availability. Use SSDs for storage a= nd keep node size 3 TB or less for reasonable administration.=C2=A0 If six = nodes are too many =E2=80=93 you probably don=E2=80=99t need Cassandra. If you can define what you need your data platform to deliver, = then you can start a sizing discussion. The good thing is, you can always s= cale (as long as the data model is good).

=C2=A0

=C2=A0

Sean Durity

=C2=A0

From: sha p <shatesttest@gmail.com>
Sent: Wednesday, September 05, 2018 9:21 AM
To: u= ser@cassandra.apache.org
Subject: [EXTERNAL] Regarding migrating data from Oracle to Cassandr= a.migrate data from Oracle to Cassandra.

=C2=A0

=C2=A0

Hi all ,

Me new to Cassandra , i was asked to migrate data fr= om Oracle to Cassandra.

Please help me giving your valuable guidance.=

1) Can it be done using open source Cassandra.

2) Where should I start data model from?

3) I should use java, what kind of=C2=A0 jar/libs/to= ols I need use ?

4) How I decide the size of cluster , please provide= some sample guidelines.

5) this should be in production , so what kind of th= ings i should take care for better support or debugging tomorrow?=

6) Please provide some good books /links which can h= elp me in this task.

=C2=A0

=C2=A0

Thanks in advance.

Highly appreciated your every amal help.

=C2=A0

Regards,

Shyam



The information in this Internet Email is confidential and may be legally p= rivileged. It is intended solely for the addressee. Access to this Email by= anyone else is unauthorized. If you are not the intended recipient, any di= sclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibite= d and may be unlawful. When addressed to our clients any opinions or advice= contained in this Email are subject to the terms and conditions expressed = in any applicable governing The Home Depot terms of business or client engagement letter. The Home Depot d= isclaims all responsibility and liability for the accuracy and content of t= his attachment and for any damages or losses arising from any inaccuracies,= errors, viruses, e.g., worms, trojan horses, etc., or other items of a destructive nature, which may be contain= ed in this attachment and shall not be liable for direct, indirect, consequ= ential or special damages in connection with this e-mail message or its att= achment.
--000000000000c8b932057521b08c--