I just submitted a MySQL Contribution and I would like to gather feedback about it. Depending on the received feedback, I might submit an updated contribution. The contribution is Counters for Slow InnoDB Sync Reads, and its goal is to make MySQL easier to operate on “complex” IO subsystems (like network drives in the cloud).
The bug report / feature request Bug #117740 :
In this blog, we will look at the differences between LTS (Long Term Stable) versions of Percona Server for MySQL. Released in April 2019, MySQL 8.0 represented a major change from the previous version, 5.7, introducing significant changes to the data dictionary and enabling many features and enhancements. It also provided no direct downgrade path, […]
Percona is excited to announce the community release of our MySQL 5.7 End-of-Life (EOL) source code for both Percona Server for MySQL (PS) version 5.7.44-52 and Percona XtraDB Cluster (PXC) version 5.7.44-31.65.5. This release is an accumulation of several customer-only releases we’ve done as part of our post-EOL support for MySQL 5.7, and we’re happy […]
Yesterday I participated to the Oracle Technology Roundtable for Digital Natives in Zurich.
It was a good opportunity to learn more about AI, Cloud and HeatWave with the focus on very trendy features of this product: generative AI, machine learning, vector processing, analytics and transaction processing across data in Data Lake and MySQL databases.
It was also great to share moments with the Oracle and MySQL teams and meet customers which gave feedback and tips about their solutions already in place in this area.
I’ll try to summarize below some key take-away of each session.
Unlocking Innovation: How Oracle AI is Shaping the Future of Business (by Jürgen Wirtgen)
AI is not a new topic. But how do we …
[Read more]Multicloud is a cloud adoption strategy that utilizes services from multiple cloud providers rather than relying on just one. This approach enables organizations to take advantage of the best services for specific tasks, enhances resilience, and helps reduce costs. Additionally, a multicloud strategy offers the flexibility necessary to meet regulatory requirements and increases options for […]
At the beginning of the year, we released MySQL 9.2, the latest Innovation Release. Sorry for the delay, but I was busy with the preFOSDEM MySQL Belgian Days and FOSDEM MySQL Belgium Days. Of course, we released bug fixes for 8.0 and 8.4 LTS, but in this post, I focus on the newest release. Within […]
Learn about MySQL reserved words, their impact on database design, and how to avoid common errors. Find practical tips, examples, and resources for managing reserved words effectively.
The post MySQL Reserved Words: What You Need to Know appeared first on Devart Blog.
MySQL Shell is a powerful tool for managing MySQL databases, and
one of its most exciting features is the ability to extend its
functionality using plugins. If you're a Python developer, you
can create custom plugins to automate tasks, add new commands,
or
integrate MySQL Shell with other tools. However debugging the
python code could be cumbersome for mysql-shell given the python
code requires some specific objects available only when running
inside the shell.
In this blog post, we'll walk you through the steps to set up your development environment for creating MySQL Shell plugins in Python while able to modify and debug the mysql-shell itself.
Prerequisites
Before we dive into the setup, ensure you have the following installed on your system:
The internet has changed to a place where most protocols like HTTP etc now use secure connections with TLS by default.
While both HTTP and the MySQL Protocol use TLS for secure connections there are still many differences which make it difficult for MySQL to benefit from the same advancements as HTTP has seen in the last so many years.
What is TLS?
TLS stands for Transport Layer Security and is the successor of SSL (Socket Layer Security). SSL and TLS are often used interchangably, while this isn’t correct strictly speaking. What TLS provides is a standardized way to encrypt in transit traffic and authenticate the other end of the connection. TLS when used together with HTTP is known as HTTPS, for secure HTTP.
How TLS works in HTTPS
The client (webbrowser) connects to a server on port 443. Then negitiation is done to agree on what encryption method is to be used. The server presents the client with a …
[Read more]Typically, we receive customer tickets regarding crashes or bugs, where we request a core dump to analyze and identify the root cause or understand the unexpected behavior. To read the core dumps, we also request the linked libraries used by the server’s MySQL. However, there’s a more efficient way to achieve our goal: by using […]