Infrastructure at your Service

Hervé Schweitzer

Deep dive Postgres at the #pgconfeu conference

By | Database Administration & Monitoring | 3 Comments

Today I followed many good technical sessions at the European Postgres conference. The Postgres conferences are really technical oriented, you will find no marketing sessions there and you learn a lot of things. As promised yesterday, I wrote today my first blog about the new Postgres storage engine ZHEAP/UNDO, which is a very interesting feature, with very interesting results.

Read More
Julia Gugel

Deploy DC/OS using Ansible (Part 2) – Playbooks

By | Database Administration & Monitoring | No Comments
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 my system, so I commented the apt-get and the debian-based part out. If you want to run the playbook on another operating system, adjust it carefully. --- # This playbook enable access to all ansible targets via...
Read More
Daniel Westermann

Some psql features you are maybe not aware of

By | Database Administration & Monitoring | No Comments

It is the time of The 10th Annual PostgreSQL Conference Europe, so this is the perfect time to blog about some tips and tricks around psql you’ll love. psql is such a powerful tool that you really should use it every day. It saves you so much work and is packed with features that makes your life so much easier. In this post we’ll look at some features you maybe didn’t know before.

Read More
Michael Hein

Getting in touch with shareplex

By | Database Administration & Monitoring | No Comments

Tuesday this week I had the opportunity to get in touch with shareplex, Quest’s replication solution. This product does not rely on Oracle licenses, so can also be used with Standard Edition. It is competitor of Oracle’s GoldenGate an used for asynchronous replication, too. An interesting feature is that not only committed transactions can be replicated, which is an advantage with big transactions. With this feature replication latencies within seconds can be realized. Also migrations…

Read More
Mouhamadou Diaw

Oracle OpenWorld 2018: Day 3

By | Database Administration & Monitoring | No Comments

Today my first session was about GDPR Data Security in the GDPR Era. It was presented by Joao Nunes, IT Senior Manager, NOS Tiago Rocha, Database Administrator, “Nos Comunicaões, Sa.” Eric Lybeck, Director, PwC The speakers started by presenting what is GDPR which is a new law protecting data for European citizens. After they explain the changes for companies about this new law. They talk about the GDPR articles related to Oracle Database Security. And…

Read More
Grégory Steulet

Oracle Open World 2018 D3: Replication what’s new in MySQL 8

By | Database Administration & Monitoring | No Comments

For this last day (25.10.2018) at Oracle Open World my first technical session was “Replication what’s new in MySQL 8“. This session was given by Nuno Carvalho – Oracle MySQL Principal Software Engineer, Vitor Oliveira – Oracle MySQL Performance Architect, Louis Soares – Oracle MySQL Software Development Director. You can find the list of new features linked with MySQL InnoDB Cluster here. They introduced the session with the challenges a database has to face today: We…

Read More
Hervé Schweitzer

My first day at the #pgconfeu 2018 in Lisbon

By | Database Administration & Monitoring | No Comments

After the first Swiss PostgreSQL community dinner yesterday evening, the conference started this morning. dbi services as Gold partner of the 10th European conference in Lisbon, get the opportunity to have a booth to present all our Open Infrastructures Services. For the occasion we decided to announce this morning our brand new video of our OpenDB Appliance, which is a real success, because we have more than one hundred views and many attended of the…

Read More
Daniel Westermann

pgconf.eu finally kicked off

By | Database Administration & Monitoring | No Comments

So, finally it started: Magnus kicked off the 10th annual PostgreSQL Conference Europe this morning in Lisbon. With 450 attendees the conference is even bigger this year than it was last year in Warsaw and it will probably be even bigger next year. One can really feel the increasing interest in PostgreSQL in Europe (and probably around the world as well). Even Tom Lane is attending this year.

Read More
Mouhamadou Diaw

Oracle OpenWorld 2018: Day 2

By | Database Administration & Monitoring | No Comments

Today is my second day of Oracle OpenWorld 2018. I can now go to the Moscone Center without GPS (cool) and then I decided to follow a MySQL session (my boss will be happy). Yes my first session was Using the MySQL Binary Log as a Change Stream by Luis Soares, Software Development Director, Oracle The speaker explains what are the binary logs. How to initialize the binary logs and how to manage them How…

Read More
Grégory Steulet

Oracle Open World 2018 D2: Peter Zaitsev – MySQL 8 Field Report

By | Database Administration & Monitoring | No Comments

As a former MySQL Consultant during this second day (24.10.2018) I couldn’t miss a session given by Peter Zaitsev founder of Percona and assuming the role of CEO. This session named MySQL 8 Field Report is a kind of summary of all new features encapsulated in MySQL 8. During the first slides, Peter presented performance related to utf8mb4 since it’s the default characterset in version 8. These slides had an Oracle logo on the botom that why…

Read More