(Marcelo Altmann) In this blog post, I want to share a case we worked on a few days ago. I’ll show you how we approached the resolution of a MySQL performance issue and used Percona Monitoring and Management PMM to support troubleshooting.
Tag: Open Source
Dealing with Unreliable Networks When Crafting an HA Solution for MySQL or MariaDB
(Krzysztof Ksiazek) Long gone are the days when a database was deployed as a single node or instance – a powerful, standalone server which was tasked to handle all the requests to the database.
Parsing Intents and Their Targets into SQL Queries with spaCy: Part 2
In the previous article of this series, you learned that spaCy allows you to train its parser to be specific to your domain, which can be useful if you, for example, are developing a conversational application. In the example given in the article, you were guided through the steps of preparing training examples for the parser and then training the...
PHP with Vue.js & MySQL: REST API CRUD Tutorial
(Ahmed Bouchefra) In this tutorial, we’ll build a RESTful CRUD application with PHP & MySQL in the backend and Vue.js in the frontend. We’ll also be using Axios for sending Ajax request to PHP from Vue.
How to Upgrade Amazon Aurora MySQL from 5.6 to 5.7
(Yves Trudeau and Jacques Fu) Over time, software evolves and it is important to stay up to date if you want to benefit from new features and performance improvements.
Un-split brain MySQL via gh-mysql-rewind
(Shlomi Noach) We are pleased to release gh-mysql-rewind, a tool that allows us to move MySQL back in time, automatically identify and rewind split brain changes, restoring a split brain server into a healthy replication chain.
Improvements to ROLLUP in MySQL
(Chaithra Gopalareddy) ROLLUP has been supported in MySQL for sometime now. But until now its use has come with two implementation restrictions: it cannot be combined with DISTINCT or ORDER BY in the same query expression.
NULL comparisons in MySQL, PostgreSQL, and SQLite
(Federico Razzoli) Any comparison involving at least one NULL operand will return NULL. This is expected, as it is implicit in how NULL works. But somtetimes developers write verbose conditions to handle NULL.
MySQL Replication Setup
(Lalit) Replication used to replicate data from the Master node to a slave node[Replica].
Your SQL IS NOT JavaScript (neither PHP)
(Gabriela D’Ávila) People like to complain about JavaScript, how can one thing be equal to the other, i.e. null == undefined evaluates to true unless you use the triple equals ===.