|
Archived MySQL Articles
|
23 May 2012
|
A Collection of FAQs on MySQL 5.6 Replication [26388]
Includes Link to the On-demand Webinar
Global Transaction IDs, auto-failover and self-healing, multi-threaded, crash-safe slaves ... all part of MySQL 5.6 Development Release. Mat Keep has collected FAQs on the release that were collected in a webinar held by the MySQL Development Team. The questions covered the following aspects of the release:
- Multi-threaded slaves
- Global Transaction iDs and HA utilities
- Replication event checksums
- Time delayed replication
- Informational log events
- Remote binlog backup
Keep also includes links to the on-demand webinar itself and to the collection of slides used in the webinar.
(Get More Information . .)
|
|
18 May 2012
|
MySQL Workbench 5.2 GA; Includes 28 Bug Fixes [26314]
Improves Stability and Performance in Windows
The MySQL Developer Tools team has released MySQL Workbench version 5.2.40, the next maintenance release of its flagship product, which contains more than 28 bug fixes applied over version 5.2.39. The team reports that, in addition to the new Query/SQL Development and Administration modules, version 5.2 features improved stability and performance especially in Windows, where OpenGL support has been enhanced, and the UI was optimized to offer better responsiveness. Sources and binary packages for several platforms, including Windows, Mac OS X and Linux are available as downloads.
(Get More Information . .)
|
|
18 May 2012
|
PHP & MySQL: Novice to Ninja, 5th Edition [26318]
Includes Reference Guide to PHP and MySQL
"PHP and MySQL: Novice to Ninja, 5th Edition," Kevin Yank's book that covers everything from installing PHP & MySQL under Windows, Linux, and Mac through to building a live web-based content management system, has been released by SitePoint. The book is written for beginners but nevertheless covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP. It comes complete with a set of handy reference guides for PHP & MySQL that include:
|
|
10 May 2012
|
Meet The MySQL Experts Podcast: Managing Scalability of MySQL Enterprise Edition [26237]
MySQL Thread Pool Is the Tool
On this episode of Meet the MySQL Experts Podcast, Mikael Ronstrom, senior MySQL Architect, discusses how the MySQL Thread Pool improves MySQL Scalability. Ronstrom summarizes the typical problems that commonly crop up when scalability is called for, one of them being MySQL Thread Pool itself, which was resolved in a later version. Ronstrom also notes the best use cases for MySQL Thread Pool, which are for sorting out active connections and managing long-running queries. Finally, he points out that, even with more than 64 active connections MySQL Thread Pool can produces results up to 20x better than MySQL Enterprise alone.
(Get More Information . .)
|
|
07 May 2012
|
Using MySQL Enterprise Backup with Symantec NetBackup. [26157]
Performs a Full Range of Backup and Restore Operations
The paper "MySQL Enterprise Backup and Symantec NetBackup" focuses on how Symantec NetBackup and MEB interact with each other. MySQL Enterprise Backup delivers online "Hot" database backup, whether full, incremental and partial backups, or Point-in-Time Recovery and backup compression. MySQL Enterprise Backup can interface with media management software (MMS) to execute backup and restore operations via System Backup to Tape (SBT) interface. SBT is the Oracle API implemented as shared library (libobk.so in Linux and orasbt.dll in Windows) to backup /restore data via 3rd party software vendors. Registration and log in are required to access the document.
(Get More Information . .)
|
|
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 . .)
|
|
|
|
|
