How to Troubleshoot a MySQL Replica IO Thread that is Stuck in a Connecting State
Category: MySQL Developer Insights
PostgreSQL 16 brings Load Balancing Support in libpq (psql)
Get ready for PostgreSQL 16's release and learn about the new Connection Load Balancing Support feature in libpq. Discover how it can help scale out read queries and improve PostgreSQL's performance.
Mastering MySQL Group Replication Primary Promotion Techniques
Table of contents: IntroductionCommon reasons for switching the primary nodePrimary Promotion and its importanceMethods for switching the primary nodeSetting up a three-node MySQL group replication cluster for demonstrationAuto-switch method and its implementationAuto-switch by weight of the node method and its implementationManual Primary Promotion method and its implementationConclusion Introduction MySQL's group replication is a powerful feature … Continue reading Mastering MySQL Group Replication Primary Promotion Techniques
Upgrade Your MySQL Database: Don’t Get Left Behind
The End-of-Life (EOL) date for MySQL 5.7 is scheduled for October 2023, which means that after that date, MySQL 5.7 will no longer receive updates, bug fixes, or security patches. This does not mean that MySQL 5.7 will stop working after the EOL date, but it does mean that any issues or vulnerabilities discovered after … Continue reading Upgrade Your MySQL Database: Don’t Get Left Behind
Synopsis of Mydbops 19th edition of MyWebinar
Thank you to everyone who joined us for the 19th edition of MyWebinar. We hope that our time together helped to elevate and seam your work to perfection. We’re committed to giving back to the opensource database community in the coming days by presenting more LIVE events. Recently, Mydbops conducted a webinar on the top … Continue reading Synopsis of Mydbops 19th edition of MyWebinar
10 New Functions for JSON Columns in MySQL 8.
MySQL has come a long way, and keeps on bringing in new improvements and new collections of JSON functions. Here are a few techniques to store data in JSON columns. MySQL Vs MariaDB JSON Implementation : There is a key difference on how JSON is implemented in MySQL and in MariaDB. MySQL has implemented JSON … Continue reading 10 New Functions for JSON Columns in MySQL 8.
GeoSpatial data handling made easy with MySQL 8.0
Human geography examines the dynamics of cultures, societies and economies, and physical geography examines the dynamics of physical landscapes and the environment. In this blog i am going to explain what are the new Geography features available in MySQL 8.0 Major Difference in MySQL 5.7 & 8.0 Geography : There is a big change from … Continue reading GeoSpatial data handling made easy with MySQL 8.0
A Linux Tool to Monitor Progress of MySQL Data Imports and Exports.
One problem I have experienced during logical exporting and importing databases is the tools don’t output any progress indicator (or anything at all really) and using the -v (verbose) switch outputs every single MySQL command being run from the import file. As, importing and exporting of databases is one of the most frequent activity being … Continue reading A Linux Tool to Monitor Progress of MySQL Data Imports and Exports.
Common Table Expression (CTE) MySQL 8.0.
1.0. Introduction: MySQL 8.0 was released with awesome features. One of its most prominent features is CTE (Common Table Expression). The Common Table Expression can be used to construct complex queries in a more readable manner. In this blog, I have described how the CTE works with some useful examples. 1.1 What is CTE? A Common … Continue reading Common Table Expression (CTE) MySQL 8.0.