Infrastructure at your Service

All Posts By

Franck Pachot

Franck Pachot

DynamoDB PartiQL – part II: SELECT

By | AWS | No Comments

By Franck Pachot . In the previous post I insertd a few rows in a Demo table using the SQL-like new API on DynamoDB. I checked my items with a SELECT but was limited in the ORDER BY clause. Here is the most important to understand: there are no additional data processing engine here. PartiQL (pronounce it like ‘particle’ and it helps to avoid any kind of dyslexia) parses a statement with INSERT/UPDATE/DELETE/SELECT and calls…

Read More
Franck Pachot

DynamoDB PartiQL – part I: INSERT

By | AWS | No Comments

By Franck Pachot . This sounds paradoxical to execute SQL statements on a NoSQL database, but we have now a new API to interact with DynamoDB, which looks like SQL. AWS data services is a collection of purpose-built database services that have their own API. The relational databases in RDS all share a similar API thanks to the SQL standard. However, for non-relational databases, there is no standard: each NoSQL databases, even if they have…

Read More
Franck Pachot

AWS burstable EC2 and CloudWatch metrics

By | AWS | No Comments

By Franck Pachot . Your application workload is usually not constant and maybe not predictable. If you undersize the capacity, you will save money but in case of peak of activity you will have severe performance issues. Thus, you need to size the capacity for peak workloads: you pay for idle CPU when out of those peaks. This is one major reason for virtualization and cloud: elasticity. Because the hardware is shared by multiple applications,…

Read More
Franck Pachot

Recovery in the ☁ with Oracle Autonomous Database

By | Cloud, Oracle | No Comments

By Franck Pachot . I’ll start this series with the Oracle Autonomous database but my goal is to cover the Point In Time recovery for many managed databases in the major cloud providers. Because I’ve seen lot of confusion about database backups (see What is a database backup (back to the basics)). On one side, in a managed database, we should not have to care about backups, but only about recovery. The way it is…

Read More
Franck Pachot

AWS DynamoDB -> S3 -> OCI Autonomous Database

By | AWS, Cloud, Oracle | No Comments

By Franck Pachot . I contribute to multiple technologies communities. I’m an Oracle ACE Director for many years, and I also became an AWS Data Hero recently 🎉. I got asked if there’s no conflict with that, as Amazon and Oracle are two competitors. Actually, there’s no conflict at all. Those advocacy programs are not about sales, but technology. Many database developers and administrators have to interact with more than one cloud provider, and those…

Read More
Franck Pachot

PostgreSQL in AWS: clearing the doubts

By | AWS, Postgres | No Comments

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 Obviously, you can install PostgreSQL on an EC2 instance, as a database running on IaaS (Infrastructure as a Service). You have the full choice of version, you can even compile it from sources, and add whatever extensions…

Read More
Franck Pachot

NoSQL and SQL: key-value access always scale

By | AWS, Cloud, NoSQL, Oracle | 4 Comments

By Franck Pachot . I have written about some NoSQL myths in previous posts (<a href="https://blog.dbi-services.com/rdbms-scales-the-algorithm/" rel="noopener noreferrer" target="_blank"4here and here) and I got some feedback from people mentioning that the test case was on relatively small data. This is true. In order to understand how it works, we need to explain and trace the execution, and that is easier on a small test case. Once the algorithm is understood it is easy to infer…

Read More
Franck Pachot

What is a database backup (back to the basics)

By | Database Administration & Monitoring, Postgres | 11 Comments

By Franck Pachot . TL;DR: do not consider a dump (like PostgreSQL pg_dump or Oracle expdp) as a database backup do not consider that your backup is successful if you didn’t test recovery databases provide physical database backups, easy and safe to restore and recover to any point-in-time between first backup and point of failure managed databases provide an easy recovery interface, but don’t trust it before you try it and… I’ve written this after…

Read More
Franck Pachot

YCSB (NoSQL benchmark) on Oracle Database

By | Cloud, Database Administration & Monitoring, NoSQL | 7 Comments

By Franck Pachot . The NoSQL technologies emerged for Big Data workloads where eventual consistency is acceptable and scaling out to multiple server nodes is an easy answer to increase throughput. With cloud services rising, those key-value document datastores started to be used by the web-scale companies for some transactional processing workloads as well. The solutions can provide high performance and easy partitioning capabilities thanks to the very simple API of NoSQL. Each table or…

Read More
Franck Pachot

CLUSTER

By | Oracle | No Comments

By Franck Pachot . Statistically, my blog posts starting with a single SQL keyword (like COMMIT and ROLLBACK) in the title are not fully technical ones, but about moves. Same here. It is more about community engagement, people sharing. And about a friend. And clusters of course… In 2020 because of this COVID virus, we try to avoid clusters of people. And everybody suffers from that in the community because we have no, or very…

Read More