In this big data era—when businesses, healthcare organizations, the financial sector, social media, etc. are all taking advantage of the insights they gain from data—the volume of data being gathered is growing at an unprecedented rate. Managing all this data requires powerful databases, and choosing the right one is vital.
4.4 Identifying potential performance concerns in storage
4.4.1 Problems with file layout
4.4.2 Problems with file size
4.5 System databases
4.6 An overview of storage hardware
4.7 Hands-on lab
Databases on AWS
4.1 The database
4.2 Choosing the right database model
4.2.1 Relational databases
4.2.2 NoSQL databases
4.2.3 How to choose
4.3 Infrastructure design: where does your database belong?
4.4 Estimating costs
4.5 Migrating your database to RDS
4.5.1 Creating a MySQL dump
4.6 Building an Amazon RDS instance
4.7 Configuring security group settings
4.8 Populating the new database
NoSQL: It’s about making intelligent choices
1.1 What is NoSQL?
1.2 NoSQL business drivers
1.3 NoSQL case studies
1.3.1 Case study: LiveJournal’s Memcache
1.3.2 Case study: Google’s MapReduce—use commodity hardware to create search indexes
1.3.3 Case study: Google’s Bigtable—a table with a billion rows and a million columns
1.3.4 Case study: Amazon’s Dynamo—accept an order 24 hours a day, 7 days a week
1.3.5 Case study: MarkLogic
1.3.6 Applying your knowledge
About the book
To help you understand the capabilities and limitations of the different kinds of databases available, David Clinton—technology guru, teacher, and author—has chosen chapters from three Manning books to create this free mini ebook, Understanding Databases. In it, you’ll learn about database configuration, how to assess database storage, and how and why to move or copy your database. As you look at relational databases and infrastructure design, you’ll also discover the factors to consider when choosing your database architecture and explore illuminating real-world case studies that shine a light on NoSQL databases and the elements that drive NoSQL business solutions. This on-point guide is a great way to start learning about databases, how to use them, and how to choose the right one for your tasks.
“Managing databases” from Learn SQL Server Administration in a Month of Lunches by Don Jones
“Databases on AWS” from Learn Amazon Web Services in a Month of Lunches by David Clinton
“NoSQL: It’s about making intelligent choices” from Making Sense of NoSQL by Daniel G. McCreary and Ann M. Kelly
David Clinton is a system administrator, teacher, and writer. He has administered, written about, and created training materials for many important technology subjects including Linux systems, cloud computing (AWS in particular), and container technologies like Docker. Many of his video training courses can be found on Pluralsight.com, and links to his other books (on Linux administration and server virtualization) can be found at https://bootstrap-it.com.