Experience of implementation of the projects based on MySQL

Versions of MySQL DBMS: 3.x, 4.x, 5.x.

Design of DB model and business-processes:

  • Design tools: Sybase PowerDesigner, Erwin, Rational Rose.
  • Design experience: DB model contains more than 200 tables with wide range of records stored, starting from hundreds and ending with millions.

DB-side design of business logic:

  • Programming languages: SQL with specific MySQL extensions
  • Usage of stored procedures, triggers, views and other features for implementation of db-layer business logic object. Vast experience in SQL-queries optimization.
  • Technologies:
    • FULL-TEXT search support;
    • MERGE table types - is used to reach the best performance;
    • MySQL clustering;
    • Native SSL support.
  • Administering:
    • Installation of DB MySQL and other components to Linux and Windows platforms;
    • Initial data filling, using export/import, data pump utilities;
    • DB monitoring. Settings and recommendations for improving of its performance;
    • DB cloning;
    • DB backup and restoring;
    • Server hardware settings;
    • Data privacy and security-related issues.
  • Additional info:
    • Experience in DB remote installation and maintenance;
    • Experience in managing of large data bulks;
    • Experience in adjusting and applying systems to various business areas.