Tweet
Tweet

Slide 1

Slide 1 text

Database Architecture for 
 SaaS ConFoo 2016 @shawnhooper - shawnhooper.ca

Slide 2

Slide 2 text

@shawnhooper - shawnhooper.ca Me

Slide 3

Slide 3 text

@shawnhooper - shawnhooper.ca

Slide 4

Slide 4 text

@shawnhooper - shawnhooper.ca

Slide 5

Slide 5 text

@shawnhooper - shawnhooper.ca

Slide 6

Slide 6 text

@shawnhooper - shawnhooper.ca

Slide 7

Slide 7 text

@shawnhooper - shawnhooper.ca

Slide 8

Slide 8 text

@shawnhooper - shawnhooper.ca

Slide 9

Slide 9 text

@shawnhooper - shawnhooper.ca

Slide 10

Slide 10 text

@shawnhooper - shawnhooper.ca

Slide 11

Slide 11 text

@shawnhooper - shawnhooper.ca

Slide 12

Slide 12 text

@shawnhooper - shawnhooper.ca ?

Slide 13

Slide 13 text

@shawnhooper - shawnhooper.ca

Slide 14

Slide 14 text

@shawnhooper - shawnhooper.ca

Slide 15

Slide 15 text

@shawnhooper - shawnhooper.ca

Slide 16

Slide 16 text

@shawnhooper - shawnhooper.ca

Slide 17

Slide 17 text

@shawnhooper - shawnhooper.ca

Slide 18

Slide 18 text

@shawnhooper - shawnhooper.ca

Slide 19

Slide 19 text

@shawnhooper - shawnhooper.ca

Slide 20

Slide 20 text

@shawnhooper - shawnhooper.ca

Slide 21

Slide 21 text

@shawnhooper - shawnhooper.ca

Slide 22

Slide 22 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 23

Slide 23 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 24

Slide 24 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 25

Slide 25 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747 https://www.flickr.com/photos/westmidlandspolice/6812082757

Slide 26

Slide 26 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747 https://www.flickr.com/photos/westmidlandspolice/6812082757

Slide 27

Slide 27 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747 https://www.flickr.com/photos/westmidlandspolice/6812082757

Slide 28

Slide 28 text

@shawnhooper - shawnhooper.ca

Slide 29

Slide 29 text

@shawnhooper - shawnhooper.ca

Slide 30

Slide 30 text

@shawnhooper - shawnhooper.ca Tenant 1 Tenant 2 Tenant 3

Slide 31

Slide 31 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 32

Slide 32 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 33

Slide 33 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 34

Slide 34 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 35

Slide 35 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 36

Slide 36 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 37

Slide 37 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 38

Slide 38 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 39

Slide 39 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 40

Slide 40 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 41

Slide 41 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 42

Slide 42 text

@shawnhooper - shawnhooper.ca https://www.flickr.com/photos/dumptruck/1603512747

Slide 43

Slide 43 text

@shawnhooper - shawnhooper.ca Tenant 1, 2 & 3 Tenant 4 Tenant 5

Slide 44

Slide 44 text

@shawnhooper - shawnhooper.ca

Slide 45

Slide 45 text

@shawnhooper - shawnhooper.ca !

Slide 46

Slide 46 text

@shawnhooper - shawnhooper.ca

Slide 47

Slide 47 text

@shawnhooper - shawnhooper.ca

Slide 48

Slide 48 text

@shawnhooper - shawnhooper.ca Authentication Products Transactions

Slide 49

Slide 49 text

@shawnhooper - shawnhooper.ca Summary 1. All Tenants in a Single Database 2. All Tenants in Separate Schemas or Databases 3. Compromised Approach (Some Shared, Some Isolated) 4. Microservice Model

Slide 50

Slide 50 text

@shawnhooper - shawnhooper.ca

Slide 51

Slide 51 text

@shawnhooper - shawnhooper.ca

Slide 52

Slide 52 text

@shawnhooper - shawnhooper.ca

Slide 53

Slide 53 text

@shawnhooper - shawnhooper.ca

Slide 54

Slide 54 text

@shawnhooper - shawnhooper.ca

Slide 55

Slide 55 text

@shawnhooper - shawnhooper.ca

Slide 56

Slide 56 text

@shawnhooper - shawnhooper.ca

Slide 57

Slide 57 text

@shawnhooper - shawnhooper.ca

Slide 58

Slide 58 text

@shawnhooper - shawnhooper.ca

Slide 59

Slide 59 text

@shawnhooper - shawnhooper.ca

Slide 60

Slide 60 text

@shawnhooper - shawnhooper.ca

Slide 61

Slide 61 text

@shawnhooper - shawnhooper.ca