Cloud, PostgreSQL Google Cloud SQL Insights: ASH, plans and statement tagging 31.01.2021 by Open source Team By Franck Pachot . Looking at database performance has always been necessary to optimize the response time or throughput, but when it comes to public cloud where you are charged by resource usage, performance tuning is critical for cost(…)
Cloud Exoscale scaling up and down 30.12.2020 by Open source Team In my previous Blog I had wrote about Swiss Cloud Provider: Exoscale. Read the Blog Today we will look little bit deeper in three subjects: Template & Template sharing Scaling up and down instances dbi(…)
Database Administration & Monitoring Running two Patroni on one host using an existing etcd 23.12.2020 by Open source Team Have you ever asked yourself, how to create a second Patroni PostgreSQL cluster on an existing server using the existing etcd? My first idea was to study the documentation of Patroni, but unfortunately without big(…)
AWS, NoSQL DynamoDB Scan: the most efficient operation 😉 20.12.2020 by Open source Team By Franck Pachot . The title is provocative on purpose because you can read in many places that you should avoid scans, and that Scan operations are less efficient than other operations in DynamoDB. I(…)
Cloud, PostgreSQL Recovery in the ☁ with Google Cloud SQL (PostgreSQL) 11.12.2020 by Open source Team By Franck Pachot . In a previous post I started this series of “Recovery in the ☁” with the Oracle Autonomous database. My goal is to explain the recovery procedures, especially the Point-In-Time recovery procedures(…)
Cloud, Database Administration & Monitoring, MySQL Installing MySQL Database Service (MDS) 30.11.2020 by Open source Team On a previous blog post, we saw how to create an account on the Oracle OCI using the Oracle Cloud Free Tier offer and then how to(…)
Database Administration & Monitoring Installing EDB Advanced Server without EDB Repository 24.11.2020 by Open source Team Almost all of us, who already installed Enterprise DB Tools on a Linux server know the procedure. You need to add the EDB Repository to your server or your Red Hat Satellite configuration and after that you can easily install(…)
Cloud, Database Administration & Monitoring Swiss Cloud Provider: Exoscale 10.11.2020 by Open source Team Background More and more companies are moving from on premise hosting to cloud hosting. There are many justifications to move to the cloud, but also also many justifications not to move to the cloud. It depends(…)
AWS, PostgreSQL PostgreSQL in AWS: clearing the doubts 09.11.2020 by Open source Team By Franck Pachot . I’ve heard and read people saying that the PostgreSQL managed service is not the true open-source PostgreSQL from the community. This is wrong and I’m writing this post to clarify it. PostgreSQL on EC2(…)
Database Administration & Monitoring What is EDB? 01.11.2020 by Open source Team Last few days I played around with EDB tools. In this Blog I will introduce you to EDB. What is EDB? PostgreSQL is Open Source and has no owner. The owner of PostgreSQL is the community itself. That means, if(…)