The State of NoSQL in 2021

Transcript

1. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. Denis Rosa | Developer Advocate The State of NoSQL in 2021
2. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 2 • +18 of experience • NoSQL & Java specialist • OSS contributor Denis Rosa deniswsrosa @deniswsrosa denis.rosa@couchbase.com
3. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 3 Aren’t NoSQL Databases supposed to replace relational?
4. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 4
5. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 5
6. 6 Nails date back to at least to Ancient Egypt circa 3400BC
7. 7 Nails are awesome
8. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 8 Can we build a Burj Khalifa with nails?
9. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 9 Jesse Ramsden created the first screw-cutting lathe circa 1770
10. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 10 Nails are not “Legacy” Using screws for everything is suboptimal
11. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 11 We use booth
12. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 12
13. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 13 JOINS are SLOW ?
14. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 14 https://www.brianlikespostgres.com/cost-of-a-join.html
15. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 15 Cross-Node Join Server 1 Server 2 User Product Latency ~0.150ms | Bandwidth up to 25Gbps on AWS https://aws.amazon.com/premiumsupport/knowledge-center/network-throughput-benchmark-linux-ec2/ https://www.infoq.com/news/2018/02/aws-increase-bandwidth-ec2/
16. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 16
17. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 17
18. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 18 NewSQL? Distributed Relational
19. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 19
20. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 20 id name 1 Yuri id Name 1 User Cross-Node Join Server 1 Server 2 User Role
21. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 21 NewSQL will spend extra resources to improve sharding or to move data around
22. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 22 Relational / NewSQL == ACID ? NoSQL == BASE ?
23. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 23
24. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 24 Databases are like Airplane Engines ( Both need a few years to be mature )
25. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 25 • Integrations with dozens of tools; • Higher failure tolerance; • Tested in critical scenarios; • Medium and Long-Term return; • Professional Support; • Good documentation; • ACID • Cost-Based Optimizer;
26. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 26 Relational Document
27. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 27 https://jepsen.io/consistency
28. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 28 https://jepsen.io/consistency
29. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 29 Read Committed
30. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 30 SDK Tx (No central Coordinator / No SPOF) N1QL Tx
31. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 31 Has support for Multi Version Concurrency Control (MVCC) Does NOT support Rollbacks
32. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 32 https://jepsen.io/consistency
33. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 33 Has support for Multi Version Concurrency Control (MVCC) Does NOT support Rollbacks https://redis.com/blog/you-dont-need-transaction-rollbacks-in-redis/
34. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 34
35. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 35
36. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 36 Pay attention to the defaults They tell a lot about the database design
37. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 37 Do Not treat the database as a Blackbox
38. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 38
39. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 39 Some of them are not good ( Not gonna lie )
40. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 40
41. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 41 https://www.alliedmarketresearch.com/NoSQL-market 2018 - $2,410 M 2026 - $22,087 M
42. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 42
43. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 43
44. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 44
45. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 45 NoSQL - Q1 2019 https://reprints.forrester.com/#/assets/2/363/ES136481/reports
46. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 46 The market strategy of a few Cloud Providers forced database vendors to change their licenses
47. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 47 SSPL RSAL https://www.scylladb.com/2018/10/22/the-dark-side-of-mongodbs-new-license/ ELv2
48. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 48 BSL BSL BSL
49. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 49 (at least not for N period of time)
50. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 50 How to Manage a NoSQL?
51. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 51 + • Couchbase Cloud • Elastic Cloud / AWS • Atlas / AWS • Datastax Managed Svc / AWS • Neo4j Aura • …
52. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 52 https://www.youtube.com/watch?v=PLAwcExtLVw
53. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 53
54. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 54 It still is hard to migrate from one NoSQL to another
55. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 55
56. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 56
57. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 57 Others are coming soon…
58. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 58 SELECT fname, age, age/7 AS age_dog_years FROM tutorial WHERE fname = 'Dave' SELECT relation, COUNT(*) AS count FROM tutorial GROUP BY relation HAVING COUNT(*) > 1 INSERT INTO tutorial (KEY, VALUE) VALUES ("baldwin", { "name":"Alex Baldwin, "type":"contact”}) DELETE FROM tutorial t USE KEYS "baldwin" RETURNING t
59. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 59
60. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 60
61. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. 61
62. Confidential and Proprietary. Do not distribute without Couchbase consent. © Couchbase 2021. All rights reserved. THANK YOU @deniswsrosa deniswsrosa denis.rosa@couchbase.com