Setting a WordPress website using Azure Web Apps And Azure Database for MySQL Eduardo Piairo @EdPiairo @EdPiairo, #SqlSatPortugal 

About me Eduardo Piairo Operations Engineer @ Basecone DevOps Porto Founder Friend of Redgate @EdPiairo https://pt.linkedin.com/in/jesuspiairo [email protected] http://www.eduardopiairo.com/ 

Intro Challenges to solve WordPress hosting in Azure Change management/promotion – a pipeline @EdPiairo, #SqlSatPortugal 

WordPress Content Management System (CMS) Web/App layer (PHP) Data layer (MySQL) @EdPiairo, #SqlSatPortugal 

Azure Web App App Service, Web App Resource for hosting a website / web application @EdPiairo, #SqlSatPortugal 

Azure Database for MySQL MySQL Database as a service Relational database as a service @EdPiairo, #SqlSatPortugal 

The pipeline GitHub repo @EdPiairo, #SqlSatPortugal WordPress TEST WordPress PROD /develop /master 

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 

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 

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 

Q&A @EdPiairo, #SqlSatPortugal @EdPiairo https://pt.linkedin.com/in/jesuspiairo [email protected] http://www.eduardopiairo.com/ 

Thanks to all Sponsors 

The Team Ivan Campos @WizardDBA João Sarmento @jopedro87 Eduardo Piairo @EdPiairo Diamantino Falcão @_dfalcao_