After 12 consecutive years of MySQL presence at FOSDEM, the MySQL Devroom has been rejected of the 2024 edition. The MySQL & Friends Devroom has been always very popular, almost full for each sessions and maybe the room with the most received submissions. This is also the reason why since 2017, MySQL was proposing a […]

Register for the MySQL Belgian Days 2024, 2 days of exclusive MySQL content from engineers, customers and community.

EXPLAIN INTO The INTO clause for EXPLAIN introduced in MySQL 8.1 allows storing the output of an EXPLAIN query in a user variable, instead of returning it to the client. It is currently only supported for the JSON format, but that should be sufficient for most use cases. With the EXPLAIN output stored in a […]

MySQL NDB Cluster 8.3.0 introduces the use of TLS to secure the network protocols used inside MySQL NDB Cluster. NDB Cluster is a distributed database system that provides very high availability and real-time performance, and this important change makes it possible to deploy cluster nodes not just on trusted, private networks, but also on untrusted networks […]

In this article, we'll briefly review some advantages of SQL Azure, a Microsoft cloud-based SQL database service, and explore how to export and import data between Azure SQL and MySQL server using a universal ODBC driver for SQL Azure and a powerful MySQL tool - dbForge Studio for MySQL.

The post How to Import/Export MySQL Data to SQL Azure: Using ODBC Driver for Data Migration appeared first on Devart Blog.

52 + 52 = 104. A letter from Josh. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Maybe you have guessed already. Or used your incredible math skills and surmised that OpenLampTech issue #104 is a historic event for me and this newsletter.

Be sure and grab your free subscription to OpenLampTech so you don’t miss out on anything!

More ways I can help

• Need hosting for your …

As you know, one of the most eagerly waited features was released with MySQL 8.2: the transparent read/write splitting. In this post, we’ll look at how to use it with MySQL-Connector/Python. Architecture To play with our Python program, we will use an InnoDB Cluster. This is an overview of the cluster in MySQL Shell: JS […]

In this article you will see how to use MySQL 8.2 transparent read/write splitting using MySQL Connector/Python and a MySQL InnoDB Cluster

As you know, one of the most eagerly waited features was released with MySQL 8.2: the transparent read/write splitting.

In this post, we’ll look at how to use it with MySQL-Connector/Python.

Architecture

To play with our Python program, we will use an InnoDB Cluster.

This is an overview of the cluster in MySQL Shell:

JS > cluster.status()
{
    "clusterName": "fred", 
    "defaultReplicaSet": {
        "name": "default", 
        "primary": "127.0.0.1:3310", 
        "ssl": "REQUIRED", 
        "status": "OK", 
        "statusText": "Cluster is ONLINE and can tolerate up to ONE failure.", 
        "topology": {
            "127.0.0.1:3310": {
                "address": "127.0.0.1:3310", 
                "memberRole": "PRIMARY", …

With the release of Percona XtraBackup 8.0.34-39, Percona XtraBackup (PXB) allows a backup on server version 8.0.35 and higher. We have removed the server version check because the MySQL 8.0 series has transitioned to bug fixes.A feature change in the MySQL 8.0 series, such as the redo log record structure, could cause PXB to fail […]