Getting Started with MariaDB

Book description

MariaDB is growing in popularity as a “drop-in” replacement for MySQL. Now you can quickly learn how to install and configure it to meet your own data storage needs in this beginner-friendly tutorial.

  • A step-by-step guide to installing and configuring MariaDB
  • Includes real-world examples that help you learn how to store and maintain data on MariaDB
  • Written by someone who has been involved with the project since its inception

In Detail

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 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.

Getting Started with MariaDB literally starts at square one by walking you through the basics of what you need to know about MariaDB. This book will teach you how to install MariaDB as well as how to configure it. Following that, you will then be shown how to secure MariaDB. This book will also teach you common commands and will help you learn how to maintain a MariaDB server.

Table of contents

  1. Getting Started with MariaDB
    1. Table of Contents
    2. Getting Started with MariaDB
    3. Credits
    4. About the Author
    5. About the Reviewers
      1. Support files, eBooks, discount offers, and more
        1. Why Subscribe?
        2. Free Access for Packt account holders
    7. Preface
      1. What this book covers
      2. What you need for this book
      3. Who this book is for
      4. Conventions
      5. Reader feedback
      6. Customer support
        1. Downloading the example code
        2. Errata
        3. Piracy
        4. Questions
    8. 1. Installing MariaDB
      1. Choosing a MariaDB series
        1. The development series
        2. The stable series
        3. The maintenance series
      2. Installing MariaDB on Windows
      3. Installing MariaDB on Mac OS X
      4. Installing MariaDB on Debian, Ubuntu, and Linux Mint
      5. Installing MariaDB on Fedora, Red Hat, and CentOS
      6. Installing MariaDB on other Linux distributions
      7. MariaDB package security
      8. After the installation
      9. Troubleshooting installation issues
      10. Summary
    9. 2. Configuring MariaDB
      1. Filesystem layout for MariaDB
        1. Filesystem layout for Windows
        2. Filesystem layout for Linux
        3. Modular configuration on Linux
        4. The MariaDB configuration file
        6. Groups
        7. Options which do not require values
        8. Options which require values
        9. Options, options everywhere
        10. Activating configuration changes
      2. Summary
    10. 3. MariaDB Security
      1. Securing MariaDB in ten seconds
      2. Connecting safely
      3. Server security
      4. Building security
      5. Internal network security
      6. Internet security
      7. Summary
    11. 4. MariaDB User Account Management
      1. User privileges
        1. Global administrative privileges
        2. Database, table, and column privileges
        3. Miscellaneous privileges and limits
      2. Creating users
      3. Granting permissions
        1. Adding and removing privileges
        2. Showing grants
      4. Changing passwords
      5. Removing users
      6. Summary
    12. 5. Using MariaDB
      1. Running the mysql command-line client
      2. Using a database
        1. Listing all databases on a server
      3. Creating and dropping databases
        1. Creating a database
        2. Dropping a database
      4. Creating, altering, and dropping tables
        1. Creating a table
          1. Showing the command used to create a table
          2. Exploring the structure of a table
        2. Altering a table
          1. Adding a column
          2. Modifying a column
          3. Dropping a column
        3. Dropping a table
      5. Selecting, inserting, updating, and deleting data
        1. Inserting data
        2. Updating data
        3. Deleting data
        4. Reading data
      6. Summary
    13. 6. MariaDB Maintenance
      1. MariaDB log files
        1. The all-important binary log
        2. The error log
        3. The general query log
        4. The slow query log
      2. Optimizing and tuning MariaDB
      3. Backing up MariaDB
        1. Basic backups with mysqldump
        2. Restoring and importing data with mysqlimport
        3. Making backups of MyISAM tables quickly with mysqlhotcopy
      4. Making cold backups
      5. Checking and repairing tables
        1. Checking and optimizing tables with mysqlcheck
        2. Repairing tables
      6. Summary
    14. A. MariaDB Next Steps
    15. Index

Product information

  • Title: Getting Started with MariaDB
  • Author(s):
  • Release date: October 2013
  • Publisher(s): Packt Publishing
  • ISBN: 9781782168096