Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
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. Before…
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…
To start into this topic I want to shortly explain some basics. Afterwards I show you how to prepare the configuration files. Ansible Ansible is a Open Source automation utility. It is used for orchestration and configuration as well as the administration of PCs/Servers. You could say, okay but we have puppet or saltstack or an other framework, why should…
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.…
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…
By Mouhamadou Diaw 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…
By Mouhamadou Diaw 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…
Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating availability groups. Let’s start with the SQL Browser service. It is not uncommon to disable this service at customer shops…
By Mouhamadou Diaw The first session I assisted today was Oracle Active Data Guard: Best Practices and New Features Deep Dive. This session was done by Nitin Karkhanis Director of Software Development managing the Data Guard Broker development team and Mahesh Girkar Senior Director of Software Development in Oracle’s Database Division. His team is responsible for developing High Availability features…
By Mouhamadou Diaw Today was the day 0 for the oracle Openworld 2018. The event is officially not started but there were many nice entertainments to discover and enjoy San Francisco. The one Gregory Steulet (CFO of dbi services) and myself participated was the bike ride organized by Bryn Llewellyn who is the PL/SQL Product Manager. There were also Mike…
With Oracle 18.3, we have the possibility to create schemas without a password. Effectively in a perfect world, we should not be able to connect to application schemas. For security reasons it is a good thing that nobody can connect directly to the application schema. A good way is to use proxy connections, in fact connect as app_user but using…
In a recent project at a customer where we synchronize the users and group out of Active Directory we hit a little issue I was not aware of before. Suppose you have created a role in PostgreSQL, you made that role a superuser and then granted that role to another role. What happens when you login using the other role?…
