Upgrade to Pro — share decks privately, control downloads, hide ads and more …

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

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

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
ADDO_2021: Why and how to include database changes in the deployment pipeline
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
38
Adding unit tests to the database deployment pipeline
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
17
Start by changing the way of work
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
17
Adding unit tests to the database deployment pipeline
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
17
Adding unit tests with tSQLt to the database deployment pipeline
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
29
Adding unit tests with tSQLt to the database deployment pipeline
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
66
Operations for databases – The DevOps journey
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
34
Deployment pipeline for databases
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
47
Deployment pipeline for databases
7b47fb5bb7f32e0ffdbd7bba5598ba98?s=48 eduardopiairo
0
740

Other Decks in Technology

See All in Technology
ニコニコ生放送におけるWebフロントエンドBFFサーバーのKubernetes移行事例の紹介
3a206ec7df76023cca167a8886b69672?s=48 himenon
1
190
Microsoft Data Analytics trends : ”Lakehouse” , ”Data Mesh"
0d7a3b61c5c1f64a50136cf4bb5702b7?s=48 ryomaru0825
2
150
hey BOOK
69f5ab96892df4d8cbe32189f2ed2d9d?s=48 heyinc
26
290k
Amazon Comprehendで始める感情分析
57c6e82f3c8eece6caa83c6d2dadbcb3?s=48 46ta
0
200
Sysdig Secure/Falcoの活用術! ~Kubernetes基盤の脅威モデリングとランタイムセキュリティの強化~
41202c03511a51064abb970da0ca9fad?s=48 owlinux1000
0
310
聊聊 Cgo 的二三事
B3a7c0d5c590642dbce68bce8929a2df?s=48 david74chou
0
340
Learning to Solve Hard Minimal Problems
2c88806cbaab6024dc95b9a654c99d86?s=48 takmin
1
520
サイバー攻撃を想定したクラウドネイティブセキュリティガイドラインとCNAPP及びSecurity Observabilityの未来
D9130a0952480278c7f44527c6989da7?s=48 syoshie
2
1.5k
サイバー攻撃を想定したクラウドネイティブセキュリティガイドラインとCNAPP及びSecurity Observabilityの未来
E7f82c6db76f340b8ccc175d4330405b?s=48 sakon310
4
470
EKS AnywhereとIAM Anywhereを組み合わせてみた
28dd434482959f605e535fb81f691326?s=48 regmarmcem
0
410
テクニカルライティングの検定を受けてみた話 / "My Story About Taking the Technical Writing Exam
A3966f193f4bef226a0d3e3c1f728d7f?s=48 line_developers
PRO
1
220
ECS on EC2 で Auto Scaling やってみる！
5a6e159c3f74fb7bd85e62efe5f34e2b?s=48 sayjoy
1
280

Featured

See All Featured
A better future with KSS
5f2da528927a2ec9ba4fec2069cbc958?s=48 kneath
226
16k
Atom: Resistance is Futile
7fa6101cd43067653cf4ac6c7ca54305?s=48 akmur
255
20k
4 Signs Your Business is Dying
E4f5d494ebdc9e7cce1aecf3ce3e8bc1?s=48 shpigford
169
20k
Fantastic passwords and where to find them - at NoRuKo
8ec1383b240b5ba15ffb9743fceb3c0e?s=48 philnash
27
1.6k
How GitHub Uses GitHub to Build GitHub
78b475797a14c84799063c7cd073962f?s=48 holman
465
280k
Distributed Sagas: A Protocol for Coordinating Microservices
9128d500301ae51524e887bb680f471d?s=48 caitiem20
316
19k
We Have a Design System, Now What?
95d9f37115fbb0d13135d0f77132f856?s=48 morganepeng
35
3k
Automating Front-end Workflow
96270e4c3e5e9806cf7245475c00b275?s=48 addyosmani
1351
200k
Art Directing for the Web. Five minutes with CSS Template Areas
433acaea1012b25d97ae66da9b998dad?s=48 malarkey
196
9.5k
The Art of Programming - Codeland 2020
719435d98d452de7ac367c828266cf01?s=48 erikaheidi
32
11k
Adopting Sorbet at Scale
2bb923c57a1fdc3a2eb484bb8d565fd2?s=48 ufuk
63
7.6k
Learning to Love Humans: Emotional Interface Design
5f50f94346fbcb23706f0707169317a4?s=48 aarron
261
37k

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_