Taking care of the elephant

Elephant Shed是一个开源的PostgreSQL设备,它捆绑并集成了经验证的组件,这对于PostgreSQL服务器的轻松管理是必需的。
创建一个可靠且可维护的平台需要一个以上的软件。有不同的方法来填补这个空白,但通常开放源码提供所需的所有位和块。然而,这些需要很好地整合。象棚是一个高性能PostgreSQL平台所有必要工具的集成。
这轮子不是重新发明的。与新的开发不同,已建立的、可靠的、能够满足特定方面需求的开源项目被组装到Elephant-Shed PostgreSQL设备中。它们集成在单个用户界面中。后台的自动化脚本确保所有这些工具的交互顺利运行。
本演示解释了为什么要创建象棚,并展示了技术细节及其带来的优势。

展开查看详情

1. PERCONA LIVE EUROPE Taking Care of the Elephant credativ 2018 www.credativ.com

2. PERCONA LIVE EUROPE Actively • Free Software since 1993 Working • Linux since 1994 On • Debian GNU/Linux since 1995 Open Source • PostgreSQL since 1998 credativ 2018 www.credativ.com

3. PERCONA LIVE EUROPE Actively • 1992 – 1996 Ph.D. • 1996 – 1998 Project Manager Working • 1998 – 2000 Branch Manager On • Since 2000 President/CEO Open Source credativ 2018 www.credativ.com

4. PERCONA LIVE EUROPE 24/7/365 Open Source Support Center Phone ➢ Consulting Email ➢ Installation ➢ Administration Remote ➢ Operations On-site ➢ Training ➢ Support US/EU/India credativ 2018 www.credativ.com

5. PERCONA LIVE EUROPE Current State Of The Community - Forks credativ 2018 www.credativ.com

6. PERCONA LIVE EUROPE Incompatible differences in Plenty ➢ Statements Of ➢ Datatypes (c) Alexander Madyankin, Roman Shamin Differences ➢ Storage ➢ Features credativ 2018 www.credativ.com

7. PERCONA LIVE EUROPE Current State Of The Community - Forks credativ 2018 www.credativ.com

8. PERCONA LIVE EUROPE Business Create IP Different Solutions Models vs. Resources Diverging Code Community credativ 2018 www.credativ.com

9. PERCONA LIVE EUROPE The community does not accept our patches! Sales Community does not want big patches! Company XYZ is the one company behind PostgreSQL! vs. You cannot do this with the community version! Community We are PostgreSQL! credativ 2018 www.credativ.com

10. PERCONA LIVE EUROPE Open Source Has Everything credativ 2018 www.credativ.com

11. PERCONA LIVE EUROPE Vendoring is the act of making your own copy of the 3rd party packages your project is using. Those Software copies are traditionally placed inside each project and then saved in the project repository. Development - Vendoring Vendoring is the conceptual opposite of using a dependency manager credativ 2018 www.credativ.com

12. PERCONA LIVE EUROPE ➢ Flatpak Modern ➢ Snap ➢ AppImage ➢ Docker Deployment ➢ Appliances ➢ Cloud Methods © Tomomarusan credativ 2018 www.credativ.com

13. PERCONA LIVE EUROPE Current State Of The Community - Cloud credativ 2018 www.credativ.com

14. PERCONA LIVE EUROPE ➢ Configure database servers Database ➢ Monitor and maintain system health and security Administrator ➢ Design backup processes for server and associated data ➢ Establish a disaster recovery protocols Responsibilities ➢ Schedule and perform regular server maintenance credativ 2018 www.credativ.com

15. PERCONA LIVE EUROPE ➢ Complete solution Elephant ➢ No external dependencies Shed ➢ Modular - ➢ Covers most use case Design Goals ➢ Easily adjustable and extendable ➢ Ease of use credativ 2018 www.credativ.com

16. PERCONA LIVE EUROPE Portal - Point Of Entry credativ 2018 www.credativ.com

17. PERCONA LIVE EUROPE Multi Version - Multi Cluster credativ 2018 www.credativ.com

18. PERCONA LIVE EUROPE all active PostgreSQL for all active distribution versions versions Apt ● 3-4 Debian Releases + 3-4 Ubuntu Releases . ● 6 PostgreSQL Releases Postgresql ● Server, Extensions, Modules . ● 3 Architectures Org  200 different source packages © Syllabub@ Wikimedia Commons  25,473 binary packages credativ 2018 www.credativ.com

19. PERCONA LIVE EUROPE Tests are done automatically Jenkins Continuous Integration Server Quality ====== Running all tests with tight umask 077 ● Source - ======= === Running test 001_packages.t ... === build source 1..19 packages # PostgreSQL versions installed: 9.4 Asssurance ok 1 - postgresql-9.4 installed ok 2 - postgresql-plpython-9.4 installed ● Binary – ok 3 - postgresql-plpython3-9.4 installed ok 4 - postgresql-plperl-9.4 installed build binary ok 5 - postgresql-pltcl-9.4 installed ok 6 - postgresql-server-dev-9.4 installed packages ok 7 - postgresql-contrib-9.4 installed ok 8 - libecpg-dev installed ... ● Test credativ 2018 www.credativ.com

20. PERCONA LIVE EUROPE Portal - PostgreSQL Clusters credativ 2018 www.credativ.com

21. PERCONA LIVE EUROPE systemd - System & Service Manager credativ 2018 www.credativ.com

22. PERCONA LIVE EUROPE Cockpit - System Management credativ 2018 www.credativ.com

23. PERCONA LIVE EUROPE pgAdmin4 - Manage PostgreSQL credativ 2018 www.credativ.com

24. PERCONA LIVE EUROPE Dashboard with data from different sources Grafana - Analytics Visualization Monitoring credativ 2018 www.credativ.com

25. PERCONA LIVE EUROPE Dashboard with data from different sources Grafana - Analytics Visualization Monitoring credativ 2018 www.credativ.com

26. PERCONA LIVE EUROPE Collect and display metrics Prometheus - Monitoring Time series credativ 2018 www.credativ.com

27. PERCONA LIVE EUROPE pgBadger - Reporting credativ 2018 www.credativ.com

28. PERCONA LIVE EUROPE pgBackRest - Backup & Restore credativ 2018 www.credativ.com

29. PERCONA LIVE EUROPE ➢ Shell In A Box – Web based terminal Additional ➢ Ferm – Firewalling toolkit for creating iptables rules ➢ Tmate – Remote control Tools ➢ Etckeeper – Configuration revisioning credativ 2018 www.credativ.com