MySQL

MySQL is a relational database management system. Data is stored in tables with defined relationships and read or modified using SQL. Depending on storage engine and configuration, MySQL supports transactions, foreign keys, indexes, replication, and multiple character sets. It is commonly used as a data store for websites and business applications.

Good database performance is not automatic. Data models, queries, indexes, connection load, storage, backups, and monitoring must fit the use case. Access should follow least-privilege principles, and application values should be bound through prepared statements. Scaling may require optimisation, caching, replication, or architectural changes.

• Relational tables and SQL queries
• Transactions, relationships, and indexes
• Optimise data models and queries deliberately
• Test backups and recovery regularly
• Use least privilege and prepared statements