651.288.7000 info@intertech.com

Intertech MySQL Consulting

Intertech delivers expert consulting on MySQL. Whether installing, configuring, or optimizing MySQL on Unix and Windows, we take you from startup to finish!

Our professionals help you:

        • Install, configure, and optimize MySQL on Unix and Windows from startup options to tuning the server using system variables to configuring the MyISAM and Falcon storage engines
        • Understand and optimize access MySQL from C, Perl, and PHP including compiling, linking, connecting to the server, handling errors, processing SQL statements and results sets, specifying connection parameters, and debugging
        • Administer MySQL including understand the MySQL Data Directory, the operating system constraints on database object names, factors that affect max table size, and the data directory for system performance
        • Understand internationalization and localization issues including configuring time zone support, selecting the language for error messages, and configuring the character set
        • Manage security including setup of access control and security, securing the install, preventing unauthorized network access, and use of the MySQL grant tables
        • Maintain logs including error, general query, slow query, relay, and binary
        • Understand MySQL syntax, naming rules, character set support, and creating, dropping, and altering databases and tables
        • Understand MySQL metadata
        • Select data across multiple tables via joins and unions
        • Implement transactions including savepoints and transaction isolation
        • Maintain referential integrity with foreign keys
        • Optimize and execute full text searches
        • Understand the MySQL data types including numeric, string, date, time, spatial, Boolean, null, and type conversion
        • Work with sequences including use of AUTO_INCREMENT
        • Implement stored programs including compound statements, stored functions, stored procedures, triggers, events, and security for stored programs
        • Optimize queries with indexes and leveraging the MySQL Query Optimizer with a focus on efficiently loading data, changing statement scheduling priorities, using delayed and concurrent inserts, using correct locking levels, and administrative level optimization
        • Outline a backup and maintenance strategy
        • Troubleshoot MySQL performance issues

    For more information, contact us today.