Infrastructure at your Service

 
Franck Pachot

Oracle Rolling Invalidate Window Exceeded(3)

By | Oracle | No Comments

By Franck Pachot . This extends a previous post (Rolling Invalidate Window Exceeded) where, in summary, the ideas were: When you gather statistics, you want the new executions to take into account the new statistics, which means that the old execution plans (child cursors) should be invalidated You don’t want all child cursors to be immediately invalidated, to avoid an hard parse storm, and this is why this invalidation is rolling: a 5 hour window…

Read More
Daniel Westermann

8000 PostgreSQL clusters on one host?

By | AWS, Database Administration & Monitoring | No Comments

Coming back to the last post: 8000 databases in one PostgreSQL cluster?. As we’ve seen this is doable but comes with a lot of pain points. Another solution for this kind of requirement would be to host 8000 PostgreSQL clusters on one host. Again, I am not saying this is something you should do, and again, this is not how it finally will be implemented. This is more about if you can do it, and…

Read More
Franck Pachot

Oracle DB on Azure with Multitenant Option

By | Cloud | 3 Comments

By Franck Pachot . If you want to run an Oracle Database in the Microsoft Azure cloud, you will install it yourself on a VM. And then, you can expect the same as when you install it in your premises, in a virtual environment. Except that Oracle makes it two times more expensive by accepting to license the processor metric on vCPUs at the condition that the Intel core factor is not applied. And in…

Read More
Daniel Westermann

PostgreSQL on FreeBSD, installation from source code

By | Database Administration & Monitoring | No Comments

This is the next post in this little series about PostgreSQL on FreeBSD. You can find the previous one here: PostgreSQL on FreeBSD, getting started PostgreSQL on FreeBSD, updating & configuration PostgreSQL on FreeBSD, installation from packages The downside with installing from packages on FreeBSD is, that you can only run one version of PostgreSQL. If you want to run more than one, you need to install from source code, and this is the topic…

Read More
Nabil Saoual

JENKINS create a pipeline using Blue Ocean

By | DevOps | No Comments

Hi everybody, Last time we have seen what is Pipeline concepts including scripted and declarative pipeline methods.Today we will see how to create easily a declarative pipeline using Blue ocean tool.It will allow us to generate a workflow without needing advanced scripting skills. what’s blue ocean? Blue Ocean is graphical user interface making it easier to define continuous delivery pipelines. To build your pipelines you will use an integrated editor. You will be able to…

Read More
Daniel Westermann

PostgreSQL on FreeBSD, updating & configuration

By | Database Administration & Monitoring | No Comments

In the last post we installed FreeBSD, configured the keyboard, time zone and the first network interface, which gets it’s IP address via DHCP. In this post we’ll look at how we can configure the second interface, which gets a static IP address in the host only network. Once we’ve done that, we’ll update the system to the latest packages, have a look at the file system layout and kernel parameters so we can later…

Read More
Franck Pachot

Grafana, SQL and IN() list for multi-value variable

By | Database Administration & Monitoring | No Comments

By Franck Pachot . I’ve recently looked at Grafana. Pros: it is really nice, I mean aesthetically. If you want to build a dashboard for your boss, or put it on a large screen in the open space, that’s beautiful. Cons: not mature. I’m working for years with technology that works. When I have a problem, I find the solution (blog posts, forums, mailing lists, support notes)… But with modern software, the first problems I…

Read More
Daniel Westermann

PostgreSQL on FreeBSD, getting started

By | Database Administration & Monitoring | No Comments

Although we are running PostgreSQL mostly on Linux distributions, you can install an run PostgreSQL on a lot of other operating systems. On of them is FreeBSD. FreeBSD is one of those Unixes that derived from the Berkeley Software Distribution (BSD) and it is well known for having very few security issues and it is running a wide range of websites today. In addition, it is the foundation of storage appliances such as Isilon. Running…

Read More
Furkan Suv

SUMA Server Part 2

By | Development & Performance, Operation systems | No Comments

In my previous Blog I wrote how to install and configure SUSE Manager. In this Blog I will go more in the deep like repository management and PXE boot configuration. Configuring repository To syncronize products from SUSE repository, you need configure first the Organization Credentials. To get your username and password for repository you need to go: https://scc.suse.com/ Login with your SUSE Account   Admin -> Setup Wizard -> Organization Credentials -> Add a new…

Read More
Nabil Saoual

JENKINS – Introduction to pipelines

By | DevOps | No Comments

Hi, We already know how to create a build on Jenkins using freestyle job, it’s a quick way to make a job, but what happened when we want to have complex tasks and workflow to trigger? Freestyle job limitation Indeed ,it’s still possible to chain these builds to get a sophisticated workflow,but freestyle jobs are limited by many ways : -the builds will not survive a restart of Jenkins -freestyle job is only based on…

Read More