#Ghost6 has arrived! Looks like I will be updating as soon as 6.1 comes out! ;)
Nothing major in terms of breaking changes that was not expected and the #MySQL8 is still the supported version.
#MySQL8
2/2 ...
The top of the exported file has these lines:
CREATE DATABASE IF NOT EXISTS `databaseName` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `databaseName`;
If I change "databaseName" to a different name, is that enough for it to restore everything from the export file to a new database of a different name?
#MySQL8 backup/restore question
If I've exported my database to a single SQL file, and checked "Include Create Schema", how can I do a test restore without it dropping and/or recreating the existing database from the backup (which I'm trying to test, so isn't yet known to be reliable)?
1/2 ...
【MySQL】知っておくと便利なinformation_schemaのクエリ集
https://qiita.com/lvn-okino/items/d2797f17398410973ae8?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items
How to Install MySQL 8 on VPS Server
#mysql #mysql8 #vps #Cloud #Guides #VPS
https://blog.radwebhosting.com/how-to-install-mysql-8-on-vps-server
Инструкция: как перенести сайт WordPress с MySQL 5.7 на MySQL 8
Недавно WordPress при проверке здоровья сайта начал рекомендовать использование версии MySQL 8. В этой статье расскажем, как перенести сайт на WordPress на MySQL 8 на примере нашего хостинга. Спойлер: это намного легче, чем может показаться.
https://habr.com/ru/companies/spaceweb/articles/819925/
#миграция_сайта #перенос_на_MySQL8 #MySQL8 #mysql #wordpress
How to Install MySQL 8 on VPS Server
#mysql #mysql8 #vps #Cloud #Guides #VPS
https://blog.radwebhosting.com/how-to-install-mysql-8-on-vps-server
Quick fix / fallback for an error returned by #Mysql8 .
It's fine enough for local installs, when a client doesn't support `caching_sha2_password` #authentication plugin.
"SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client"
1. Add to `my.cnf`
[mysqld]
default_authentication_plugin=mysql_native_password
2.
ALTER USER 'root'@'localhost'
IDENTIFIED WITH mysql_native_password
BY 'password';
Sources:
Query and Transaction size in MySQL
Some times it's important to know the size of a transaction, especially when you plan to migrate to a HA solution where by default transactions have a limited size to guarantee an optimal behavior of the cluster.
Today we will see the different possibilities to have an idea of the size of transactions.
First we need to split the t
https://lefred.be/content/query-and-transaction-size-in-mysql/
#8.0 #MySQL #MySQL8.0 #MySQLShell #Performance_Schema
How to get client’s IP address when using MySQL Router ?
When you connect to a server (or cluster) using a TCP proxy level 7, also referred to as an application-level or Layer 7 proxy (highest level of the OSI model), the application doesn't connect directly to the back-end server(s). The proxy usually understands the p
https://lefred.be/content/how-to-get-clients-ip-address-when-using-mysql-router/
#8.0 #HA #InnoDBCluster #InnoDBReplicaSet #MySQL #MySQL8.0 #Performance_Schema #Router
MySQL 8.0.33: thank you for the contributions
The latest MySQL release has been published on April 18th, 2023 (my eldest daughter's birthday).This new version of MySQL brings a new service that I'm excited to play with: Performance Schema Server Telemetry Traces Service. MySQL 8.0.33 contains bug fixes and contributions from our great MySQL community.
I would like to thank all
https://lefred.be/content/mysql-8-0-33-thank-you-for-the-contributions/
#8.0 #Contributions #MySQL #MySQL8.0
Book Review: MySQL Crash Course
Today, I would like to present this new book from Rick Silva: MySQL Crash Course - A Hands-on Introduction to Database Development, No Starch Press, 2023.
I participated in this project as technical reviewer and I really enjoyed reading the chapters Rick was writing as soon as they were ready... and thank you Rick for the kind words to me in the book ;-)
About the
https://lefred.be/content/book-review-mysql-crash-course/
#8.0 #Books #MySQL #MySQL8.0
MySQL Database Service – find the info: part 4 – connections
As a MySQL DBA, you like to know who is connected on the system you manage. You also like to know who is trying to connect.
In this article, we will discover how we can retrieve the information and control who is using the MySQL DB instance we launched in OCI.
https://lefred.be/content/mysql-database-service-find-the-info-part-4-connections/
#8.0 #Cloud #Information_Schema #MDS #MySQL #MySQL8.0 #OCI #Performance_Schema
MySQL Database Service – find the info: part 2 – disk space utilization
This article is the second of the new series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure.
The first article was dedicated on Backups, this one is about Disk Space Utilization.
This
https://lefred.be/content/mysql-database-service-find-the-info-part-2-disk-space-utilization/
#8.0 #Cloud #HeatWave #MDS #MySQL #MySQL8.0 #OCI #Performance_Schema
MySQL Database Service – find the info: part 1 – backups
In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job.
Of course there is way less things to take care of, like backups, upgrades, operating system and hard
https://lefred.be/content/mysql-database-service-find-the-info-part-1-backups/
#8.0 #Cloud #HeatWave #MDS #MySQL #MySQL8.0 #OCI #Performance_Schema
Client Info
Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst