Mariadb Essentials
Download Mariadb Essentials PDF/ePub or read online books in Mobi eBooks. Click Download or Read Online button to get Mariadb Essentials book now. This website allows unlimited access to, at the time of writing, more than 1.5 million titles, including hundreds of thousands of titles in various foreign languages.
MariaDB Essentials
Author: Emilien Kenler
language: en
Publisher: Packt Publishing Ltd
Release Date: 2015-10-27
Quickly get up to speed with MariaDB—the leading, drop-in replacement for MySQL, through this practical tutorial About This Book Get to know the basic SQL queries so you can quickly start using MariaDB Take control of your data through the advanced features of MariaDB Exploit the full potential of MariaDB's exclusive features through quick, practical examples Who This Book Is For If you don't know the SQL language, but you want to quickly jump into the SQL world and learn how to use MariaDB, or if you already know how to use MySQL but you want to go further, then this book is ideal for you. What You Will Learn Install and configure MariaDB Create databases, tables, and indexes Import and export data from and to external files Work with views and virtual columns Create, read, update, and delete records in your database Use dynamic columns Set up a powerful full-text search system Access your external data from MariaDB through the CONNECT engine In Detail This book will take you through all the nitty-gritty parts of MariaDB, right from the creation of your database all the way to using MariaDB's advanced features. At the very beginning, we show you the basics, that is, how to install MariaDB. Then, we walk you through the databases and tables of MariaDB, and introduce SQL in MariaDB. You will learn about all the features that have been added in MariaDB but are absent in MySQL. Moving on, you'll learn to import and export data, views, virtual columns, and dynamic columns in MariaDB. Then, you'll get to grips with full-text searches and queries in MariaDb. You'll also be familiarized with the CONNECT storage engine. At the end of the book, you'll be introduced to the community of MariaDB. Style and approach This is a complete guide that uses concrete examples to help you understand and exploit the full potential of MariaDB.
MariaDB Essentials
"MariaDB Essentials" Unlock the full potential of your database infrastructure with "MariaDB Essentials," a comprehensive guide that explores MariaDB’s architecture, deployment patterns, performance optimization, and advanced data modeling. This book delves beneath the surface to explain the modular, extensible architecture of MariaDB, including its innovative pluggable storage engine model, memory management strategies, and the full lifecycle of SQL query execution. Readers will gain a deep understanding of MariaDB's internal mechanisms—from threading, concurrency, and metadata locking to cutting-edge plugin integrations—empowering database professionals to design resilient, high-performing systems. Designed for practitioners seeking both foundational knowledge and advanced techniques, "MariaDB Essentials" covers every phase of a database’s lifecycle. Readers will find practical guidance for installation across bare metal, containers, and managed cloud platforms, along with fine-tuned deployment paradigms—emphasizing best practices for configuration, security, continuous delivery, and regulatory compliance. Advanced chapters tackle topics such as schema design, partitioning, multi-tenancy, indexing, transaction isolation, clustering, high-availability replication, automated backup and disaster recovery, and ongoing health monitoring, all illustrated with real-world trade-offs and optimizations. Concluding with a forward-looking tour of observability, integration, DevOps automation, and tooling, this book provides actionable insights into connecting MariaDB with modern ecosystems—including ETL, data streaming, monitoring platforms, and polyglot persistence patterns. Whether you are a DBA, backend developer, data engineer, or architect, "MariaDB Essentials" is your self-contained, authoritative resource for mastering the intricacies of MariaDB and building robust data platforms for the most demanding applications.
Learning MySQL and MariaDB
Author: Russell J.T. Dyer
language: en
Publisher: "O'Reilly Media, Inc."
Release Date: 2015-03-30
If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines. Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned. Create and alter MySQL tables and specify fields and columns within them Learn how to insert, select, update, delete, join, and subquery data, using practical examples Use built-in string functions to find, extract, format, and convert text from columns Learn functions for mathematical or statistical calculations, and for formatting date and time values Perform administrative duties such as managing user accounts, backing up databases, and importing large amounts of data Use APIs to connect and query MySQL and MariaDB with PHP and other languages