Chapter 5. Handling Databases

In this chapter, we will cover the following recipes:

• Installing relational databases with MySQL
• Storing and retrieving data with MySQL
• Importing and exporting bulk data
• Adding users and assigning access rights
• Installing web access for MySQL
• Setting backups
• Optimizing MySQL performance – queries
• Optimizing MySQL performance – configuration
• Creating MySQL replicas for scaling and high availability
• Troubleshooting MySQL
• Installing MongoDB
• Storing and retrieving data with MongoDB