Join Sheeri Cabral for an in-depth discussion in this video What you should know before watching this course, part of Advanced Topics in MySQL and MariaDB.
- Before you begin to explore advanced topics in MySQL and MariaDB, there are a few things you should know. Firstly, you should already have access to a MySQL or MariaDB installation. This course does not cover how to install MySQL or MariaDB. If you need help installing MySQL, you can watch a video from the course, Installing Apache, MySQL, and PHP in the Lynda.com library. If you need help installing MariaDB, the knowledge base at www.mariadb.org has a good getting started guide, including how to install MariaDB on different operating systems.
I will be using a virtual CentOS server on my machine with MariaDB 10.0. For MySQL examples, I will show slides with the output from a MySQL server. You can choose to use MariaDB 10.0 or higher, or you can use MySQL 5.6 or higher on a machine running Linux, Unix, Mac OS X, or Windows. This course is geared towards people already familiar with MySQL. So, it assumes you know how to work with MySQL at the command line and are familiar with SQL statements like, create, alter, show, grant, and also assumes that you're comfortable with setting variables on the command line and in configuration files, querying the information schema database, and that you already know how replication works.
If you need a refresher on any of the SQL syntax, check out Up and Running with MySQL Development here in the Lynda.com library. So, now let's jump into advanced topics in MySQL and MariaDB.
Want more information about MariaDB? Check out Understanding MariaDB for MySQL Users.
- Comparing MariaDB and MySQL
- Creating and using virtual columns in MariaDB
- Building Sphinx tables
- Installing HandlerSocket
- Setting up GTIDs in MariaDB and MySQL
- Audit logging in MariaDB and MySQL
- Using GIS in MariaDB and MySQL