Oracle’s MySQL OEM Tech Tour - Miami :

Tuesday, December 11, 2012
10:00 AM – 2:00 PM

Oracle Office
6505 Blue Lagoon Dr., Suite 400
Miami, FL 33126 Rm: DEMO-4004


Embedding MySQL:
Higher Application Performance and Streamlined Development with MySQL Embedded
Join us and get tips directly from the MySQL technical experts on how to better develop, integrate, secure, and tune MySQL for your application.

MySQL is not only the most popular open source database for Web applications, it's also a popular embedded database relied on by over 3,000 ISVs and technology providers around the world such as Adobe, Dell, Sage and Symantec. Whether for distributed on-premise applications …

MySQL for Excel is one of the newest products of the MySQL on Windows group broadening the way MySQL data can be accessed in an easy and friendly way from within MS Excel. This is the first blog post of a small series aimed to present the current features of this great product and to get feedback from users about ideas for enhancements.

Parallel Universe is now available as part of Linux OS images at Amazon Web Services.
Amazon Web Services is a scalable cloud service provider at http://aws.amazon.com .

Launch Instance -> Classic Wizard -> Community AMIs -> type in “parallel universe” (All Images)

Host OS:
Amazon Linux
Red Hat Enterprise Linux
SUSE Linux Enterprise Server
Ubuntu Server
Cluster Compute Amazon Linux
Cluster GPU Amazon Linux
Cluster Instances SUSE Linux Enterprise Server
Cluster Instances Ubuntu Server

With MySQL 5.6.8 RC available more and more people will start to test installs and upgrades.  This often comes up for some people so I hope this helps some.

If you seeing the error "The server quit without updating PID file" then obviously something recently changed on your environment.

So lets take it step by step:

# /etc/init.d/mysql start
Starting MySQL..The server quit without updating the PID file (/var/lib/mysql/localhost.localdomain.pid).

While yes people do say just move the my.cnf file and restart the database to by pass this error... You need to understand why. Why would moving the my.cnf allow mysql to start? Check the error logs that is how and why you will be able to fix it and get it restarted.

Issue 1:
"Fatal error: Can't open and …

In my three previous MongoDB blogs I wrote about our implementation of Fractal Tree(R) indexes on MongoDB, showing a 10x insertion performance increase, a 268x query performance increase, and a comparison of covered indexes and clustered indexes. These benchmarks show the difference that rich and efficient indexing can make to your MongoDB workload.

Given the high performance of Fractal Tree Indexes, we’ve created a new benchmark to test our ability to handle indexing large …

If you are considering using MySQL and/or MySQL Cluster as the embedded database solution for your application, you should join us for today's webcast where we will discuss how you can cut costs, add flexibility and benefit from new performance and scalability enhancements that are now available in MySQL 5.6 and MySQL Cluster 7.2.  We will cover the top 10 reasons that make MySQL and MySQL Cluster the best solutions for embedding in both shrink wrapped and SaaS provided applications, how industry leaders leverage MySQL products and how you can get started with the latest innovations and support offerings across the MySQL product line.

You can learn more and reserve your seat here.

As always, thanks for your support of MySQL!

Imagine that Microsoft and Apple got into a big fight for the market some 15 years ago and that Apple lost. Big time. Apple went down completely and there was nothing left. And as an IT expert, you were called in to look at what remained, what could be salvaged and what was just a waste of everyones time and money.

If you had seen the iPhone back then what would you have said? (I'm not so sure myself, chances are I would have been terribly negative). Note that there would have been no AppStore, no HTML5 sites, none of that neat stuff.

Or to make a different analogy: Was VHS better than BetaMax? Well, that depends on who you ask: The end consumer wanting to rent a movie or the techie looking at the specifications of the technology in question.

Just after the second world …

Join major names among MySQL customers by learning to power dynamic database-driven websites with MySQL & PHP.

With the MySQL and PHP: Developing Dynamic Web Applications course, in 4 days, you learn how to develop applications in PHP and how to use MySQL efficiently for those applications! Through a hands-on approach, this instructor-led course helps you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.

You can currently take this course as a:

• Live Virtual Class (LVC): There are a number events on the schedule to suit different timezones in January 2013 and March 2013. With an LVC, you get to follow this live instructor-led class from your own desk - so no travel expense or inconvenience.
• In-Class Event: Travel to an education center to attend this class. Here are some …

SkySQL’s Newest Training Course, “MySQL Database for the Cloud”, Helps DBAs and Developers Find Success in the Cloud  

Increasingly, more organisations are moving their database applications to cloud to take advantage of its superior agility and faster deployment over legacy systems.

read more

Don't you hate disclaimers? I do, but before I do anything else, I must ask that you don't use the techniques below unless you are emailing responsibly.

Today I needed to pull email addresses for people who had signed up to a thing out of MySQL and into MailChimp so that I could actually email them about the thing. MySQL actually has a very cute feature for exporting the results of an SQL query as a CSV file, which I had to look up to remember how to do it. It goes something like this:

My original query*

select u.username, u.email, a.account_name
from users u
inner join accounts a on a.user_id = u.id
where a.status_id = 2;

To write this to a file, we use MySQL's SELECT ... INTO OUTFILE feature, so my query suddenly looks like this:

select u.username, u.email, a.account_name
into outfile '/tmp/users-extract.csv'
from users u
inner join …