Infrastructure at your Service

Category

Database Administration & Monitoring

Julia Gugel

Patroni 2.0: New features – Patroni on pure Raft

By | Database Administration & Monitoring | No Comments

Last week the new Patroni 2.0 release was published which brings many new features. But one makes me absolutely curious. At the moment only as BETA, but I had to test it. Patroni on pure Raft. It’s possible to run Patroni without 3rd party dependencies. So no Etcd, Consul or Zookeeper is needed anymore. Great improvement! In this blog we will have a look at the setup and try an failover as well.

Read More
Saïd Mendi

Installing MariaDB Columnstore 1.5 on CentOS 8

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

In my previous blog, I talked about how to install the latest MariaDB Community Server 10.5.5 on CentOS 8 but now I will talk about the latest version of MariaDB ColumnStore 1.5 which is not anymore a separate fork of MariaDB but rather a pluggable storage engine.  This allows to move easily data from InnoDB to ColumnStore and it is also the first version to be released as a plugin for the community Server.

Read More
Lazhar Felahi

Oracle REST Data Services – Create Web Services

By | Database Administration & Monitoring | No Comments

In my previous blog Oracle REST Data Services – Installation and Configuration : We have installed ORDS in standalone mode. Configured ORDS to be administer by SQL Developer In this blog, we will explain how to create simple RESTful Web Services using PL/SQL and a browser Rest Client.. My sources are : Oracle REST Data Services documentation.  Thatjeffsmith. oracle-base. First, let’s try to REST the schema/tables “HR/EMPLOYEES” using the Auto REST feature. Auto REST feature…

Read More
Lazhar Felahi

Oracle REST Data Services – Installation and Configuration

By | Database Administration & Monitoring | No Comments

The goal of this blog is to install and configure Oracle REST Data Services 19.2 in Standalone mode into an oracle database 12.2. The official documentation is stored here and you will find a lot of resources and examples from the Thatjeffsmith website. The first step is to download the last version of ORDS from the Oracle REST Data Services download page. Unzip the zip file into a directory (or folder) of your choice :…

Read More
Furkan Suv

Configure PostgreSQL to allow remote connection

By | Database Administration & Monitoring | No Comments

By default, PostgreSQL will only allow localhost connection. If you want allow remote connections, you need to configure it. Configuring postgresql.conf First we need to find out where our conf file is located. You have two options: If you are new to Postgres, you would like to use the classic ‘find’ command: find / -name “postgresql.conf” And the Pro users would be use: psql -c “show config_file” postgres config_file After you find the location of…

Read More
Mouhamadou Diaw

Reimaging an ODA to 19.8 Part II

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

In my previous blog, I described the steps to deploy an ODA 19.8 by reimaging. The ODA was reimaged with the latest available version 19.8 but some components were not up-to-dated. [[email protected] ~]# odacli describe-component System Version ————— 19.8.0.0.0 Component Installed Version Available Version —————————————- ——————– ——————– OAK 19.8.0.0.0 up-to-date GI 19.8.0.0.200714 up-to-date DCSAGENT 19.8.0.0.0 up-to-date ILOM 4.0.4.38.a.r132148 4.0.4.51.r134837 BIOS 52020500 52021300 OS 7.8 up-to-date FIRMWARECONTROLLER VDV1RL02 VDV1RL04 FIRMWAREDISK 1120 1102 HMP The patch was…

Read More
Mouhamadou Diaw

Reimaging an ODA to 19.8 Part I

By | Database Administration & Monitoring, Operation systems, Oracle | No Comments

Recently I was deploying some ODA X8-2M. To install the 19.8 software, I decide to reimage the server with the 19.8 image. In this blog I describe the main steps I did. First, we will need to download following patches from Oracle support website -Patch 30403643: Oracle Database Appliance 19.8.0.0.0 OS ISO IMAGE for all platforms -Patch 30403673: Oracle Database Appliance GI Clone for ODACLI/DCS stack (and -Patch 30403662: Oracle Database Appliance RDBMS Clone for…

Read More
Jérôme Dubar

Boost your CPU speed with Standard Edition 2 on ODA

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction There is no need to decrease the number of cores on your ODA when using Standard Edition 2, because your license is based on the number of physical CPU. So why would you do that? Obviously, the more cores you have, the more performance you should get. But that simply isn’t always true. Base CPU speed and Turbo Boost If you didn’t read my previous blog, please do so to understand how Xeon processors…

Read More