Main application: InnoDB’s Full Text Search overview (with Shiny/R)
Credits Author: Emanuel Calvo
Company: Pythian
Thanks to Valerie Parham-Thompson @ Pythian and Daniel Prince @ Oracle.
Repository available at Github.
For the whole article and the Shinyapp application is available here.
Some initial thoughts A couple of days ago one of our customers came up with a question regarding FTS over InnoDB engine. Although the question is not answered in the current article, I came up with the conclusion that FTS is sometimes misunderstood.
Problem description Some systems have a bug that makes xbstream fail to create the destination directory, you need to force its creation. This is the reason, that in this post, I’ll be adding extra steps prior to open the xbstream process.
xtrabackup_56: Error writing file 'UNOPENED' (Errcode: 32 - Broken pipe) xb_stream_write_data() failed. Update: it’s been long time since new versions haven’t been tested by me, so this bug might be fixed as of now.
Sponsored: Pythian Inc.
Note 1: All the of this presentation is published in this repository. You will find a lot of folders and information, probably part of a blog series.
Note 2: All the work on this article is a POC (Proof of concept).
Note 3: This is something that is related for HIPAA compliant.
KMS/RDS The POC on this article was developed before the releasing of the Key Management service for RDS.