Infrastructure at your Service
Amazing conference, amazing people and awesome party like every year and of course great networking like every year This year, I was quite impressed about the number of different technologies. Speeches were not only centered around the big red O. As already summarized, by my colleague Alain yesterday: DOAG 2018 – Not only database – Docker and Kubernetes rule the world Open Source RDBMS, containers and microservices are arising much more quickly than cloud computing…
The DOAG Konferenz is about everything around the Oracle database and Oracle technologies. But this year, as stated in the blog of Daniel Westermann more and more open source as well as “hype” subjects from which Docker and Kubernetes are very popular. Looking at the program we can see about 20 presentations on those 2 technologies: DevOps mit der Oracle Datenbank Oracle, PostgreSQL, Docker und Kubernetes bei der Mobiliar Docker und die Oracle Fusion Middleware…
As each year dbi services is present at the DOAG with a nice booth and with many presentations. Today my colleague Daniel Westermann had a very funny session with Jan Karremans “Oracle vs PostgreSQL” battle. The rule of who will defend which technology was not defined before and without surprise Daniel won the Oracle Technology. But Daniel since the last year is convinced from the PostgreSQL technology. Daniel started the Battle with aggressive question to…
We speak about the increasing interest in open source technologies since several years and now, in 2018, you even feel that at the DOAG. There are sessions about PostgreSQL, MariaDB, Docker, Kubernetes and much more. As usual we had to do our hard preparation work before the conference opened to the public and prepare our booth and Michael almost came to his limits (and maybe he was not even sure on what he was doing…
We all know that security becomes…sorry, is one of the hottest topic when setting up IT environment. One basis for that is to be compliant with regulations or standards such as GDPR or CIS. What is not so well known, is that ODA already integrates some tool to support you for that.
Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to deal with of my customers a couple of weeks ago. Usually DBAs complain when they don’t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of tools for memory pressure troubleshooting. But what about of the opposite? This question raised in a context of an environment…
This article describes patching a virtualized Oracle Database Appliance (ODA) containing only an ODA_BASE virtual machine. Do this patching first on test machines because it can not be guaranteed that all causes of failures of single VM ODAs are covered in this article. I got the experience that precheck for ODA patches does not detect some failure conditions which may lead to an unusuable ODA. Overview: Patch first to 12.1.2.12.0 After that patch to 12.2.1.4.0…
After the minimal setup of the DC/OS in my further articles, I wanted to extend my DC/OS and add a loadbalancer. There are two options for loadbalancing in DC/OS 1. Marathon-LB (a layer 7 load balancer, used for external requests, based on HAProxy) 2. Named VIPs (a layer 4 load balancer used for internal TCP traffic) In this article we will use Marathon-LB. In case you want to read more about the VIP solution, just…
Some days ago EnterpriseDB released the latest version of its backup and recovery tool for PostgreSQL and EDB Postgres Advanced Server, release notes here. The main new features, at least for me, are backups using multiple cores and parallel incremental restores. Besides that BART does not require pg_basebackup anymore for taking full backups of a PostgreSQL instance. The downside with that could be that you can not easily restore the backups without using EDB BART….
When a patch fails on a virtualized Oracle Database Appliance (ODA), this ODA is often unusuable because Linux and OAKD are patched to new release but Grid Infrastructure is still on old version. OAKD cannot be restarted in default mode because in this mode the active Grid Infrastructure version is checked, which will fail due to old version. Also Grid Infrastructure cannot be started due to the fact that OAKD controls access of shared hardware…
