Database Architecture for SaaS

Fa4da3fe79ba23c483bcb977b0a340ca?s=47 Shawn Hooper
February 26, 2016

Database Architecture for SaaS

A look at some different ways to architect your database model to work in a scalable, secure and maintainable SaaS model. This talk was presented at ConFoo 2016 in Montreal.

Fa4da3fe79ba23c483bcb977b0a340ca?s=128

Shawn Hooper

February 26, 2016
Tweet

Transcript

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

  2. @shawnhooper - shawnhooper.ca Me

  3. @shawnhooper - shawnhooper.ca

  4. @shawnhooper - shawnhooper.ca

  5. @shawnhooper - shawnhooper.ca

  6. @shawnhooper - shawnhooper.ca

  7. @shawnhooper - shawnhooper.ca

  8. @shawnhooper - shawnhooper.ca

  9. @shawnhooper - shawnhooper.ca

  10. @shawnhooper - shawnhooper.ca

  11. @shawnhooper - shawnhooper.ca

  12. @shawnhooper - shawnhooper.ca ?

  13. @shawnhooper - shawnhooper.ca

  14. @shawnhooper - shawnhooper.ca

  15. @shawnhooper - shawnhooper.ca

  16. @shawnhooper - shawnhooper.ca

  17. @shawnhooper - shawnhooper.ca

  18. @shawnhooper - shawnhooper.ca

  19. @shawnhooper - shawnhooper.ca

  20. @shawnhooper - shawnhooper.ca

  21. @shawnhooper - shawnhooper.ca

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

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

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

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

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

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

  28. @shawnhooper - shawnhooper.ca

  29. @shawnhooper - shawnhooper.ca

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Tenant 5
  44. @shawnhooper - shawnhooper.ca

  45. @shawnhooper - shawnhooper.ca !

  46. @shawnhooper - shawnhooper.ca

  47. @shawnhooper - shawnhooper.ca

  48. @shawnhooper - shawnhooper.ca Authentication Products Transactions

  49. @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
  50. @shawnhooper - shawnhooper.ca

  51. @shawnhooper - shawnhooper.ca

  52. @shawnhooper - shawnhooper.ca

  53. @shawnhooper - shawnhooper.ca

  54. @shawnhooper - shawnhooper.ca

  55. @shawnhooper - shawnhooper.ca

  56. @shawnhooper - shawnhooper.ca

  57. @shawnhooper - shawnhooper.ca

  58. @shawnhooper - shawnhooper.ca

  59. @shawnhooper - shawnhooper.ca

  60. @shawnhooper - shawnhooper.ca

  61. @shawnhooper - shawnhooper.ca