Mastering MariaDB

Debug, secure, and back up your data for optimum server performance with MariaDB

Mastering MariaDB

Federico Razzoli

1 customer reviews
Debug, secure, and back up your data for optimum server performance with MariaDB
Mapt Subscription
FREE
$0.00/m after trial
eBook
$10.00
RRP $29.99
Save 66%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$10.00
$49.99
$29.99 p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


Mastering MariaDB Book Cover
Mastering MariaDB
$ 29.99
$ 10.00
MariaDB High Performance Book Cover
MariaDB High Performance
$ 26.99
$ 10.00
Buy 2 for $20.00
Save $36.98
Add to Cart

Book Details

ISBN 139781783981540
Paperback384 pages

Book Description

MariaDB is a community-driven fork of MySQL, and is a relational DBMS that can be used to build reliable, high-performance database servers. MariaDB combines MySQL characteristics such as replication, backup and disaster recovery, transactions and locks, and also includes important improvements to the performance, stability, security, and monitoring capabilities.

Mastering MariaDBstarts with an overview of the basic features and mechanisms, which includes diagnosing and solving real-life problems such as data corruption, poorly performing queries, and deadlocks. You will learn how to improve the performance of a server by identifying slow queries, and how to choose and set up a proper backup plan and recover data when disasters occur. You will learn how to share your data through several servers using replication. By the end of this book, you will be able to configure MariaDB servers, diagnose as well as troubleshoot common transactional problems, and execute database maintenance.

Table of Contents

What You Will Learn

  • Identify inefficient queries using logs and log analysis tools
  • Design your indexes and optimize your queries to produce efficient query plans
  • Tune MariaDB and InnoDB configuration to achieve a stabilized degree of performance and reliability
  • Create and manage users, roles, and permissions
  • Perform regular backups and restore data
  • Share your data through several partitions, disks, or servers using techniques such as replication to make operations faster
  • Set up, maintain, and troubleshoot a replication environment as well as a database cluster

Authors

Table of Contents

Book Details

ISBN 139781783981540
Paperback384 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

MariaDB High Performance Book Cover
MariaDB High Performance
$ 26.99
$ 10.00
MariaDB Essentials Book Cover
MariaDB Essentials
$ 23.99
$ 10.00
Getting Started with MariaDB - Second Edition Book Cover
Getting Started with MariaDB - Second Edition
$ 19.99
$ 10.00
Mastering Docker - Second Edition Book Cover
Mastering Docker - Second Edition
$ 39.99
$ 10.00
R Data Analysis Cookbook - Second Edition Book Cover
R Data Analysis Cookbook - Second Edition
$ 39.99
$ 10.00
Python: End-to-end Data Analysis Book Cover
Python: End-to-end Data Analysis
$ 71.99
$ 10.00