MySQL Connector/Net 6.5.4 has gone GA!  This is the first production-ready version of our new 6.5 connector and we are very excited about it.  Connector/Net is an all-managed .NET driver for MySQL and is the best solution for your MySQL and .NET data access needs. 

Version 6.5.4 includes full support for MySQL server versions 5.0-5.6 and includes some exciting new features such as:

• Much improved partial trust support.  Hosting providers can now configure their trust policies exactly the way they are configured for SQL Server and your application can run without trouble in partial/medium trust.
• Auto-completion support in the Visual Studio editor.  We have integrated a brand new parser into our Visual Studio work and we are jut getting started showing it's benefits. Open up a VS editor start typing your SQL and you'll see what i mean.
• Command injection support!  …

I’m at Hotsos Symposium this week, and it suddenly occurred to me that a lot of Oracle DBAs who are beginning to manage MySQL servers might have some things to share with others in a similar role shift:

• Familiar, comfortable tools and techniques, or capabilities of the Oracle Database, that you miss in MySQL
• Equivalents or replacements for the aforementioned

Do you have anything to share with your fellow DBAs going through ODT (Oracle Delerium Tremens)? Do you have any wishes that you haven’t satisfied yet? Post in the comments and let’s see if we can create a sort of forum for sharing and/or a wishlist in case someone gets an urge to fill in a missing piece!

Further Reading:

• Making …

The first step in creating an effective import plan for comma-separated value (CSV) files is recognizing your options in a database. There are several options in an Oracle database. You can read the file with Java, C/C++, C#, PL/SQL (through the UTL_FILE package), PHP, Perl, or any other C-callable programming language; or you can use SQL*Loader as a standalone utility or through externally managed tables (known as external tables). The most convenient and non-programming solution is using external tables.

Adopting external tables as your import solution should drive you to consider how to manage the security surrounding this type of methodology. Host hardening is a critical security step because it shuts down most, hopefully all, unauthorized use of the operating system where the database and external files reside. Next, you need to manage the access to the external tables and ensure that exposure of business sensitive information …

With new blog posts covering newest technologies, discovered bugs and anomalies, this Log Buffer Edition is presented for you. In this Log Buffer #261, you would savor posts from Oracle, SQLServer and MySQL arena. Enjoy Oracle: Oracle ACE Director, Alex Gorbachev makes a quick announcement that Method-R is organizing the online class reunion for the [...]

Read the original article at Oracle to MySQL – prepare to bushwhack through the open source jungle

I was recently approached by a healthcare company for advice on suitable database solutions capable of executing its new initiative. The company was primarily an Oracle shop so naturally, they began by shopping for possible Oracle solutions.

The CTO relayed his conversation with the Oracle sales rep, who at first recommended an Oracle solution that, expensive as it may have been, ultimately aligned with the company’s existing technology and experience. Unfortunately this didn’t match their budget and so predictably, the Oracle sales rep whipped out a MySQL-based solution as an alternative.

Having worked as an Oracle DBA throughout the dot-com years, I know the technology well. I also know …

MySQL Connector/Net 6.5.3, a new version of the all-managed .NET driver for MySQL has been released.  This is the second of our two Release Candidate (RC) releases.  As is the case with all non-GA releases, it 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 http://dev.mysql.com/downloads/connector/net/#downloads 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 6.5 release of MySQL Connector/Net brings new features such as

• Exception and command injector support
• Millseconds support
• Better partial-trust support
…

Some time ago I wrote a post introducing two members of my team, Fernando and Gabriella.  I was focused at the time on introducing relatively new members to the team and, in my error, I failed to introduce one member who has been with me for quite some time.  We have also since added 3 more individuals to our growing team.  This team is called the Windows Experience Group and we are doing some really exciting work.  You've already met Fernando and Gabriella. Here is the rest of the team.

This release is just a quick bug fix release of an older 1.1.1 version of the plug-in. It’s long overdue but I’ve managed to fix “” problem only couple weeks ago. I’ve distributed the new version to the folks who have reached out to me by email of via blog reporting the issue in the [...]

Nothing pleases the technology bloggers more than the moment when somebody thank them for a helpful blog entry. That is one of the many awesome advantages of the technology blogs. In database arena, the developers, DBAs and evangelists are sharing their tips and tricks through their blogs and this Log Buffer Edition is projecting them [...]

It seems that our friends at Oracle have been pretty busy with the GA release of MySQL Cluster 7.2.

This is not just old wine in new bottles.

While it may be a dot release, it does appear to be a more significant step forward than a dot release would imply.

First off, we are very excited to announce that the Severalnines Cluster Configurator now includes support for 7.2 GA.

As the title of this blog suggests, it is possible, as we have experienced, to deploy 7.2 GA in 288 seconds, i.e. just a few minutes. This was done on m1.large instances on Amazon. We have published a quick how-to deployment guide for Amazon here: http://support.severalnines.com/entries/20916823-installing-on-amazon-ec2.

…