(Johannes Schlüter) In part 2 of this series of blog posts about MySQL 5.7.12 you could read about our new X Protocol for MySQL. Part 3 gave a glance on our new common basic API, the DevAPI. What’s a protocol and an API without clients using it?
Tag: Open Source
Virtual Hosting with vsftpd + TLS encryption and MySQL on Ubuntu 15.10
Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually, vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users.
MySQL 5.7.12 – Part 4: A new MySQL Command Line Shell
(Alfredo Kojima) The classic MySQL command line tool is how most users – developers and administrators – interact with a MySQL server. From administrative tasks to trying out queries, it wouldn’t be far-fetched to call it the face of MySQL.
Orchestrator-agent: How to recover a MySQL database
(Tibor Korocz) In our previous post, we showed how Orchestrator can handle complex replication topologies. Today we will discuss how the Orchestrator-agent complements Orchestrator by monitoring our servers, and provides us a snapshot and recovery abilities if there are problems.
Rosetta Stone: MySQL, Pig and Spark (Basics)
(Todd Farmer) In a world where new data processing languages appear every day, it can be helpful to have tutorials explaining language characteristics in detail from the ground up. This blog post is not such a tutorial.
Evaluating Database Compression Methods: Update
(Peter Zaitsev and Vadim Tkachenko) This blog post is an update to our last post discussing database compression methods, and how they stack up against each other.
Query Rewrite Plugin and Binlog for Replication
(Mario Beck) Starting with MySQL 5.7 we introduced the Query Rewrite Plugin. That tool is really useful for changing queries. Of course the best location to modify the query is the source code of the application, but this is not always possible.
Understanding Percona XtraDB Cluster threading model
(Krunal Bauskar) In this blog, we’ll discuss how the Percona XtraDB Cluster threading model works.
In Search of a Regex Replace Function for MySQL
(Rob Gravelle) One of my favorite TV shows as a boy was In Search of…, hosted by the late great Leonard Nimoy. Every week he would explore some unusual natural phenomena or paranormal occurrence. It never failed to stoke the fires of my imagination! Fast forward to 2016, and I now found myself o
Time Zone Conversion in MySQL
(Ike Walker) A wise man once said that the safest way to store date and time values in MySQL is to store Unix timestamps in an unsigned INT column. I agree with Baron, but most of us have to deal with DATE, DATETIME, and/or TIMESTAMP values sometimes, and it’s often useful to know how to convert val
