Get up-to-date on MariaDB, MySQL, Cloud Databases and SkySQL’s expertise: whitepapers and presentations now available on skysql.com

read more

How do you implement a parallel algorithm for a software which needs to be streamed to tapes?
How do you ensure that you have the capability to be able to tune the level of parallelism for varying input and output devices and varying levels of load?
These were some of the questions that we needed to answer when we were trying to implement multi-threading capability for MySQL Enterprise Backup (MEB).
The trivial way of achieving parallelism is by having the multiple threads pick up the different files (in a file per table) scenario. But this did not seem adequate because:
a) The sizes of these files (corresponding to the tables) could be different and then one large file would limit the level of parallelism since it would be processed by a single thread.
b) If you have to stream the backup how do you reconcile these multiple files being streamed by separate threads? Large backups are streamed directly to tape so it is …

The MySQL Enterprise Backup 3.8.1 release's main goal was support MySQL 5.6 server. But also beyond that primary goal MEB team added some valuable new options and features to ensure you'll get most from the new features in 5.6 as well. At a glance, here are some of the highlights,

MEB copy of InnoDB undo log tablespaces

MySQL 5.6 introduces a new feature to store undo logs in separate files called as undo tablespaces for improved performance. These undo tablespaces are logically part of system  tablespace. All the commands associated with MEB - "backup", "apply-log" and "copy-back"  now take care of the undo tablespaces in the same way as they process the system tablespace. MEB now supports innodb_undo_directory[logs][tablespace] option variables. When backup is executed, undo datafiles (up to number specified by innodb_undo_tablespaces) are stored in same directory as the datafiles of system tablespace. During …

Tuesday, February 5th was an important day in the MySQL ecosystem due to the release by Oracle of the long-awaited MySQL 5.6 GA. Many MySQL users have been looking forward to this release in order to benefit from the improved performance and scalability. Features such as online operations/schema changes, NoSQL access from memcached to InnoDB, multi threaded-replication and Global Transaction ID significantly improve the competitiveness of MySQL.

read more

MySQL Server 5.6 GA has several new features. These new features are supported in the latest version of Connector/Net 6.6.5. We'll review them into a brief introduction and example about how to use them inside any .Net Application.

Oracle launches MySQL 5.6. IBM expands PureData line. And more

For 451 Research clients: IBM adds to PureData family with new Netezza-based system for analytics bit.ly/UXhZ8G

— Matt Aslett (@maslett) February 6, 2013

For 451 clients: Panopticon illuminates real-time visual analysis business, rides SAP’s HANA coattails bit.ly/YQpemt By Krishna Roy

— Matt Aslett (@maslett) February 5, 2013

Oracle Announces General Availability of MySQL 5.6 mwne.ws/XTC2Se

— Matt Aslett (@maslett) February 5, …

A new version for Connector/Net 6.6 has been released. This new 6.6.5 version includes several new features that support the new capabilities included in MySQL Server 5.6, which recently has became at GA state.

Learn to create best-of-breed web applications with the MySQL and PHP - Developing Dynamic Web Applications course. 

After taking this course you will be able to:

• Describe the LAMP architecture
• Use the basic components of PHP to build a foundation for more complex web applications
• Understand the basic components of MySQL
• Use SQL query commands to retrieve data from the MYSQL database
• Change table data using the SQL Data Manipulation Language (DML) commands
• Retrieve data from multiple MySQL tables using Joins
• Create web based forms that interact with the end user and the data within MySQL
• Use session handling to authenticate and monitor user identities
• Describe the purpose of template systems

When it comes to information and its management, nothing compliments information more than the database. This Log Buffer Edition #304 covers the latest and greatest database technologies related to Oracle, SQL Server and MySQL.

Oracle:

Vikram Das is discussing a case study of an error aftering cloning OTM database and the instance.

Katsumii blogs about attaching to foreground process with strace in sh script.

Is Oracle Changing The Way That Exams Are Scored? Brandye Barrington asks.

…

We are very honoured to have been asked to give a “state of the MySQL” keynote presentation at the Percona Live MySQL Conference and Expo in April.

While this will not be in any way an official “state of the dolphin” presentation, I think it is fitting given the expansion of the MySQL ecosystem that the Percona Live event includes an independent perspective on the state of MySQL. The full title of the presentation – MySQL, YourSQL, NoSQL, NewSQL – the state of the MySQL ecosystem – reflects that.

We want to present an independent perspective on the health of the MySQL ecosystem in 2013, drawing on our research and analysis, as well as the views of the participants in that ecosystem.

You have …