December 13, 2006 at 21:47MySQL 5.1 - what's new?
At the end of November, MySQL 5.1 beta release took place . This is not a stable version, but you can already understand from it what innovations await us in the final release.
As the authors of the site whenpenguinsattack.com write , in version 5.1, among others, the following features appear:
* Separation of tables. Now, one table can, from the point of view of MySQL, be split into parts that are physically stored in various places. For a DBMS user, such a table will still be unified and the breakdown will be transparent.
* API for plugins. Now MySQL will load plugins (various components) during program execution, i.e. without restarting the server. The first step in this direction is the emergence of full-text parsing plugins designed to write custom filters for indexed text (as an example, the implementation of full-text search in PDF).
* Event planner. A new object appears in the database - an event. This is a set of SQL commands that will be executed regularly on a given schedule.
* Inline replication. Previously, replication was based on sending SQL expressions from the master machine to the slave machine, and now it will be possible to use the mechanism for writing events to the binary log, which will describe how to process specific rows.
original
As the authors of the site whenpenguinsattack.com write , in version 5.1, among others, the following features appear:
* Separation of tables. Now, one table can, from the point of view of MySQL, be split into parts that are physically stored in various places. For a DBMS user, such a table will still be unified and the breakdown will be transparent.
* API for plugins. Now MySQL will load plugins (various components) during program execution, i.e. without restarting the server. The first step in this direction is the emergence of full-text parsing plugins designed to write custom filters for indexed text (as an example, the implementation of full-text search in PDF).
* Event planner. A new object appears in the database - an event. This is a set of SQL commands that will be executed regularly on a given schedule.
* Inline replication. Previously, replication was based on sending SQL expressions from the master machine to the slave machine, and now it will be possible to use the mechanism for writing events to the binary log, which will describe how to process specific rows.
original