Chapter 7. Managing Databases

In this chapter, you will cover:

  • Using MySQL packages, files, and services
  • Using MySQL databases
  • Creating MySQL database users
  • Running MySQL queries
  • Providing MySQL user grants
  • Using PostgreSQL packages, files, and services
  • Setting up PostgreSQL groups and users
  • Configuring PostgreSQL databases

Introduction

With the availability of so many types of databases in present times, it is a really complex task to design and implement infrastructure with lots of parameters to consider. Among the multiple options available, MySQL and Postgres seem to be most widely used, both in small business infrastructures as well as large enterprises, due to the flexibility and stability they offer.

The most common tasks that are generally performed ...

Get Salt Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.