PlanetMysql.ru – информация о СУБД MySQL

A new version of Kontrollbase – the enterprise monitoring, analytics, reporting, and historical analysis webapp for MySQL database administrators and advanced users of MySQL databases – is available for download. There are several upgrades to the reporting code with improved alert algorithms as well as a new script for auto-archiving of the statistics table based [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.1.1. It is ideally suited for delivering fast response times for complex / high-volume Web applications that must simultaneously store and query large volumes of rapidly arriving data:

• Social Networking
• Real-time clickstream analysis
• Logfile Analysis
• eCommerce Personalization
• High-speed Webcrawling

TokuDB v4.1.1 replaces TokuDB v4.1.0 and is recommended for all users. (We found a bug in v4.1.0 and have withdrawn it from our website). The new version has all of v4.1.0′s new features, including support for SAVEPOINT and an even better Fast Loader. As always, this release uses our high-performance Fractal Tree™ indexing to provide a unique combination of capabilities:

• 10x-50x faster indexing for faster querying
• Full support for ACID transactions
• Short recovery time (seconds or minutes, not hours or days)
• Immunity to database aging to eliminate performance degradation and maintenance headaches
• 5x-15x data compression for reduced disk use and lower storage costs

PlanetMySQL Voting: Vote UP / Vote DOWN

After two months of submissions, Monty Program employee review, community voting and Monty’s final decision, we are happy to announce that the Maria storage engine will henceforth be known as …

Aria!

Congratulations to Chris Tooley who suggested the name. Chris said about Aria in his submission, “Maria without the ‘M’, plus aria is a pleasant musical term.” Chris is now the proud new owner of a System 76 Meerkat net-top computer. Thanks to our good friends at System76 for providing this nifty prize.

Hopefully, in time, “Aria” will also be a pleasing database engine term. And now we will not have the confusion between MariaDB and Maria.

PlanetMySQL Voting: Vote UP / Vote DOWN

Tokutek is pleased to announce immediate availability of TokuDB for MySQL, version 4.0. It is designed for continuous querying and analysis of large volumes of rapidly arriving and changing data, while maintaining full ACID properties.

New in TokuDB v4.0 is our multi-threaded Fast Loader. Capable of utilizing all available CPU cores, the Fast Loader greatly accelerates creating a new index or initializing a database with a bulk load. On an 8 core machine, loading operations speed up by over 4x and with 16 cores the acceleration is even greater.

Other improvements in v4.0 include:

• Shorter Logfiles – The logs needed for ACID transactions are now considerably
  smaller. In addition to saving disk space, smaller logs means faster recovery in many cases.
• Faster Logfile Reclamation – When a transaction commits, the space associated with logging for that transaction is reclaimed more quickly. This helps keep disk space requirements to a minimum.
• Support for READ COMMITTED isolation level – Fulfills a very popular customer request.

This new release builds on TokuDB’s unique capabilities:

• 10x-50x faster indexing for faster querying
• Full support for ACID transactions
• Short recovery time (seconds or minutes, not hours or days)
• Immunity to database aging to eliminate performance degradation and maintenance headaches
• 5x-15x data compression for reduced disk use and lower storage costs

Because of its high indexing performance and transaction support, TokuDB is well suited to Web applications that must simultaneously store and query large volumes of rapidly arriving data, including:

• Logfile Analysis
• High-speed Webcrawling
• Real-time clickstream analysis
• Social Networking
• eCommerce Personalization

PlanetMySQL Voting: Vote UP / Vote DOWN

OpenSQL Camp Boston 2010 will be held at the Stata Center in Cambridge, Massachusetts, October 15-17, 2010.

The Stata Center was designed by Frank Gehry and was completed in 2005. The Stata Center houses CSAIL (The MIT Computer Science and Artifical Intelligence Laboratory) and LIDS (The MIT Laboratory for Information and Decision Systems). Some of my favorite pictures of the Stata Center were taken during construction. (I’m a member of CSAIL)

The OpenSQL Camp will be held on the first floor of the Stata Center where we’ve reserved four classrooms (with capacities 318, 90, 60, and 60 respectively). We expect to have access also to the social areas along the interior “student street”.

The OpenSQL Camp has been running since 2008 in an “unconference format” with a blend of spontaneity and planning, no registration fees, and is open for all essentially on a first-to-sign-up basis (the sign up sheet isn’t up yet, however). The unconference typically includes seminars, hackathons, freeform discussions, and socializing with discussion topics including MySQL, PostgresQL, NoSQL, Maria, Drizzle, Storage Engines, the implications of new hardware and data structures technologies, and “soft” topics such as the formation of the Open Database Alliance, as well as anything else people want to talk about.

Mid October is near the peak of the fall foliage season. We are trying to get the conference organized early so that people will be able to find reasonable accomodation and travel arrangements.

It looks like Sheeri and I will be doing a lot of the legwork to organize this event, but this event can succeed only if many people pitch in to make it work.

I hope to see you there!

PlanetMySQL Voting: Vote UP / Vote DOWN

MariaDB 5.1.44b Linux and Solaris binaries, Ubuntu/Debian/CentOS packages, and source are now available for download.

This is a bugfix/security release of MariaDB 5.1.44.

From the MariaDB 5.1.44b Release Notes:

MariaDB 5.1.44b fixes a buffer overflow that might potentially allow an authenticated user to run arbitrary code inside the server. It also has a fix for MySQL Bug #53371: “Security hole with bypassing grants using special path in db/table names.” In all other respects, it is the same as MariaDB 5.1.44.

See the MariaDB 5.1.44 Release Notes for a summary of the differences between MariaDB 5.1.42 and MariaDB 5.1.44.

A Windows binary is coming soon.

PlanetMySQL Voting: Vote UP / Vote DOWN

Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are some required bug fixes to the formerly new python backup script and some Solaris compatible changes to the various my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads, or here: http://code.google.com/p/kontrollkit/
PlanetMySQL Voting: Vote UP / Vote DOWN

Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are some required bug fixes to the formerly new python backup script and some Solaris compatible changes to the various my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads, or here: http://code.google.com/p/kontrollkit/
PlanetMySQL Voting: Vote UP / Vote DOWN

Quick note to let our users know that there was an XML tag closure error on the “alert_22″ subroutine in the “bin/kontroll-reporter-cli.pl” script. This does not affect the webapp portion of Kontrollbase – only reports generated via the command line reporter script. It is not a fatal error but will cause the XML file to [...]
PlanetMySQL Voting: Vote UP / Vote DOWN

April 1, 2010. Tokutek’s acquisitions of Oracle, Apple, HP, Microsoft and Google were today blocked by the European Union on the basis that the announced acquisitions were “in bad taste”. John Partridge, CEO of Tokutek said “They made us take our TokuFish back. They made us take our TokuPad back. They made us take our stock back. And our stack. Now we’re just a handful of engineers building a MySQL storage engine.”

“But it’s a really good storage engine.”

PlanetMySQL Voting: Vote UP / Vote DOWN