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.
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 …
[Read more]
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:
[…] View post: MySQL Server 5.6.13 Community Release Notes | InsideMySQL.com […]
When using the bundled memcached that comes with MySQL Cluster and trying to set one of the 'classic' options along with passing the cluster connect string with -e you may end up getting the following message:
ERROR: You can't mix -e with the old options
It can be hard for software engineers to understand the following principle, however it is very important for improving performance and obtaining immediate scalability options. The principle is “Do Less Work”. That is, run less SQL statements.
Just one method to achieving the execution of less SQL statements is to eliminate Row At a Time (RAT) processing. In simple terms, do not perform identical repeating SQL statements in a loop. Relational algebra, and the Structure Query Language (SQL) specification is specifically designed to work with sets of data, or as I describe, Chunk At a Time (CAT) processing.
Customer Example
Your online social media website lets you send messages to multiple friends at one time. You enter the message, select the friends you want to receive the message and click send. While the user waits a moment and gets a success message, behind the scenes the application runs the …
[Read more]Over three years ago, I noticed that there was no STATUS counter for COM_PING commands – something that is useful for ensuring proper configuration of JDBC connection pools. Mark Leith even provided a patch, but it’s never been incorporated. With the advances PERFORMANCE_SCHEMA makes in MySQL 5.6, that’s OK – a STATUS counter becomes somewhat redundant:
mysql> SELECT SUM(count_star) as pings
-> FROM events_statements_summary_global_by_event_name
-> WHERE event_name = 'statement/com/Ping';
+-------+
| pings |
+-------+
| 12 |
+-------+
1 row in set (0.02 sec)
Not only does PERFORMANCE_SCHEMA provide capabilities which
mirror the STATUS counters, it really goes well beyond what’s
capable there. A global counter is interesting, but …
With the release of MySQL Utilities 1.3.4, the standalone (not bundled with the MySQL WorkBench GUI) package is now Generally Available and fully supported. This post will focus on a very important change (the ability to run as a daemon rather than in a terminal) to the mysqlfailover utility which allows you to build a light-weight HA database solution using MySQL Replication.
For a general overview of MySQL Utilities, take a look at this recent webinar or for a deeper dive into using them to setup replication and adding auto-failover of the master function to slaves watch this video and worked example. …
[Read more]