Linuxkommando.com::linux,ubuntu,software,news,reviews,articles

Proposed to replace MySQL to MariaDB in the beginning of the development cycle Fedora 19. MySQL will continue to be available for at least one more release, but MariaDB will now be the default. In addition, support will be a parallel installation of both packages on the same machine, will have to choose just one.

Development and support of MySQL implements Corporation Oracle, acquired the rights to the brand with the absorbed Sun Microsystems, which had previously acquired the Swedish company MySQL AB. Recent changes to Oracle, indicate that they are moving toward greater secrecy project MySQL. They do not publish information on security issues, and a very large part of the MySQL bug tracking system is no longer accessible. (more…)

Twitter has opened the source code of modified versions of MySQL, which is used in the company to store the texts tweets, timeline and data users.

The sources include a large number of changes , including:

• additional status variables for monitoring InnoDB;
• optimization of memory allocation for large NUMA-systems;
• the ability to cancel long-running queries times out with a millisecond resolution;
• unloading and recovery buffer InnoDB, allowing the quick restart database;
• optimization for SSD.

(more…)

Monty Program and several volunteers have released a free database system MariaDB in version 5.3. MariaDB 3.5 is based on MySQL 5.1, but contains several additional storage engines, chunks of code from MySQL 5.5, 5.6 and 6.0 and various improvements.

In MariaDB 5.3 is the first version of the 5.3-series, occur in no more known bugs and is assessed as stable enough for production systems. The developers mainly corrected errors, so there are only a few new features. These counters are for the Multi-Range Read-and-index condition pushdown optimization.
(more…)

MySQL Workbench is one of the key tools for the design and administration of MySQL databases. Allows creation of entity-relationship models, queries, SQL Scripts, Ingreniería Reverse …

To install such a valuable tool in Ubuntu 11.10 will follow the following steps:
(more…)

Oracle has announced the commercial extensions to the database MySQL. These extensions are available only for editorial Enterprise, and they will be future major difference between the corporate version and the version for the community. Previously a corporate version in addition included only external tools, monitor and backup tool, but now the new expansion is much deeper affect the kernel of the database.
(more…)

With the announcement of new features that should be included only in the only commercial version of MySQL, is the difference between the free and commercial version of the increasingly serious.

Prior to the acquisition of Sun by Oracle , MySQL is by far the most hotly disputed point dar. Critics feared above all that the acquisition would reduce competition in the massive database segment.

When they saw the ground pressure of MySQL database on the giants in the lower price segment. Especially in this area, the free MySQL system enjoys a dominance that Oracle makes things difficult and have a direct impact on prices in the upper segment. It is therefore predictable, so the critics, that Oracle does not allow a further strengthening of MySQL will try and will reduce revenue by closing or functional depreciation of MySQL limit.

With a new announcement by Oracle, not more Five new features of MySQL public, but to make available only to paying customers, some critics see now confirmed. Oracle is so loud the introduction of a thread pool , the speed of the system can be further expanded.
(more…)

The free monitoring software is in version 2.2.0 Monitorix available with new features.

The release features two major innovations: first, the tool creates a comprehensive statistics now for MySQL database server, including traffic, links and query types. Secondly, the software is supported with FreeBSD and OpenBSD, and also registers the system call “vfork” on BSD systems. In addition, the developers have improved detection of Lighttpd on FreeBSD and other bugs fixed. A detailed list, see the Changelog .
(more…)

Knowledgeroot, a Web application to store information in a tree structure, is available in version 1.0.1.

The new release allows symbolic links in the tree can move content within a page and hide the menus. In addition, the Dojo Toolkit to version 1.6.1 used and the Zend Framework was updated to 1.11.7. To edit the content instead of FCKeditor is now the Dojo rich text editor. Knowledgeroot now runs under the PHP version 5.3. The feature release 1.0.0, the developers soon afterwards sent the bug fix 1.0.1, fixes the upgrade and installation problems with MySQL. Details can be found in the Release Notes .
(more…)

The Percona server, which is under GPL expanded version of the MySQL database server with XtraDB, released in version 5.5.

Percona promises to the MySQL server settings and more and better scalability. In the new version, “Stable 5.5.11-20.2″ the developer the handler socket NoSQL plugin for MySQL renewed. The InnoDB now also works with MySQL dumps. Various bug fixes have also been incorporated to help avoid including those crashes of InnoDB. A marked as experimental version of Percona for Mac OS is also new in the offer.

Oracle has following the acquisition of Open Office as part of the purchase of Sun Microsystems has indicated that no offer commercial version of Open Office more.

Open Office is to become a pure community project, “said Edward Screven, Oracle’s Chief Corporate Architect. Oracle now wants to work with the community and Open Office help to continue to succeed. The extent to which support is expressed in full time developers, Oracle has not yet made known. Oracle promises in general, is the commitment to open standards such as the Open Document Format and to support their development. Large investments in open source are also announced, with Linux and MySQL are highlighted.
(more…)