Infrastructure at your Service

Category

Database Administration & Monitoring

Casimir Schmid

Persistent Memory and first usage on Oracle Exadata platform

By | Database Administration & Monitoring | No Comments

Todays fastest possible interface for flash storage in terms of bandwidth and latency are DRAM sockets. Exadata X8M is the first Oracle engineered system using this technology that, according to first measurements taken by Oracle corporation, result in 200% read IO increase compared to Exadata X8. Summary from a presentation by Gavin Parish held at DOAG 2019 conference with a comment by Michael Wirz.

Read More
Saïd Mendi

Deploying a MariaDB 10.4 Galera cluster with Clustercontrol

By | Database Administration & Monitoring | No Comments

What is ClusterControl ? Since years, I’m using and installing by customers a management and automation software called “ClusterControl” from Severalnines (www.severalnines.com). With it, you can easily deploy, manage, monitor and scale your open source database servers or clusters (MariaDB, Percona, Postgres, Galera) from one GUI (Clustercontrol User Interface) on premise or even in the cloud. Some weeks ago, Severalnines announced the version 1.7.4 with several new features. One of these was the support of…

Read More
Mehdi Bada

First day at DOAG 2019 Conference

By | Database Administration & Monitoring, Oracle | No Comments

This year I have the opportunity to take place at one of the most popular Oracle conferences, the DOAG. In the meantime, I have the chance to give a talk on Thursday about Docker containers. Yes! Because at DOAG we are not only speaking about Oracle products. I’m really impressed by the quality of the presentations. I followed 4 presentations, on different subjects/technologies and the quality of them was very good. David Hueber, OCI vs…

Read More
Hervé Schweitzer

Some news from the DOAG2019

By | Database Administration & Monitoring | No Comments

As each year dbi services is present at the DOAG, but this year it’s a little bit special, because we have a complete new booth which is just wonderful! Big thanks to the dbi services marketing teams which did a marvelous job. What is also new for dbi services, all dbi consultants have they own dedicated tee shirt with dedicated messages and colors. For me it is Mountain, Mountain bike and Natural Trance Music. Therefor…

Read More
Jérôme Dubar

A day of conferences with the Swiss Oracle User Group

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

Introduction I’m not that excited with all these events arround Oracle technologies (and beyond) but it’s always a good place to learn new things, and maybe the most important, discover new ways of thinking. And regarding this point, I was not disappointed. Franck Pachot: serverless and distributed database Franck talked about scaling out, it means avoid monoliths. Most of the database servers are this kind of monoliths today. And he advises us to think microservices….

Read More
Mouhamadou Diaw

PostgreSQL 12 : Setting Up Streaming Replication

By | Database Administration & Monitoring, Postgres | No Comments

PostgreSQL 12 was released a few month ago. When actually setting up a replication, there is no longer recovery.conf file in the PGDATA. Indeed all parameters of the recovery.conf should be now in the postgresql.conf file. And in the cluster data directory of the standby server, therre should be a file named standby.signal to trigger the standby mode. In this blog I am just building a streaming replication between 2 servers to show these changes….

Read More
Clemens Bleile

Elapsed time of Oracle Parallel Executions are not shown correctly in AWR

By | Database Administration & Monitoring | 2 Comments

As the elapsed time (time it takes for a task from start to end, often called wall-clock time) per execution of parallel queries are not shown correctly in AWR-reports, I thought I setup a testcase to find a way to get an elapsed time closer to reality. REMARK: To use AWR (Automatic Workload Repository) and ASH (Active Session History) as described in this Blog you need to have the Oracle Diagnostics Pack licensed. I created…

Read More
Daniel Westermann

Dealing with corrupted system indexes in PostgreSQL

By | Database Administration & Monitoring | No Comments

This is something you do not want to see on an important PostgreSQL system: [email protected]:/home/postgres/ [pgdev] psql psql: error: could not connect to server: FATAL: index “pg_class_oid_index” contains unexpected zero page at block 0 HINT: Please REINDEX it. The hint is pretty clear on how you should fix this, but anyway, lets do a short demo on how to do it.

Read More