I recently gave a talk about importing and exporting data between MySQL and Hadoop at Oracle Open World.  Here are the slides for that talk:

MySQLandHadoopNov2011.pdf

Apologies for the scheduling conflict but the date has moved to the 20th of July.

 

Save the date: July 20, 2011

RSVP here: Ning-Tech-Talks

There have been many database infrastructure changes through Ning’s history since the company began in 2004. Our most recent, and hopefully final, database iteration is running on MySQL.  Over the past year we’ve designed and implemented a stable and highly available MySQL environment.  MySQL was chosen to reduce Ning’s total cost of ownership and increase overall availability to our customers, Network Creators and their members.

 

Led by Chris Schneider, Ning’s MySQL Architect, join us at this Ning Tech Talk as he explains how we implemented and currently maintain

  [Read more...]

MySQL Ning Meetup Coming Soon

 

Save the date: July 20, 2011

RSVP here: Ning-Tech-Talks

 

There have been many database infrastructure changes through Ning’s history since the company began in 2004. Our most recent, and hopefully final, database iteration is running on MySQL.  Over the past year we’ve designed and implemented a stable and highly available MySQL environment.  MySQL was chosen to reduce Ning’s total cost of ownership and increase overall availability to our customers, Network Creators and their members.

 

Led by Chris Schneider, Ning’s MySQL Architect, join us at this Ning Tech Talk as he explains how we implemented and currently maintain MySQL on the Ning Platform.

 

Pizza, beer and

  [Read more...]

There are many ways you can replicate MySQL data, whether it be a simple two-node cluster, chain or master/master. This article explains the two types of data replication (Statement-Based Replication and Row-Based Replication) available in MySQL.

There are many ways you can replicate MySQL data whether it be a simple two-node cluster, chain or master/master. If you use MySQL you probably know about replication and might have experimented with the replication layouts' listed above. In this article I will explain not the layout of replication and why or why not to use a specific layout but the types of replication you can use. In MySQL, you can use two types of replication, Statement-Based Replication (SBR) and

  [Read more...]

MySQL Workbench has come a long way and keeps getting better! I honestly don't think that millage may vary on this one as it is one of the best no-cost GUI tools created for MySQL.

I've always been pro command line for MySQL administration; however, there have always been powerful GUI tools that can aid administration, development and other tasks. Some great tools that I have used in the past are Toad, Navicat, phpmyadmin, and WebYog. Although all of the tools listed above are good I have had a lot of success with MySQL Workbench, plus it's free.

I should also note that when I do use MySQL Workbench it's more for my QA, test and development MySQL instances. Call me crazy but I think it's just too easy to inadvertently damage production with how easy this tool is to work with. Plus, in most environments you don't want a flock of users

  [Read more...]

Hey everyone,

I always attend the O'REILLY MySQL Conference in April every year, but this year found another interesting conference that brings both Oracle and MySQL users together, KSCOPE11. This will be the second year with a dedicated MySQL track at Kscope11. There will be a clear focus on providing both developers and DBAs the right information, tools and best practices within MySQL, emphasizing scalability and performance.

I'll be presenting "MySQL HA Possibilites" at KSCOPE11 next June.

This talk will cover high availability techniques, sharding fundamentals, third party technologies, and how to decrease the likelihood of

  [Read more...]

I have a new article posted on the Database Journal...

- Abstract -

In the majority of MySQL systems, the schema is always updated and changed based on the needs and focus of the application, making it somewhat difficult to keep up with all of the changes that come down the pipe.

Knowing how to index a schema based on the queries using the system is a great skill to have. In the majority of the systems I have worked on, the schema is always updated and changed based on the needs and focus of the application. That said, it can be somewhat difficult to keep up with all of the changes that come down the pipe, especially if there are many changes every week. To help identify the indexes that are being used there are a few tools out there to help. One of the best resides in the MAAKIT called,

  [Read more...]

Hi Friends

I wanted to let you know that my employer Ning is Hiring! Ning is the largest platform in the world for creating your own custom social network. It's an exciting time to be a part of Ning since we recently decided to focus 100% of the energy of the company on our premium subscription business. Our platform now has over 70,000 paid subscribers, up from 15,000 from before transition from our “freemium” model, and we are currently seeing 80 million monthly unique visitors globally.

Because of this success, we are currently growing our organization and would love to chat with you about your background to see if there is a potential fit for our engineering team. We are hiring for a number of openings -- scalability/infrastructure engineers (We are in the top 100 largest sites in US), application developers (we have a number of killer consumer facing



  [Read more...]

Gear up for the 2011 MySQL Conference!

Get your presentations submitted soon, Call closes 11:59pm 10/25/2010 PDT.

2011 Conference Home Page

Submit a Paper

I've been using MySQL Enterprise Monitor for some time now and have seen it grow from a somewhat clunky (ALPHA version) to a scalable and robust monitoring system. The MySQL Enterprise Monitor makes my job easier in a number of ways. Below is a short list of what I love about MySQL Enterprise Monitor:

Tunable, agent based monitoring

Historic RRD graphs

MySQL Query Analyzer

Replication topology visualization

MySQL Enterprise Monitor was highlighted during "MySQL Sunday" at the Oracle Open World conference this past month. Given the ease of implementation and helpful GUI tools, MySQLEnterprise Monitor (http://www.mysql.com/products/enterprise/monitor.html" target="_blank) provides almost instant benefits for any MySQL shop.

Check out the full article






  [Read more...]

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








  [Read more...]