Infrastructure at your Service

Tag

MySQL Archives - Blog dbi services

Marc Wagner

Nutanix Era with oracle databases : Part 1 – Introduction

By | Oracle | No Comments

I’m currently setting up a lab for Nutanix Era in order to be able to provide some presentation on this subject and see how Nutanix Era interacts with Oracle databases. I therefore thought it would be certainly helpful and a good opportunity to share the feedback I’m getting from this experience. The lab has been built using Nutanix Cluster free trial integrated with our AWS Cloud account. This fist blog intends to provide only a…

Read More
Marc Wagner

oracle update-dcscomponents failure during ODA patching to 19.11

By | Oracle | No Comments

You might know that since ODA 19.10, the ODA metadata database is now stored in a MySQL database and not in the apache derby database any more. During a patching to 19.10 or 19.11 from a release earlier than 19.10, the apache derby database will be migrated to a mysql database. This is performed during the odacli update-dcscomponent command. Starting 19.10, DCS Agent will then use MySQL server to display any metadata information, as for…

Read More
Elisa Usai

The evolution of MySQL authentication mechanism

By | Database Administration & Monitoring, Database management, MySQL, Security | No Comments

The authentication, the first level of security for each IT system, is the stage to verify the user identity through the basic username and password scheme. It is crucial to have a mechanism to protect and secure password storing and transmitting over network. In MySQL, there is plenty of different authentication methods available, and last versions improved the security of this concept.

Read More
Open source Team

Refactoring procedural to SQL – an example with MySQL Sakila

By | Development & Performance | 4 Comments

By Franck Pachot What I want to show in this blog post is that, as in mathematics where you have to apply some algebra rules to transform an equation to an equivalent one, the database developer must translate the business specification to an equivalent that is optimized (in performance, reliability and readability) for the data model. I was looking at the Sakila sample database provided with MySQL. It simulates a DVD rental store. For my…

Read More
Yann Neuhaus

Flashback to the DOAG conference 2018

By | Application integration & Middleware, Database Administration & Monitoring, Database management | No Comments

Each year, since the company creation in 2010, dbi services attends the DOAG conference in Nürnberg. Since 2013 we even have a booth. The primary goal of participating to the DOAG Conference, is to get an overview about the main trends in the Oracle business. Furthermore, this conference and our booth allow us to welcome our Swiss and German customers and thank them for their trust. They’re always pleased to receive some nice Swiss Chocolate…

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