If you are SQL Server DBA interested in comparing "apples to apples" with MySQL... tomorrow's free webinar will be worth checking out. Windows/SQL Server vet Mike Frank and I will be running through the feature sets of both products and sorting out functional equivalents. (And yes, there will be some apples to oranges comparisons as well!) We'll be covering security, log shipping/replication, datatypes, partitioning and clustering just to name a few.

It's not too late to sign up for this and the rest of the "MySQL on Windows" webinar series, either...

Register for tomorrow's webinar here

View the upcoming webinars scheduled in the rest of the "MySQL on Windows" series …

We’re proud to announce the availability of the next Alpha release of MySQL Workbench 5.2.
This is the first release of WB 5.2 that enables part of the upcoming administrative feature set. The following tasks can be performed in the WB 5.2.4 release:

• Registration of Server Profiles
• Start/Stop of the MySQL Server
• Configuration File Edition (my.cnf / my.ini)
• Show Connections and Server-variables

Further we have added the long awaited SSH Tunnel features that enables MySQL connections to machines where only SSH access is available.
Select the new Connection Method “Standard TCP/IP over SSH” in the Connection Management dialog and fill out the SSH connection information.

More information about the new features is coming up here on our blog pages.

Please fetch your copy, try the new features and tell us if you like it or what we can improve. But …

For the italian session, we have just broken the 300 participants barrier and we aim to reach 400 registrants. The webinar will be held tomorrow morning at 10am (CET) in italian; you still have time to register here.
Please help us to overachieve this goal!

In this presentation we'll cover the benefits of deploying MySQL on Windows. You will learn the basic “How-To’s” of installation, security and configuration. We will show you how to start using MySQL tools on Windows, such as MySQL Workbench and MySQL Enterprise Monitor with the new Query Analyzer. If you are interested in learning how to get started with MySQL on Windows this webinar is for you.

To have more informations on this topic, please go to …

If you want to play with Amazon cloud computing stuff, I think using AWS Management Console web interface is the best, easiest, and most intuitive approach, based on my experience so far.

My usage with Amazon Web Services has been only with EC2 up to this point. Prior to AWS Management Console, I had to set up Java, EC2 API tools, various path and environmental variables, certificates, keys, etc., etc.. It is a fairly convoluted process.

AWS Management Console is much easier, except for downloading PuTTY and PuTTYgen on Windows and tsclient on Linux, and a private key pair, everything else is handled inside the browser. Here are a few things I learned:

• Once you are in, create a Key Pair. The web interface will prompt you to save it. Do so, because you will need it to start instances and, depending on what type of instances …

We’re happy to announce the availability of the next Alpha release of MySQL Workbench 5.2. There have been further improvements to the querying part and we added the foundations for the administration part (which will be onboard in the next alpha).
On startup, MySQL Workbench 5.2 now doesn’t automatically create a new design-document anymore – thats for decreasing resource-usage when you only launch Workbench for running a few queries against your database. Also the fix to make Workbench work on Snow Leopard has been included in 5.2 now as well.

Please download the program, take it for a test-drive and tell us what you think. But keep in mind, that this is still an alpha version – so be advised to not use it for production data! Also please note, MySQL Workbench files saved with version 5.2 cannot be opened with previous versions of our
program.

For Linux we now …

I track security updates for the following vendors: Apple, Cisco, FreeBSD, Microsoft, Red Hat, and Sun Microsystems. I chose these vendors based on my own needs for the networks and systems I manage. I've also found that updates from these vendors tend to catch the major updates necessary for common software applications. If you have other vendors you would like me to provide updates for, send me a message.

If you have an interest in information security from both a technical and managerial level, check out Principles of Information Security. It does an excellent job of presenting material for both audiences.

Cisco Systems Inc.

• TCP State Manipulation Denial of Service …

We are proud to announce the next service release of MySQL Workbench 5.1.18. We have fixed another set of bugs and made some improvements you people have been asking for. We have optimized the layout of the Columns-section in our table-editor considering the ideas and exeriences you posted in feature requests, bug-reports and on the forums. Now it should provide a smoother more comfortable workflow.
As already reported in previous blog-posts, this version is also compatible with Apples recently released version of OSX – 10.6 Snow Leopard.
Detailed information on the fixes can be found on our Releases Page.

The new files are available on our download page:

http://dev.mysql.com/downloads/workbench/5.1.html

If you encounter problems or have any questions, you …

We’re proud to announce the first service release of our current GA product MySQL Workbench 5.1. This maintenance release encompasses a number of stability, performance and quality improvements.
We were able to fix 56 bugs – as always, details on latest changes can be found on our Releases Page.

Please head over to our download page and fetch this new update:

http://dev.mysql.com/downloads/workbench/5.1.html

In addition to the improvements on the application, we also updated our packaging procedure to provide a more up to date selection of packages for recent distributions. Along with the Windows and OSX (intel) binaries we now provide binaries for the following Linux distributions:

Ubuntu 8.04  …

Every once in a while a programmer finds himself in need of a tool that allows him to edit very large text files. By large, I mean several gigabytes. For DBAs it is common, especially if you’re using MySQL dumps a lot. What do you do if you’re doing this on Windows?
If you’re using Notepad++ or any other Scintilla derivatives, you’re out of luck - those editors are not cut out for this kind of work. Using Visual Studio also won’t work. There are some partial solutions just for viewing, like LTFViewer – but it cannot handle large files without line breaks, something common in MySQL dumps. So what do you do?
The answer is simple and somewhat unexpected – use Vim for Windows. …

Reggie Burnett, the lead behind MySQL Connector/NET, will be presenting a MySQL webinar, "For ISVs: ADO.NET Entity Framework for MySQL", tomorrow at 10 Pacific Time!

Among other topics, Reggie will discuss how to

• Develop your application against SQL Server and then switch it to MySQL with zero code changes

• Optimize your database schema without requiring any code changes in your application

• Use LinQ syntax for type safety in your applications

(Interest in using MySQL on Windows is growing. The 2008 MySQL OEM Annual Survey, which closed in March 2009, shows that some 73% of MySQL OEM customers develop …