(Marco Tusa) This article is the spin-off of the article How ProxySQL deal with schema (and schemaname)
Tag: Open Source
LDAP with auth_pam and PHP to authenticate against MySQL
(Sheeri K. Cabral) In the quest to secure MySQL as well as ease the number of complicated passwords to remember, many organizations are looking into external authentication, especially using LDAP. For free and open source, Percona’s PAM authentication plugin is the standard option.
Docker Secrets and MySQL Password Management
(Trond Humborstad) In this posting we will look at currently recommended ways of managing passwords in MySQL Docker containers and explore whether the recently introduced concept of Docker Secrets could play a role in this area.
More on Studying MySQL Hashes in gdb, and How P_S Code May Help
(Valeriy Kravchuk) I have to get back to the topic of checking user variables in gdb to clarify few more details. In his comment Shane Bester kindly noted that calling functions defined in MySQL code is not going to work when core dump is studied.
A complete MySQL monitoring system with early-warning mechanisms: Liam Terblanche, CTO, Airvantage
(ravikiran.iyengar) Airvantage is a Value Added Service Provider for mobile telecommunication networks. Airvantage offers various gaming platforms, and subscriber retention initiatives like emergency airtime, mobile money integration, etc.
Handy JSON to MySQL Loading Script
(Dave Stokes) So how do you load that JSON data file into MySQL. Recently I had this question presented to me and I thought I would share a handy script I use to do such work. For this example I will use the US Zip (postal) codes from JSONAR.
How to Configure Aurora RDS Parameters
(Nik Vyzas) In this blog post, we’ll look at some tips on how to configure Aurora RDS parameters.
An Adventure in InnoDB Table Compression (for read-only tables)
(Jean-François Gagné) In my last post about big MySQL deployments, I am quickly mentioning that InnoDB compression is allowing dividing disk usage by about 4.3 on a 200+ TiB dataset. In this post, I will give more information about this specific use case of InnoDB table compression and I will share
MySQL Group Replication: read your own write across the group
(Frederic Descamps) Today is my last day in Asia (China and Taiwan), and between the sessions I had the time to code a small proof-of-concept for people that are asking how they could read their writes on all nodes and ensure the read consistency with their last write ?
ProxySQL and MySQL 8.0.2 (la suite)
(Frederic Descamps) Recently I wrote a blog post on how to use ProxySQL with 8.0.2 dmr
