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

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

7b47fb5bb7f32e0ffdbd7bba5598ba98?s=47 Eduardo Piairo
October 28, 2017
Technology
0
650

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

More Decks by Eduardo Piairo

See All by Eduardo Piairo
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
6
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
1
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
5
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
15
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
36
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
20
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
29
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
590
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
460

Other Decks in Technology

See All in Technology
Eebedc2ee7ff95ffb9d9102c6d4a065c?s=48 line_devday2020
0
130
5af8e5bd2f24e4ea0cee732c6cc259b3?s=48 haruharuharuby
0
440
7e6a435700dda6cdb22105d601f20892?s=48 picardparis
4
2.2k
Eebedc2ee7ff95ffb9d9102c6d4a065c?s=48 line_devday2020
0
120
8248e84865938642ea12d175c8bd0020?s=48 rocketmaso
0
180
Eebedc2ee7ff95ffb9d9102c6d4a065c?s=48 line_devday2020
0
200
Eebedc2ee7ff95ffb9d9102c6d4a065c?s=48 line_devday2020
0
380
F01c8fdfa64bdfc00a94896e0b1359e0?s=48 tmdoi
0
200
Eebedc2ee7ff95ffb9d9102c6d4a065c?s=48 line_devday2020
0
180
Eebedc2ee7ff95ffb9d9102c6d4a065c?s=48 line_devday2020
0
120
9df0566fad9c9ca3bf669917848878fe?s=48 i35_267
0
150
D16bc1f94b17ddc794c2dfb48ef59456?s=48 mosky
0
500

Featured

See All Featured
Bfd6b681ec6e8c9bef82ff0521c364f7?s=48 kastner
54
1.9k
D67fff74178013024d833b3eec6cf27f?s=48 lynnandtonic
268
16k
9cde37f47e4a800ea081ea42de8d749a?s=48 dougneiner
55
5.3k
A60068bce2e73de3a37ca9d2dbe36092?s=48 bryan
100
11k
D83926c323d4f9289f947b4b4e76b939?s=48 jensimmons
205
10k
A16eb159db895e3b01d3dc95767ad595?s=48 jonyablonski
10
940
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
119
15k
F68cb25ae3e5c2106997454b13b7737d?s=48 brad_frost
155
6.3k
7559f6cff1f5efc2d210965febd4d71c?s=48 bermonpainter
341
26k
C157b16234f1e75e8eac3698c1d4414a?s=48 ddemaree
274
31k
7edec06b5435e0dac07a353b2cc26253?s=48 geeforr
331
29k
5b9fe87ec1faa67a4599782930f45ec9?s=48 sstephenson
144
12k

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_