Slide 1

Slide 1 text

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

Slide 2

Slide 2 text

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/

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

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

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

Thanks to all Sponsors

Slide 13

Slide 13 text

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