Experience of implementation of the projects based on MySQL

Versions of MySQL we use: 4.x, 5.x.

Design of DB model:

• Design tools: EMS SQL Manager for MySQL, Sybase PowerDesigner, Erwin, Rational Rose.
• Design experience: DB models that contain more than 200 tables with huge number of stored records starting from hundreds and ending with millions, foreign keys, views, triggers and stored procedures.

DB-side design of business logic:

• Great experience in optimization of SQL queries and indexes.
• MySQL greatest features:
  • FULLTEXT search;
  • MERGE table type;
  • MySQL clustering;
  • MySQL replication;
  • Native SSL support;
• Administering:
  • Installation and maintenance of MySQL and related components to Linux and Windows platforms;
  • DB cloning, backup and restoring, upgrade;
  • DB migration from one server to another using export/import, data pump utilities;
  • MySQL status monitoring;
  • MySQL server tuning and recommendations for improving of its performance;
  • Suggestions in choose of server hardware;
  • Data privacy and security-related issues solving;
  • Experience in support and maintenance of large databases (50+ Gb);