Design and Modeling with MySQL and PostgreSQL - Percona University Istanbul Sep 2024.pptx.pdf

Database Design and Modeling with PostgreSQL and MySQL: Build efficient and scalable databases for modern applications using open source databases. This talk proposal explores the essential concepts and practical skills outlined in the book "Database Design and Modeling with MySQL." Databases, the backbone of modern applications, are a crucial area for professional growth. Mastering their design and modeling is not just important but essential for building efficient and scalable systems. This talk will provide an overview of the book's key insights and how they can empower developers, database administrators, and data professionals to create robust, high-performing databases.

1. In partnership with
Design and Modeling
with MySQL and
PostgreSQL
ALKIN TEZUYSAL
September
2024

@ask_dba

2. Let’s get connected!
Alkin Tezuysal - Director of Services @AltinityDB
●Linkedin : https://www.linkedin.com/in/askdba/
Open Source Database Evangelist
●Previously ChistaDATA, PlanetScale, Percona and Pythian as Senior Technical
Manager, SRE, DBA
●Previously Enterprise DBA , Informix, Oracle, DB2 , SQL Server



@ask_dba

3. Born to Sail, Forced to Work!


●Most Influential in Database Community 2022 - The Redgate 100
●MySQL Cookbook, 4th Edition 2022 - O'Reilly Media, Inc.
●MySQL Rockstar 2023 - Oracle (MySQL Community)
●Database Design and Modeling with PostgreSQL and MySQL 2024 - <Packt>


Recognitions
@ask_dba

4. About Altinity Inc.
Founded in 2017 by Alexander Zaitsev, Mindaugas Zukas, Peter Zaitsev, Robert
Hodges, Vadim Tkachenko
Focusing on ClickHouse infrastructure engineering and performance operations
What’s ClickHouse anyway?
Services and Products around dedicated Altinity.Cloud, Support and Training

www.altinity.com

@ask_dba
@Altinity 2024

5. Born to Sail, Forced to Work!


Catching winds
@svrubato
How to contribute
to open source
community?
@ask_dba

6. Sailing Maritime Trivia
@ask_dba
What’s a keel?

7. Maritime Trivia
@ask_dba
What’s a keel?

8. Keel
@ask_dba

9. Agenda
@ask_dba

10. @ask_dba

11. @ask_dba

12. @ask_dba

13. @ask_dba

14. @ask_dba

15. @ask_dba

16. @ask_dba

17. @ask_dba

18. @ask_dba

19. @ask_dba

20. @ask_dba

21. Hierarchical Model
@ask_dba

22. Network Model
@ask_dba

23. Object Oriented Model
@ask_dba

24. Object Relational Model
@ask_dba

25. Relational Model
@ask_dba

26. Entity Relationship Model
@ask_dba

27. @ask_dba
@ChistaDATA Inc. 2024

28. @ask_dba

29. MySQL Workbench
@ask_dba

30. @ask_dba

31. @ask_dba

32. @ask_dba

33. @ask_dba

34. @ask_dba
@ChistaDATA Inc. 2024

35. @ask_dba

36. @ask_dba

37. @ask_dba

38. @ask_dba

39. Proxy Solution
@ask_dba

40. Clustering Solutions
@ask_dba

41. Sharding Solutions

42. @ask_dba

43. @ask_dba

44. @ask_dba
@ChistaDATA Inc. 2024

45. @ask_dba

46. In partnership with
Thank you!

47. In partnership with

48. References & Credits
●Vitess
●MySQL 8.0 Reference Manual :: 23 InnoDB Cluster
●ProxySQL
●MySQL Workbench
●Percona XtraDB Cluster - MySQL Software
●PlanetScale
●TiDB: The Advanced Distributed SQL Database
●YugabyteDB: High-Performing Distributed SQL Database