From Monolith Database to Microservice Database, and how to improve Application and DB performance in all projects [CodeOne 2018]

Slide 1

Slide 1 text

#CodeOne @VladimirD_42 From Monolith to Microservice DB and Improving App and Database Performance in Projects [DEV4790] Vladimir Dejanović 22 October 2018

Slide 2

Slide 2 text

@VladimirD_42 #CodeOne https://upload.wikimedia.org/wikipedia/en/8/83/Safe_Harbor_Logo.jpg Safe Harbor Statement

Slide 3

Slide 3 text

@VladimirD_42 Vladimir Dejanović Let’s Meet @VladimirD_42 vladimir@itshark.xyz http://itshark.xyz #CodeOne

Slide 4

Slide 4 text

@VladimirD_42 Vladimir Dejanović Let’s Meet http://itshark.xyz #CodeOne

Slide 5

Slide 5 text

@VladimirD_42 Vladimir Dejanović Let’s Meet #CodeOne

Slide 6

Slide 6 text

@VladimirD_42 Vladimir Dejanović Let’s Meet and Others... #CodeOne

Slide 7

Slide 7 text

@VladimirD_42 #CodeOne

Slide 8

Slide 8 text

@VladimirD_42 #CodeOne Agenda

Slide 9

Slide 9 text

@VladimirD_42 #CodeOne Agenda Data and Databases

Slide 10

Slide 10 text

@VladimirD_42 #CodeOne Agenda DB in Microservices world Data and Databases

Slide 11

Slide 11 text

@VladimirD_42 #CodeOne Agenda DB in Microservices world Problems with data Data and Databases

Slide 12

Slide 12 text

@VladimirD_42 #CodeOne Agenda DB in Microservices world Questions Problems with data Data and Databases

Slide 13

Slide 13 text

@VladimirD_42 #CodeOne How important is data?

Slide 14

Slide 14 text

@VladimirD_42 #CodeOne How important is data?

Slide 15

Slide 15 text

@VladimirD_42 #CodeOne How important is data?

Slide 16

Slide 16 text

@VladimirD_42 #CodeOne Data is foundation of application

Slide 17

Slide 17 text

@VladimirD_42 #CodeOne Data is foundation of application Users

Slide 18

Slide 18 text

@VladimirD_42 #CodeOne Data is foundation of application Application Users

Slide 19

Slide 19 text

@VladimirD_42 #CodeOne Data is foundation of application Data => Database Application Users

Slide 20

Slide 20 text

@VladimirD_42 #CodeOne Data Base in Microservices world

Slide 21

Slide 21 text

@VladimirD_42 #CodeOne DB in Microservices world

Slide 22

Slide 22 text

@VladimirD_42 #CodeOne DB in Microservices world

Slide 23

Slide 23 text

@VladimirD_42 #CodeOne DB in Microservices world

Slide 24

Slide 24 text

@VladimirD_42 #CodeOne DB in Microservices world

Slide 25

Slide 25 text

@VladimirD_42 #CodeOne DB in Microservices world

Slide 26

Slide 26 text

@VladimirD_42 #CodeOne DB in Microservices world

Slide 27

Slide 27 text

@VladimirD_42 #CodeOne DB in Microservices world

Slide 28

Slide 28 text

@VladimirD_42 #CodeOne DB in Microservices world

Slide 29

Slide 29 text

@VladimirD_42 #CodeOne Problems that we encounter with data

Slide 30

Slide 30 text

@VladimirD_42 #CodeOne Problems that we encounter with data Correctness

Slide 31

Slide 31 text

@VladimirD_42 #CodeOne Problems that we encounter with data ref: http://www.clker.com/cliparts/6/7/5/0/13349271331017964165Twin%20Baby%20Boys.svg.med.png

Slide 32

Slide 32 text

@VladimirD_42 #CodeOne Problems that we encounter with data ref: https://gerardnico.com/wiki/_media/data/modeling/normalization_process.jpg

Slide 33

Slide 33 text

@VladimirD_42 #CodeOne ref: http://i.investopedia.com/content/short_article/one_thing_to_never_d/shutterstock_189826829.jpg

Slide 34

Slide 34 text

@VladimirD_42 #CodeOne ref: http://www.peoplefluent.com/images/default-source/Blog-Images/truth.jpg

Slide 35

Slide 35 text

@VladimirD_42 #CodeOne Problems that we encounter with data Correctness

Slide 36

Slide 36 text

@VladimirD_42 #CodeOne Problems that we encounter with data Correctness Performance/Size

Slide 37

Slide 37 text

@VladimirD_42 #CodeOne Performance with Size

Slide 38

Slide 38 text

@VladimirD_42 #CodeOne Performance with Size

Slide 39

Slide 39 text

@VladimirD_42 #CodeOne Performance with Size

Slide 40

Slide 40 text

@VladimirD_42 #CodeOne Performance with Size Write

Slide 41

Slide 41 text

@VladimirD_42 #CodeOne Performance with Size Write

Slide 42

Slide 42 text

@VladimirD_42 #CodeOne Performance with Size Read Write

Slide 43

Slide 43 text

@VladimirD_42 #CodeOne Performance with Size

Slide 44

Slide 44 text

@VladimirD_42 #CodeOne Performance with Size

Slide 45

Slide 45 text

@VladimirD_42 #CodeOne Performance with Size

Slide 46

Slide 46 text

@VladimirD_42 #CodeOne Performance with Size

Slide 47

Slide 47 text

@VladimirD_42 #CodeOne Performance with Size

Slide 48

Slide 48 text

@VladimirD_42 #CodeOne Performance with Size

Slide 49

Slide 49 text

@VladimirD_42 #CodeOne Performance with Size

Slide 50

Slide 50 text

@VladimirD_42 #CodeOne Performance with Size

Slide 51

Slide 51 text

@VladimirD_42 #CodeOne Performance with Size

Slide 52

Slide 52 text

@VladimirD_42 #CodeOne Performance with Size

Slide 53

Slide 53 text

@VladimirD_42 #CodeOne Performance with Size

Slide 54

Slide 54 text

@VladimirD_42 #CodeOne Performance with Size

Slide 55

Slide 55 text

@VladimirD_42 #CodeOne Split Database Table A Table B

Slide 56

Slide 56 text

@VladimirD_42 #CodeOne Split Database Table A Table B Table A Table B

Slide 57

Slide 57 text

@VladimirD_42 #CodeOne Split Database

Slide 58

Slide 58 text

@VladimirD_42 #CodeOne Split Database No Triggers

Slide 59

Slide 59 text

@VladimirD_42 #CodeOne Split Database No Triggers No Store Procedures

Slide 60

Slide 60 text

@VladimirD_42 #CodeOne ref: http://vignette4.wikia.nocookie.net/powerlisting/images/5/5f/Keys_29082.jpg/revision/latest?cb=20140507065434

Slide 61

Slide 61 text

@VladimirD_42 #CodeOne ref: http://2.bp.blogspot.com/_pmRMnll-HJA/TIBdeYySPeI/AAAAAAAAJ80/x6-n71cBi4A/s1600/2006_08_28_juggler.jpg

Slide 62

Slide 62 text

@VladimirD_42 #CodeOne ref: https://anakage.in/blog/wp-content/uploads/2016/04/speed-300x199.jpg

Slide 63

Slide 63 text

@VladimirD_42 #CodeOne Sharding

Slide 64

Slide 64 text

@VladimirD_42 #CodeOne Sharding

Slide 65

Slide 65 text

@VladimirD_42 #CodeOne Sharding

Slide 66

Slide 66 text

@VladimirD_42 #CodeOne Sharding

Slide 67

Slide 67 text

@VladimirD_42 #CodeOne Problems that we encounter with data Correctness Performance/Size

Slide 68

Slide 68 text

@VladimirD_42 #CodeOne Problems that we encounter with data Correctness Performance/Size Evolution

Slide 69

Slide 69 text

@VladimirD_42 #CodeOne ref: http://cdn.playbuzz.com/cdn/135533e4-8b11-4af0-8638-6525eff069e0/9d2f35d6-a75a-44e7-8259-6ff1abb00ce4.jpg

Slide 70

Slide 70 text

@VladimirD_42 #CodeOne Evolution

Slide 71

Slide 71 text

@VladimirD_42 #CodeOne Evolution

Slide 72

Slide 72 text

@VladimirD_42 #CodeOne Evolution

Slide 73

Slide 73 text

@VladimirD_42 #CodeOne Evolution

Slide 74

Slide 74 text

@VladimirD_42 #CodeOne Evolution CRUD

Slide 75

Slide 75 text

@VladimirD_42 #CodeOne Evolution Read Delete Update Create

Slide 76

Slide 76 text

@VladimirD_42 #CodeOne Read

Slide 77

Slide 77 text

@VladimirD_42 #CodeOne Read All above applies

Slide 78

Slide 78 text

@VladimirD_42 #CodeOne Read Denormalization where needed All above applies

Slide 79

Slide 79 text

@VladimirD_42 #CodeOne Read Denormalization where needed Join on App level All above applies

Slide 80

Slide 80 text

@VladimirD_42 #CodeOne Read Denormalization where needed Transactions multiple DB in App Join on App level All above applies

Slide 81

Slide 81 text

@VladimirD_42 #CodeOne Create/Add

Slide 82

Slide 82 text

@VladimirD_42 #CodeOne Create/Add mysql> create table post ( id int not null, body text, primary key (`id`));

Slide 83

Slide 83 text

@VladimirD_42 #CodeOne Create/Add mysql> create table post ( id int not null, body text, primary key (`id`)); mysql> alter table post add column title varchar(50) not null default '-';

Slide 84

Slide 84 text

@VladimirD_42 #CodeOne Create/Add First Update DB

Slide 85

Slide 85 text

@VladimirD_42 #CodeOne Create/Add First Update DB Then update code accordingly

Slide 86

Slide 86 text

@VladimirD_42 #CodeOne Delete

Slide 87

Slide 87 text

@VladimirD_42 #CodeOne Delete mysql> alter table post drop column title;

Slide 88

Slide 88 text

@VladimirD_42 #CodeOne Delete mysql> alter table post drop column title; mysql> drop table post;

Slide 89

Slide 89 text

@VladimirD_42 #CodeOne Delete Remove in code

Slide 90

Slide 90 text

@VladimirD_42 #CodeOne Delete Remove in code Make sure everything is still good

Slide 91

Slide 91 text

@VladimirD_42 #CodeOne Delete Remove in code Make sure everything is still good Delete/Drop in DB

Slide 92

Slide 92 text

@VladimirD_42 #CodeOne Update/Modify

Slide 93

Slide 93 text

@VladimirD_42 #CodeOne Update/Modify mysql> alter table post change `title` `new_title` varchar(30);

Slide 94

Slide 94 text

@VladimirD_42 #CodeOne Update/Modify mysql> alter table post change `title` `new_title` varchar(30);

Slide 95

Slide 95 text

@VladimirD_42 #CodeOne Update/Modify Add new in DB

Slide 96

Slide 96 text

@VladimirD_42 #CodeOne Update/Modify Add new in DB Add new in Code, but don’t use

Slide 97

Slide 97 text

@VladimirD_42 #CodeOne Update/Modify Add new in DB Add new in Code, but don’t use Populate new in code, but don’t use

Slide 98

Slide 98 text

@VladimirD_42 #CodeOne Update/Modify Use new in code, old failsafe

Slide 99

Slide 99 text

@VladimirD_42 #CodeOne Update/Modify Use new in code, old failsafe Remove old in code

Slide 100

Slide 100 text

@VladimirD_42 #CodeOne Update/Modify Use new in code, old failsafe Remove old in code Remove old in Database

Slide 101

Slide 101 text

@VladimirD_42 #CodeOne Summary

Slide 102

Slide 102 text

@VladimirD_42 #CodeOne Summary Data

Slide 103

Slide 103 text

@VladimirD_42 #CodeOne Summary Data DB in Microservices world

Slide 104

Slide 104 text

@VladimirD_42 #CodeOne Summary Data DB in Microservices world Problems with data

Slide 105

Slide 105 text

@VladimirD_42 #CodeOne Problems with data Correctness

Slide 106

Slide 106 text

@VladimirD_42 #CodeOne Problems with data Correctness Performance/Size

Slide 107

Slide 107 text

@VladimirD_42 #CodeOne Problems with data Correctness Performance/Size Evolution

Slide 108

Slide 108 text

@VladimirD_42 #CodeOne Thank You

Slide 109

Slide 109 text

@VladimirD_42 Questions @VladimirD_42 vladimir@itshark.xyz http://itshark.xyz #CodeOne