(Lalit) In Generic binary Installation method, we are extracting compressed tar files of MySQL and later we can do customization for MySQL setup as per our requirement. Like having different data directory, log directory etc.
Tag: Open Source
MySQL PITR The Fastest Way With DevOps
(Bhuvanesh R) Point In Time Recovery – is a nightmare for DBAs if the MySQL clusters are self managed. It was 10PM, after had my dinner I was simply watching some shows in YouTube.
Using SQLAlchemy with MySQL 8
(Jesper Krogh) I few months ago, I wrote about using the Django framework with MySQL 8. There are also other Python frameworks that are worth considering. In this blog, I will look at using SQLAlchemy with MySQL 8.
The Format for Timestamps in MySQL Logs
(Jesper Krogh) MySQL changed the timestamp format in the log files in MySQL 5.7. Since then, I have a few times seen questions about the new format, and how to change the time zone that is used.
A Review of the New Analytic Window Functions in MySQL 8.0
(Joshua Otwell) Data is captured and stored for a variety of reasons. Hours beyond count (and even more budget) invested in collecting, ingesting, structuring, validating, and ultimately storing of data; to say that it is a valuable asset is to drive home a moot point. This day in age it may, in fac
How to concatenate strings in MySQL and MariaDB
(Federico Razzoli) The standard way to concatenate strings in MySQL is:
Charset and Collation Settings Impact on MySQL Performance
(Vadim Tkachenko) Following my post MySQL 8 is not always faster than MySQL 5.7, this time I decided to test very simple read-only CPU intensive workloads, when all data fits memory. In this workload there is NO IO operations, only memory and CPU operations.
Parsing Intents and Their Targets into SQL Queries with spaCy: Part 1
People use natural languages to communicate with each other. To efficiently interact with a machine, good knowledge of programming languages is required. Natural Language Processing (NLP) is here to enable human-machine communications through natural languages. This is however, a very general notion of what NLP is. Intuitively, it may seem that an NLP-enabled application understands human speech natively, like a...
MySQL Master High Availability and Failover: more thoughts
(Jean-François Gagné) Some months ago, Shlomi Noach published a series about Service Discovery. In his posts, Shlomi describes many ways for an application to find the master. He also gives detail on how these solutions cope with failover to a slave, including their integration with Orchestrator.
MySQL 8.0: New Storage Format for Compressed BLOBs
(Annamalai Gurusami) In this article, let us look at the new storage format of compressed large objects (compressed LOB or ZLOB).