Using Post Hook to Initialize a Database

Using Post Hook to Initialize a Database

In the OpenShift v2 days, we used Action Hooks to initialize a database with test data. OpenShift 3.x also provides pod lifecycle hooks that can be leveraged to initialize the database after the database starts inside a pod. This blog explains the approach using pod lifecycle hooks. In this blog, I am using MYSQL database as an example. A similar approach can be used with other databases.

Read More...

Deploying a PostgreSQL Pod in OpenShift V3

Deploying a PostgreSQL Pod in OpenShift V3

At Crunchy Data Solutions (Crunchy) we were excited to hear the recent announcement from the OpenShift team regarding the new public Origin repo integrating the work Red Hat has been doing for over twelve months in OpenShift Origin and related projects like Docker, Kubernetes, GearD and Project Atomic.

As we began our deep dive into the new OpenShift Origin repo and Kubernetes orchestration, we wanted to pass along our initial learning on how to provision a simple PostgreSQL database on an OpenShift Pod in Kubernetes.

Specifically, in this blog post, we will provide an example of how to deploy a PostgreSQL Pod, running as a Docker container, in OpenShift v3 and end up with a deployed solution.

Read More...

OpenShift Developer Spotlight: Rajiv Subramanian M

OpenShift Developer Spotlight: Rajiv Subramanian M

This week’s developer spotlight features Rajiv Subramanian M. Rajiv created WaterFlows Web App, a free Notes App on OpenShift using PostgresSQL, Django, HTML5, jQuery, and Bootstrap. Write down your ideas, things you like, things you hear, and things you see. Save your ideas and notes of any type (coding, articles, image/video gallery, ASCII Art). The Notes app is also useful as music reference for music studies. It comes with a music notation converter too.

Read More...

ER-Mapping with OpenShift, Getting Started with pgModeler

ER-Mapping with OpenShift, Getting Started with pgModeler

Greetings Shifters! I am an unabashed PostgreSQL fanboi. I am also someone who likes to design databases visually (ER Diagrams), I can’t visualize anything beyond two tables and their relationships without pictures. I also really want tools that can do roundtripping with the database – meaning they can generate the tables (or SQL) for the database or given a database (or SQL) they can generate a diagram. Finally, it has to run on Fedora Linux since that is my Operating System of choice. Bonus points are awarded if the tool is FOSS.

I looked around for a new tool and I hit a gold mine – pgModeler! It not only meets all my criteria it a joy to use. Today’s post will just cover some of the cool parts and how to get pgModeler to work with OpenShift.

Read More...

Cloud Connections: How to Use OpenShift with External Databases

The OpenShift Platform as a Service (PaaS) makes it easy to spin up a database alongside your hosted web application, but you can also choose to use the platform with your existing storage solution. In this blog post, I will demonstrate how to call out to databases that reside off the PaaS. The focus will be on PostgreSQL, MySQL, MongoDB and Oracle databases, but the same technique can be used for a host of other DBs.

Read More...