Your roadmap to understanding whether NoSQL is right for you.
Technology that can scale, perform and deliver 100% uptime is the difference between today’s successful online applications and those that fail. Relational databases (RDBMS) have struggled to keep up with the wave of modernization, leading to the rise of NoSQL as the most viable database option for online Web and mobile applications.
The path to understanding whether a NoSQL technology like DataStax Enterprise is right for your business as either a complementary technology to an RDBMS or as a complete replacement is a three step approach:
Step 1: Learn
Learn the difference between relational systems and Cassandra and the types of use cases it can solve. This content is applicable to both database developers, database administrators, and architects.
Get Started with NoSQL
- What is NoSQL?
- Why NoSQL? (White Paper)
- NoSQL Comparison
- Introduction to Apache Cassandra (White Paper | Video)
- Introduction to DataStax Enterprise (White Paper | Video)
- DBA’s Guide to NoSQL (Free e-book)
- Benchmarking Top NoSQL Databases (White Paper)
Compare DataStax Enterprise to Relational Systems
- When to Choose NoSQL Over an RDBMS (Video)
- Comparing DataStax Enterprise and Oracle (White Paper)
- Comparing Cassandra/DataStax Enterprise and Oracle RAC (Article)
- Why Migrate from MySQL to DataStax Enterprise? (White Paper)
- A Comparison of DataStax Enterprise and RDBMS’s (Comparison Matrix)
- How to Model Data in NoSQL/Cassandra vs. an RDBMS (Recorded Webinars)
- Learning CQL: The SQL-like Language for Cassandra (Video | Documentation)
Develop Dynamic Online Applications with Cassandra
- DataStax Ac*ademy: Free online training for developers; tutorials on data modeling, coding, and more. Learn More
Step 2: Migrate
There are a number of ways to move existing data into Cassandra on a one-time or continual basis. The information below will help guide you in migrating data from RDBMS’s to Cassandra.
Implement a Migration Strategy from Relational to NoSQL
- How to Implement a NoSQL strategy (White Paper)
- Migrating from Oracle to DataStax Enterprise (White Paper)
- Migrating from MySQL to DataStax Enterprise (White Paper)
- Available Methods for Moving RDBMS Data to DataStax Enterprise (Article)
- Using Sqoop to Move RDBMS Data to DataStax Enterprise (Article | Documentation)
Step 3: Succeed
Learn how to manage and optimize DataStax Enterprise clusters for maximum performance and uptime.
Manage and Scale a Successful DataStax Implementation
DataStax vs. RDBMS
Top 10 Ways DataStax Enterprise Compares to RDBMS’s
|Product Capability||DataStax Enterprise||Oracle RDBMS||Oracle MySQL||Microsoft SQL Server|
|Core Architecture||Masterless (no single point of failure)||Master-slave (single points of failure)||Master-slave (single points of failure)||Master-slave (single points of failure)|
|High Availability||Always-on continuous availability||General replication with master-slave||General read-only scale out replication; simple master-master||SQL Server replication, clustering & mirroring|
|Data Model||Dynamic; structured and unstructured data||Legacy RDBMS; Structured data||Legacy RDBMS; Structured data||Legacy RDBMS; Structured data|
|Scalability Model||Big data/Linear scale performance||Oracle RAC or Exadata||Manual sharding with MySQL||Manual sharding, general partitioning, etc.|
|Multi-Data Center Support||Multi-directional, multi-cloud availability||Nothing specific||Nothing specific||Nothing specific|
|Security||Full security support||Full security support||Full security support||Full security support|
|Enterprise Search||Integrated search on Cassandra data.||Handled via Oracle search||Full-text indexes only||Full-text indexes only|
|Enterprise Analytics||Integrated streaming, real-time, and batch analytics with workload isolation.||Analytic functions in Oracle RDBMS via SQL MapReduce||Some analytic functions. No Hadoop support||Basic analytic functions|
|In-Memory Database Option||Built-in in-memory option||Columnar in-memory option||MySQL cluster||In-memory option|
|Enterprise Management & Monitoring||DataStax OpsCenter & automated management services||Oracle Enterprise Manager||MySQL Enterprise Monitor||SQL Server Enterprise Studio|
Get a detailed look into the differences between DataStax Enterprise and RDBMSs