[MYSQL] NO_PUBKEY error in apt update

2022-05-12 KENNETH 0

환경 OS : Ubuntu 20.04 MYSQL : 8.0.26     발생에러 Err:1 http://repo.mysql.com/apt/ubuntu focal InRelease The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 .. .. W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://repo.mysql.com/apt/ubuntu focal InRelease: The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 W: Failed to fetch http://repo.mysql.com/apt/ubuntu/dists/focal/InRelease The following signatures couldn’t be verified because the public key is not available: NO_PUBKEY 467B942D3A79BD29 W: Some index files failed to download. They have been ignored, or old ones used instead.     원인 URL : https://docs.oracle.com/cd/E17952_01/mysql-8.0-relnotes-en/news-8-0-28.html#mysqld-8-0-28-packaging https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature.html The GnuPG build key used to sign MySQL downloadable packages has been updated. The previous GnuPG build key is set to expire on 2022-02-16. [ more… ]

[MYSQL] ‘user’ entry ‘[email protected]’ ignored in –skip-name-resolve mode

2022-04-05 KENNETH 0

  에러메세지 [Warning] ‘user’ entry ‘[email protected]’ ignored in –skip-name-resolve mode.     원인 mysql의 skip-name-resolve 옵션에 의해 ‘DNS Lookup’ 과정을 처리하지 않도록 되어있는 상황에서 mysql.user 테이블의 ‘Host’컬럼에 도메인(호스트이름)이 들어갔기 때문에 이는 무시된다는 메세지로서 성능에 영향이 없으며 그냥 두어도 되며 결국 문제는 없는 메세지 즉, 말 그대로 warning 형태의 메세지 이므로 걱정할 필요는 없다     해결 하지만… error-log 에 남는것은 앞으로도 불편한 내용일 수 있으니 처리해서 나쁠것은 없다 단, skip-name-resolve 는 어쩔 수 없이 off 하는 경우가 아님을 전제로 하고 (즉, 사용함) 및 이와 상응하는 방법으로 해결하시면 되겠다      

No Image

MySQL Shell 8.0.24 – What’s New?

2021-04-22 KENNETH 0

MySQL Shell 8.0.24 – What’s New? The MySQL team is proud to announce the general availability of version 8.0.24 of the MySQL Shell. In addition to a considerable number of bugs fixed, the following changes were introduced. Improved Command Line Integration Integrating the shell functionality in DevOps operations is a key feature and this release has introduced a big improvement on this area being the most remarkable improvements the following: No longer need to execute APIs using the –execute (-e) command line argument: all of the data required for any API available in CLI can be defined through command line arguments (including lists). … Facebook Twitter LinkedIn Source: MySQL Shell 8.0.24 – What’s New?

No Image

InnoDB: Converting old atomic code to C++11

2021-04-22 KENNETH 0

InnoDB: Converting old atomic code to C++11 Atomics (or GCC intrinsics) were first introduced in InnoDB (5.0) by a patch  from Mark Callaghan’s team at Google for mutexes and rw-locks. InnoDB code then was written in C.  When the code was ported to C++ ,  part of the 5.6 release, there was no C++ standard for atomics.… Facebook Twitter LinkedIn Source: InnoDB: Converting old atomic code to C++11

No Image

The MySQL 8.0.24 Maintenance Release is Generally Available

2021-04-20 KENNETH 0

The MySQL 8.0.24 Maintenance Release is Generally Available The MySQL Development team is very happy to announce that MySQL 8.0.24 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.24 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories.… Facebook Twitter LinkedIn Source: The MySQL 8.0.24 Maintenance Release is Generally Available