Book Image

Getting Started with MariaDB

By : Daniel Bartholomew
Book Image

Getting Started with MariaDB

By: Daniel Bartholomew

Overview of this book

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.
Table of Contents (16 chapters)
Getting Started with MariaDB Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
MariaDB Next Steps
Index

Index

A

  • ALTER COMMAND command
    • URL / Using ALTER TABLE – dropping a column
  • ALTER TABLE command
    • using / Using ALTER TABLE
    • syntax / Using ALTER TABLE – basic syntax
    • column, adding / Using ALTER TABLE – adding a column
    • column, modifying / Using ALTER TABLE – dropping a column
  • AND operator
    • using / Using the AND operator
  • AVG function / The AVG function

B

  • backups
    • creating, mysqldump used / Basic backups with mysqldump
    • restoring, mysqldump used / Restoring backups made with mysqldump
    • with xtrabackup, restoring / Restoring backups made with xtrabackup
  • binary log
    • about / The binary log
    • URL / The binary log
  • brew
    • URL / Installing MariaDB on Mac OS X

C

  • Centos
    • MariaDB, installing on / Installing MariaDB on Fedora, Red Hat, and CentOS
  • column user privileges
    • about / Database, table, and column user privileges
  • comment lines
    • about / Comments
  • configuration file, MariaDB
    • anatomy / The anatomy of the MariaDB configuration file
    • about / Where is my configuration file?
    • comment lines / Comments
    • groups / Groups
    • options, values not required / Options that do not require values
    • options, values required / Options that require values
    • options, formatting / Option formatting
    • options / Options, options everywhere
    • modifications / Activating configuration changes
  • COUNT function / The COUNT function
  • CREATE DATABASE command
    • used, for creating database / Using CREATE DATABASE to create a database
    • URL / Using CREATE DATABASE to create a database
  • CREATE TABLE command
    • used, for creating tables / Using CREATE TABLE
    • syntax / Using CREATE TABLE – basic syntax
    • datatypes / Using CREATE TABLE – datatypes
    • other options / Using CREATE TABLE– other options
    • example / Using CREATE TABLE – an example
    • URL / Using CREATE TABLE – an example

D

  • data
    • about / Data, tables, and normalization
    • retrieving / Retrieving data, Retrieving everything
    • selected columns, retrieving / Retrieving selected columns
    • filtering / Filtering and searching data
    • searching / Filtering and searching data
    • filtering, by exact values / Filtering by exact values
    • logical operators, using / Using logical operators
    • sorting / Sorting data
    • joining / Joining data
    • summarizing / Summarizing data
  • data, summarizing
    • about / Summarizing data
    • AVG function / The AVG function
    • COUNT function / The COUNT function
    • MAX function / The MIN and MAX functions
    • MIN function / The MIN and MAX functions
    • SUM function / The SUM function
    • GROUP BY used / Using GROUP BY with summarized data
    • GROUP BY filtering, HAVING clause used / Using HAVING to filter GROUP BY
  • database
    • selecting, USE command used / Using USE to select a database
    • listing on server, SHOW command used / Using SHOW to list all databases on a server
    • creating / Creating and deleting databases
    • deleting / Creating and deleting databases
    • creating, CREATE DATABASE command used / Using CREATE DATABASE to create a database
    • deleting, DROP DATABASE command used / Using DROP DATABASE to delete a database
  • database user privileges
    • about / Database, table, and column user privileges
  • datatypes
    • URL / Using CREATE TABLE – datatypes
  • Debian
    • MariaDB, installing on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
  • DELETE command
    • about / Using DELETE
    • URL / Using DELETE
  • DESCRIBE command
    • used, for exploring table structure / Using DESCRIBE to explore the structure of a table
    • URL / Using DESCRIBE to explore the structure of a table
  • development series / The development series
  • DROP DATABASE command
    • used, for deleting database / Using DROP DATABASE to delete a database
  • DROP TABLE command
    • using / Using DROP TABLE
    • URL / Using DROP TABLE
  • DROP USER statement
    • URL / Removing users

E

  • error log
    • about / The error log
    • URL / The error log

F

  • Fedora
    • MariaDB, installing on / Installing MariaDB on Fedora, Red Hat, and CentOS
  • filesystem, MariaDB
    • layout / The MariaDB filesystem layout
    • layout, on Windows / The MariaDB filesystem layout on Windows, The MariaDB filesystem layout on Linux
  • floating point numbers
    • URL / Using CREATE TABLE – datatypes

G

  • general query log
    • about / The general query log
    • URL / The general query log
  • global administrative user privileges
    • about / Global administrative user privileges
  • Gnu Privacy Guard (GPG) / MariaDB package security
  • GRANT statement
    • URL / Granting permissions
  • GROUP BY
    • used, for data summarizing / Using GROUP BY with summarized data
    • filtering, HAVING clause used / Using HAVING to filter GROUP BY
  • groups
    • about / Groups

I

  • InnoDB tables backups
    • creating, xtrabackup used / Making backups of XtraDB and InnoDB tables with xtrabackup
  • IN operator
    • using / Using the IN operator
  • INSERT...SELECT command
    • URL / Inserting from another table
  • INSERT command
    • using / Using INSERT
    • complete rows, inserting / Inserting complete rows
    • partial rows, inserting / Inserting partial rows
    • URL / Inserting partial rows
    • another table, inserting from / Inserting from another table
    • inserting, from file / Inserting from a file
  • internal network security
    • about / Internal network security
  • Internet security
    • about / Internet security
  • IRC channel
    • URL / Troubleshooting installation issues

L

  • LIKE
    • searching with / Searching with LIKE
  • limit user privileges / Miscellaneous user privileges and limits
  • Linux
    • modular configuration / Modular configuration on Linux
  • Linux Mint
    • MariaDB, installing on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
  • LOAD DATA INFILE command
    • URL / Inserting from a file
  • log files
    • binary log / The binary log
    • error log / The error log
    • general query log / The general query log
    • slow query log / The slow query log
  • logical operators
    • AND operator, using / Using the AND operator
    • OR operator, using / Using the OR operator
    • evaluation order / Evaluation order
    • IN operator, using / Using the IN operator
    • NOT operator, using / Using the NOT operator

M

  • Mac OS X
    • MariaDB, installing on / Installing MariaDB on Mac OS X
  • maintenance series / The maintenance series
  • MariaDB
    • series / Choosing a MariaDB series
    • installing, on Windows / Installing MariaDB on Windows
    • downloads, URL / Installing MariaDB on Windows
    • installing, on Mac OS X / Installing MariaDB on Mac OS X
    • installing, on Ubuntu / Installing MariaDB on Debian, Ubuntu, and Linux Mint
    • installing, on Linux Mint / Installing MariaDB on Debian, Ubuntu, and Linux Mint
    • installing, on Debian / Installing MariaDB on Debian, Ubuntu, and Linux Mint
    • installing, on Red Hat / Installing MariaDB on Fedora, Red Hat, and CentOS
    • installing, on Centos / Installing MariaDB on Fedora, Red Hat, and CentOS
    • installing, on Fedora / Installing MariaDB on Fedora, Red Hat, and CentOS
    • installing, on other Linux distributions / Installing MariaDB on other Linux distributions
    • package security / MariaDB package security
    • documentation, URL / MariaDB package security
    • post installation / After the installation
    • installation, issues / Troubleshooting installation issues
    • filesystem, layout / The MariaDB filesystem layout on Windows, The MariaDB filesystem layout on Linux
    • security / Security layers
    • securing / Securing MariaDB in 10 seconds
    • safe connection / Connecting safely
    • safe connection, on command line / Connecting safely on the command line
    • safe connection, in scripts / Connecting safely in scripts
    • user privileges / User privileges
    • connecting to / Connecting to MariaDB
    • log files / MariaDB log files
    • optimizing / Optimizing and tuning MariaDB
    • tuning / Optimizing and tuning MariaDB
    • data, backing up / Backing up, importing, and restoring data
    • data, importing / Backing up, importing, and restoring data
    • data, restoring / Backing up, importing, and restoring data
    • repairing / Repairing MariaDB
  • MAX function / The MIN and MAX functions
  • MIN function / The MIN and MAX functions
  • miscellaneous user privileges / Miscellaneous user privileges and limits
  • MyISAM tables
    • backup creating, mysqlhotcopy used / Making backups of MyISAM tables with mysqlhotcopy
  • mysqlcheck
    • used, for optimizing tables / Checking and optimizing tables with mysqlcheck
    • used, for checking tables / Checking and optimizing tables with mysqlcheck
    • URL / Checking and optimizing tables with mysqlcheck
  • mysql command-line client application
    • running / The mysql command-line client application
  • mysqldump
    • used, for creating backup / Basic backups with mysqldump
    • used, for creating tab-delimited backups / Making tab-delimited backups with mysqldump
    • URL / Making tab-delimited backups with mysqldump
  • mysqlhotcopy
    • used, for creating MyISAM tables backup / Making backups of MyISAM tables with mysqlhotcopy
    • URL / Making backups of MyISAM tables with mysqlhotcopy
  • mysqlimport
    • used, for restoring backups / Restoring backups made with mysqldump
    • data, importing with / Restoring and importing data with mysqlimport
    • data, restoring with / Restoring and importing data with mysqlimport
    • URL / Restoring and importing data with mysqlimport

N

  • normalization
    • about / Data, tables, and normalization
  • NOT operator
    • using / Using the NOT operator

O

  • OR operator
    • using / Using the OR operator

P

  • passwords
    • changing / Setting and changing passwords
    • setting / Setting and changing passwords
  • permissions
    • granting / Granting permissions
    • revoking / Revoking permissions
    • showing / Showing permissions
  • Pretty Good Privacy (PGP) / MariaDB package security

R

  • Red Hat
    • MariaDB, installing on / Installing MariaDB on Fedora, Red Hat, and CentOS
  • repository configuration tool
    • URL / Installing MariaDB on Debian, Ubuntu, and Linux Mint, Installing MariaDB on Fedora, Red Hat, and CentOS
  • REVOKE statement
    • URL / Revoking permissions

S

  • security
    • layers / Security layers
    • Internet security / Security layers, Internet security
    • internal network security / Security layers, Internal network security
    • building / Security layers, Building security
    • server / Security layers
  • SELECT command
    • URL / Retrieving data
  • series
    • selecting / Choosing a MariaDB series
    • about / Choosing a MariaDB series
    • development series / The development series
    • stable series / The stable series
    • maintenance series / The maintenance series
  • server security
    • about / Server security
  • SET PASSWORD statement
    • URL / Setting and changing passwords
  • SHOW command
    • used, for listing databases on server / Using SHOW to list all databases on a server
    • used, for displaying comand / Using SHOW to display the command used to create a table
  • SHOW CREATE TABLE command
    • URL / Using SHOW to display the command used to create a table
  • slow query log
    • about / The slow query log
    • URL / The slow query log
  • stable series / The stable series
  • Structured Query Language (SQL) / Using SHOW to list all databases on a server
  • SUM function / The SUM function

T

  • tab-delimited backups
    • creating, mysqldump used / Making tab-delimited backups with mysqldump
  • tables
    • about / Data, tables, and normalization
    • creating / Creating, altering, and dropping tables
    • CREATE TABLE command, using / Using CREATE TABLE
    • CREATE TABLE command, basic syntax / Using CREATE TABLE – basic syntax
    • CREATE TABLE command, datatypes / Using CREATE TABLE – datatypes
    • CREATE TABLE command, other options / Using CREATE TABLE– other options
    • CREATE TABLE command, example / Using CREATE TABLE – an example
    • SHOW command, used for displaying command / Using SHOW to display the command used to create a table
    • structure exploring, DESCRIBE command used / Using DESCRIBE to explore the structure of a table
    • ALTER TABLE command, using / Using ALTER TABLE
    • ALTER TABLE command, syntax / Using ALTER TABLE – basic syntax
    • ALTER TABLE command, used for adding column / Using ALTER TABLE – adding a column
    • ALTER TABLE command, used for modifying column / Using ALTER TABLE – modifying a column
    • ALTER TABLE command, used for dropping column / Using ALTER TABLE – dropping a column
    • DROP TABLE command, using / Using DROP TABLE
    • optimizing, mysqlcheck used / Checking and optimizing tables with mysqlcheck
    • repairing / Repairing tables
  • table user privileges
    • about / Database, table, and column user privileges

U

  • Ubuntu
    • MariaDB, installing on / Installing MariaDB on Debian, Ubuntu, and Linux Mint
  • UPDATE command
    • about / Using UPDATE
    • URL / Using UPDATE
  • USE command
    • used, for selecting database / Using USE to select a database
  • user privileges
    • global administrative user privileges / Global administrative user privileges
    • table user privileges / Database, table, and column user privileges
    • database user privileges / Database, table, and column user privileges
    • column user privileges / Database, table, and column user privileges
    • table privileges / Database, table, and column user privileges
    • database privileges / Database, table, and column user privileges
    • miscellaneous user privileges / Miscellaneous user privileges and limits
    • limits privileges / Miscellaneous user privileges and limits
    • URL / Miscellaneous user privileges and limits
  • users
    • creating / Creating users
    • creating, URL / Creating users
    • removing / Removing users

W

  • Windows
    • MariaDB, installing on / Installing MariaDB on Windows
    • URL / Installing MariaDB on Windows
    • MariaDB filesystem layout / The MariaDB filesystem layout on Windows, The MariaDB filesystem layout on Linux

X

  • xtrabackup
    • used, for creating XtraDB backups / Making backups of XtraDB and InnoDB tables with xtrabackup
    • used, for creating InnoDB tables backup / Making backups of XtraDB and InnoDB tables with xtrabackup
    • URL / Making backups of XtraDB and InnoDB tables with xtrabackup
    • backups, restoring / Restoring backups made with xtrabackup
    • cold backups, creating / Making cold backups
  • XtraDB backups
    • creating, xtrabackup used / Making backups of XtraDB and InnoDB tables with xtrabackup
    • URL / Repairing tables

Y

  • Yellowdog Updater, Modified (YUM) package / Installing MariaDB on Fedora, Red Hat, and CentOS