|
Archived MySQL Articles
|
13 Sep 2012
|
Interview about MySQL Connect [27610]
with Lenz Grimmer
Some year and a half since his responsibilities shifted from MySQL to his current assignment as a member of the Oracle Linux product management team, Lenz Grimmer nonetheless maintains a keen interest in MySQL. In an interview with Keith Larson, he discusses the MySQL Connect conference and applauds Oracle's decision to hand over the gathering to the MySQL Community. Grimmer said he regards MySQL 5.6 as a "very promising release," and recommends Oracle Linux as the ideal choice for running MySQL. He also highlights several MySQL Connect sessions that strike him as especially attractive.
(Get More Information . .)
|
|
27 Aug 2012
|
Blog Explains Parallel Backup Operations in MySQL Enterprise Backup v3.8.0 [27334]
Pipeline Processing Enables Parallelism, Speeds Backups
In a post on parallel backup in MySQL Enterprise Backup (MEB) v3.8.0 jothir (Hema Sridharan) explains how read/write operations are now performed in parallel using pipeline parallelism. The post explains that the pipelined parallel execution of read, process (if requested) and write operations is achieved by invoking multiple threads for different operations and usage of buffers. Each operation is split into segments, and threads operate on different segments from different iterations concurrently. Each segment is assigned one or more worker threads and in-queue buffers which store the work to be processed by that stage. The post provides an example.
(Get More Information . .)
|
|
02 Aug 2012
|
MySQL Cluster Performance Best Practices: Q & A [27101]
On-demand Webinar, Performance Guide Now Available
Developers looking for a solution that will scale both read and write traffic with ultra-low latency and fault tolerance on commodity hardware need look no further than MySQL Cluster, Mat Keep blogs. He suggests that developers do need to think a little differently about data access patterns along with schema and query optimizations in order to get the best possible performance from this distributed database, however. He suggests logging in to the on-demand Performance Essentials webinar, which is accompanied by the newly published Guide to Optimizing the Performance of MySQL Cluster.
(Get More Information . .)
|
|
02 Aug 2012
|
MySQL Enterprise Backup 3.8 Employs Multi-threaded, Parallel Processing for Performance Gains [27103]
Improvements Range from 20-100% Depending on Size and Nature of Data Involved
The development team behind MySQL Enterprise Backup (MEB) has released MEB 3.8, which, as team member Rob Young explains, provides a substantial improvement in backup operation performance by implementing parallel processing during backup of related internal operations such as reading/writing data, compression/decompression, and page checksum validation. Parallel execution, Young continues, takes advantage of multi-threading, and the resulting performance increase is particularly evident when backing up to or restoring from RAID and SSD storage, and when using compressed backups. Internal benchmarks show that performance gains range from 20% to 1000% depending on the size and content of the data involved.
(Get More Information . .)
|
|
31 Jul 2012
|
Oracle Announces New Migration Tool for Microsoft SQL Server to MySQL [27048]
Helps Lower Database TCO up to 90 Percent ; Requires No Prior MySQL Technical Knowledge
Oracle has announced a new migration tool that allows users to easily and quickly migrate data from Microsoft SQL Server to MySQL, along with a a new MySQL for Excel application plug-in that enables data analysts to seamlessly access and manipulate MySQL data within Microsoft Excel, without requiring prior MySQL technical knowledge. An enhanced version of the MySQL Installer for Windows is also available. Oracle claims users will appreciate database TCO reductions of up to 90 percent in using MySQL over Microsoft SQL Server 2012. These new tools will be featured at the MySQL Connect Conference on September 29-30.
(Get More Information . .)
|
|
12 Jul 2012
|
NoSQL Java API for MySQL Cluster: Q&As [26851]
Webinar Followup on Building Java-based Services
During the recent webinar conducted by the MySQL Cluster Engineering Team on ClusterJ and ClusterJPA NoSQL APIs for MySQL Cluster and how these can be used in building real-time, high scale Java-based services that require continuous availability, some insightful questions were raised that Mat Keep has now compiled for consideration. The webinar itself is available on demand. Keep precedes the Q&A with a brief account of why the team developed these APIs and why they are interesting to Java developers.
(Get More Information . .)
|
|
|
|
|
