MySQL Sunday at Oracle's Open world was a huge success given that it was MySQL's first year at the conference. I had a lot of fun and even a little excitement when a shirt caught fire during my presentation.

Just added a video to the site for MySQL High Availability. Check it out here if you missed it at MySQL Sunday, also, you can get the slides in PDF format here.

You can also check out all the other presentations here, brought to you by PalominoDB.

-- UPDATE --
9-29-10

Recently I was contacted by a fellow community member at Oracle who had some great …

The first ever MySQL Sunday is coming soon to the Bay Area. There are plenty of great speakers with new and interesting material to choose from. Come join us at Oracle's Open World conference and make sure to check out the MySQL Sunday page.

This is going to be a great event that you don't want to miss!

Have a great day and see you there.

Chris

ANDROID SMART PHONE

Senior DATA WAREHOUSING ENGINEER

“We are at the intersection of all things cool in the valley”

We are a Sunnyvale, CA based software applications and services development
team in the heart of Silicon Valley that is combining the best of the internet,
messaging, and social networking into intuitive software, called MOTOBLUR.
MOTOBLUR is an innovative cloud-assisted solution to manage and integrate
messaging, social networking, and other web services and will debut on the
T-Mobile/Motorola CLIQ with MOTOBLUR Android smartphone. This product
aggregates contacts, posts, messages, photos and more from sources including
Facebook®, Twitter™, MySpace®, Gmail™, and Microsoft Exchange and many more to
come.

In collaboration with Google’s Android team, we …

Senior Database Administrator Position: Senior Database Administrator
Job Type: Full-Time
Department: Engineering
Location: San Jose, CA
Responsibilities

• Manage MySQL in production/QA/development environments including installation, configuration, backup, recovery, upgrades, schema changes, etc.

• Perform database health monitoring and diagnostics

• Implement monitoring, auditing and alert systems for MySQL databases

• Troubleshoot and resolve problems with MySQL

• Design, implement, maintain and automate the appropriate backup and recovery architecture required

• Work with various teams for performance tuning and optimization, query optimization, index tuning, caching, buffer tuning, etc.

• Perform capacity planning exercises to properly identify required hardware, software, database configuration/architecture necessary to support …

There's a lot of buzz lately about Hadoop. If you're completely new to Hadoop, I recommend the free videos from Cloudera (http://www.cloudera.com/resources/?type=Training). If you have a vague idea and want to play around, it's easy!
First, download Cloudera's training VM which has a small Hadoop cluster already installed and running: http://www.cloudera.com/developers/downloads/virtual-machine/
Second, you need to put some data into Hadoop. Fortunately for database folks, there's a tool to import data into Hadoop from MySQL called "Sqoop". It's already installed on the VM and there are instructions for using Sqoop to import some MySQL tables into Hadoop (see Desktop/instructions/exercises/SqoopExercise.html inside the VM). FYI, it's not uncommon to "Sqoop" data …

In this note I'll show how to use the color palettes in "slide:ology" by Nancy Duarte (those of us who spoke at the MySQl Conference received it as a nice gift from O'Reilly).
Step 1 is to download Entrance Community edition from our web site: http://dbentrance.com/. You need JRE 1.6 or better and access to a MySQL server to run it. Simply unzip the download and start the program with "java -jar entrance.jar".
To make a chart, click "New" and enter a PLOT command:

   plot

       axislabels, red bar, blue bar, green bar

   select "label", 1, 2, 3;

The SELECT part of the command can be almost any MySQL SELECT statement. (e.g. unfortunately you can't change delimiters yet).
Click "Run" and you have the chart. Now to replace those eye-scorching colors with something better from the book. Take a look at the section "Using the Power of …

We will be demonstrating Entrance Community version in booth 525 at the MySQ User Conference in Santa Clara. Stop by the booth and be sure to mention 'everythingmysql'.
Entrance is a desktop application for drawing charts using data in MySQL databases. If you know a little SQL, browse the documentation page for our PLOT command: http://dbentrance.com/newdocs/en/plotsyntax.html. and I think you will get the idea: Any MySQL SELECT command becomes a chart when you add Entrance PLOT.
Community version is GPLed. We can get help you get set up to both run and build it if you bring a laptop to the booth. (We can also show you the "Animated Shower Curtain" demo made almost famous by the LA MySQL Meetup)
Tod Landis http://www.dbentrance.com/

I'll be presenting two talks this year:

Faster Than Alter - Less Downtime

"This will be a informative talk about real world problem solving and the powerful yet sometimes overlooked LOAD DATA INFILE command. This talk is for MySQL DBAs who want to expand their
knowledge, improve performance and decrease customer facing downtime"

Get Your Replication On: Advanced Techniques, Tips and Tricks

Co-speaking with Sarah Sproehnle for this one! We have lots of interesting uses for replication and some best practices up our
sleeves. Warning: we won't be covering how to set up basic replication
- that's a prerequisite for this talk!

Hope to see you there!

I'll be giving 2 talks this year. Here's a quick description:


Want Faster Queries?
Fixing slow queries is often very easy if you know what to look for and it can give huge performance gains. In this talk I'll cover common SQL mistakes, how to identify "bad" queries, indexing techniques, using EXPLAIN to verify execution plan, etc.


Get your Replication on: Advanced Techniques, Tips and Tricks
I'll be co-speaking with Chris Schneider for this one! We have lots of interesting uses for replication and some best practices up our sleeves. Warning: we won't be covering how to set up basic replication - that's a prerequisite for this talk.

While working with the MySQL Enterprise Dashboard I found a small problem when trying to use the Query Analyzer. The test server I am running on had a user used by the dev team that had the following privileges:

GRANT USAGE ON *.* TO 'test_user'@'10.18.%' IDENTIFIED BY PASSWORD 'HASHNOTGIVEN';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, SHOW VIEW, TRIGGER ON `canoe`.* TO 'test_user'@'10.18.%';
GRANT SELECT on `mysql`.`proc` TO 'test_user'@'10.18.%';

I the agent running on this server is mysqlmonitoragent-2.1.0.1093 and the proxy has been set to receive connections on the default port, 6446. When I try to connect I received the following error:

shell> mysql -utest_user -p --host=m120649.ningops.com --port=6446
Enter password:
ERROR 1045 (28000): Access denied for user 'test_user'@'localhost' (using password: YES)

I …