Infrastructure at your Service

Franck Pachot
CaptureSUM

Google Cloud Spanner – no decimal numeric data types

By | Cloud, Database Administration & Monitoring | No Comments
 

 Google Cloud Spanner is a distributed relational database focused on scalability without compromising consistency and integrity. It is available only as a managed service in Google Cloud. Basically, the idea is to keep the scalability advantages of NoSQL database (like Bigtable) but adding transactions, relational tables, SQL, structured data,… as in the relational databases we love for decades. The commercial pitch includes all the NoSQL buzzwords, with the addition of the legacy properties of SQL…

Read More
Franck Pachot

Drilling down the pgSentinel Active Session History

By | Database Administration & Monitoring, Postgres | No Comments
 

 In pgSentinel: the sampling approach for PostgreSQL I mentioned that one of the advantages of the ASH approach is the ability to drill down from an overview of the database activity, down to the details where we can do some tuning. The idea is to always focus on the components which are relevant to our tuning goal: Filter/Group by the relevant dimension to focus on what you want to tune (a program, session, query, time…

Read More
Mouhamadou Diaw

Database Vault : Rules, Rule Sets and Command Rules

By | Database Administration & Monitoring | No Comments
 

 In a previous blog I talked about protecting data using Realms. With Database Vault we can also protect our database against some SQL statements. These statements can include SELECT, ALTER SYSTEM, database definition language (DDL), and data manipulation language (DML) statements. We can do this with Command Rules. In this blog I am demonstrating how we can use a Command Rule to prevent SYS from creating a new pluggable database in a multitenant environment. Before…

Read More
Daniel Westermann

PGDay Amsterdam – follow up 1 – Adding columns with a default value and changing the default value right after

By | Database Administration & Monitoring | No Comments
 

 As always, this time during my talk about the PostgreSQL 11 new features in Amsterdam, there have been question I could not immediately answer. The first one was this: Suppose we add a column with a default value in PostgreSQL 11, what happens when we change that default afterwards? Does the table get rewritten? Do we have more than on distinct default value for that column? Here we go …

Read More
Daniel Westermann

What a great event – PGDay Amsterdam

By | Database Administration & Monitoring | No Comments
 

 PostgreSQL conferences are always cool and this time it was in Amsterdam: PGDay Amsterdam. Beside that meeting all the great people was fun again the location was really outstanding: The TOBACCO Theater: Some impressions: Here you can see Devrim preparing the opening of the event with the introduction session: … and then it happened: We finally started: Jan kicked of the sessions with his talk about the reasons he finally arrived in the PostgreSQL community…

Read More
Franck Pachot

pgSentinel: the sampling approach for PostgreSQL

By | Database Administration & Monitoring, Postgres | 3 Comments
 

 Here is the first test I did with the beta of pgSentinel. This Active Session History sampling is a new approach to Postgres tuning. For people coming from Oracle, this is something that has made our life a lot easier to optimize database applications. Here is a quick example showing how it links together some information that are missing without this extension.

Read More
Daniel Westermann

Active session history in PostgreSQL: Say hello to pgSentinel

By | Database Administration & Monitoring | No Comments
 

 There is new project, currently in beta, which aims to bring active session history (and probably more) to PostgreSQL: pgSentinel. Because PostgreSQL is highly extensible such projects are possible and usually are coming as an extension. pgSentinel is no exception to that so lets see how it can be installed. When you want to try the beta for your own, please connect with the project on twitter.

Read More
Stephane Biehler

Documetum xPlore: Failed to load content file + file system full

By | Database Administration & Monitoring | No Comments
 

 We had issues with our indexing server when launching batches of indexes to the queue, in the xPlore server. The indexing was taking so much time to index documents and almost all queue items fell down to the warning/error state. In addition, our file system was growing too fast : 100Go for only 30.000 docs. I was like the temp folders weren’t cleared properly. And in other hand the queue was telling that the temp…

Read More
Mehdi Bada

Creating and Using a Parcel Repository for Cloudera Manager

By | Big Data | No Comments
 

 This blog post describes how to create a hosted Cloudera repository and use it in your Cloudera Manager deployment. The first step is to install a web server, which will host RPM packages and repodata. The common way, is to use an Apache web server. Installing Apache HTTPD service [cdhtest@edge ]$ sudo yum install httpd -y   Starting Apache HTTPD service [cdhtest@edge ]$ sudo systemctl start httpd Verify that the service has been started properly….

Read More
Mouhamadou Diaw

Oracle Database Vault: Realm in a Pluggable Database

By | Database Administration & Monitoring, Oracle | No Comments
 

 Database Vault can also be used in a multitenant environment. In a multitenant environment we must register Oracle Database Vault in the root first, then after in the PDBs. In this blog we will see how we can use realms to protect data in a pluggable database 12.1. In CDB$ROOT we have to create common accounts that will be used for the Database Vault Owner (DV_OWNER role) and Database Vault Account Manager (DV_ACCTMGR role) accounts….

Read More
Mehdi Bada

Create an HDFS user’s home directory

By | Big Data | No Comments
 

 Let’s assume we need to create an HDFS home directory for a user named “dbitest”. We need first to verify if the user exists on the local filesystem. It’s important to understand that HDFS is mapping users from the local filesystem. [cdhtest@master ~]$ cat /etc/passwd | grep dbitest  Create a user on the local file system When the user is not created, we can easily create one with it associated group. [cdhtest@master ~]$ sudo groupadd…

Read More