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

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

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

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

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

@VladimirD_42 Vladimir Dejanović Let’s Meet #CodeOne

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

@VladimirD_42 #CodeOne

@VladimirD_42 #CodeOne Agenda

@VladimirD_42 #CodeOne Agenda Data and Databases

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

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

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

@VladimirD_42 #CodeOne How important is data?

@VladimirD_42 #CodeOne Data is foundation of application

@VladimirD_42 #CodeOne Data is foundation of application Users

@VladimirD_42 #CodeOne Data is foundation of application Application Users

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

@VladimirD_42 #CodeOne Data Base in Microservices world

@VladimirD_42 #CodeOne DB in Microservices world

@VladimirD_42 #CodeOne Problems that we encounter with data

@VladimirD_42 #CodeOne Problems that we encounter with data Correctness

@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

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

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

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

@VladimirD_42 #CodeOne Problems that we encounter with data Correctness

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

@VladimirD_42 #CodeOne Performance with Size

@VladimirD_42 #CodeOne Performance with Size Write

@VladimirD_42 #CodeOne Performance with Size Read Write

@VladimirD_42 #CodeOne Performance with Size

@VladimirD_42 #CodeOne Split Database Table A Table B

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

@VladimirD_42 #CodeOne Split Database

@VladimirD_42 #CodeOne Split Database No Triggers

@VladimirD_42 #CodeOne Split Database No Triggers No Store Procedures

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

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

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

@VladimirD_42 #CodeOne Sharding

Evolution

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

@VladimirD_42 #CodeOne Evolution

@VladimirD_42 #CodeOne Evolution CRUD

@VladimirD_42 #CodeOne Evolution Read Delete Update Create

@VladimirD_42 #CodeOne Read

@VladimirD_42 #CodeOne Read All above applies

@VladimirD_42 #CodeOne Read Denormalization where needed All above applies

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

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

@VladimirD_42 #CodeOne Create/Add

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

@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 '-';

@VladimirD_42 #CodeOne Create/Add First Update DB

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

@VladimirD_42 #CodeOne Delete

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

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

@VladimirD_42 #CodeOne Delete Remove in code

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

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

@VladimirD_42 #CodeOne Update/Modify

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

@VladimirD_42 #CodeOne Update/Modify Add new in DB

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

@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

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

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

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

@VladimirD_42 #CodeOne Summary

@VladimirD_42 #CodeOne Summary Data

@VladimirD_42 #CodeOne Summary Data DB in Microservices world

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

@VladimirD_42 #CodeOne Problems with data Correctness

@VladimirD_42 #CodeOne Problems with data Correctness Performance/Size

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

@VladimirD_42 #CodeOne Thank You

@VladimirD_42 Questions @VladimirD_42 [email protected] http://itshark.xyz #CodeOne

From Monolith Database to Microservice Database...

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

More Decks by Vladimir Dejanovic

Other Decks in Programming

Featured

Transcript