# Database Deployment and Administration
## Agenda
1. Database System Architecture Overview
- Database Architecture Tiers

2. Database Access & Administration Tools
- GUI (e.g. MySQL Workbench)
- CLI (e.g. mysql console)
- Web-based admin tools (e.g. PHPMyAdmin)

3. Database Server Deployment Options
- Physical vs. Virtual vs. Container-based installation
- Cloud deployment options

4. Data Dictionaries
- mysql
- sys
- information_schema
- performance_schema

5. Configuration & Automation Options
- Config methods
- Infrastructure-as-Code, Automation components

## References
[MySQL System Architecture](https://www.developer.com/print/article.php/3678571)

Lenz Grimmer, mySQL: A look into a MySQL DBA's toolchest

[Comparison of open-source configuration management software](https://en.wikipedia.org/wiki/Comparison_of_open-source_configuration_management_software)

[Full list of 5.7 configuration parameters](http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html)

[Automating MariaDB Deployments With Ansible](https://www.percona.com/resources/videos/automating-mariadb-deployments-ansible)

[Erste Schritte mit CockroachDB - Binary, Docker und Kubernetes](https://friends.cockroachlabs.com/MzUwLVFJTi04MjcAAAGDDfaDt-Rz0uQPchBsnRypWfq2dA69irEiumKVHOL1GiZ9zjiMGVIAIz0h-1ByPebx_y8WdAg=)

[MySQL :: MySQL Community Downloads](https://dev.mysql.com/downloads/)

[Docker Desktop](https://www.docker.com/products/docker-desktop/)

[How to Install MySQL on Docker Desktop](https://expknow.com/run-mysql-in-docker/)

[Dockerize Your Databases: A Step-by-Step Guide to MySQL Containerization | by Dolamu Oludare | Towards Data Engineering | Medium](https://medium.com/towards-data-engineering/dockerize-your-databases-a-step-by-step-guide-to-mysql-containerization-8dc2deabeebd?source=tag_recommended_feed---------37-85----------mysql----------8e6df101_250b_4ab0_bcad_82e618d3bd89-------)

[Connect Your SQL Client to a MySQL Database Running in Docker | by rajashekarGaniger | May, 2024 | Medium](https://medium.com/@rajashekarganiger2002/connect-your-sql-client-to-a-mysql-database-running-in-docker-f2f4c6fcafc4?source=tag_recommended_feed---------46-84----------mysql----------83c15093_6a23_4439_ada6_c9cef3b85633-------)

[Mysql - Official Image | Docker Hub](https://hub.docker.com/_/mysql)

[centOS Linux Download](https://www.centos.org/download/)

[Oracle VM VirtualBox](https://www.virtualbox.org)

[What is Windows Subsystem for Linux | Microsoft Learn](https://learn.microsoft.com/en-us/windows/wsl/about)