MySQL - The World's most popular open source database
MySQL Community Edition is the freely downloadable version of the world's most popular open source database. It is available under the GPL license and is supported by a huge and active community of open source developers.
MySQL Software is provided under the GPL License.
Features
The MySQL Community Edition includes:
• Pluggable Storage Engine Architecture
• Multiple Storage Engines:
- InnoDB
- MyISAM
- NDB (MySQL Cluster)
- Memory
- Merge
- Archive
- CSV
- and more
• MySQL Replication for improving application performance and scalability
• MySQL Partitioning to improve performance and management of large database applications
• Stored Procedures to improve developer productivity
• Triggers to enforce complex business rules at the database level
• Views to ensure sensitive information is not compromised
• Information Schema to provide easy access to metadata
• MySQL Connectors (ODBC, JDBC, .NET, etc) for building applications in multiple languages
• MySQL Workbench for visual modeling, SQL development and administration
MySQL available on over 20 platforms and operating systems including Linux, Unix, Mac and Windows.
Download MySQL
Download MySQL 5.1.53
What's new in MySQL 5.1.53
Bugs fixed in MySQL 5.1.53 (03 November 2010)
Replication:
- SET PASSWORD caused row-based replication to fail between a MySQL 5.1 master and a MySQL 5.5 slave. This fix makes it possible to replicate SET PASSWORD correctly, using row-based replication between a master running MySQL 5.1.53 or a later MySQL 5.1 release to a slave running MySQL 5.5.7 or a later MySQL 5.5 release.
- An ALTER TABLE statement against a MyISAM table that altered a column without setting its size caused the binary log to become corrupted, leading to replication failure.
- When STOP SLAVE is issued, the slave SQL thread rolls back the current transaction and stops immediately if the transaction updates only tables which use transactional storage engines are updated. Previously, this occurred even when the transaction contained CREATE TEMPORARY TABLE statements, DROP TEMPORARY TABLE statements, or both, although these statements cannot be rolled back. Because temporary tables persist for the lifetime of a user session (in the case, the replication user), they remain until the slave is stopped or reset. When the transaction is restarted following a subsequent START SLAVE statement, the SQL thread aborts with an error that a temporary table to be created (or dropped) already exists (or does not exist, in the latter case).
Following this fix, if an ongoing transaction contains CREATE TEMPORARY TABLE statements, DROP TEMPORARY TABLE statements, or both, the SQL thread now waits until the transaction ends, then stops.
- If there exist both a temporary table and a non-temporary table having the same, updates normally apply only to the temporary table, with the exception of a CREATE TABLE ... SELECT statement that creates a non-temporary table having the same name as an existing temporary table. When such a statement was replicated using the MIXED logging format, and the statement was unsafe for row-based logging, updates were misapplied to the temporary table.
- When a slave tried to execute a transaction larger than the slave's value for max_binlog_cache_size, it crashed. This was caused by an assertion that the server should roll back only the statement but not the entire transaction when the error ER_TRANS_CACHE_FULL occurred. However, the slave SQL thread always rolled back the entire transaction whenever any error occurred, regardless of the type of error.
- When making changes to relay log settings using CHANGE MASTER TO, the I/O cache was not cleared. This could result in replication failure when the slave attempted to read stale data from the cache and then stopped with an assertion.
- Trying to read from a binary log containing a log event of an invalid type caused the slave to crash.
- When replicating the mysql.tables_priv table, the Grantor column was not replicated, and was thus left empty on the slave.
- Handling of host name lettercase in GRANT statements was inconsistent.
Source: Changes in MySQL 5.1.53 (03 November 2010)
System Requirements
MySQL available on over 20 platforms and operating systems including Linux, Unix, Mac and Windows. (http://www.mysql.com/support/supportedplatforms/database.html)
Windows Operating System
MySQL support Windows XP, Windows Vista, Windows 7, Windows 2003 Server and Windows 2008 Server
Source:
• http://www.mysql.com/products/community/
No comments:
Post a Comment