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

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_