Acceleration and Protection of MySQL

Unload, Load, Reorg, Query, Masking and Test

Overview
Cassandra
DB2 UDB
MongoDB
MySQL/MariaDB
Oracle
PostgreSQL
SAP HANA
Snowflake
SQL Server
Sybase
Teradata
Challenges

You may face one or more of these time-consuming problems when working with MySQL:

· Data Discovery: Profiling, Classification, ERDs

· Loading and unloading large tables

· Routine maintenance operations (Reorgs)

Complex queries

Migration or replication

- Masking sensitive data

- Generation of intelligent and secure test data

Also, specific performance diagnostics and tuning also take time and can affect other users. Finally, stored SQL procedures can also be programmed inefficiently, require optimization, and still take too long.

Solutions

IRI FACT (Fast Extract) to speed up MySQL dumps. Use the SQL syntax in FACT's CLI or GUI, to transfer table data to flat files.

Provide SELECT * from the table so that you do not burden the unload with qualifiers like „distinct“, „order by“, and „group by“. But once these data are in the flat file, use the program SortCL in IRI CoSort, to deduplicate, sort, merge, group (and report on) the extracts much faster... in parallel, outside the database.

IRI CoSort to pre-sort flat files for mass BCP import.

First, create the clustered index and pre-sort the input files (on the primary index key) to shorten the index creation step. Use the „SORTED_DATA“ option when creating indexes to show that CoSort bypassed the slower sorting in bcp.

Offline Reorg Wizard in the IRI Workbench, to combine and automate the combination of the above-mentioned fast extraction, sorting, and reloading operations for classic (offline) MySQL reorgs, simplifying the maintenance of your tables in optimal query order.

IRI CoSort to relieve the database of processing overhead. Utilize the advantages of file system I/O, multithreading, and the proven data transformation power and consolidation of the CoSort SortCL program.

IRI NextForm–Database edition for capturing, remapping, reformatting, and creating/populating new tables during migrations to and from MySQL. You can also use IRI NextForm or the SortCL program in IRI CoSort to remap and convert data in MySQL., Customized reports, Copies and Federated views of data.

IRI FieldShield To mask sensitive data in MySQL, such as Personally Identifiable Information (PII) or Protected Health Information (PHI), FieldShield applies masking, encryption, and other de-identification features to one or more columns simultaneously. Use FieldShield to comply with privacy laws such as HIPAA, PCI DSS, FERPA, and GDPR.

IRI RowGen Quickly populate MySQL operations with secure test data. RowGen uses your data models to automatically generate test data for an entire database with referential integrity.