book

Mastering Apache Cassandra - Second Edition

by Nishant Neeraj

March 2015

Beginner to intermediate

350 pages

7h 54m

English

Packt Publishing

Read now

Unlock full access

Support files, eBooks, discount offers, and moreWhy subscribe?Free access for Packt account holders
What this book covers

Downloading the example codeErrataPiracyQuestions
Introduction to CassandraA distributed databaseHigh availabilityReplicationMultiple data centers
Modeling dataWriting codeSetting upInserting recordsRetrieving dataWriting your applicationGetting the connectionExecuting queriesObject mapping
Problems in the RDBMS world
The CAP theoremConsistencyAvailabilityPartition-toleranceThe significance of the CAP theorem
Ring representationVirtual nodesHow Cassandra worksWrite in actionRead in actionThe components of CassandraThe messaging serviceGossipFailure detectionGossip and failure detectionPartitionerReplicationThe notorious R + W > N inequalityLSM treeCommit logMemTableSSTableThe bloom filterIndex filesData filesCompactionTombstonesHinted handoffRead repair and anti-entropyMerkle tree
The Cassandra data modelThe counter column (cell)The expiring cellThe column familyKeyspacesData typesThe primary indexCQL3Creating a keyspaceSimpleStrategyNetworkTopologyStrategyAltering a keyspaceCreating a tableTable propertiesAltering a tableAdding a columnRenaming a columnChanging the data typeDropping a columnUpdating the table propertiesDropping a tableCreating an indexDropping an indexCreating a data typeAltering a custom typeDropping a custom typeCreating triggersDropping a triggerCreating a userAltering a userDropping a userThe granting permissionRevoking permission using REVOKEInserting dataCollections in CQLListsSetsMapsLightweight transactionsUpdating a rowDeleting a rowExecuting the BATCH statementOther CQL commandsUSETRUNCATELIST USERSLIST PERMISSIONS
DESCRIBETRACINGCONSISTENCYCOPYCAPTUREASSUMESOURCESHOWEXIT
Evaluating requirementsHard disk capacityRAMCPUIs node a server?Network
Optimizing user limitsSwapping memoryClock synchronizationDisk readahead
Installing Oracle Java 7RHEL and CentOS systemsDebian and Ubuntu systemsInstalling the Java Native Access library
Installing from a tarballInstalling from ASFRepository for Debian or UbuntuAnatomy of the installationCassandra binariesConfiguration filesSetting up data and commitlog directories
The cluster nameThe seed nodeListen, broadcast, and RPC addressesnum_tokens versus initial_tokennum_tokensinitial_tokenPartitionersThe Random partitionerThe Byte-ordered partitionerThe Mumur3 partitionerSnitchesSimpleSnitchPropertyFileSnitchGossipingPropertyFileSnitchRackInferringSnitchEC2SnitchEC2MultiRegionSnitchReplica placement strategiesSimpleStrategyNetworkTopologyStrategyMultiple data center setupsLaunching a cluster with a scriptCreating a keyspace
Stress testingDatabase schemaData distributionWrite patternRead queries
Write performanceRead performanceChoosing the right compaction strategySize-tiered compaction strategyLeveled compactionRow cacheKey cacheCache settingsEnabling compressionTuning the bloom filterMore tuning via cassandra.yamlcommitlog_synccolumn_index_size_in_kbcommitlog_total_space_in_mbTweaking JVMJava heapGarbage collectionOther JVM optionsScaling horizontally and verticallyNetwork
ScalingAdding nodes to a clusterAdding new nodes in vnode-enabled clustersAdding a new node to a cluster without vnodesRemoving nodes from a clusterRemoving a live nodeRemoving a dead node
Using the Cassandra bulk loader to restore the data
Cassandra's JMX interfaceAccessing MBeans using JConsole
Monitoring with nodetoolcfstatsnetstatsstatusring and describeringtpstatscompactionstatsinfoManaging administration with nodetooldraindecommissionremovenodemoverepairupgradesstablesnapshot
The OpsCenter featuresInstalling OpsCenter and an agentPrerequisitesRunning a Cassandra clusterInstalling OpsCenter from tarballSetting up an OpsCenter agentMonitoring and administrating with OpsCenterOther features of OpsCenter
Installing NagiosPrerequisitesPreparationInstallationInstalling NagiosConfiguring Apache httpdInstalling Nagios pluginsSetting up Nagios as a serviceNagios pluginsNagios plugins for CassandraExecuting remote plugins via the NRPE pluginInstalling NRPE on host machinesInstalling the NRPE plugin on a Nagios machineSetting up things to monitorMonitoring and notification using Nagios
Enabling Java options for GC logging
High CPU usageHigh memory usageHotspotsOpen JDK's erratic behaviorDisk performanceSlow snapshotsGetting help from the mailing list
Using Hadoop
Introduction to HadoopHDFSData managementNameNodeDataNodesHadoop MapReduceJobTrackerTaskTrackerReliability of data and processes in HadoopSetting up local HadoopTesting the installation
Preparing Cassandra for HadoopColumnFamilyInputFormatColumnFamilyOutputFormatCqlOutputFormat and CqlInputFormatConfigHelperWide row supportBulk loadingSecondary index support
Executing, debugging, monitoring, and looking at results
Cassandra filesystem
Installing PigIntegrating Pig and CassandraIntegration with other analytical tools

Content preview from Mastering Apache Cassandra - Second Edition

Chapter 3. Effective CQL

This chapter will introduce you to the underlying data structure of tables in Cassandra. Let's set some development rules of thumb before we dive into CQL. With CQL 3, Cassandra development team has done a commendable job of almost entirely eliminating any chance of using an antipattern, and at the same time bringing an interface that is SQL people friendly.

If you are a developer, this is probably the most important chapter for you. You will get a sense of things that are possible and not possible when working with Cassandra. You may also want to refer Chapter 8, Integration with Hadoop, to understand how to use Cassandra with various big data technologies such as the Hadoop ecosystem and Spark/Shark.

When dealing with ...