Database Administration & Monitoring SUSE Expert Day Zürich 28.05.2019 by Open source Team On May 16th I visited the SUSE Expert Day in Zürich. An interesting Agenda was waiting for me, all under the topic: "My kind of open"(…)
Database Administration & Monitoring Two node patroni does not failover when one node crashes 30.04.2019 by Open source Team A few days ago I had the interesting mission to build a two Node Patroni Postgres 9.6 Cluster using etcd in our openDB Appliance environment. Sounds easy, one leader, one secondary, both running etcd, that's it. But that's only the(…)
Database Administration & Monitoring, MySQL, Security MySQL 8 and Security – Encryption of binary logs 22.02.2019 by Open source Team As I discussed in some of my recent talks at conferences (at the DOAG for example), MySQL 8 came out with new features which bring lots of improvements in terms of security.
Database Administration & Monitoring DC/OS: Install Marathon-LB with keepalived 13.11.2018 by Open source Team 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,(…)
Database Administration & Monitoring, MySQL, Security Password Verification Policy in MySQL 8.0.13 29.10.2018 by Open source Team The new release 8.0.13 for MySQL is available since last week. Concerning security, this comes with a new feature already announced: the Password Verification Policy. Let's have a look...
Database Administration & Monitoring Deploy DC/OS using Ansible (Part 2) – Playbooks 26.10.2018 by Open source Team Finally, after all the configuration stuff is done, we can run the playbooks Create SSH Access First the SSH Access on all nodes need to be created. Therefore the access-onprem.yml is used: Be careful, I used CentOS on(…)
Database Administration & Monitoring Deploy DC/OS using Ansible (Part 1) – Getting Started 26.10.2018 by Open source Team To start into this topic I want to shortly explain some basics. Afterwards I show you how to prepare the configuration files.
Database Administration & Monitoring, DevOps, MySQL Deploy a MySQL Server in Docker containers 08.10.2018 by Open source Team We hear about Docker every day. By working on MySQL Server, I am curious to test this platform which makes it possible to create containers independent of the OS to deploy virtualized applications. So let's try to deploy a MySQL(…)
Database Administration & Monitoring, MySQL, Security MySQL 8.0 – Roles are finally there 22.06.2018 by Open source Team Roles have been existing on many RDBMS for a long time by now. Starting from version 8.0, this functionality is finally there for MySQL. The most important advantage is to define only once a role that includes a “set(…)
Database Administration & Monitoring How uid mapping works in Docker containers? 02.05.2018 by Open source Team It can be interesting to see how uids between the docker host and docker containers are mapped. For example, for security concerns. As a reminder, docker containers are based on two linux kernel features:(…)