Explore the powerful features of MariaDB with practical examples
ABOUT THIS BOOK
* Install, configure, and manage MariaDB
* Store and manipulate data with MariaDB
* Get up and running with real-world, practical examples based on MariaDB 10
WHO THIS BOOK IS FOR
This book is for anyone who wants to learn more about databases in general and wants to get started more » with MariaDB. Prior database experience is not required.
WHAT YOU WILL LEARN
* Install MariaBD on Windows, Mac OS X, and Linux
* Configure MariaDB for better performance using the features of version 10
* Get familiar with the usage of operators for retrieving rows more selectively
* Use MariaDB 10's powerful tools to store, retrieve, and analyze data
* Secure MariaDB from unauthorized access
* Maintain the databases associated with MariaDB to ensure efficient and optimum functioning
* Retrieve data and learn how to sort, summarize, group, and manipulate it.
MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world, taking full advantage of the latest computing hardware available.
From installing and configuring through basic usage and maintenance, each chapter in this revised and expanded guide leads on sequentially and logically from the one before it, introducing topics in their natural order so you learn what you need, when you need it. The book is based on the latest release of MariaDB and covers all the latest features and functions. By the end of this beginner-friendly book, not only will you have a running installation of MariaDB, but you will have practical, hands-on experience in the basics of how to install, configure, administer, use, and maintain it. « less
Get a Jump Start on working with MySQL today!
MySQL is an extremely popular open source relational database management system that that powers many of the applications on the Web. Discover why MySQL's speed, ease of use, and flexibility make it the database of choice for so many developers.
In more » just one weekend with this hands-on tutorial, you'll learn how to:
* Get started with MySQL
* Store, modify, and retrieve data
* Work with multiple tables
* Connect to your database through code
* Program the database
* Back up your data « less
Heading in the right direction with MySQL and MariaDB
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 more » 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 « less
Over 95 recipes to unlock the power of MariaDB
***** About This Book *****
* Enable performance-enhancing optimizations
* Connect to different databases and file formats
* Filled with clear step-by-step instructions that can be run on a live database
***** Who This Book Is For *****
This book is for anyone who wants to learn more about more » databases in general or MariaDB in particular. Some familiarity with SQL databases is assumed, but the recipes are approachable to almost anyone with basic database skills.
***** What You Will Learn *****
* Enable various MariaDB optimizations
* Link MariaDB to a Cassandra cluster
* Enable and use the TokuDB storage engine
* Read from and write to various data formats including XML and CSV
* Search through your data with Sphinx
* Connect to other databases with ODBC
* Tune MariaDB for the best performance
***** In Detail *****
MariaDB is a new database that has become very popular. It is easy to install and use, even on personal systems. It is evolving and expanding to meet the database needs of today, tomorrow, and into the future. MariaDB is a drop in replacement for MySQL it also has a lot of new features and performance enhancements that differentiate it from MySQL. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world.
This practical guide unlocks the advanced features of MariaDB's capabilities, including new storage engines, performance enhancing optimizations, and other advanced abilities. If you're looking to backend your enterprise, cloud, or embedded or mobile apps with a fast, free, open source, and familiar SQL database, MariaDB is perfect for you.
We begin with installing MariaDB and configuring it to unlock powerful optimizations that can speed up certain queries exponentially. We will then move on to using the extra storage engines included with MariaDB, such as TokuDB and the CONNECT engine. With those mastered, it's then time to branch out from single to multi-server installations, so we will dive into MariaDB's clustering and replication features, learning how to efficiently search and index our data, work with NoSQL-style data, and connect MariaDB with a Cassandra cluster. It's a dangerous world out there, so last of all, we wrap things up with recipes on securing MariaDB.
This is your ideal guide for getting the most out of MariaDB. « less
Solutions for database developers and administrators
MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise more » explanations for programmers who don't have the time (or expertise) to solve MySQL problems from scratch.
Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. « less
Tools for Building Robust Data Centers
Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it's running on hardware, virtual more » machines, or in the cloud.
Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availabilityâknowledge that's essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features. « less
Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL more » language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code. « less
Learn how to use MariaDB to store your data easily and hassle-free
In the modern age, storing data is of paramount importance, and this is where databases enter the picture. MariaDB is a relatively new database that has become very popular in a short amount of time. It is a community-developed fork of MySQL and it is designed to be an enhanced and backward compatible more » database solution.
Getting Started with MariaDB is a practical, hands-on, beginner-friendly guide to installing and using MariaDB. This book will start with the installation of MariaDB before moving on to the basics. You will then learn how to configure and maintain your database with the help of real-world examples. « less
A quick reference guide to walk you through the setup of InnoDB, and help you start unlocking the engine's potential
InnoDB, the default storage engine for MySQL, is one of the most robust and commonly used in the world today. It can, however, be initially daunting to learn how to start implementing its features, and it can pose unique problems to the beginner user. This guide is written to address these problems.
Instant more » InnoDB addresses everything you need to know for the installation, configuration, load testing, analysis, and long term support of an InnoDB based database environment. If you've ever wanted to learn more about InnoDB but didn't want to sit down with a formidably large or dry read, then the Instant InnoDB is your ideal companion. « less
Optimization, Backups, and Replication
How can you bring out MySQL's full power? With High Performance MySQL, you'll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways more » to scale applications through replication, load balancing, high availability, and failover.
Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL's principles in action. With this book, you'll learn how to think in MySQL. « less