Getting Started with MariaDB

✍ Scribed by Bartholomew, Daniel

• Publisher: Packt Publishing
• Year: 2013
• Tongue: English
• Leaves: 100
• Series: Community experience distilled
• Category: Library

✦ Synopsis

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.

Overview

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

What you will learn from this book

• Install MariaDB on Windows/RedHat/Fedora/CentOS Linux/Debian/Ubuntu Linux
• Configure MariaDB to optimize data storage
• Administer users on MariaDB
• Learn how to utilize MariaDB to maintain a backup of your data
• Maintain MariaDB and keep it running smoothly

Approach

A practical, hands-on, beginner-friendly guide to installing and using MariaDB.

Who this book is written for

Getting Started with MariaDB is for anyone who wants to learn more about databases in general or MariaDB in particular. No prior database experience is required. It is assumed that you have basic knowledge of software installation, editing files with a text editor, and using the command line and terminal.

✦ Table of Contents

Content: Cover
Copyright
Credits
About the Author
About the Reviewers
www.PacktPub.com
Table of Contents
Preface
Chapter 1: Installing MariaDB
Choosing a MariaDB series
The development series
The stable series
The maintenance series
Installing MariaDB on Windows
Installing MariaDB on Mac OS X
Installing MariaDB on Debian, Ubuntu, and Linux Mint
Installing MariaDB on Fedora, Red Hat, and CentOS
Installing MariaDB on Other Linux Distributions
MariaDB Package Security
After the installation
Troubleshooting installation issues
Summary
Chapter 2: Configuring MariaDB. Filesystem layout for MariaDBFilesystem layout for Windows
Filesystem layout for Linux
Modular configuration on Linux
The MariaDB configuration file
Comments
Groups
Options which do not require values
Options which require values
Options, options, everywhere
Activating configuration changes
Summary
Chapter 3: MariaDB Security
Securing MariaDB in ten seconds
Connecting safely
Server security
Building security
Internal network security
Internet security
Summary
Chapter 4: MariaDB User Account Management
User privileges
Global administrative privileges. Database, table, and column privilegesMiscellaneous privileges and limits
Creating users
Granting permissions
Adding and removing privileges
Showing grants
Changing passwords
Removing users
Summary
Chapter 5: Using MariaDB
Running the mysql command-line client
Using a database
Listing all databases on a server
Creating and dropping databases
Creating a database
Dropping a database
Creating, altering, and dropping tables
Creating a table
Showing the command used to create a table
Exploring the Structure of a Table
Altering a table
Adding a column
Modifying a column. Dropping a columnDropping a table
Selecting, inserting, updating, and deleting data
Inserting data
Updating data
Deleting data
Reading data
Summary
Chapter 6: MariaDB Maintenance
MariaDB log files
The all-important binary log
The error log
The general query log
The slow query log
Optimizing and tuning MariaDB
Backing up MariaDB
Basic backups with mysqldump
Restoring and importing data with mysqlimport
Making backups of MyISAM tables quickly with mysqlhotcopy
Making cold backups
Checking and repairing tables
Checking and optimizing tables with mysqlcheck
Repairing tables.

✦ Subjects

Databases.;Open source software.;Client/server computing.;Database management.;MariaDB.;COMPUTERS;Computer Literacy.;COMPUTERS;Computer Science.;COMPUTERS;Data Processing.;COMPUTERS;Hardware;General.;COMPUTERS;Information Technology.;COMPUTERS;Machine Theory.;COMPUTERS;Reference.