|
Archived MySQL Articles
|
20 Feb 2013
|
MySQL 5.6 Replication: New Resources for Database Scaling and HA [29872]
More Replication Enhancements than in any Previous Release
MySQL 5.6 features the "largest set of enhancements to replication ever delivered in a single release," posts Mat Keep. These include 5x higher performance to improve consistency across a cluster and reduce the risks of data loss; self-healing clusters with automatic failover and recovery from outages or planned maintenance; assured data integrity with checksums implemented across the replication workflow; and DevOps automation. He also announces two new guides:
"MySQL Replication: An Introduction"
"MySQL Replication Tutorial: Configuration, Provisioning and Management"
Keep alerts users to an upcoming live webinar in March on what's new in MySQL 5.6 replication.
(Get More Information . .)
|
|
20 Feb 2013
|
MySQL Workbench 5.2.46 GA Released [29873]
Includes MySQL Utilities 1.2.0
The MySQL Workbench Tool is now available in version 5.2.46, Alfredo Kojima posts, adding that MySQL Utilities 1.2.0 have been included on the distro. Kojima provides a convenient link to the release notes. He includes a download link as well to MySQL Workbench, noting its availability for Windows, Mac OS X and Linux. And he provides links to the documentation for both Workbench and Utilities.
(Get More Information . .)
|
|
05 Feb 2013
|
Oracle Releases MySQL 5.6 to GA [29677]
Release Features Increased Performance, Scalability, Reliability and Manageability
Oracle has released MySQL 5.6 to general availability, featuring the increased performance, scalability, reliability and manageability that make MySQL 5.6, the worlds most popular open-source database. According to Oracle's press release, MySQL 5.6 improves developer agility with subquery optimizations, online Data Definition Language (DDL) operations, NoSQL access to InnoDB, new instrumentation in Performance Schema and better condition handling. A MySQL Technology Update webcast will discuss the new release on February 14 at 10:00 a.m. PST. For more details, join the MySQL Technology Update webcast on Feb 14 at 10:00 a.m. US, Pacific Time.
(Get More Information . .)
|
|
24 Jan 2013
|
Getting the Most out of MySQL Enterprise Edition [29485]
Maximize Scalability, Security and Uptime
Oracle's MySQL Enterprise Edition, according to Bertrand Matthelié, includes the most comprehensive set of advanced features, management tools and technical support needed to assist in reducing the cost, risk and time to deploy and manage MySQL applications. His post includes a link to the MySQL Resource Kit, where users will learn how to boost scalability by 20x with MySQL Enterprise Scalability; automatically detect and recover from failures with MySQL Enterprise High Availability; eliminate security vulnerabilities, improve replication and optimize performance with the MySQL Enterprise Monitor; and how MySQL Enterprise Backup reduces the risk of data loss with online "Hot" backups of databases.
(Get More Information . .)
|
|
24 Jan 2013
|
MySQL 5.6 Soon Available in GA [29489]
Offers Improvements in Performance, Scalability, Availability
The pending release to GA of MySQL 5.6 has a lot of people excited, according to Rob Young. The new version offers many improvements and new functionalities. Among the chief improvements are security features; improvements in the InnoDB storage engine and in the Optimizer, making for better query execution times and diagnostics. Young also cites enhanced application availability featuring Online DDL/Schema changes; better developer agility with NoSQL Access with Memchached API to InnoDB; improvements in the Replication capability, making for high performance and self-healing distributed deployments; and improved performance schema for better instrumentation. The MySQL 5.6 Release Candidate is now available for download.
(Get More Information . .)
|
|
17 Jan 2013
|
18 MySQL 5.6 Troubleshooting Improvements [29387]
Favorites from a Support Engineer
In anticipation of the release to GA of MySQL 5.6 Sveta Smirnova offers a list of 18 favorite troubleshooting improvements from the perspective of the support engineer. Each is presented with a brief comment on its nature and its utility. To name but a few: EXPLAIN for UPDATE/INSERT/DELETE; new InnoDB tables in Information Schema; option to log all InnoDB deadlocks into error log file: innodb_print_all_deadlocks; persistent statistics for InnoDB tables; support of backup/restore of InnoDB Buffer Pool during restart and on demand; partial images in RBR.
(Get More Information . .)
|
|
|
|
|
