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 […]
Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.41-26.22 (release notes, download), with Galera replication library 4.22 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.4-26.22 (release notes, …
[Read more]Learn about how Global Transaction Identifiers (GTID's) and how they are used with MySQL replication.
I have been working on MyDumper for over three years now, and I usually don’t use the tax-consistency-only feature during backups because it wasn’t an option I quite understood. So, when reviewing another issue, I stepped into a curious scenario, and I finally got it and decided to share with you what I learned and when it should […]
If you’ve ever wanted to deploy Galera Cluster on Rancher by SUSE, you now can since Galera Cluster is a partner chart in their repository. This means Codership’s Galera Cluster is a SUSE Ready Verified partner. A direct link to the HELM charts for MySQL/Galera Cluster is here.
What is Rancher? Rancher is a Kubernetes management tool to deploy and run clusters anywhere and on any provider. Rancher can provision Kubernetes from a hosted provider, provision compute nodes and then install Kubernetes onto them, or import existing Kubernetes clusters running anywhere.
Rancher comes with very good …
[Read more]The NIS2 Directive strengthens EU cybersecurity standards by expanding sector coverage and imposing stricter requirements. This document outlines how MySQL Enterprise Edition can help organizations meet these demands, focusing on key areas for securing MySQL database servers within the NIS2 framework.
These are the MySQL Rockstars 2024 winners !