Infrastructure at your Service

 
Franck Pachot

Database announcements at re:Invent 2020

By | AWS | No Comments

By Franck Pachot . This year is not very nice for conferences as everything is virtual and we miss the most important: meeting and sharing with people. But the AWS re:Invent is actually a great experience. As an AWS Data Heros, I received an Oculus Quest 2 to teleport to the virtual Neon City where we can meet and have fun in Virtual Reality (but incredibly real-life chatting): A little bit of what @AWSreInvent looks…

Read More
Steven Naudet

An Introduction to Pester – Unit Testing and Infrastructure checks in PowerShell

By | Database Administration & Monitoring | No Comments

Introduction If you never heard of it, Pester is a PowerShell module, written in PowerShell. It’s a framework for writing and running unit tests, integration tests, and also infrastructure checks as we will see in a moment. Pester is used for example to test PowerShell Core and Pester itself. In this blog post, I’ll do a short introduction to Pester with Installation and basic checks examples. Installation Pester is shipped by default with Windows 10…

Read More
Franck Pachot

DynamoDB Scan (and why 128.5 RCU?)

By | AWS | No Comments

By Franck Pachot . In the previous post I described the PartiSQL SELECT for DynamoDB and mentioned that a SELECT without a WHERE clause on the partition key may result in a Scan, but the result is automatically paginated. This pagination, and the cost of a Scan, is something that may not be very clear from the documentation and I’ll show it here on the regular DynamoDB API. By not very clear, I think this…

Read More
Daniel Westermann

PostgreSQL 14: Automatic hash and list partitioning?

By | Database Administration & Monitoring | No Comments

Declarative partitioning was introduced in PostgreSQL 10 and since then has improved quite much over the last releases. Today almost everything is there what you would expect from such a feature: You can partition by range, list and hash Attaching and detaching partitions Foreign keys Sub-partitioning Indexing and constrains on partitions Partition pruning What is missing, is the possibility to let PostgreSQL create partitions automatically. With this patch this will finally be possible for hash…

Read More
Franck Pachot

Cross-cloud PMM: which TCP ports to open

By | AWS, Database Administration & Monitoring | No Comments

By Franck Pachot . I recently installed Percona Monitoring & Management on AWS (free tier) and here is how to monitor an instance on another cloud (OCI), in order to show which TCP port must be opened. PMM server I installed PMM from the AWS Marketplace, following those instructions: https://www.percona.com/doc/percona-monitoring-and-management/deploy/server/ami.html. I’ll not reproduce the instructions, just some screenshots I took during the install: I have opened the HTTPS port in order to access the console,…

Read More
Daniel Westermann

The PostgreSQL shared/global catalog

By | Database Administration & Monitoring | No Comments

A PostgreSQL instance (or cluster) can contain many databases, three of them (template0, template1 and postgres) are there by default. Over the last years we trained many people on PostgreSQL Essentials and there have been mainly two points that needed more clarification when it comes to catalogs and the postgres default database: Does the postgres default database define the catalog and somehow is the master database? What exactly is in the global catalog? In this…

Read More
Morgan Patou

Documentum – D2 doesn’t load repositories with “Unexpected error occured”

By | Application integration & Middleware, Entreprise content management | No Comments

I had a case today where all Documentum components were up and running, including D2 but while accessing its login page, the repositories wouldn’t appear and a message “An unexpected error occurred. Please refresh your browser” would pop-up in the lower-right corner and disappear quickly. Refreshing the browser or opening a private window wouldn’t do anything. In such cases, of course the first thing to do would be to make sure the docbroker and repositories…

Read More
Pascal Brand

Using LDAP resolved connection descriptor in WebLogic JDBC data sources.

By | Application integration & Middleware | No Comments

I got the question if it is possible to have a the WebLogic JDBC Data Source to be resolved by an LDAP entry. The answer is yes; since WebLogic 12.2.1.3 a JDBC connection pool URL declaration can point to an LDAP entry. This can be done by simply editing an existing JDBC data source. jdbc:oracle:thin:@ldap://vm01.dbi-workshop.com:1389/cn=orcl,cn=OracleContext,dc=DatabaseConnection,dc=com Of course the LDAP server needs to have been configured to store the TNS entries. I explained how to do…

Read More
Pascal Brand

How to declare TNS entries in Oracle Unified Directory (OUD)

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

Using a LDAP server to store the TNS connection strings can be a single point of declarations for all client tools. Note that it can be a single point of failure too, thus, a High Availability LDAP configuration is recommended for production use. In my case, I was interested in using a LDAP as TNS connections repository for the WebLogic Domains Data-Source connections. I used a Oracle Unified Directory (OUD). The first step is to…

Read More