SQL or NoSQL - TrueNorthPHP
?
1 like?2,113 views
This is slides for my talk at TrueNorthPHP 2013. Title of the talk is: "SQL or NoSQL that's the question"
SQL or NoSQL - TrueNorthPHP
- 1. OR S Q L NoSQL Thats T H E Ques.on
- 3. BIG DATA
- 4. NoSQL
- 10. 2012 2011 2013
- 13. 2012 2011 2013
- 14. DATA Global Speci?c Pro?le Info. Deta i ls Aggregated stats Activities Community Events L ea de rbo a rds
- 15. + SQL / JOIN ACID Transaction Partitioning Replication Tools OPs Data Modeling Volume No Details Variant Schema Partitioning Scale out Sharding -
- 16. + SQL / JOIN ACID Transaction xbox v.1 xbox v.2 { { Partitioning player_id: 1234, player_id: 1234, game_id:Replication 1002, game_id: 4001, platform: wiiu, platform: xbox360, Tools * calories: 75, * calories: 40, OPs * duration: 120 * duration: 75, } di?culty_level: medium, Data Modeling jumping_ropes: 178, score: 450, endurance:3, category: 4 } Volume No Details Variant Schema Partitioning Scale out Sharding -
- 17. + SQL / JOIN ACID Transaction Partitioning Replication Tools OPs Data Modeling Volume No Details Variant Schema Partitioning Scale out Sharding -
- 18. Data Access Layer + SQL / JOIN ACID B A ta ta Transaction Da Da Partitioning Replication Tools OPs Data Modeling D ata C Volume No Details Variant Schema Partitioning Scale out Sharding -
- 19. + SQL / JOIN ACID Transaction Partitioning Replication Tools OPs Data Modeling Volume No Details Variant Schema Partitioning Scale out Sharding -
- 20. No SQL ...
- 22. + Schema-Less Aggregated Data Object Mapping Large Scale Data Sharding Map/Reduce Eventual Consistency Memory Storage Journaling
- 23. + Schema-Less Aggregated Data Object Mapping Large Scale Data Sharding Map/Reduce Eventual Consistency Memory Storage Journaling { * * } xbox v.1 player_id: 1234, game_id: 1002, platform: wiiu, calories: 75, duration: 120 { * * } WiiU player_id: 1234, game_id: 4001, platform: xbox360, calories: 40, duration: 75, di?culty_level: medium, jumping_ropes: 178, score: 450, endurance:3, category: 4
- 24. + Schema-Less Aggregated Data Object Mapping Large Scale Data Sharding Map/Reduce Eventual Consistency Memory Storage Journaling { player: { name: example, gender: M, country:CA } game_id: 4001, date: 2013-11-08, calories: 40, duration: 75, }
- 25. + Schema-Less Aggregated Data Object Mapping Large Scale Data Sharding Map/Reduce Eventual Consistency Memory Storage Journaling ata D A ata D B ata D C
- 26. + Schema-Less Aggregated Data Object Mapping Large Scale Data Sharding Map/Reduce Eventual Consistency Memory Storage Journaling
- 27. + Schema-Less Aggregated Data Object Mapping Large Scale Data Sharding Map/Reduce Eventual Consistency Memory Storage Journaling - Denormalized data Disk Space Expertise Complex Querying Resource Usage DB-Level Locking
- 28. BENCH MARK
- 30. Relational Data Model Schema Less Ease of Use Performance Sharding
- 31. GO! Hybrid
- 32. Con?g Server ste a r M v Sla e Shard 1 Replicaset Shard 2 Replicaset
- 33. Concerns ! Inconsistency 2 Consistency vs. Latency 3 Data Duplication 4 Complexity
- 37. DATA Migration
- 39. 4 Pro?le Versioning !! 2 s One Shot Migration hr 1 ! ve Li
- 40. e rit W d R ea
- 41. TEST!
- 43. Final Results
- 44. Scalability &...
- 48. > 1 year uptime
- 49. 1 Based on Requirements 2 Benchmark! 3 Choose Wisely!
- 53. Got Q? @majidfn