Infrastructure at your Service

Docker Archives - Blog dbi services

Daniel Westermann

Scaling the EDB containers in MiniShift/OpenShift

By | Database Administration & Monitoring | No Comments

When you followed the last post you should have two pgpool instances and one EDB Postgres instance running in OpenShift. pgpool is responsible for the load balancing, meaning: Send write requests to the master instance and spread read requests over all instances. In the current setup this does not make much sense as we only have one instance so in this post we will scale the setup to finally consist of one master and one…

 
Read More
Franck Pachot

Some ideas about Oracle Database on Docker

By | Oracle | No Comments

This is not a ‘best practice’ but just some ideas about building Docker images to provide an Oracle Database. I started with the images provided by Oracle: https://github.com/oracle/docker-images/tree/master/OracleDatabase/SingleInstance and this is great to validate the docker environment. Then I customized for my needs and here are the different points about this customization.  

 
Read More
Franck Pachot

ADWC – a Docker container to start/stop Oracle Cloud services

By | Oracle | One Comment

In the previous post, I’ve explained how to start and stop the Autonomous Data Warehouse Cloud service from PSM (PaaS Service Manager). There’s a setup phase, and a run phase starting with service-start and ending with service-stop. And the setup is specific to an Oracle Cloud account, storing information in the local user home. You may want to run different setups, and even provide an easy way to start/stop an Oracle Cloud service without knowing…

 
Read More
David Barbarin

Load Balancing with Docker Swarm mode and SQL Server containers

By | Database Administration & Monitoring | No Comments

Docker swarm mode provides an easy way to publish ports for services. Indeed, in this mode all nodes participate in an ingress routing mesh and accept connections to any service port published. Thus, all incoming requests are routed to available nodes hosting a service. That’s a pretty cool feature but it has some drawbacks. Let’s say that a node goes wrong … In this case the application must retry connecting to the next available node…

 
Read More
David Barbarin

Managing SQL Server sa credentials with Docker secrets on Swarm

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, I was working on a MSSQL Server docker image in a context of Hidora, a swiss cloud provider based on jelastic and for Docker-based applications. When writing my jps manifest file I was agreeably surprised about the section concerning the MSSQL Server credentials information. We may able to define global variables for SQL Server sa password with ${fn.password} as function as shown below: globals: sa_password: ${fn.password} user_password: ${fn.password} nodes: -…

 
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
Franck Pachot

Docker-CE on Oracle Enterprise Linux 7

By | Oracle | One Comment

Here is how I install the latest Docker version on Oracle Linux 7. You find several blog posts about it which all install ‘docker-engine’. But things move fast in this agile world and docker package name has changed. The Community Edition is now ‘docker-ce’ and you want this one to run the latest version.  

 
Read More
David Barbarin

SQL Server on Docker and network bridge considerations

By | Database Administration & Monitoring | No Comments

Let’s continue with this blog post series about SQL Server and Docker. A couple of days ago, I was in a customer shop that already implemented SQL Server 2017 on Linux as Docker containers. It was definitely a very interesting day with a lot of customer experience and feedbacks. We discussed with him about lot of architecture scenarios. The interesting point here is I was able to compare with a previous customer who used docker…

 
Read More