Презентация «Install Apache Cassandra on Ubuntu. Work with Cassandra and Python»

Pic.1

Apache Cassandra

Pic.2

Week plan 1. What is Cassandra? 2. Install Apache Cassandra on Ubuntu 3. Work with Cassandra and Python

Pic.3

Tutorial

Pic.4

What is Cassandra? Apache Cassandra is a top level Apache project born at Facebook and built on Amazon’s Dynamo and Google’s BigTable, is a distributed database for managing large amounts of …

Pic.5

What is Cassandra? Cassandra’s architecture is responsible for its ability to scale, perform, and offer continuous uptime. Rather than using a legacy master-slave or a manual and …

Pic.6

What is Cassandra? In Cassandra, all nodes are equal, which means no master node, no master-slave relationships between nodes, no sharded system. Cassandra’s scalable architecture allows it to handle …

Pic.7

Features of Cassandra Elastic scalability - add more nodes to accommodate more clients for data easily. Always on architecture - Business-critical applications cannot afford failures and Cassandra …

Pic.8

Disadvantages With all its shiny parts, Cassandra still has some let downs: A range scan implementation is far from perfect. A lot of adjustments are made at the cluster level. SSTable compaction, …

Pic.9

Data Replication in Cassandra In Cassandra, replicas for a given piece of data are distributed on one or more of the nodes in a cluster. If it is detected that some of the nodes responded with an …

Pic.10

Components of Cassandra Node − It is the place where data is stored, single machine. Data center − It is a collection of related nodes. Cluster − A cluster is a component that contains one or more …

Pic.11

Cassandra Architecture

Pic.12

Cassandra Query Language The Cassandra Query Language (CQL) is the primary language for communicating with the Cassandra database. CQL is purposefully similar to Structured Query Language (SQL) used …

Pic.13

Cassandra Operations Let’s find out how querying in Cassandra works.

Pic.14

Write Operation When write request comes to the node, first of all, it logs to the commit log. Then, Cassandra writes the data in the memtable. Mem-table is a temporarily stored data in the memory …

Pic.15

Read Operation There are three types of read requests that are sent to replicas by a coordinator node. Direct request Digest request Read repair request The coordinator sends direct request to one of …

Pic.16

Install Java on Ubuntu Before installing Cassandra, make sure that Java is already installed on your computer. To make the Oracle JRE package available, you'll have to add a Personal Package …

Pic.17

Install Java on Ubuntu Then, install the Oracle JRE. Installing this particular package not only installs it but also makes it the default JRE. When prompted, accept the license agreement: sudo …

Pic.18

Install Apache Cassandra on Ubuntu We will use DataStax Community repository with a few simple steps to install Cassandra: 1. Add the DataStax Community repository to the /etc/apt/sources. list. …

Pic.19

Install Apache Cassandra on Ubuntu 2. Add the DataStax repository key to your aptitude trusted keys sudo curl -L | sudo apt-key add - 3. Install the package: sudo apt-get update sudo apt-get install …

Pic.20

Install Apache Cassandra on Ubuntu Because the Ubuntu packages start the Cassandra service automatically, you must stop the server and clear the data: sudo service cassandra stop Next remove the …

Pic.21

Cassandra and Python For managing Cassandra via Python you have to install cassandra-driver package from PyPI (Python Package Index), it can be done using pip. Open console and run command: pip …

Pic.22

Create a Keyspace and Table

Pic.23

Create a Keyspace and Table Let's create a table, it will be called "users_".

Pic.24

Insert and Select Records We are going to add data to our table in three different ways: a standard one, using variables and a dictionary.

Pic.25

Insert and Select Records Let's select all the records to make sure that we have done everything right.

Pic.26

Update and Delete Records Let's change country for record with id = 3, and then check if something has changed in the table.

Pic.27

Update and Delete Records Let's delete one of the records, such as having id = 2. And display all records from the table.

Pic.28

Alter Table Modify the column metadata of a table. Adding a column To add a column (other than a column of a collection type) to a table, use ALTER TABLE and the ADDinstruction as follows: Dropping a …

Pic.29

Exercises

Pic.30

Task #1 Add a new record to the users_ table with the following values: id = 4, name = "User_4", born = 1998, country = "France". And check what you've done using current …

Pic.31

Task #2 Add new column into your table, let it be called "login", it should contain the same values as "name" column, but starting from lower case, type also should be the same. …

Pic.32

Task #3 Change country to "Ukraine" for user having id = 4 and display count of users from this country.

Pic.33

Thank for your attention

Скачать презентацию

Если вам понравился сайт и размещенные на нем материалы, пожалуйста, не забывайте поделиться этой страничкой в социальных сетях и с друзьями! Спасибо!