|
Archived MySQL Articles
|
30 Apr 2012
|
Connecting MEB and MMS through System Backup to Tape Interface [26156]
Oracle White Paper on MySQL Enterprise Backup (MEB) and Media Management System (MMS)
The Oracle white paper "Connecting MySQL Enterprise Backup (MEB) and Media Management System (MMS) through System Backup to Tape (SBT) Interface" describes the use of MySQL Enterprise Backup with Media Management software through System Backup to Tape interface. The white paper addresses the numerous potential issues that can arise in the course of planning for backups. Without proper guidance the further complexity inherent in using the Oracle database, MySQL, and other databases can present difficulties that can be resolved by the use of a single tool to ensure consistency of backup policy. Registration and log in are required.
(Get More Information . .)
|
|
|
|
17 Apr 2012
|
New MySQL 5.6 Development Milestone Release [26019]
Delivers new replication features
Oracle has released MySQL 5.6, focusing on improved availability, performance and manageability for web, cloud and embedded applications. Oracle is simultaneously providing early access to features under development for community testing and feedback. These include online operations for ADD index and NoSQL access to InnoDB via the Memcached protocol. The new MySQL 5.6 delivers enhanced high availability with new replication features; new optimizer features for better throughput of complex queries; and an improved PERFORMANCE_SCHEMA. Oracle also seeks feedback on these features: online Operations for ADD Index; high performance NoSQL access to InnoDB from Memcached; and performance improvements on modern hardware.
(Get More Information . .)
|
|
17 Apr 2012
|
MySQL Workbench 5.2.39 Released to GA [26021]
Includes Data Modeling, New Query and Administation Features
MySQL Workbench 5.2.39 has been released to General Availability. This is a maintenance release that contains MySQL Utilities 1.0.5, a set of command line Python utilities for helping to perform and script various administration tasks for MySQL. In this release one will find Data Modeling; Query, which replaces the old MySQL Query Browser; and Administration, which replaces the old MySQL Administrator. Version 5.2 also features improved stability and performance especially in Windows, where OpenGL support has been enhanced and the UI was optimized to offer better responsiveness. The release also includes improvements to the scripting capabilities of the SQL Editor.
(Get More Information . .)
|
|
11 Apr 2012
|
Benchmarking MySQL Replication with Multi-Threaded Slaves [25964]
Multi-Threaded Slaves Delivers 5x Higher Replication Performance when Configured with 10 Databases/schemas
In his post "Benchmarking MySQL Replication with Multi-threaded Slaves" Mat Keep measures performance improvements achieved when enabling the Multi-Threaded Slave enhancement feature of MySQL 5.6. His apparatus included two Linux servers, one running the replication master, the other running the replication slave. Multi-threaded slaves deliver ~5x higher replication performance when configured with 10 worker threads, with the load evenly distributed across the 10 x schemas. The configuration does not scale noticeably from 5 to 9 worker threads, but, configured with 10 worker threads, scalability increases significantly, suggesting it is desirable to configure the same number of worker threads as schemas.
(Get More Information . .)
|
|
04 Apr 2012
|
MySQL 5.5 Available on Oracle Linux 6 and RHEL 6 [25871]
Downloads are Available
MySQL 5.5 is now available on both Oracle Linux 6 with the Unbreakable Enterprise Kernel and on Red Hat Enterprise Linux 6 (RHEL 6) and Oracle Linux 6 with the Red Hat compatible kernel Bertrand Matthelié reports. Users can download MySQL 5.5 Community Edition binaries for Oracle Linux and Red Hat Linux 6. Matthelié's post adds that MySQL customers can rely on Oracle Premier Support for MySQL when using the MySQL database on either Oracle Linux or Red Hat Enterprise Linux 6 and confirms that, in addition to offering direct Linux support to customers running RHEL6, Oracle Linux 6, or a combination of both, Oracle also provides Oracle Linux 6 binaries, update and erratas for free from Oracle's Public Yum Server.
(Get More Information . .)
|
|
|
|
|
