(Robert Neumayer) Any software system requires secrets to run, be it credentials to communicate with databases, tokens to access resources, or encryption keys that need to be distributed.
Tag: Open Source
MySQL master discovery methods, part 1: DNS
(Shlomi Noach) This is the first in a series of posts reviewing methods for MySQL master discovery: the means by which an application connects to the master of a replication tree. Moreover, the means by which, upon master failover, it identifies and connects to the newly promoted master.
Axis Order in Spatial Reference Systems
(Norvald H. Ryeng) MySQL 8.0 has many new GIS features, including a catalog of spatial reference systems (SRSs) and support for geographic (latitude-longitude) computations.
ProxySQL Query Rewrite Use Case
(Alkin Tezuysal) In this blog post, I’m going to revisit the ProxySQL Query Rewrite feature. You may have seen me talking about possible use case scenarios in the past few conferences, but the reason I’m starting with this is that query rewriting was the original intention for building ProxySQL.
How to Overcome Accidental Data Deletion in MySQL & MariaDB
(Krzysztof Ksiazek) Someone accidently deleted part of the database. Someone forgot to include a WHERE clause in a DELETE query, or they dropped the wrong table. Things like that may and will happen, it is inevitable and human. But the impact can be disastrous.
Geography in MySQL 8.0
(Norvald H. Ryeng) MySQL 8.0.11 comes with a catalog of 5108 spatial reference systems (SRSs): 4628 projections (flat maps), 479 geographic (ellipsoidal) representations of Earth, and one Cartesian all-purpose abstract plane (SRID 0).
Authenticating Vault Against LDAP For Accessing MySQL Through ProxySQL
(Valerie Parham-Thompson) Earlier this year, I was presented with the challenge of streamlining user access to MySQL, allowing users self-serve access using their LDAP credentials, while logging all access.
Linux configuration for MySQL Cluster
(Mikael Ronström) NDB Cluster was designed from the ground up for real-time operations. It has its origins in the telecom industry where predictability of performance and latency is absolutely critical. In addition the telecom vendors are competing very much on pricing of their product.
Keep Sensitive Data Secure in a Replication Setup
(Nickolay Ihalainen) This blog post describes how to keep sensitive data secure on slave servers in a MySQL async replication setup.
Spatial Reference Systems in MySQL 8.0
(Norvald H. Ryeng) MySQL 8.0 brings a lot of new spatial features. The main feature is the support for multiple spatial reference systems (SRSs).