Optimizing MySQL and MariaDB Environments with Pure Storage

Organizations that use MySQL or MariaDB databases for business-critical functions may struggle with direct attached storage (DAS) limitations for these deployments. Typically these platforms can accelerate access to data, increase business agility, and deliver business breakthroughs.

However, sometimes several roadblocks can stump businesses that want to improve outcomes, speed up decisions, and reduce complexity.

DBTA held a webinar featuring Ron Ekins, principal solutions architect, Pure Storage and Nihal Mirashi, principal product marketing manager, Pure Storage who discussed successful strategies in overcoming common MySQL/MariaDB issues.

Ekins recommended architecting for reporting and data protection rather than performance. Storage arrays used to be about Size and IOPS, it’s now speed.

All-Flash-Arrays provide consistent sub-millisecond latencies. Increase MySQL and MariaDB read scale with DirectMemory Cache.

Enable developers to work on secure, full size, high fidelity data sets, according to Ekins and Mirashi. Enable Self Service database through use of REST API’s.

Perform on-demand and scheduled snapshots without being blocked by parent child constraints. And use public Pure REST API’s with your preferred DevOps tools.

The SafeMode protection of Snapshots protects backup data sets and metadata. This feature included at no charge with FlashBlade and FlashArray.

Snapshots created and expired by policy Policies are modified only by an authorized company designee working with Pure support.

Businesses can also use the MYSQL Operator for Kubernetes. It is an operator for Kubernetes managing MySQL InnoDB Cluster setups inside a Kubernetes Cluster.

The MySQL Operator manages the full lifecycle with setup and maintenance including automation of upgrades and backup, they said.

An archived on-demand replay of this webinar is available here.