Disaster Recovery for MySQL with FlashArray

MySQL and MariaDB

Audience: Public
Source Type: Documentation

MySQL and MariaDB
Data Protection and Copy Data Management
Creating Volume Snapshots for MySQL on FlashArray
Matching MySQL Directories to FlashArray Volumes
Finding MySQL Directories
Matching MySQL Directories to Mounted File System(s)
Match the File System(s) to FlashArray Volume(s)
Creating Storage Snapshots for MySQL
Disaster Recovery for MySQL with FlashArray
Recovering MySQL From FlashArray Volume Snapshots
Recovery Process
Step 1. Stop the MySQL Instance
Step 2. Unmount the Volume
Step 3. Recover the Volume Snapshot
Step 4. Mount the volume
Step 5. Start the MySQL Instance
Recovery for Data, Transaction, and Binary Logs on Separate Volumes
Recovery for Databases/schema on a Separate Volume
High Availability
High Availability for MySQL with FlashArray
MariaDB - Getting Started
InnoDB Configuration Parameters
InnoDB Configuration Parameters
MySQL option file examples
MariaDB on FlashArray Implementation and Best Practices
Hardware Environment Requirements
Recommended Configuration for MariaDB on FlashArray
Operating System Requirements
File System layout and configuration
Server System Variables
MySQL - Getting Started
Configuring MySQL on AWS Outposts With FlashArray
Network Configuration
EC2 Instance Configuration
Deploy EC2 Instance
Configure EC2 Instance for iSCSI Connectivity and Connect to FlashArray
MySQL Database Deployment
InnoDB Configuration Parameters
InnoDB Configuration Parameters
MySQL option file examples
Linux
Microsoft Windows
MySQL Cluster On FlashArray Implementation and Best Practices
Implementing MySQL Cluster on FlashArray
Installing MySQL Cluster
Prepare Storage for MySQL Cluster
Initial MySQL Cluster Configuration
Initial Startup of the MySQL Cluster
MySQL on FlashArray Implementation and Best Practices
Hardware Environment Requirements
Recommended Configuration for MySQL on FlashArray
Operating System Requirements
File System Configuration
Volume and File System Architectural Layout
Server System Variables
Optimizing SQL Server Operations and Scale with Everpure
Optimizing SQL Server Operations and Scale Introduction
Optimizing SQL Server Operations and Scale Technology Overview
Optimizing SQL Server Operations and Scale Technical Solution Design
T-SQL Backups Using FlashBlade for File or Object Storage
Database Copies for Development, Testing, or Analysis Using FlashArray Snapshots
Data Protection Using Storage Snapshots on FlashArray or Everpure Cloud Dedicated
High Availability for SQL Server Using ActiveCluster
Near-synchronous Replication for SQL Server with ActiveDR
SQL Server with Everpure Design Validation and Benchmarking
SQL Server Deployment with FlashArray
Software Replication
Galera Cluster - Cloning Node From Volume Snapshot
Using FlashArray Volume Snapshots as a State Snapshot Transfer method
Step 1. Create a Volume Snapshot of the Donor Volume
Step 2. Copy the Volume Snapshot to an Existing Volume Attached to the Replica
Step 3. Mount the Volume on the Joiner and Configure the Cluster Properties
Step 4. Start the Joiner Node and Ensure it has Joined the Cluster Successfully

You can download the PDF file here.

Back to home page