Infrastructure at your Service

Daniel Westermann

Can I do it with PostgreSQL? – 19 – Create user … identified by values

By | Database Administration & Monitoring | No Comments
 

 Puh, that last post in this series is already half a year old. Time is moving too fast Today, while being at a customer again, this question came up: Can I do something comparable in PostgreSQL to what I can do in Oracle, which is: Create a user and provide the hashed password so that the password is the same on the source and the target (which implies not knowing the password at all)? In…

Read More
Franck Pachot

Covering indexes in Oracle, and branch size

By | Oracle | No Comments
 

 A covering index is an index that contains all the columns required by your query, so that you don’t have to do a TABLE ACCESS BY INDEX ROWID, which is the major cost of an index range scan. You don’t need any special feature to do that in Oracle. Just add the required columns at the end of the index. In the execution plan you will see the columns used as index keys for the…

Read More
Elisa Usai

MySQL – Time mismatch between system and log files

By | Database Administration & Monitoring | No Comments
 

 I was working on MySQL upgrades to version 5.7 at a customer, when I found out that for my instance, time in the error log file didn’t correspond to local system time: mysql@test1:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] mysql -uroot -p Enter password: ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES) mysql@test1:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] ls -ltr mysqld1.err -rw-r—–. 1 mysql mysql 13323 Apr 12 10:54 mysqld1.err mysql@test1:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] tail -1 mysqld1.err 2018-04-12T08:54:55.300633Z 67 [Note] Access denied for…

Read More
Mehdi Bada

Deploy a Cloudera cluster with Terraform and Ansible in Azure – part 1

By | Big Data, Cloud | No Comments
 

 Deploying a Cloudera distribution of Hadoop automatically is very interesting in terms of time-saving. Infrastructure as Code tools such as Ansible, Puppet, Chef, Terraform, allow now to provision, manage and deploy configuration for large clusters. In this blog posts series, we will see how to deploy and install a CDH cluster with Terraform and Ansible in the Azure cloud. The first part consists of provisioning the environment with Terraform in Azure. Terraform features an extension…

Read More
Marc Wagner

Dbvisit Standby Archive Log Daemon

By | Database Administration & Monitoring, Oracle | No Comments
 

 Dbvisit Standby version 8 comes with a nice feature, a daemon, which gives the benefit to send and apply the archive log automatically in the background. Bypassing the system scheduling, the daemon will facilitate customer RPO (Recovery Point Objective) and RTO (Recovery Time Objective) fine tuning. Monitoring to apply logs to the Standby only when needed, will also optimize use of resources. Originally available for the Linux based environments, the feature has been made available…

Read More
Olivier Gautreau

Automating Oracle Linux Installation with Kickstart

By | Database Administration & Monitoring | No Comments
 

 Automating Oracle Linux Installation with Kickstart Kickstart ? If you need to setup from scratch several Oracle Linux systems for your Oracle databases, it can be boring to repeat the install tasks again and again on each servers. Automation and standardization are the keys. Kickstart can provide an easy way to accomplish mass deployment. Kickstart configuration files Kickstart will use a Kickstart configuration file to perform the deployment. Maintaining ready to go Kickstart configurations is…

Read More
Grégory Steulet

Password Validation in MySQL

By | Database Administration & Monitoring | No Comments
 

 Introduction on validate_password plugin Since version 5.6.6 MySQL provides a new security plugins named Password Validation Plugin. The password-validation plugin aims to test passwords strength and improve security. The goal of this blog is to provide you a short overview of the functionalities provided through this plugin and illustrate these functionalities with concrete examples. As explained into the documentation The validate_password plugin implements two capabilities: 1. The plugin checks the password against the current password…

Read More
Mouhamadou Diaw

PgBackRest : Dedicated Backup Host

By | Database Administration & Monitoring | No Comments
 

 In previous blogs (blog1 and blog2) we saw a configuration of PgBackRest where the tool is installed in the same server that also hosts the PostgreSQL cluster. This configuration is fine if we have a single database server. But in the case that we have many database servers, it is more suitable to have a dedicated server for backups. This will also separate the backups and WAL archive from databases server In this article we…

Read More
Franck Pachot

After IoT, IoP makes its way to the database

By | Oracle | 3 Comments
 

 At each new Oracle version, I like to check what’s new, not only from the documentation, but also from exposed internals. I look (and sometimes diff) on catalog views definitions, undocumented parameters, and even the new C functions in the libraries. At last Oak Table World, I was intrigued by this V$SQLFN_METADATA view explained by Vit Spinka when digging into the internals of how execution plans are stored. This view has entries with all SQL…

Read More
Clemens Bleile

sqlplus and its column output

By | Database Administration & Monitoring, Database management | No Comments
 

 During tuning or normal DBA activities one of the most annoying things is sqlplus with its default column output when running queries. I.e. even after setting a linesize of 1000 and a pagesize of 1000 the output may look as follows in your preferred terminal emulation (putty here): Most people address this by using other tools like sqldeveloper (or sqlcl with sqlformat ansiconsole). However, a lot of people still use sqlplus. How can you address…

Read More
Franck Pachot

Docker: efficiently building images for large software

By | Oracle | No Comments
 

 I see increasing demand to build a Docker image for the Oracle Database. But the installation process for Oracle does not really fit the Docker way to install by layers: you need to unzip the distribution, install from it to the Oracle Home, remove the things that are not needed, strop the binaries,… Before addressing those specific issues, here are the little tests I’ve done to show how the build layers increase the size of…

Read More