I’ve just had a new article published with the Software Developers Journal talking about how you can write applications to take full advantage of Continuent Tungsten and Tungsten Replicator.

As a developer of an application there really isn’t a problem better than finding that you have to scale up the application and the database that supports it to handle the increased load. The main bottleneck to most expansion is the database server and in many modern environments that replication is based around MySQL. Application servers are easy to add on to the front-end of your environment.

Read: Qt5 – How to Become a Professional Developer- RELEASED | News | Magazine for software developers, programmers and designers – …

MySQL Connect is taking place in San Francisco September 21-23; Counting over 85 sessions and tutorials, the event represents a unique opportunity to boost your MySQL skills and hear from Oracle's MySQL engineers along with customers, partners and MySQL community members.

Have you signed up yet? If not, you can still save US$300 over the onsite price if you register now!

Here are the top 10 reasons why you should do so:

1. Better understand Oracle's MySQL strategy. Hear straight from the source how Oracle is driving MySQL innovation, and what are the latest developments and roadmaps.
2. Learn about real-world experiences from other organizations. Find out …

Dear MySQL users,

MySQL Connector/C 6.1.1, a new version of the C API for client/server communication for the MySQL database management system, has been released. This version of Connector/C provides full support for MySQL 5.6 protocol. Connector/C is compatible with the client libraries (libmysql).

It includes all the features in the MySQL client library shipped with MySQL servers 5.6 as well as prior versions. You can recompile existing code linked with Connector/C 6.1.0 without any code changes. You can use Connector/C to run and build client applications which communicate with MySQL server versions from 4.1 to 5.6 without a need to do a complete server installation. The release is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/connector/c/

For information on installing, please see the documentation at …

Over time, some options have crept into the MySQL server which are comma separated lists of options. These include SQL_MODE, optimizer_switch, optimizer_trace and a few other variables.

Optimizer_switch is particularly problematic to work with as it contains many options and is hard to interpret. This is what you usually see when you examine optimizer_switch:

index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on

As you can see, seeing which option is on or off is rather difficult. You can use the REPLACE function to make this easier:

mysql> select replace(@@optimizer_switch, ',','\n')\G …

Over time, some options have crept into the MySQL server which are comma separated lists of options. These include SQL_MODE, optimizer_switch, optimizer_trace and a few other variables.

Optimizer_switch is particularly problematic to work with as it contains many options and is hard to interpret. This is what you usually see when you examine optimizer_switch:

index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on

As you can see, seeing which option is on or off is rather difficult. You can use the REPLACE function to make this easier:

mysql> select replace(@@optimizer_switch, ',','\n')\G …

This week we interview Noam Kritzer from the law firm of Bakos & Kritzer about copyright, patents and trademarks. Ear Candy is about SUBSTRING_INDEX and At the Movies is Colin Charles presenting a panel on MariaDB.

Events
DB Hangops - every other Wednesay at noon Pacific time

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

read more

This week, we announced the launch of GenieDB cloud-hosted Globally Distributed MySQL-as-a-Service, our scalable, highly available database-as-a-service (DBaaS).

When I start recounting the many benefits of this new automated platform to build web-scale applications, I fear I might sound one of those late-night infomercials…

“But wait, if you act now, you’ll get all the amazing benefits of geographical database distribution, including: continuous availability during regional outages (whether datacenter or cloud failure, be it hurricane, earthquake or other natural disaster). And that’s not all! You also get better application response time for globally distributed users.”

While our product won’t melt away your waistline, serve as an amazing do-it-all “Omnitool,” or help you stop snoring, we get pretty fired up when we think about our customers who are …

In an earlier post, I commented on clients and utility programs which seem to no longer be useful, and opened (or referenced existing) public bug reports to deprecate and remove, where appropriate.  That effort came actually was the product of a different initiative:  I was looking for clients which might leverage the full spectrum of MySQL protocol commands in an effort to understand whether certain protocol commands are in use.  I thought I would share my observations, in the hope that we might also get feedback from others regarding usage of these commands. And even though it’s no longer spring (I started this post in April), I finally found time to finish this post.

The first group to mention are those which are …

Some users have asked us what is the minimum set of privileges that your Microsoft SQL Server user needs to successfully migrate databases from SQL Server using the MySQL Workbench Migration Wizard. Even though we don’t execute any query that alters anything in your source RDBMS servers, it’s never a bad idea to add an extra security barrier around it.

In short, you need the VIEW ANY DEFINITION permission for the server and the CONNECT and SELECT permissions for the database(s) you want to migrate. But to make this easier for you, we have created a video tutorial showing how to create a user with these permissions using the Microsoft SQL Server Management Studio.

In this tutorial I’m going to show you how to migrate your Sybase Adaptive Server Enterprise databases to MySQL.

As usual, we’ll start with a couple assumptions:

• You have MySQL Workbench 6.0 installed.
• You have a running Sybase Adaptive Server Enterprise database somewhere in your network. I’ll be using the pubs3 sample database that Sybase distributes with Adaptive Server Enterprise 15.
• You have installed the Sybase Adaptive Server Enterprise ODBC drivers in the same PC where MySQL Workbench is running. The ODBC drivers are distributed with the Sybase Adaptive Server Enterprise SDK and included in the Adaptive Server Enterprise Developer Edition.
• A running MySQL Server instance …