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

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 …

The recently revived MySQL Meetup group had its first meeting. A big thanks to Venu Anuganti, our host and Schooner our sponsor. If anyone is interested in joining the fun please check out the Meetup.com site here.

During our first meetup we went over basic MySQL topics including configuration, performance tuning, locking, along with running MySQL in the cloud. All in all it was a well done presentation and I am looking forward to the next.

Thanks again for getting the Meetup going!

Chris

Lets just get it over with!

"MySQL co-founder David Axmark says "Oracle has no real reason to support" the open-source database it's trying to acquire as part of Sun, but he also says "I doubt they'd 'kill' anything." Rather, the real intrigue will center on what happens when Oracle's database customers want to migrate downstream to MySQL.

From a cbronline.com article quoting Axmark:"

-- FULL Article
http://www.informationweek.com/blog/main/archives/2010/01/oracle_wont_kil.html;jsessionid=R2UWL0QMOQMSHQE1GHPSKHWATMY32JVN