(Marcelo Altmann) In this post, I will cover a bit of ProxySQL. ProxySQL is a proxy which implements MySQL protocol, allowing it to do things that other proxies cannot do.
Tag: Open Source
Monitor Critical Databases Confidently with the Sensitive Data Vault
(Samantha Toet) Building extremely deep monitoring as a SaaS product has a drawback: we capture too much data for some customers’ compliance requirements
MySQL Cluster 7.6GA in the Cloud: the RPM/YUM platform
(Tonci Grgin) In this series of blogs I will do my best to demonstrate how to set up and run Cluster in Cloud environment by hand and by utilizing MCC.
Creating Your Own Spatial Reference Systems 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). And if for some reason that isn’t enough, we can create our own.
How to Recover Galera Cluster or MySQL Replication from Split Brain Syndrome
(Krzysztof Ksiazek) You may have heard about the term “split brain”. What it is? How does it affect your clusters? In this blog post we will discuss what exactly it is, what danger it may pose to your database, how we can prevent it, and if everything goes wrong, how to recover from it.
Don’t Drown in your Data Lake
(Rick Golba) A data lake is “…a method of storing data within a system or repository, in its natural format, that facilitates the collocation of data in various schemata and structural forms…”1.
MySQL 8.0 InnoDB Cluster – Creating a sandbox and testing MySQL Shell, Router and Group Replication
(Tony Darnell) MySQL InnoDB cluster provides a complete high availability solution for MySQL. MySQL Shell includes AdminAPI which enables you to easily configure and administer a group of at least three MySQL server instances to function as an InnoDB cluster.
The Best (and Worst) Cloud Services for MySQL
(Rob Gravelle) Each and every day, new cloud-based database providers are cropping up to meet the demands of Big Data.
Upgrading Spatial Indexes to MySQL 8.0
(Norvald H. Ryeng) MySQL has had spatial indexes for many years, but they have all been Cartesian (X and Y coordinates) indexes. MySQL 8.0 adds support for geographic (latitude-longitude) indexes.
Debugging MySQL On Docker
(Fernando Ipar) In a recent post, my colleague and teammate Peter Sylvester explained how we could customize MySQL’s configuration when running it as a Docker container.