HTI Technology specializes in database consulting. It has been more than 10 years dedicated to this topic, doing research, collaborating with the source code in RDBMS MySQL and encouraging related communities and forums. 

In our client portfolio stands out the biggest users of MySQL in Latin America. It is a very diverse group, with companies/institutions of all sizes, from the government and private sector. 

Our team has the most celebrated consultants in MySQL ecosystem in Portuguese, as well as associate consultants in countries like Argentina, Venezuela, Colombia and the United States. Therefore, we can offer the highest quality consulting in: Portuguese, Spanish and English. All our consultants have over 5 years experience in MySQL, they also teach the official training courses, some participate in the creation of official MySQL material, and currently collaborate on documenting MariaDB, and the creation of official material and the certification program.  

No matter the kind or size of your company, the complexity of the problem, or your requirements, we surely have the answer you need.   

Among our main consulting services, we can highlight: 

Performance Tuning: These are fine adjustments exclusively made in the MySQL server configuration and the operating system. MySQL/MariaDB has an intricate web of configuration variables. It takes great theoretical and practical experience to its correct adjustment. From the analysis of your server load, most common type of operation, among other factors, we can determine what are the best adjustments for each variable. It is important to highlight, there is no magic configuration, and it is often necessary to go beyond adjusting variables to get a really high performance environment.

Schema Review: It is a comprehensive analysis of your database design (or a particular set of tables). It is a delicate work that will follow the best practices for modeling database. Determining the best choice of data type that will provide further optimization of columns. Table normalization and/or denormalization. Index strategy. Choice and suitability of storage engines.  

Replication Review: Replication is a distinctive and powerful MySQL feature and has simple implementation. However, this simplicity leads many DBA´s to disregard some details that can generate implementation errors. Our work here may be twofold: implementing replication or review all the existing architecture. We can create highly scalable, redundant environments, which can bring benefits such as contingency, online backup, performance and robustness, besides following the best practices and uses. 

Query Review: You tell us about a set of queries to be validated / improved before its entry into production, or those that are considered problematic. We can examine all the queries executed on your server and find those that take more resources than necessary. In short, no matter how they are acquired / informed, the work here involves applying the best practices in writing SQL sentences always looking for: the best performance, the possibility of the greatest possible competition and no locks. Among the techniques used, we can mention: applying specific MySQL hints, using indexes (b-tree,b+tree, rtree, hash, fulltext), implementation and optimization of caches & buffers, setting the optimizer, pre-compilation of queries, using events & summarized tables.               

Partitioning Review: Horizontal partitioning of tables can be something great to divide large tables into smaller physical files. The idea behind this concept is to generate sub tables, transparent for application but recognized by the RDBMS. In this manner, we intend to achieve greater performance, and solve other issues related to the operating system. However, it can become a major headache, if the concept of partitioning implemented by MySQl is not understood. In this type of consulting, we will implement the best partitioning techniques and use the appropriate strategies to make the most of MySQL pruning, increasing your queries performance. Partition maintenance strategies, choosing the best partition factor, indexing, storage engine, etc.     

CCR Customer Code Review: It is a trend that business rules and / or complex routines / functions are delegated to the database in the form of procedures, functions, triggers and events. It is commonly believed that routines that ran well on another RDBMS will also do it in MySQL, and therefore don´t need review…but not quite. We can create store routines based on requirement analysis, improve the existing ones or even rewrite them.  

Server Extensions: MySQL, among many unique features, allows plugins and extensions being added to the Server. Among these extensions we can mention new (or new versions) of storage engines, fulltext parsers and other features that change the behavior of MySQL server. We can assist you in choosing, installing and using these plugins. 

UDF Review: MySQL allows you to create your own functions in C++. These functions can be inserted into the MySQL core to be used by your applications as if they were native RDBMS functions. We can help you create these functions that can translate into greater power and flexibility for your applications.      

SCR Server Code Review: HTI, along with Monty Program, PERCON and OPENQUERY, stands out among the few select companies in the world to offer this kind of consulting, and, indeed, unique in Latin America. Due to our experience in code contribution to MySQL community and now for MariaDB, we have a team of consultants who can perform customizations in MySQL source code or MariaDB, in order to deliver new features or ultimately apply patches. 

Rock Start!: or jump start is nothing more than getting to know your need for RDBMS, and thereafter, scale the most appropriate hardware and operating system. The MySQL server will be chosen from among the various flavors and platforms available, and if it is necessary compiled with a series of parameters that best suit your needs. A general tuning range is run as a bonus. In this consulting are considered other MySQL distributions that can bring more appropriated resources to the type of operation that your application will require from your RDBMS. 

High Availability: High availability is a legitimate need for mission critical applications. And, in our service, high availability is not only being on air as long as possible, but it also includes a high volume of data delivery. Does your database demand high levels of uptime with SLA from 99.99% to 99.9999%? Low impact on the application of preventing and corrective maintenances and backups? High volume of data delivery? Whatever your need for high availability is, we have the solution:

• Active Active Cluster 
• Active Passive Cluster 
• MySQL Cluster
• DRDB
• Memcached
• Continuent Uni/Tungsten
• Replication Multi-Master  

Data Migration: Changing database? Distributing applications among multiple databases? We have the means to help you migrate data among MySQL, MariaDB, Drizzle, Oracle, PostgreSQL, Informix, MS-SQL (SQL Server), DB2, Sybase, Access, Dbase, etc. 

Transaction Review: Do you know the concept ACID? Are its applications really transactional? What isolation level is more appropriate for your transaction? What is the ideal time to wait for a locked row (record)? How to identify locked rows by other sessions? Is the used storage engine the best option for the transaction? How to take advantage of MySQL transactional characteristics? Do you need simultaneous multimodal transaction among different databases, for instance, start the same transaction in Oracle and MySQL? We can review your source code and pass on all the necessary knowledge so your applications can work with transactions safely and effectively.