Section 15. Other MySQL Enterprise Services Defined

• 15.1 Custom MySQL Builds
• 15.2 Technical Alerts Advisor
• 15.3 Update Advisor
• 15.4 Knowledge Base
• 15.5 Remote Troubleshooting
• 15.6 Replication Review
• 15.7 Schema Review
• 15.8 Query Review
• 15.9 Performance Tuning
• 15.10 Customer Code Review: Client APIs
• 15.11 Customer Code Review: User Defined Functions
• 15.12 Customer Code Review: Server Extensions
• 15.13 Customer Code Review: Stored Routines (Triggers, Procedures, Functions)
• 15.14 Replication Review

Return to table of contents

15.1 Custom MySQL Builds

This service includes the creation of binaries that we compile to your custom specifications, as most suited for your hardware, operating system, or optimized performance needs.

Back to top
 

15.2 Technical Alerts Advisor

The MySQL Enterprise Monitor Technical Alerts Advisor notifies you in the event of bugs, updates, or security vulnerabilities whether they are related to MySQL or certain other elements in our customer's infrastructure that could impact MySQL. This service is currently only available in English.

Back to top
 

15.3 Update Advisor

The MySQL Enterprise Monitor Update Advisor notifies you of new versions that are most appropriate for your environment. This service is currently only available in English.

Back to top
 

15.4 Knowledge Base

The MySQL Knowledge Base provides a self serviced web based comprehensive library of technical articles resolving difficult problems on popular database topics such as performance, replication, and migration. This is the primary entry point for support costumers to get quick help on their issues and questions. Articles are primarily available in English, however, a large portion are also available in Japanese.

Back to top
 

15.5 Remote Troubleshooting

Sometimes you want a MySQL expert to log in to your servers and handle a task directly. MySQL Support Engineers can connect to your servers remotely and:

• Perform Installations and Upgrades for supported software and related systems
• Analyze and Alter Server Configuration
• Diagnose Performance or Stability Concerns
• Gather System and Server Statistics and Information

Back to top
 

15.6 Replication Review

Whether you use replication as part of a scale out strategy or for providing redundancy for your database servers or simply for making backups, MySQL Support Engineers can review your proposed replication architecture or existing implementation and configuration and recommend or identify:

• Potential flaws in your configuration or architecture
• Possible performance enhancements for different use cases
• Strategies to make better use of your replication implementation
• Alternative implementations

Back to top
 

15.7 Schema Review

If you need to verify some of your table designs or indexing strategies, MySQL Support Engineers can review portions of your schema and recommend or identify:

• Candidates for Improved Normalization
• Candidates for Improved Denormalization
• Optimal Indexing Strategy
• Optimal Column Types
• Optimal Storage Engine

This can include the creation of original or sample schemas intended to demonstrate techniques for solving particular problems.

Back to top
 

15.8 Query Review

If you have a problem query that consumes too many resources or does not have the performance that you need, MySQL Support Engineers can review your query and recommend or identify:

• Improvements to Query Structure and Form
• Indexing Improvements
• Alternative Queries
• Options to Make Better Use of MySQL Internals
• Options to Make Better Use of MySQL-Specific Features

This can include the creation of original queries or sample queries intended to demonstrate techniques for solving particular problems.

Back to top
 

15.9 Performance Tuning

If you would like expert advice on platform selection and server configuration targeting your unique usage patterns, MySQL Support Engineers can review your server configuration and system information and recommend or identify:

• Opportunities to Improve Performance
• Server and OS Configuration Changes
• Platform/Hardware Selection for Optimal Performance

Back to top
 

15.10 Customer Code Review: Client APIs

Whether your application uses one of the MySQL Connectors such as Connector/ODBC or Connector/JDBC, or one of the client APIs such as the C API, PHP, Python "MySQLdb" or Perl DBI, MySQL Support Engineers can review your usage of the MySQL APIs and recommend or identify:

• Best Practices
• Code Correctness
• Solutions to Common Problems
• Alternative Implementations
• Enhanced Connection Robustness

Back to top
 

15.11 Customer Code Review: User Defined Functions

MySQL Enterprise Server software allows you to create your own C++ user-defined functions. MySQL Support Engineers can review your UDF and recommend or identify:

• Best Practices
• Code Correctness
• Solutions to Common Problems
• Alternative Implementations

Back to top
 

15.12 Customer Code Review: Server Extensions

MySQL Enterprise Server allows you to extend the server in a variety of ways, including custom storage engines, custom full-text parsers or direct modifications of server behavior itself. MySQL Support Engineers will work with you to review your extensions and recommend or identify:

• Best Practices
• Code Correctness
• Solutions to Common Problems
• Alternative Implementations

Back to top
 

15.13 Customer Code Review: Stored Routines (Triggers, Procedures, Functions)

If you place your complex business logic in MySQL Enterprise Server stored routines such as stored procedures, triggers or stored functions, you may benefit from a review by the MySQL Support Engineers who can recommend or identify:

• Best Practices
• Code Correctness
• Solutions to Common Problems
• Alternative Implementations

This can include the creation of original or sample routines intended to demonstrate techniques for solving particular problems.

Back to top
 

15.14 Replication Review

Whether you are using partitioning to enhance query performance, distribute I/O across storage devices, facilitate backups or simplify the maintenance of historical data, MySQL Support Engineers can review your existing or proposed implementation and recommend:

• Alternative partitioning functions and techniques
• Strategies for making better use of partition pruning
• Techniques for partition maintenance relevant to your environment
• Different types of partition and subpartition organization

Back to top