MySQL DBA - An Oracle DBA's Journey

Best Practices for Installing MySQL (MOCA)

2013-04-07T12:45:00.000-06:00

<!--[if gte mso 9]> Normal 0 false false false EN-US JA X-NONE

VMWare VM - The Default Platform for MySQL

2012-07-27T06:07:00.002-06:00

The MySQL Market Continues to Grow I am continuing to see the continued growth of MySQL not only in the SMB market but in Fortune 500 accounts. I recently asked a large customer what their distribution of databases is and they responded with: 2000 Oracle databases 4000 SQL Server databases 6000 MySQL databases MySQL the Internet Database Platform Since taking over MySQL, Oracle has added

Virtualizing MySQL - The Next Big Step

2011-11-20T11:25:00.001-07:00

MySQL is continuing to be a big player in hosting and cloud companies. Two of MySQL's great features are how light weight it is and it's speed. This gives MySQL a lot of advantages over other database vendors. Yet it is also a disadvantage because the other larger database vendors have more infrastructure and tooling that can impact MySQL being chosen as a long term enterprise solution. This

MySQL at Oracle Open World 2011

2011-10-03T10:28:00.000-06:00

It's great to see so many presentations and activities surrounding MySQL at Oracle Open World this year. There are a lot of Dolphins around the conference which is great to see as well. They MySQL reception Tuesday evening is going to be a great opportunity to get caught up with everyone.

Oracle Open World 2011 - Virtualization Activities

2011-09-23T07:09:00.000-06:00

Virtualization is going to be one of the hottest topics at Oracle Open World 2011. Here is a link to track a number of the virtualization presentations. http://www.oracle.com/openworld/oow11-focuson-virtualization-485282.pdf

Where the MySQL Users Conference Should Consider Going

2011-04-20T12:17:00.001-06:00

The MySQL Users Conference and the Oracle Collaborate Conference both finished last week. Since that time there has been a pretty significant bitstream discussing where the MySQL Users Conference should go and what is it's future. Here are a few insights and overviews of MySQL Users Conference: http://tinyurl.com/3zr3kbw http://tinyurl.com/3kl7x6p http://tinyurl.com/y4x3qch http://tinyurl.com

MySQL Growing Faster in the Cloud

2011-02-10T01:18:00.001-07:00

It's been amazing to see the growth of MySQL in the cloud. I'm seeing more customers moving to cloud providers that are offering MySQL platforms running in Virtual Machines. It's interesting to see the way the cloud providers are configuring and delivering the platforms. Virtualization is going to continue to be the deployment method for the delivering of systems in the cloud. There is

MySQL Most Popular Database and Growing

2010-10-23T10:33:00.000-06:00

The great thing about Open Source is that despite proprietary vendors best efforts, they can't control the market for open source. When I first joined MySQL AB years ago, industry analysts estimated there were over 12 million MySQL database servers running. Which is why MySQL has been considered the most popular database. Now conservative estimates are now at 80 million MySQL database servers

MySQL Sunday at Oracle Open World 2010

2010-09-19T09:07:00.002-06:00

MySQL Sunday is an open series and looks like a great start to the Oracle Open World conference. Everyone is waiting to see if there are any announcements for MySQL at the conference from Oracle. I like that they are starting with Edward Scriven and closing with Marten Mickos. Hopefully there will be a lot of questions answered on stated directions and the MySQL 5.5 release and product updates

MySQL at Oracle Open World - San Francisco 2010

2010-08-19T07:55:00.001-06:00

Everybody is very interested in understanding the Oracle message about MySQL. Oracle is responding with a "MySQL Sunday" and a number of excellent presentations throughout the week in San Francisco at Oracle Open World. My session on MySQL is: Session S316920 - The Ultimate Bootstrap for MySQL on Windows There are also a number of excellent old MySQLers and friends presenting like: Sarah

MySQL and Open Source at Oracle Open World

2010-07-21T17:39:00.000-06:00

Oracle Open World is fast approaching. I am definitely looking forward to the MySQL and open source activity at the upcoming Oracle Open World conference in San Francisco. I'm scheduled to deliver a presentation on implementing MySQL on Windows. I am also looking forward to Oracle's first Open World conference with MySQL under the Oracle family umbrella.

MYSQL 5.5 highlights and MySQL Cluster 7.1

2010-04-13T10:43:00.001-06:00

MySQL 5.5 Highlights - It's a lot faster! InnoDB Multiple Buffer Pool Instances Multiple Rollback Segments Extended change buffering and purge scheduling Improved Log Sys and Flush List mutex Improved locking Improved statistics on InnoDB mutexes, rw-locks, threads and I/O operations. Improved performance/scale with Win32, 64 Scales to 32 cores Semi-synchronoous replication Performance

MySQL Users Conference 2010

2010-04-13T08:43:00.018-06:00

Since the Sun acquisition and the following announcement of the Oracle acquisition, the owner of MySQL have been fairly silent in terms of stated directions of MySQL. This has allowed a lot of FUD to be spread throughout the user community. At the MySQL users conference there are going to be some excellent keynotes helping customers get an update on MySQL technology. It will be very

The Journey Continues ...

2010-02-13T14:22:00.001-07:00

I was a leader in the Oracle community who joined MySQL two years ago to learn more about the open source world. The two years at MySQL were fantastic. The extraordinary camaraderie, spirit and energy of the company was unbelievable. I worked with some fantastic people and made a number of life time friends. On Monday I become a full time employee of Oracle, so I've come full cycle.

Ken Jacobs a great advocate of the database user communities

2010-02-08T08:07:00.000-07:00

Ken Jacobs has been a fantastic advocate of the Oracle and MySQL user communites. I met Ken on the board of the Independent Oracle Users Group (IOUG). While Ken was the board liasson on the IOUG board, he was always supporting the Oracle user groups and made very important contributions throughout his time on the board and afterwards. After serving time on the board, Ken was still always

Oracle's Commitment to MySQL, MySQL Releases and Development Cycles

2010-02-07T06:27:00.002-07:00

The last few weeks I am still being asked what is going on with Oracle and MySQL and where is MySQL with it's software releases. So I am going to include some URLs to hopefully answer some of your questions regarding MySQL. Oracle's press release on December 14, 2009 regarding MySQL.http://www.oracle.com/us/corporate/press/042364 Summary list MySQL software releases. A more detailed list can be

Configuring the InnoDB Plugin (1.0.6) in MySQL 5.1.43

2010-02-02T23:01:00.006-07:00

Configuring the InnoDB Plugin (1.0.6) is just as easy in the MySQL 5.1.43 release. There are a few subtle changes in the new release. Set the following parameters to configure the InnoDB plugin in 5.1.43. A few notes: Set the PLUGIN_DIR parameter to the location of the plugin libraries. Verify all the libraries listed below are in the PLUGIN_DIR directory. The PLUGIN_LOAD parameter needs to

Installing MySQL 5.1 on Linux using MOCA

2010-01-14T01:16:00.024-07:00

IntroductionThe following instructions will lay out an installation of MySQL on Linux using the MySQL Optimal Configuration Architecture (MOCA) for someone with fundamental knowledge of MySQL and basic Linux administration skills. MOCA is a set of best practices I put together to lay out a set of guidelines for installing and configuring a MySQL database server. MOCA is designed for someone with

MySQL Conference and Expo 2010

2010-01-12T23:55:00.001-07:00

The MySQL Users Conference and Expo 2010 scheduled for April 12 - 15, 2010 in Santa Clara is definitely a conference I highly recommend you attend if you can. The insights, networking and knowledge gained is invaluable. The fantastic dynamics of the open source community has to be experienced to be understood. :)

Accessing Metadata through Stored Routines

2009-10-24T17:06:00.002-06:00

Accessing metadata can be optimized by using stored routines. Stored routines provide the ability to filter the data in a more useful way. For example, when I'm looking at table data I usually want to look at the index information also. So I use a stored routine called tabinfo that gives me key information I need for tables and indexes. -- Create the tabinfo stored procedure. DROP PROCEDURE

Oracle Versus MySQL Classes

2009-09-28T09:44:00.001-06:00

I'm always being asked what is the difference between Oracle classes and MySQL classes. What are the similarities and what are some of the differences? So I thought I'd jot down a few notes. Course similarities: Oracle Classes MySQL Classes Oracle Database 11g: Introduction to SQL MySQL for Beginners Oracle Database 11g: Introduction for Exp. SQL Users MySQL for Developers

MySQL Continues to be a "Tipping Point" in the IT Industry

2009-09-08T11:34:00.007-06:00

MySQL continues to be a tipping point for the IT industry. In March of 2008 and January 2009 I talked about MySQL being a very important factor in the IT industry. Today, MySQL continues to play an important role in the direction of the IT industry. Some facts about MySQL in a down economy:While technical conferences are being canceled or running at 50% attendance of

Configuring INFORMATION_SCHEMA Plugin Tables for InnoDB Plugin

2009-09-04T11:52:00.001-06:00

There are seven new INFORMATION_SCHEMA tables (plugins) available with the InnoDB plugin. They need to be loaded to be used. New InnoDB Plugins contain information on: Compressed InnoDB tables Compressed InnoDB buffer pool Current InnoDB transactions Transaction Locks Blocking transactions These INFORMATION_SCHEMA plugins are available by setting the plugin-load parmeter: plugin-load=

InnoDB Plugin Parameters

2009-09-04T09:33:00.005-06:00

Here is the set of new parameters available with the InnoDB Plugin 1.0.4 NameScopeDynamicDefault innodb_adaptive_flushingGLOBALYESTRUE innodb_change_bufferingGLOBALYESinserts innodb_file_formatGLOBALYESAntelope innodb_file_format_checkGLOBALYESON innodb_io_capacityGLOBALYES200 innodb_read_ahead_thresholdGLOBALYES56 innodb_read_io_threadsGLOBALNO4 innodb_spin_wait_delayGLOBALYES6

Configuring the InnoDB Plugin (1.0.4) in MySQL 5.1.38

2009-09-04T08:12:00.009-06:00

The InnoDB Plugin (1.0.4) is pretty straight forward configuration. These instructions are for MySQL 5.1.38. There is a new release of InnoDB Plugin with the 5.1.41 release. With MySQL you can use the default version of InnoDB or the new Plugin but not both. If using a non-default configuration make sure and set the plugin_dir variable to point to the ha_innodb_plugin library for your system.