We have around 20 Million rows and around 200 concurrent users The reason we want single Node is we have only single DC , I believe if there is only one DC there is no question of keeping multiple nodes
The main reason we want to migrate to Cassandra is we have a denormalized data structure in Ms Sql server Database and we want to move to Open source database , currently we are in process of POC of Cassandra only I want to keep it less complicated and simple hence I want to go with Single Node The main issue that we have is the Transaction support Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019 e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/> From: Jack Krupansky [mailto:jack.krupan...@gmail.com] Sent: April 06, 2016 7:29 PM To: user@cassandra.apache.org Subject: Re: Cassandra Single Node Setup Questions Generally, regardless of your expected cluster size, you need to perform a proof of concept implementation (POC) to obtain those numbers for your own application. These numbers are not absolute limits enforced by Cassandra, but practical limits based on your actual data model, actual data patterns, and actual access patterns, as well as your actual hardware - RAM, storage (SSD vs. HDD), and network connectivity. And queries drive the data modeling - how do you intend to access the data, latency requirements, and how many concurrent clients do you expect. Generally, Cassandra is chosen for applications which have a lot of data and the need for high availability (redundancy, meaning at least three copies of the data.) Neither of which seems to be your requirement. How much data do you have? What led you to believe that you only need a single node? -- Jack Krupansky On Wed, Apr 6, 2016 at 9:44 AM, Bhupendra Baraiya <bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net>> wrote: Hi , I had few question related to Single Node Setup in Cassandra 1) We want to install Cassandra but multiple Node is not what we need Can we proceed with Single Node and store millions of data in Single Node only 2) How many Partitions are allowed per Node , that is what is the limit of Partition in single node if exceeded will impact the Performance 3) How many rows allowed per Partition in Single Node Thanks and regards, Bhupendra Baraiya Continuum Managed Services, LLC. p: 902-933-0019<tel:902-933-0019> e: bhupendra.bara...@continuum.net<mailto:bhupendra.bara...@continuum.net> w: continuum.net<http://continuum.net> [http://cdn2.hubspot.net/hub/281750/file-393087232-png/img/logos/email-continuum-logo-151x26.png]<http://www.continuum.net/>
