Setting a WordPress website using Azure Web Apps And Azure Database for MySQL

Talk presented @ SQLSaturday Porto 2017(28-10-2017)

Transcript

1. Setting a WordPress website using Azure Web Apps And Azure Database for MySQL Eduardo Piairo @EdPiairo @EdPiairo, #SqlSatPortugal
2. About me Eduardo Piairo Operations Engineer @ Basecone DevOps Porto Founder Friend of Redgate @EdPiairo https://pt.linkedin.com/in/jesuspiairo eduardopiairo@gmail.com http://www.eduardopiairo.com/
3. Intro Challenges to solve WordPress hosting in Azure Change management/promotion – a pipeline @EdPiairo, #SqlSatPortugal
4. WordPress Content Management System (CMS) Web/App layer (PHP) Data layer (MySQL) @EdPiairo, #SqlSatPortugal
5. Azure Web App App Service, Web App Resource for hosting a website / web application @EdPiairo, #SqlSatPortugal
6. Azure Database for MySQL MySQL Database as a service Relational database as a service @EdPiairo, #SqlSatPortugal
7. The pipeline GitHub repo @EdPiairo, #SqlSatPortugal WordPress TEST WordPress PROD /develop /master
8. Step by step 1. WordPress download and GitHub repo creation 2. TEST infrastructure provisioning • Web App • Azure DB for MySQL 3. Git clone @ Web App @EdPiairo, #SqlSatPortugal
9. Step by step 4. Database creation and access • Create database • Add firewall rules 5. WordPress installation • Connection between Web App and Azure DB for MySQL • WP Migrate DB plugin installation 6. Export database @EdPiairo, #SqlSatPortugal
10. Step by step 7. Import database 8. Connect PROD Web App to GitHub • Deployment setup 9. Apply changes to PROD WordPress • wp-config.php @EdPiairo, #SqlSatPortugal
11. Q&A @EdPiairo, #SqlSatPortugal @EdPiairo https://pt.linkedin.com/in/jesuspiairo eduardopiairo@gmail.com http://www.eduardopiairo.com/
12. Thanks to all Sponsors
13. The Team Ivan Campos @WizardDBA João Sarmento @jopedro87 Eduardo Piairo @EdPiairo Diamantino Falcão @_dfalcao_