MySQL 8 requested authentication method unknown

Hey folks,
Be aware when you’re migrating from MySQL 5.7 to 8.0 on how you’re doing and what kind of applications have access to it. The version 8.0 introduced a new authentication plugin called caching_sha2_password and it’s the default auth plugin now.  Here is the list of compatible connectors to check if your app is ok with that or if you should call the dev team.

Example: If, for some reason, you get stuck with the following error (PHP sample), you have to do a few changes.

Connect Error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

Edit your config file and set the option default-authentication-plugin with mysql_native_password value, restart the server and set the password again with the following command.

Config File:

[mysqld]
/... other configs .../
default-authentication-plugin=mysql_native_password

SQL:

ALTER USER 'adv'@'localhost' IDENTIFIED WITH mysql_native_password BY '1AB@8CD#E91F22!';

New users should be created the same way. Be aware that you have to do that just for users that the application will use. Regular users for DBAs and queries you don’t have to do that change.

So, look out before just doing a update on your server, or you could break your app 😉

Formação DBA em Três de Maio (em 19c!)

Olá pessoal,

Atipicamente post em português hoje, para lembrar a todos que no próximo dia 14/09 começa a Formação DBA em Três de Maio/RS, no Campus SETREM. Aulas somente em Sábados.

Não perde tempo e se increve já!

A formação é resultado da parceria entre a SETREM e a TargetTrust, que ministra cursos de TI há mais de 26 anos. Eu serei o instrutor da formação que é de 132 horas no total, dividida em 5 módulos.

O primeiro módulo “SQL e SQL ANSI” a se iniciar no dia 14/9 e tem 24 horas aula (3 sábados: 14/9, 28/9 e 5/10) , tratará de entre outros:

  • Comando SELECT, suas cláusulas e operadores
  • Funções single row, de conversão e expressões de condição
  • Sub-consultas e operadores SET.
  • Criação, gerenciamento e manipulação de tabelas
  • Implementação de constraints e utilização de views
  • Construção de SQLs avançados.
  • Performance de SQL e ferramentas para análise

Inscrições até 30/8!
Valores promocionais pra egressos, colaboradores SETREM e Pacotes Empresariais disponíveis.

HrOUG: Croatian Oracle Users Group Conference 2019!

Hello all,

I’m very happy to announce I’ll be at this years Croatia Oracle Users Group annual event, in Rovinj, at Hotel Istra 4, in St. Andrew island. When? October 15-18th.

This is one of 6 events on european Oracle Groundbreakers Tour this year.

Lectures will have 20 speakers from Oracle ACE Program (11 directors, 5 ace, 3 associate, 1 alumni). I’m happy to be one of those 11. 🙂

The event also has:

  • 4 keynotes
  • 20 Oracle ACE program speakers
  • 10 Oracle Corp. speakers
  • 3-4 Social evening events

More info:

 

Just a few pics to give a taste…

See you there!

Stop Migrating Databases to 12c!

If you are starting an upgrade plan, do it directly to 19c. Why?

Well, first let’s say that 19c is “equal” to 12.2.0.3 on previous version model, while 18c is 12.2.0.2, after latest 12.2.0.1. So, thinking reasonably, you would already plan for latest PSU on the future version, right? So this is 19c.

But not only this. It’s well known that Oracle’s Terminal Patchset is the Long Term Release for each version. And for 12.2 family this is 19c.

The image below (From Doc ID 742060.1) should help on clarifying this:

versions

In summary, since August 1st 2019:
– 11.2.0.4 is already on Extended Support (20% more expensive unless you have ULA)
– 12.1 family is already on Extended Support (20% more expensive unless you have ULA)

Which only leave us with 12.2 Family. Now I ask you, why jump to any “PSU” other than the final one?
Also, support on 12.2.0.1 goes only up to Nov 2020 and for 18c (12.2.0.2) only to Jun 2021, while 19c goes up to 2026 with ES/ULA!

I’m not even raising the great improvements we have on newer versions (if you are in 11.2, shame on you, you are basically 6 years behind the world technology wise).
Myself , I already migrated several databases on different clients to 19c and it’s running preeeetty fine. So trust on it!

Ok, so to migrate to 19c? (Some tips):
– To migrate directly to 19c you need to be on supported terminal patch set (11.2.0.4, 12.1.0.2) or on 12.2 family (12.2.0.1, 18c).
– Get in touch and use AutoUpgrade mechanism (you’ll love it!) – AutoUpgrade Tool (Doc ID 2485457.1)
– Check Upgrade Guide: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/index.html
– Have a look on Mike Dietrich blog for news: https://mikedietrichde.com/
– Test it before doing in prod.

Additional Reference:
Release Schedule of Current Database Releases (Doc ID 742060.1)
Very nice and complete post (in portuguese) on this topic from Ricardo Portilho.

I like very much the table below as well:

NewScreenshot 2019-08-13 às 15.11.34

See you!

ACE Director Announcement

Hello all!
I’m proud to announce that last August 2nd Oracle promoted me from Oracle ACE to Oracle ACE Director!

And for this I can only thank:

  • ACE Program and Community itself for challenging me on this, which I discovered to be a passion after a while.
  • Friends and family for all your support and encouragement on literally every single step of this journey.
  • GREPORA and all our fellow authors on making it great on Community.
  • Pythian for all great team mates and encouragement regarding community programs.

But what is an Oracle ACE?

The Oracle ACE Program highlights excellence within the global Oracle community by recognizing individuals who have demonstrated both technical skill and strong credentials as enthusiasts and community advocates.

There are 3 levels of (active) Oracle ACEs:
ACE Associate: The entry level.
ACE: Proficient Community Advocate.
ACE Director: Expert Community Advocate.

To learn more about the program, visit Oracle ACE Program – FAQ

I’m glad to say I have covered all those steps (, ) to be where I am right now.
Also, I got originally nominated in 3 Expertises: Database Management & Performance, Cloud, MySQL.

Some additional facts:

  • I’m the first Brazilian ACE Cloud.
  •  I’m the actual youngest ACE Director in the world.
  • I’m the only ACE Director living in Brazil.

In summary, I just want to share my happiness on having this logo now on with you all.

Thanks for all your support!

O_ACEDirectorLogo_clr

MySQL InnoDB Buffer

Hi all,
Do you have a MySQL server running somewhere? I’ve seen many and many MySQL servers running with the default configuration, even the mysql_secure_installation command being ignored. Let’s talk about a tip to tune your server.

innodb_buffer_pool_chunk_size=134217728

This config, tells the server how many memory it can use, the default (using 8.0 and 5.7) its 128MB, that’s way less then it could be, in general. I usually set about 75% of the total ram of the server IF you just have the database on that server. With that, you have enough memory to accommodate OS processes and the MySQL. You can set this in your my.cfn file.

Be aware this is not a silver bullet, and if your server has a lot of ram, let’s say > 100GB, if you set at 75%, you still have about 25GB free, and that’s way more than the SO needs. So it’s all a matter of your server memory size.

Make sure you review this point on next time!

AROUG: Oracle Groundbreakers Tour Buenos Aires 2019!

¡Hola! ¿Qué tal, Cómo estas?

Como ya sabes los Grupos de Usuarios de Latinoamérica con el apoyo de OTN y LAOUC organizan por decimo año consecutivo el evento más grande de tecnología Oracle en la región, este año llamado Oracle Groundbreakers Tour, donde reconocidos expertos en tecnologías Oracle recorren el mundo llevando su conocimiento a todas las latitudes.

Este año el tour abarca 10 países y por octavo año consecutivo en Argentina, en Buenos Aires, será el lunes 6 de Agosto en la Fundación UADE – Sede Recoleta (1340 Libertad)

El motivo del presente es para invitarte a este evento, donde tendré el placer y la oportunidad de hablar sobre la tecnología de Oracle y, especialmente su tecnologia en la nube.

Además, habrá presentaciones para diversas áreas de interés: Base de Datos, Cloud computing, DevOps, Linux y BI, así como hands-on labs.

Puedes ver la agenda completa aquí.

Es necesario registrarse aquí para ayudar a estimar la asistencia, pero la inscripción es gratuita!

Subscribe here!

argentina2

Te veo allá!

UYOUG: Oracle Groundbreakers Tour Montevideo 2019!

¡Hola! ¿Qué tal, Cómo estas?

Como ya sabes los Grupos de Usuarios de Latinoamérica con el apoyo de OTN y LAOUC organizan por decimo año consecutivo el evento más grande de tecnología Oracle en la región, este año llamado Oracle Groundbreakers Tour, donde reconocidos expertos en tecnologías Oracle recorren el mundo llevando su conocimiento a todas las latitudes.

Este año el tour abarca 10 países, y en Montevideo será el lunes 5 de Agosto en la Universidad ORT sede Centro.

El motivo del presente es para invitarte a este evento, donde tendré el placer y la oportunidad de hablar sobre la tecnología de Oracle y, especialmente su tecnologia en la nube.

Además, habrá presentaciones para diversas áreas de interés: Base de Datos, Cloud computing, DevOps, Linux y BI, así como hands-on labs.

Puedes ver la agenda completa aquí.

Es necesario registrarse aquí para ayudar a estimar la asistencia, pero la inscripción es gratuita!

Subscribe here!

 

URU

Estos son algunos de los expertos presentes:

  • Alberto Salazar
  • Alex Zaballa
  • Doug hood
  • Edelweiss Kammermann
  • Franck Pachot
  • Hilmer Chona
  • Markus Michalewicz
  • Matheus Boesing
  • Mike Dietrich
  • Nelson Calero
  • Ricardo Gonzalez
  • Rolando Carrasco
  • Vicente Romero

Te veo allá!

CLOUG: Oracle Groundbreakers Tour Santiago 2019!

¡Hola! ¿Cómo estas?

Como ya sabes, los Grupos de Usuarios de Latinoamérica con el apoyo de OTN y LAOUC organizan por décimo año consecutivo el evento más grande de tecnología Oracle en la región. Este se llamado Oracle Groundbreakers Tour, donde reconocidos expertos en tecnologías Oracle recorren el mundo llevando su conocimiento a todas las latitudes.

Este año el tour abarca 10 países, y en Santiago será el lunes 2 de Agosto en la UNIVERSIDAD SAN SEBASTIÁN (Av Belavista 7, Recoleta, Santiago).

El motivo del presente es para invitarte a este evento, donde tendré el placer y la oportunidad de hablar sobre la tecnología Oracle y, especialmente su tecnologia en la nube.

Además, habrá presentaciones para diversas áreas de interés: Bases de Datos, Cloud Computing, DevOps, Linux y BI, así como hands-on labs.

Puedes ver la agenda completa aquí.
También, aquí para detalles de las charlas.

Es necesario registrarse aquí. Tarifas de acuerdo a la fecha:

  • Early Bird (hasta el 30 de junio 2019): 10.000 CLP
  • Precio Preferencial (1 de Julio al 15 de Julio): 15.000 CLP
  • Precio Normal: (16 de Julio al 1 de agosto): 20.000 CLP
  • Precio Dia del Evento: (2 de agosto): 25.000 CLP

Subscribe here!

Te veo allá!