Infrastructure at your Service

All virtual, rumours say about 1000 participants, over 200 Sessions, most of them interesting, many people to meet: that was DOAG 2021.

Myself I enjoy virtual conferences as it’s easier to get in contact with people, easier to escape to normal (family) live, no travel time and therefore eco-friendly. See dbi services booth in 8 Bits:

Larry Ellison finally discovered dbi services

Larry Ellison finally discovered dbi services

One drawback: no food and drinks. Another one: Many technical incidents. As everybody was supporting, at the end everything could be fixed, but time was wasted. If you want to organise yourself, either contact DOAG office or have a look at gather.town for meetup, Big Blue Button (open source) to record streams and chat, vimeo to distribute the streams. And as usual with digital solutions: test test test and instruct involved people well.

Next my three favourites among about 15 session followed. Way to much, I recommend to concentrate on only three per day.

25 Years of Tips and Techniques – Connor Mc Donald

Connor is technically brillant and top entertaining. Did you know there is a default commit when you accidentely exit sqlplus? Once in panic mode, many people close a session instead of rolling back. So usability wise, better to deactivate:

SQL> set exitcommit off;

Are you using Oracle RDBMS Enterprise Edition and looking for a reliable disaster recovery solution? As you probably licensed more than one server, use Data Guard which is free. So you put your primary database (the one users connect to and write) on one server and on physical standby database on another.
Bonus tip from my side: Create a second standby database which is not applying redo logs in real time but maybe with 24 hours delay. Most errors that leads in data restore and recovery are told to DBAs within 24 hours. So with the second standby, there is only recovery, no restore.
There are more advantages on Data Guard, one is certainly that you can open a standby database read write (but stop applying), select for report, test, …,  and the get in sync with primary again. So personally, I do not see any reason why not to use dataguard if you have more than one server licensed. You may want to learn more on Data Guard, so why not get instructed by my colleagues Marc, Mouhamadou or Hervé?
To sum up, Connor had more than 25 tipps for everybody dealing with Oracle RDBMS, have a look at his slides. And next time you get the chance, it worth time to follow his sessions.

A postgres-compatible DB on K8s for microservices: YugabyteDB – Franck Pachot

The Importance of a Distributed Database – Frits Hoogland

Ok, unfair, those are two session, both about Yugabyte. Frits and Franck, our formerly dbi colleague, are great team-players: One was presenting, the other one answering questions in the session chat. I’m a person that by listening I’m constantly asking questions (only to myself and sometimes verbal) to better understand, sum things up or simply in respect of my talking partner. So having questions answered promptly is a real plus for me (and maybe others).

I got in touch with database replication first developing on Lotus Notes (around 1996) and since one year when dealing with Oracle Unified Directory (where multi-master replication is being used). Frits explained replication principle and advantages (like rolling update) well, where as Franck showed how to scale up and down without service interruption. How cool would that be with Oracle RDBMS, with the free choice on cloud or on premises and without an unnecessary license nightmare.
Personally, I wish Yugabyte all the best as they are still in startup mode. To me, there is a new star shining.

Brücken bauen: mit LEGO SERIOUS PLAY® den Wandel begleiten – Dr. Reinhard Ematinger

In my experience, to deal with people is more important than to deal with technical stuff. In addition, people stay, but there are constant updates on technical side . Second problem is that not only IT  is turning more and more complex. Simplicity is a true value in my opinion, but seldom a goal among features.
However, the cool thing is that people change their mind and, being an optimistic person, there is a solution to every problem. Which are mostly people related. But how to develop a common sense to a problem? That is where LEGO SERIOUS PLAY® comes into place. Initially it was invented and used to bypass a crisis at LEGO corporation itself in the ’90s. Since some years the method is open source and it’s easier to get trained. By using LEGO people seems to get focused again and start to work to better understand each other. Seems very powerful to me, not only that I like to play LEGO myself and with family.

So hope to see you again or for the first time at a DOAG conference. They are always very well organised. Thanks to the people behind the conference, hard work, well done.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Casimir Schmid
Casimir Schmid

Consultant