Webinar, Talks, and more in April

April 5, 2016

April is busy.

  • First I speak at LonestarPHP on Relational Theory for Budding Einsteins April 6th at 1PM.
  • Then: 5 MySQL Security Vulnerabilities and What to Do About Them
    Live Webinar: Thursday, April 7, 2016 at 10am ET/2pm GMT Regsiter Here
  • Collaborate is the BIG Oracle User Groups conference in Las Vegaand you can find me in the Oracle DemoPod Area or at my talk on MySQL Certification.
  • Percona Live Data Performance Conference
  • Linuxfest Northwest where I will be speaking on the MySQL JSON Data Type and The Proper Care and Feeding of a MySQL Database for Linux Admins.
  • And finally it is MySQL Innovation Day
  • And I was interviewed By Cloudways.


MySQL NYC Meetup Wednesday!

July 13, 2015

The MySQL NYC Meetup is this Wednesday, July 15th in the Oracle office at 120 Park Avenue. I will be talking about MySQL 5.7 and the event is free but you must RSVP by 6PM July 14 (and bring ID).


Mountain Moodle Moot and MySQL in Montana

June 25, 2014

MySQL is a proud sponsor of the Mountain Moodle Moot, July 9-11, 2014 – Helena, Montana. Mountain Moodle Moot Logo There will be sessions back-to-back covering query tuning, system tuning, and little known tricks using MySQL Workbench. This years Moot is already SOLD OUT.

Moodle is a learning management system and very popular with many schools across the world.

There are 3 three amazing social events planned for Friday afternoon – sponsored by Oracle/MySQL. Lunch, a tour train ride and a great social at the Blackfoot Brewery complete with tour and brews.

If you have your ticket and want me to cover anything specific in my sessions, please let me know!


MySQL Community Team at PHPTek, Drupalcon, Texas Linux Fest, SELF, Redhat Summit, and Lonestar PHP

May 9, 2013

This is the start of the heavy travel season for the MySQL Community Team. So if you are attending PHPTek, Drupalcon, Texas LinuxFest, SELF, Redhat Summit, or Lonestar PHP please make sure to say ‘hi’ while you are in Chicago, Portland, Austin, Charlotte, Boston, or Addison. This group of trips is starting with a swag bag full of MySQL stickers, thumb drives, and ‘boogie bots’

MySQL Boogie Bots

    Talks

  • PHPTek – Ten Things to Make Your MySQL Servers Faster and Happier — May 16th, 2:45p – 3:45p
  • Texas Linuxfest – The Proper Care and Feeding of a MySQL Database for Linux Administrators — May 31st, 11:25a – 12:20p
  • SELF – Two full days of MySQL talks but I am talking on Ten Things to Make Your MySQL Servers Faster and Happier. MySQL 101, MySQL User Administration — June 8th – 9th
  • Redhat Summit – Big & Traditional Databases — June 12th, 4:40p – 5:50p</li?

MySQL Basics — mapping territory

January 28, 2013

This blog entry is on a step that many DBAs either skip, ignore, or do not know about. My last entry was on some install tricks and this time I want to cover where to put the various pieces of a MySQL server if you are looking to maximize performance. George Trujillo covered this for Oracle DBAs transitioning to MySQL but generally you do not see a lot of best practices information on this subject.

1. Pick a spot on a drive for the server software. It does not matter if it is /opt/mysql, /usr/local/mysql, or some variant.
2. Pick a spot on another drive that is on another disk controller for the log files.
3. Pick a spot on yet another drive that is on yet another disk for the data. Or get different spots for the various schemas you have to support — accounting, manufacturing, shipping all on different drives and controllers.

The more you separate the various pieces, the less bottle necks in the hardware will arise. With the data, programs, logs, and everything else on the system on one disk it is very easy get to the point where waiting for the disk to complete a prior read/write to complete. Given a preference, splitting the pieces to different controllers would be the best. But sometimes you get stuck with having to use one controller (and it will take away some potential performance).

The biggest points of contention will be log files, especially if you are using replication, and the data. So if you can only get two separated drives/controllers, please do split these two up.

But what if you are corporately mandated to use a SAN? Well, SANs are very useful. But if you are trying to eek that last 15% out of a server, then you need to get off that SAN. Virtual environments have a similar problem in that visualization itself if not going to be as fast as running the same code on the real hardware. If you are required to be on the corporate SAN check with the SAN administrators to see if there is some way to cut down on contention.

RAID? RAID 1, 5 or 10? Yes. Please use RAID and go with the level you are most comfortable with. Paranoia unfortunately pays off over time with disk drives. And a good RAID does not mean you do not have to make backups.

And if you are just starting out with a single instance on an old laptop or desktop in order to learn MySQL, then you are not concerned with performance – yet – and you can get by on a single disk. But please starting looking at the variable that point to where various items are stored. Hint SHOW VARIABLES LIKE ‘%DIR%’;


BIRT Road Shows

January 18, 2013

BIRT is a wonderful Business Intelligence tool that lets MySQL DBAs generate smart looking reports from from their databases. Currently they have a North American Road Show crossing the continent that provides a FREE day of training.

If you are near Tampa, Oakland, Indianapolis, Dallas, Toronto, Princeton, Minneapolis, Arlington, Chicago or Carlsbad then you should look into attending one of these classes. Some of the in-class exercises involve getting data from a sample MySQL database. I highly recommend that you attend.


MySQL.Com logins transitioning to Oracle SSO

December 18, 2012

The old MySQL.com logins will go away on Wednesday, December 19th and will be replaced by the Oracle Single Sign On (SSO).

Oracle SSO

This Oracle SSO will replace the old MySQL.Com login starting December 20th.

So what do you do? Go to Oracle.com and login. If your account was migrated you will be able to login. But the crimson invalid login message will require you to set up a new account. Some may be wary of providing more personal information. But this is being done to bring the MySQL.com web sites into compliance with our corporate rules and provide a better flow for those of you using more than one Oracle product.

Q: Will this affect voting statistics on Plant.MySQL.Com?
A: Probably. The run away leaders have been Giuseppe Maxia and Mark Callaghan, by very wide margins.

Q: Can I re-register with my old email and password if my account was not moved?
A: Yes.

Q: Can I opt out of sharing my information?
A: Yes, you pick how much information you want to share with Oracle or third parties.