FrenchTech SAAS

MySQL has a pluggable storage engine architecture that allows users to select the best storage engine for their application and workload. While InnoDB is the most popular storage engine, some users have had to rely on MyISAM for its full text search capabilities, and in some cases, better performance in applications that didn't require transactional capabilities. With the release of MySQL 5.6, those reasons are now gone: MySQL offers native support for full-text search in InnoDB along with significant performance improvements.

This technical presentation reviews some of InnoDB's new features, including Full Text search, and InnoDB’s performance improvements. It will also show you how to migrate your applications and data from MyISAM to InnoDB. Topics include

Portability of InnoDB files (individual .idb files and the Undo log)
Performance improvements with InnoDB Read-only transactions
Impact of changes to InnoDB page size
InnoDB Full Text Search

In this paper we will visually show you how to connect MySQL into some of the existing tools that the SQL Server DBA will already be familiar with. Specifically in this paper we will look at how configure connectivity to MySQL with your existing reporting infrastructure based on SQL Server 2008 Reporting Services.

The relational data model relies on rigid adherence to a database schema, normalization of data and joins to store data and perform complex queries. Over the last 40 years, relational modeling and query techniques have been well established and are familiar to most application developers. But changes in application, user and infrastructure characteristics have led application developers and architects to seek alternative “NoSQL” (non-relational) database technologies.This white paper highlights the differences between a relational database and a distributed document-oriented database, the implications for application development, and guidance that can ease the transition from relational to NoSQL database technology.

Don’t take your data at face value. That is the key message of this tutorial which focuses on how scholars can diagnose and act upon the accuracy of data. In this lesson, you will learn the principles and practice of data cleaning, as well as how OpenRefine can be used to perform four essential tasks that will help you to clean your data:

Remove duplicate records
Separate multiple values contained in the same field
Analyse the distribution of values throughout a data set
Group together different representations of the same reality

This whitepaper provides a guided tour through the key features and enhancements and provides examples and resources for drilling into the complete technical and implementation details.   By reading you will gain an understanding of what sets MySQL 5.6 apart and ahead of earlier releases:

Better Performance and Scalability
Improved InnoDB storage engine for better transactional throughput
Improved Optimizer for better query execution times and diagnostics
Better Application Availability with Online DDL/Schema operations
Better Developer Agility with NoSQL Access via Memcached API to InnoDB
Improved Replication for high performance and self-healing cluster deployments
Improved Performance Schema for better instrumentation and monitoring
Improved Security for worry-free application deployments
And other important enhancements
This paper highlights the key new features in each of these areas, many with practical use case examples.  To conclude, there is a summary of how MySQL 5.6 can be implemented using best practices comprising production-ready software, support and services of the MySQL Enterprise Edition offering.

In early 2009 we conducted our annual survey and what we found is that 66% percent of those surveyed used Windows for development and 48% ultimately deployed into production on Windows. Given that so many users deploy MySQL on Windows for production, it makes sense to recap how easy it is to work with data in MySQL and Microsoft Excel. With the power of the SQL language and MySQL’s RDBMs capabilities, it allows users to leverage the data so that it can be shared by multiple users concurrently, in a more secure, and manageable manner through a variety of interfaces and front ends. For the purposes of this guide we will show you how easy it is to import and export data from MySQL and Excel using MySQL’s ODBC Connector in conjunction with Excel 2007 and Access 2007’s native import/export capabilities.

MySQL and MariaDB are relational databases used in many unique situations. However, they can pose a security risk for your system and your data if you do not secure them properly. This guide will introduce some basic considerations and steps you can t