Mit Patroni steht im Bereich PostgreSQL eine hochverfügbare Open-Source-Lösung mit vielen Vorteilen zur Verfügung. Die kostenlose Lösung fodert allerdings ein gewisses Maß an Bastelfreude, denn sie liefert definitv keine „one-size-fits-all“- oder „plug-and-play“-Lösung. Eine Betrachtung des Setups und der wichtigsten Operationen gibt Aufschluss über die Vor- und Nachteile dieser Lösung, insbesondere für Produktivumgebungen, die nahezu keine Ausfallzeiten erlauben.
Boost your knowledge!
How? Let's check our Oracle, Microsoft, Open Source DB and OS workshops in detail!
Newsroom – dbi services news & events
dbi services Event
Microsoft, Oracle, Open Source, Cloud: All data infrastructure technologies in one place
4.11.2021 in French & 11.11.2021 in German
Sharpen your knowledge about data infrastructures and platforms during our dbi services event. During half a day, our experts will discuss Oracle, Microsoft, Open Source, AWS, Cloud and many other themes. Not only will you update your skills and have the possibility to broaden your scope of knowledge, but you will also have plenty of time to share with our experts and other participants around a cup of coffee or during lunch.
In this session, we will discover how the Query Store feature introduced with SQL Server 2016 now allows the automatic plan correction as well as the automatic index management on SQL Server and Azure SQL Database.
- Steven Naudet, Consultant at dbi services
There are many solutions available for High Availability on PostgreSQL. This presentation offers deeper insight into two of them: EnterpriseDB Failover Manager and Patroni. Both come with their advantages and drawbacks. Have you ever wondered which solution better suits your needs? We will explore the architecture of both solutions and look at a demo for the most common use cases. Which one will win your heart?
- Julia Gugel, Consultant at dbi services
The presentation first introduces Nutanix ERA. We will then enter the core of the subject using a Nutanix Lab built on AWS to test the solution with Oracle databases and see how the Nutanix provided backup solution interacts with the databases. We will also discover how to perform a refresh of a clone and how to restore a database using Nutanix ERA snapshots. Finally, we will examine the snapshot technology used by Nutanix.
- Marc Wagner, Consultant at dbi services
In this presentation we will try to clarify and discover some of the most popular K8S Ingress controllers with no pretence of showing and knowing everything but at least try to grasp the pros and cons of this family. And why not provide you with some guidance if needed?
- Pascal Lerch, Consultant at dbi services
If OVM, Oracle’s previous virtualization product, had never been very popular, the time has come to bring a brand-new virtualization solution product, OLVM, based on the famous and robust KVM. This could be a real alternative to appliance or bare-metal infrastructures.
- Jérôme Dubar, Senior Consultant at dbi services
Monitor your databases with Percona Monitoring and Management tool (only in the French-speaking event)
Is your infrastructure composed of a mix of Oracle products and Open Source RDBMS such as MySQL, MariaDB, PostgreSQL, or Galera Cluster? Do you want to have a single monitoring tool that supports several database technologies in the same way? Do you need to ensure your system’s health and spot your performance issues at a glance?
Percona Monitoring and Management tool (PMM) is a free and Open Source software for monitoring, alerting, and graphing your databases using some integrated tools such as Grafana and VictoriaMetrics.
Let’s have a look!
- Elisa Usai, Delivery Manager & Consultant at dbi services
What makes container virtualization different from other virtualization techniques? What are its pros and cons? What are its limitation? Which use cases are suitable for container virtualization? A technical introduction and live demonstration.
- Casimir Schmid, Consultant at dbi services
- Karsten Lenz, Consultant at dbi services
During this introduction to Artificial Intelligence and Machine Learning, we will try to answer the following questions: What is it, what is it used for, do we have to be scared about it?
- Alain Lacour, Delivery Manager and Consultant at dbi services
AWS became one of the largest cloud providers and has its own DevOps offering. During this presentation we will see how it is built, the services and the tooling offered with an end-to-end CI/CD pipeline.
- Mehdi Bada, Senior Consultant at dbi services
There are very good reasons to move Oracle Databases from on-premises to Exadata [email protected] Besides the pros and cons of such a decision in terms of security, costs, or DevOps agility, there are of course technical considerations when moving non-container databases from Sparc Solaris to container databases on Exadata [email protected] platform. What are the possible approaches when migrating to the new platform? What are the tools Oracle offers to migrate with minimum downtime? How can we inform employees concerning new technical areas like Oracle Grid Infrastructure (RAC, ASM) or Multitenant databases?
- Clemens Bleile, Technology Leader and Principal Consultant at dbi services
In recent years, Infrastructure as Code (IaC) has developed strongly, mainly because of DevOps environments. This approach is very useful for provisioning environments in a fast, traceable and repeatable way and is also of advantage for the development of pipeline environments. But how can you also benefit from these tools in production environments? In this presentation we will look at the advantages and disadvantages of production environments with IaC and highlight deployments, regardless of the public Cloud provider.
- Hervé Schweitzer, Chief Technology Officer (CTO) and Principal Consultant at dbi services
Route de Berne 148
In den letzten Jahren hat PostgreSQL in fast jedem Unternehmen Einzug gehalten und wird dabei vielseitig eingesetzt. Da aber in der heutigen Zeit zumeist mehrere Datenbank-Systeme zum Einsatz kommen, stellt sich schnell die Frage, wie Daten einfach zwischen diesen Systemen ausgetauscht werden können. PostgreSQL implementiert Teile der SQL/MED- pezifikation, die sich genau mit diesem Thema beschäftigt – und genau darum soll es in diesem Artikel gehen: Wie schaffe ich es, PostgreSQL und Oracle so zu verbinden, dass ich einfach Daten in beide Richtungen austauschen und bearbeiten kann?
Nach meinem Einstieg in die Welt des Oracle-Datenbank-Tunings vor 20 Jahren habe ich mich entschlossen, ein neues RDBMS anzuschauen. Mein Kollege Daniel Westermann, Team Leader des Open-InfrastructureTeams, der schon länger mit PostgreSQL unterwegs ist, hat mich überzeugt, mir PostgreSQL anzugucken. Da das Tuning mein Lieblingsbereich ist, habe ich Daniel gebeten, für dbi services einen „dbi InSite PostgreSQLTuning-Workshop“ zu schreiben. Bei dbi services gibt es für jeden neuen Workshop einen Dryrun. Während dieses Dryruns wurde mir klar, dass ich das PostgreSQL-Tuning vertiefen werde, weil es sehr ähnlich wie Oracle aufgebaut ist, somit werde ich den „dbi InSite PostgreSQL-Tuning-Workshop“ auch selbst geben können
Häufig werde ich nach „besten Praktiken“ gefragt – eine Frage, die mir unangenehm ist, da die Antwort in der Regel vom Kontext abhängt. Ich kann natürlich verschiedene „Standardpraktiken“ empfehlen, die sinnvoll sind, wenn es keinen besonderen Grund gibt, anders vorzugehen. Meist geht es dem Fragesteller jedoch um einfache, allgemeingültige Regeln, die sich immer und überall anwenden lassen. Wenn es um generelle Empfehlungen geht, zähle ich lieber Dinge auf, die unter allen Umständen vermieden werden sollten. An dieser Stelle werde ich daher auf einige der „schlechtesten Praktiken“ eingehen.
dbi services obtains ISO 27001 certification and AWS Advanced Partner status
Delémont, 16 December 2020 – dbi services has set itself ambitious goals for 2020. This strategy has been successful as the company has not only achieved ISO 27001:2013 certification, but also AWS Advanced Consulting Partner status. These two milestones demonstrate the company’s ongoing commitment to its customers to provide them with cutting-edge security and expertise.
Data security for the company and its customers
ISO 20000 certified for nine years, dbi services takes a further step in terms of security by obtaining the ISO 27001:2013 label. This international standard guarantees the definition, implementation, updating and continuous improvement of the company’s information security management system. In addition to attesting to the ability of dbi services to implement the means required to guard against data breaches or leaks, this standard guarantees the application of best practices along with regular monitoring and constant updating of security measures and processes.
Dominique Althuser, Security Officer at dbi services, certified Lead Implementer and Lead Auditor
27001: “We are very proud to join the select club of ISO 27001-certified companies. Security has always been a central theme at dbi services, which is why we have endeavoured to achieve this certification. This allows us in particular to optimize the integration of all security aspects during the implementation of our customers’ middleware infrastructures.”
From AWS Select to Advanced Consulting Partner
True to its strategy of increasing its expertise, dbi services has set itself the goal of moving to the next level of its partnership with AWS by becoming an Advanced Consulting Partner. The exercise was met with success on 9 December, thanks to the commitment of all employees to meet the necessary criteria. Grégory Steulet, CFO and Partner Manager of dbi services: “Expertise has been part of our DNA since our creation. We have therefore made every effort to reach this level, which attests to our vast experience in the deployment of AWS products and to the cutting-edge expertise of our consultants, both at the technical and business levels.”
Yann Neuhaus, CSO and Vice-Chairman of the Board concludes, “This result also reflects our systematic awareness of the needs of our customers for reliable and secure Cloud solutions. With this new partnership level, we are confirming our ability to deliver them and ensure their optimum functioning”.
About dbi services
dbi services designs, builds and operates state-of-the-art middleware infrastructures so that its customers can focus on their core business. Its consultants’ expertise in Oracle, Microsoft, Open Source, Cloud and ECM technologies (including OpenText) enables it to offer tailor-made and effective solutions. dbi Services is based in Delémont, Basel, Bern, Nyon and Zurich and employs 80 committed employees whose knowledge and skills are constantly evolving through continuing education. Active in Switzerland, but also in Europe, dbi services has the trust of nearly 300 companies – SMEs or multinationals – operating in various sectors.
dbi services partners with Verium to accelerate growth strategy
Delémont, 3 December 2020 – A group of investors represented by the multi-family office Verium acquires a majority stake in dbi services. The founders and key employees remain substantially invested and will continue to develop the business together with Verium. The company intends to further expand its strong position in the Swiss market and to realize an ambitious growth strategy both organically as well as through add-on acquisitions.
Yann Neuhaus, co-founder and CSO of dbi services: “With Verium we found an experienced and financially strong partner with whom we are convinced to successfully achieve our growth targets. dbi services seeks to expand its geographical footprint and its technological expertise, organically as well as through buy & build”. Yann Neuhaus and his co-founders David Hueber (CEO), Grégory Steulet (CFO) and Hervé Schweitzer (CTO), together with selected key employees, retain a significant minority stake, continue to form the management of
dbi services and are committed to drive the company’s long-term development.
“We at dbi services will continue to differentiate ourselves through our team of certified and skilled IT specialists providing very high quality and expert-driven services with a clear focus on operating enterprise information systems and IT infrastructures” says CEO David Hueber. “Verium shares our entrepreneurial philosophy and cultural values and can support our future development both strategically and financially. We will continue to invest in our people, who are key to the continuing success of our company, in order to keep pace with the rapid development in technology and to provide best-in-class and innovative services to our clients”.
Verium strengthens the company’s board with Rogier Engelsma and Stephanie Roller. “With its strong market position, highly sticky customer base, blue-chip partner network and skilled employees dbi services is very well positioned to take advantage of market opportunities such as cloud migration and increasing complexity of IT infrastructures. We look forward to a fruitful collaboration with the dbi services team as the company enters an exciting stage in its growth path”, says Stephanie Roller, Investment Director at Verium.
About dbi services
Founded in 2010 and with offices in Delémont, Basel, Nyon, Bern and Zurich, dbi services is a leading Swiss IT management consulting expert for enterprise information systems based on Oracle, Microsoft, Open Source, Cloud and ECM (incl. OpenText) technologies. The company employs more than 70 certified and experienced IT specialists who design, realize, and operate cutting-edge IT infrastructures for SMBs and multinationals from various industries such as pharma, healthcare, insurance, banking, and the public sector. dbi services enjoys the trust of more than 300 customers in Switzerland, Germany, Benelux, Italy and France.
Verium is an independent multi-family office and manages direct investments in medium-sized companies in the DACH region for its investors. Latest investments include Home Instead, basefit.ch, Christ & Heiri, Toradex, Ceposa / Frische & Service, Quickmail, Mobil in Time / S&G, DSwiss and Zünd.
For this transaction, Verium was advised by Wenger & Vieli (legal), Alvarez & Marsal (financial and commercial) and PwC (tax). The sellers were advised by P4I Partners (M&A) and Tavernier Tschanz (legal).
Häufig werde ich nach „besten Praktiken“ gefragt – eine Frage, die mir unangenehm ist, da die Antwort in der Regel vom Kontext abhängt. Ich kann natürlich verschiedene „Standardpraktiken“ empfehlen, die sinnvoll sind, wenn es keinen besonderen Grund gibt, anders vorzugehen. Meist geht es dem Fragesteller jedoch um einfache, allgemeingültige Regeln, die sich immer und überall anwenden lassen. Wenn es um generelle Emp-fehlungen geht, zähle ich lieber Dinge auf, die unter allen Umständen vermieden werden sollten.