TruTek: The Oracle Experts
OAUG: Oracle Application Users Group UTOUG: Utah Oracle Users Group

TruTek's Remote Services for MySQL

The MySQL database server is the world's most popular open source database. Its architecture makes it extremely fast and easy to customize. Extensive reuse of code within the software and a minimalistic approach to producing functionally-rich features has resulted in a database management system unmatched in speed, compactness, stability and ease of deployment. The unique separation of the core server from the storage engine makes it possible to run with strict transaction control or with ultra-fast transactionless disk access, whichever is most appropriate for the situation.

MySQL 4.1, the latest certified production-ready release includes numerous enhancements that improve performance, internationalization, and the ability to embed the MySQL Server with other hardware and software solutions. Major enhancements include:

  • Subqueries, allowing users to search complex data sets with greater ease and efficiency.
  • A significantly faster and more flexible client-server protocol with support for prepared statements, providing faster query execution and improved warning information.
  • A more highly optimized MySQL server library with a smaller memory footprint that performs significantly faster when embedded in third-party software.
  • Unicode, through the UCS2 and UTF8 international character sets, making it easier to store and manage internationalized data;
  • Industry-standard GIS data types which can be used to do efficient searches in maps and other geographic data.

When coupled with Continuent's m/cluster, which provides on-disk clustering for MySQL, TruTek can deploy a fault-tolerant, high-performing backend for MySQL 4.1 and 5.0 data-driven solutions.