Consulting Training Blog Careers About Us Contact Us

MySQL Consulting

Discuss Project

Intertech delivers expert consulting on MySQL.  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

Free One Hour Discovery Call?

Learn More About the Intertech Consulting Team

Free Resources

5 Common Mistakes on Software Engineering

Guide to Selecting & Working with an IT Consulting Firm

Guide to Becoming a Full Stack Developer

Meet Our Dev Center

Making any outsourced project work affordable

Recent Case Studies

Beef Feedlot Management Application

Remote Troubleshooting Using Raspberry Pi

Integration of Systems and Applications After Merger

Free One Hour Discovery Call?

Testimonials

Intertech impresses me as a company. I would recommend the individuals I have worked with and indeed the company as a whole because one can tell the results we have gotten are a combination of the company’s culture and the individuals capabilities.

Brian B