April 15, 2010

MySQL will be much faster

Oracle promises to improve the database system in many areas.

Oracle's acquisition by Sun has created great uncertainty for the future of the open source-based database system MySQL, which Sun acquired in 2008.
But in an interview with Reuters said Edward Screven, Oracle's chief architect, that Oracle is increasing its investments in MySQL on all fronts.
First and foremost, it seems that Oracle will now make MySQL a main challenger to Microsoft SQL Server, targeted at small and medium-sized businesses and companies who operate their own websites.
- MySQL a lot and often compete with SQL Server. It makes sense for us as a company to ensure that it places on the same line as SQL Server, "said Screven. He added that the company has already begun to provide new functionality to MySQL.
Screven presented some of the news during the O'Reilly MySQL Conference in Santa Clara, California, this week. According to Info World Screven said that MySQL has some characteristics such as Oracle databases do not have.

- It's small, it is easy to install. It is easy for developers to get started with it, "said Screven.
It is now integrated MySQL and InnoDB team should already have achieved to give MySQL a performance improvement of up to 35 percent for MySQL databases that operate with several hundred simultaneous connections. An upcoming version of MySQL, probably 5.5, will have performance improvements as a result of more fine-grained locking of rows and by avoiding any conflicts related to the tables.
According to eWeek told Screven besides that InnoDB hereafter will be the default database in MySQL, rather than MyISAM. According Screven, most are already InnoDB, including support for transactions. MyISAM will nevertheless still be supported. It will however not the Falcon storage engine, which primarily was created as a response to the Oracle at one time bought InnoDB.

To eWeek says that Screven Oracle in the future will make it easier for users to migrate data between MySQL and Oracle databases, in addition to making Oracle functionality such as the Secure Backup, Enterprise Manager, and Audit Vault available for MySQL.
Oracle has released MySQL 5.5 beta. In addition to improving performance, promised better reliability and scalability. More details can be found on this page.
As a result of dissatisfaction with how Oracle now has taken care of MySQL, former MySQL employees and members of the MySQL community started to develop MySQL in their own directions, under the name MariaDB and Drizzle.
Screven told InfoWorld that he wants these players good luck, but thinks it will be difficult for these actors to provide the kind of commercial support that customers need for production systems.