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 by configuration management tools are installing the databases, making sure the configuration files are in place, and the service is running. However, Salt goes a step ahead, and enables us to configure databases and few more important configuration tasks on the database software, so that managing databases is much simpler and scalable.
In this chapter, you will learn how to configure these databases, and dive deeper into the procedures of using different Salt modules to implement advanced parameters and configurations on the database software.