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

I see so many posts on what happened to company X, product Y and dream Z that I couldn't resist the temptation to summarize this great year for MySQL. At the end of 2010, Oracle did an announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed since then and it's time to reflect on what has been done.

I know this is a long post. I tried to rewrite it at least 10 times to make it shorter, but I couldn't condense the list. Hence, I wrote a summary in the beginning for those who don't want to read it all.

I believe that 2011 was an exceptional year for MySQL and I really enjoy being part of this team. I wish all of us a lot of success and fun in the years to come!

Summary:
Oracle released many MySQL 5.6 and MySQL Cluster 7.2 DMRs accompanied by new versions of MySQL Enterprise Monitor, MySQL Enterprise Backup, MySQL Workbench (and utilities), MySQL Proxy, MySQL Cluster Manager and Connectors.

The MySQL team unveiled new products like the MySQL Installer for Windows and Oracle VM Templates for MySQL. Besides, the MySQL Enterprise offering has been enriched with new commercial extensions. MySQL can now be leveraged as one of the Oracle data management solutions with new certifications and the integration with My Oracle Support increased the business value of customers' investment on Oracle technologies.

Additionally MySQL presented at mayor events across the world and won a few awards.


Long List:
If you're still reading, below you can find an hopefully-extensive list of announcements and blogs (in reverse chronological order). I've mainly covered product releases, events and awards. Please let me know if I missed something.

Products: 
Dec 26 - MySQL Workbench 5.2.37 Has Been Released
Dec 20 - MySQL 5.6.4 Development Milestone Now Available!
Dec 02 - MySQL Enterprise Monitor 2.3.8 is now GA!
Nov 28 - MySQL 5.5.18 Debian packaging now available
Oct 10 - New MySQL Enterprise Oracle Certifications
Oct 10 - MySQL Utilities 1.0.3
Oct 07 - MySQL Cluster 7.2 (DMR2): NoSQL, Key/Value, Memcached
Oct 03 - More Early Access Features in the MySQL 5.6.3 Development Milestone!
Oct 03 - New Development Milestone Releases & Certifications!
Sep 15 - New Commercial Extensions for MySQL Enterprise Editions
Sep 09 - MySQL@Oracle OpenWorld
Sep 06 - Oracle Enhances MySQL Installer and High Availability for Windows
Sep 06 - Oracle Enhances MySQL Manageability on Windows
Aug 19 - MySQL Proxy 0.8.2 Has Been Released
Aug 01 - More New MySQL 5.6 Early Access Features
Jul 19 - MySQL Enterprise Backup 3.6 - New backup streaming, integration with Oracle Secure Backup and other common backup media solutions
Jul 18 - Simpler and Safer Clustering: MySQL Cluster Manager Update
Jul 06 - Announced Oracle VM Templates for MySQL
Apr 12 - MySQL Cluster 7.2 Development Milestone Release - NoSQL with Memcached and 20x Higher JOIN Performance
Apr 11 - Top Features in MySQL 5.6.2 Development Milestone Release
Apr 11 - Introducing the MySQL Installer for Windows
Mar 15 - Oracle Enhances MySQL Enterprise Edition

Events:
Oct 26 - A lot of MySQL Events in Europe
Oct 12 - MySQL Roadshow in Germany
Sep 16 - OTN MySQL Developer Day in London
Aug 08 - OTN Developer Day: MySQL is Coming to Washington, DC
Jul 14 - New “Meet The MySQL Experts” Podcast Series
May 13 - Upcoming MySQL Events in Europe
Apr 26 - OTN Developer Day for MySQL - Santa Clara, CA
Mar 25 - MySQL (and Cluster) at Collaborate and O'Reilly MySQL Conference
Mar 14 - First Ever MySQL on Windows Online Forum - March 16, 2011

Awards:
Dec 15 - MySQL Wins Best Open Source Product of 2011 Award
Jun 03 - MySQL Wins the php|architect Impact Award for Data Management
Jan 17 - MySQL Makes the Cover of Oracle Magazine

To all MySQL customers, partners, colleagues, developers, users, advocates or aficionados: Thank you for this terrific year! Go MySQL!

PlanetMySQL Voting: Vote UP / Vote DOWN

MySQL Connector/Net 6.5.0, a new version of the all-managed .NET driver for MySQL has been released.  This is a beta release of our newest connector and comes with several new features.  It is of beta quality and should not be used in any production environment.  It is appropriate for use with MySQL server versions 5.0-5.6

It is now available in source and binary form from here and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

This new versions brings new features such as

• Exception and command injector support
• Millseconds support
• Better partial-trust support
• Better intellisense including auto-completion when editing stored procedures or .mysql files
  

These features are not yet documented in the shipping documentation.  We will be posting a series of posts to our blog outlining these new features and will have them fully documented by GA.

You can leave comments here on this blog or you can also post questions on our forums at http://forums.mysql.com/. 

Enjoy and thanks for the support! 
PlanetMySQL Voting: Vote UP / Vote DOWN

When Oracle acquired MySQL there was some concern about what would happen with the world's most popular open-source database.  It's clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it's related technologies.  I know because I run one of those teams!

I've been working on MySQL and .NET technologies for the past 8 years and I'm very proud to introduce a couple of people who have been and will continue be working on my team.  

Fernando Gonzalez currently serves as leader of our Connector/Net team and has just completed some early work on major intellisense improvements on Connector/Net 6.5.  He's done work on developing a new parser for our product.  We look forward to Fernando being a team leader and productive member of our team!

Gabriella Martinez has been working with Fernando on 6.5 and recently completed work on several new features including new milliseconds support and better support for partial trust scenarios. Gabriella will soon be moving to a new project that we look forward to announcing in the near future. Gabriella has already proven to be a very effective developer and important addition to the team.

We have 3 more developers starting on Jan 2 and I can't wait to write a followup to this post introducing those guys.  We are expanding our team and doing some great things with MySQL, Windows, and .NET.  2011 has been a very good year and we look forward to 2012 being even better!

Merry Christmas and Happy New Year! 

PlanetMySQL Voting: Vote UP / Vote DOWN

MySQL Connector/Net 6.3.8, a new version of the all-managed .NET driver for MySQL has been released.  This is a maintenance release to our 6.3 release chain and includes 40 changes and fixes.

Version 6.3.8 is appropriate for use with versions of MySQL 5.0-5.5.

It is now available in source and binary form from here and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

The release is also available for download on My Oracle Support (MOS).

Enjoy and thanks for the support!
PlanetMySQL Voting: Vote UP / Vote DOWN

If you were unable to attend the live webinar (or you want to go back and listen to it again) then it’s now available to view on-line here.

Databases are the center of today’s web and enterprise applications, storing and protecting an organization’s most valuable assets and supporting business-critical applications. Just minutes of downtime can result in significant lost revenue and dissatisfied customers. Ensuring database highly availability is therefore a top priority for any organization. Tune into this webcast to learn more.

The session discusses:

1. Causes, effect and impact of downtime
2. Methodologies to map applications to HA solution
3. Overview of MySQL HA solutions
4. Operational best practices to ensure business continuity

PlanetMySQL Voting: Vote UP / Vote DOWN

We have lately been talking about some upcoming features that we feel are important to MariaDB users, because the corresponding ones that will be provided with MySQL will be incompatible with MariaDB and closed source.

We’re happy to announce the following:

• The next version of MariaDB, version 5.2.10 will include an open source PAM Authentication Plugin. MariaDB 5.2.10 is scheduled for release next week.
• A Windows Authentication Plugin is in development and QA currently and will be part of MariaDB 5.2.11, which is scheduled for release before Christmas.
• MariaDB 5.5 will include both of the above plugins and an open source thread pool implementation. The soon-to-be-launched first version however will not include the thread pool.

Stay tuned for more information as soon as we start launching the above features.

Mission critical services relying on MariaDB should be aware that SkySQL has familiarized themselves with the new features and are ready to support all of the above options.

PlanetMySQL Voting: Vote UP / Vote DOWN

Not a big deal, but I just added a “Table of Contents” page to my blog to make finding older articles much easier.

I noticed most of my posts are quite lengthy, and it can take a bit of searching/clicking to find an older entry. So unless you happen to recall the ‘month/year’ it was published, which I don’t even remember that, then hopefully this will help.

Really simple, and looks just like this:

• Microseconds and MariaDB
• Dealing with Assertion failure in log/log0recv.c – !page || (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table)
• MySQL Windows Users – Use Grep to Search MySQL Source Code
• Proxy Trace Revisited with MySQL Proxy 0.8.2
• …

My hopes are that this will aid in making some posts easier to find (such as ones about InnoDB Recovery, Recovery with an Individual .ibd, Proxy-related articles, Error-related articles, How-to posts, and so forth).

You can see the full “table of contents” here:

http://www.chriscalender.com/?page_id=399

Happy reading

 
 
 

PlanetMySQL Voting: Vote UP / Vote DOWN

In the latest release of MySQL Workbench (5.2.35), we received a number of reports that some people upgrading over a previous installation ended up in not being able to launch MySQL Workbench afterwards, instead receiving an error such as Access to the path ‘C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.35\db_utils.pyc’ is denied. The cause for that seems to be a problem with access privileges on files that are created when Workbench is run. If you run into that problem, a possible workaround should be to start Workbench with elevated privileges one time. To do this, right-click the Workbench application icon in your startmenu and select “Run as administrator”. Please leave a comment whether this workaround solves the reported problem for you.

UPDATE: A new 5.2.35.1 msi package has been uploaded, which resolves this issue. You can download it from the usual location.

PlanetMySQL Voting: Vote UP / Vote DOWN

This article is just a how-to for setting up Perl on Windows in order to use the perl scripts provided with MySQL, such as mysqldumpslow.pl or mysql_explain_log.pl.

Now, you might say there is a section on this topic in the MySQL manual, to which I’d agree. But, this was for ActiveState Perl 5.6. The latest ActiveState Perl is 5.12, so thoese instructions are a bit out-of-date. Also, there are some helpful “User Comments” on that same page, but again, those are slightly out-of-date in the ActiveState 5.12. So, I thought I’d just post the steps I took in order to set this up.

First, download and install ActivePerl. Click the “Download ActivePerl 5.12.4 for Windows” button (choose either 32-bit or 64-bit). You’ll be prompted to save an msi file. Save it, and double-click on it to install it, following the prompts.

Next, install Perl DBI and DBD:MySQL:

Open Perl Package Manager (PPM) GUI (which was installed from above step). In the PPM GUI (for ActivePerl 5.10+) you have to follow these steps to obtain DBI and DBD-mysql

1. In the PPM GUI, navigate to “Edit -> Preferences” (Ctrl+P)

2. Click on “Repositories” tab, select “uwinnipeg :: University of Winnipeg” from the “Suggested” drop-down, and click “Add”

This will add a number of packages to your ActivePerl (and you should at least see DBI now).

You *may* also find DBD-mysql (worked in 5.10 days, but not in 5.12 days).

3. If you don’t have it, open a dos command line prompt and run the following (this basically adds a second repository from the University of Winnipeg, but one that does contain the DBD-mysql):

ppm rep add http://theoryx5.uwinnipeg.ca/ppms/

Here is my session output, for reference:

C:\Users\Chris>ppm rep add http://theoryx5.uwinnipeg.ca/ppms/
Downloading theoryx5.uwinnipeg.ca packlist...done
Updating theoryx5.uwinnipeg.ca database...done
Repo 3 added.

4. Then run this (also from the dos command line):

ppm install dbd-mysql

Again, the session output:

Downloading DBD-mysql-4.019...done
Unpacking DBD-mysql-4.019...done
Generating HTML for DBD-mysql-4.019...done
Updating files in site area...done
  12 files installed

5. Now, in PPM, once you “Refresh all Data” (F5), then you should see DBD-mysql in the list.

6. If for some reason you’re not sure about DBI, just run:

ppm install DBI

In my case, it was already installed (at step #2), so the output showed this:

C:\Users\Chris>ppm install DBI
No missing packages to install

Just showing there’s no harm in either of these “ppm install” commands.

Great! Now that that’s installed, let’s test somthing out, say mysqldumpslow, since it is so useful and common.

(Note for this step, I already have the slow query log enabled, and have run at least one slow query so that there is something in the log. Also, note the -v option is “verbose”, -s is sorting, and the ‘at’ is how it sorts – average query time, where ‘at’ is the default. Run mysqldumpslow –help for more details.)

C:>mysqldumpslow.pl -v -s at ..\data\Chris-PC-slow.log

Reading mysql slow query log from ..\data\Chris-PC-slow.log
Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=5.0 (5), root[root]@localhost
  select * from t;
  C:\Program Files\MySQL\MySQL Server N.N\bin\mysqld-nt, Version: N.N.N-nt-log
  (MySQL Server). started with: TCP Port: N, Named Pipe: MySQL

Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), 0users@0hosts
  C:\Program Files\MySQL\MySQL Server N.N\bin\mysqld-nt, Version: N.N.N-nt-log
  (MySQL Server). started with: TCP Port: N, Named Pipe: (null)
  # Time: N N:N:N
  # User@Host: root[root] @ localhost [N.N.N.N]
  # Query_time: N  Lock_time: N  Rows_sent: N  Rows_examined: N
  use test99;
  select * from t

And here is an invocation of mysql_explain_log (run against the general query log):

C:>mysql_explain_log.pl --user=root --password=mysql < ..\data\Chris-PC.log
explain_log     provided by http://www.mobile.de
===========     ================================

Index usage ------------------------------------

Queries causing table scans -------------------

Sum: 0 table scans

Summary ---------------------------------------

Select:         0 queries
Update:         0 queries

Init:           0 times
Field:          0 times
Refresh:        0 times
Query:          24 times
Statistics:     0 times

Logfile:        59 lines
Started:        Wed Sep 14 14:13:30 2011
Finished:       Wed Sep 14 14:13:31 2011

So there you have it.

Hope this helps any users out there needing to get Perl working on Windows for MySQL-bundled scripts.

PlanetMySQL Voting: Vote UP / Vote DOWN

This month, Alex Roedling interviews Software Development Manager Reggie Burnett about MySQL on Windows.

Reggie covers Connector/NET, integration with Visual Studio, MySQL Workbench, the new MySQL installer for Windows, the new external authentication module for Windows, and more...

Enjoy the podcast!

And, a quick reminder that if you’re either attending Oracle OpenWorld or in the bay area next Tuesday, we hope to see you at the MySQL Community Reception!

PlanetMySQL Voting: Vote UP / Vote DOWN