Pro Yearly is on sale from $80 to $50! »

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

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

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

7b47fb5bb7f32e0ffdbd7bba5598ba98?s=128

Eduardo Piairo

October 28, 2017
Tweet

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_