Author Archives: OpenSorceDBA

Early Bird Pricing for MySQL Central @ Oracle Open World Extended to August 1st

Register before August 1st for early bird pricing!

Millions of organizations around the world trust MySQL to power their business-critical web, cloud, and embedded applications. Want to learn best practices to develop next-generation applications with MySQL? Joins us at MySQL Central @ OpenWorld.

Highlights
Learn new skills
Share and network with the global MySQL community
Hear about new MySQL features directly from Oracle
Get insight on product roadmaps
Have fun

1 Comment

Filed under Oracle Open World 2014

Inaugural Meet-up Oklahoma City MySQL Meetup

The inaugural Meet-up Oklahoma City MySQL Meetup is Wednesday, July 23, 2014!
As a special guest speaker, Peter Zaitsev (CEO of Percona and co-author of High Performance MySQL) will be giving a presentation on “Best Indexing Practices”, followed by a Q/A session.

Please RSVP if you plan to attend so we can get a good headcount for food and beverages that will be provided and as always, please spread the word to friends or colleagues in the industry.

It should be a great night and great first event for the MySQL user group in OKC!

1 Comment

Filed under User Group

North Texas MySQL Users Group Meeting RSVP

Please RSVP for next Monday’s North Texas MySQL Users Group Meeting so we will know how much pizza to order.

MYSQL Tuning Trick for Queries and Server Tuning
Monday July 14th 6PM!

Event is free to the public. Newbies welcome!

Presented By: Dave Stokes, MySQL Community Manager North America, Oracle Corporation

Plus meet Oracle Ace, Oracle MySQL Ace, and IOUG Big Shot George Trujillo who has recently moved to DFW.

Oracle Corporation
6031 Connection Drive
Suite 900 Room 9068
Irving, TX 75038

Start :Monday, July 14, 2014 6:00 PM

1 Comment

Filed under User Group

MySQL APT Repository

THe MySQL APT Repository provides an easy and convenient way to get the latest MySQL software. My test server was need of a refresh so I put on a fresh install of Ubuntu 14.04 and downloaded mysql-apt-config_0.2.1-1ubuntu14.04_all.deb.

sudo dpkg -i mysql-apt-config_0.2.1-1ubuntu14.04_all.deb
[sudo] password for dstokes:
Selecting previously unselected package mysql-apt-config.
(snip)

You will get a choice to install MySQL 5.6 or the latest 5.7 DMR.

sudo apt-get update Pulls the latest information from the repository for the various packages.

sudo apt-get install mysql-server Installs the server and will start it running. And then a quick sudo apt-get install mysql-workbench to get me where i needed to be.

There is a detailed information at A Quick Guide to Using the MySQL APT Repository

2 Comments

Filed under Administration, Basics

Log Changes with MySQL 5.7

Most MySQL-ers quickly learn to move logs out of the data directory. Hopefully the logs are being written to a different disk, on a different controller than where the data is being kept. The horror of finding you database server dead to the world because the single partition used for everything was filled up by the error log should be a thing of the past. MySQL 5.7 will give DBAs better control of log files,

As of 5.7.2, we have gained the ability to control the verbosity of error messages with log_error_verbosity. This system variable controls verbosity in writing error, warning, and note messages to the error log. A value of 1 provides errors only, 2 adds warnings, and 3 adds notes. The default value is 3. And with that with level 3, aborted connections and access-denied errors for new connection attempts are written to the error log.

The good ol’ log_warnings is being deprecated in favor of the added flexibility from log_error_verbosity.

And with MySQL 5.7.2, the log_timestamps system variable lets you set the timestamp time zone of messages written to the error log, the general query log, and slow query log files. The choices are UTC (the default) and SYSTEM (local system time zone). Previously messages use the local system time zone.

Please note that as of MySQL 5.7.2, the ID included in error log messages is that of the thread within mysqld responsible for writing the message. This indicates which part of the server produced the message, and is consistent with general query log and slow query log messages, which include the connection thread ID. Earlier releases use the ID of the mysqld process in error log message.

1 Comment

Filed under DBA Tools, Security

North Texas MySQL Users Group Meting July 14th 6PM

The North Texas MySQL Uxer Group will meet July 14th in the Oracle office in Irving at 6PM. Part of the topic will be MySQL query & server tuning with MySQL Workbench and part will be a surprise from Oracle ACE, Oracle MySQL ACE, and IOUG big shot George Trujillo who was recently relocated to the Dallas / Fort Worth Area.

And yes, pizza will be served ’cause pizza makes user groups run.

6031 Connection Drive
Suite 900
Irving, TX 75039

1 Comment

Filed under community team, User Group

Mountain Moodle Moot and MySQL in Montana

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!

1 Comment

Filed under community team, MySQL Workbench

MySQL Central at Oracle Open World Sessions

Fifty eight sessions, tutorials, and birds-of-a-feather gatherings at MySQL Central at Oracle Open World! Be sure to check out the following sessions (my favorites) and register ASAP as tickets will go quickly.

  • MySQL and Tech Women (or Where Are All the Tech Women?) Erin O’Neill San Francisco MySQL meetup
  • MySQL & GIS Alexander Rubin Percona
  • The MySQL SYS Schema Mark Leith Oracle
  • MySQL 5.6 at Twitter Calvin Sun Twitter & Inaam Rana Twitter

1 Comment

Filed under community team

MySQL SELF

MySQL is proud to be a Diamond Sponsor of the Southeast Linxufest June 20-22nd in Charlotte. There is a Zero to DBA track again this year. Be sure to check out the program. I will be speaking on MySQL 5.7, Query Tuning, and Big Data. Drop by the booth for BoogieBots, heavy duty luggage tags, and to talk MySQL.

1 Comment

Filed under community team

MySQL Fabric a big hit at Texas Linuxfest

MySQL was proud to return as a sponsor of the Texas Linuxfest last weekend. Over 700 tickets sold and I probably talked to all bu two or three. Luckily I had help from Quality Assurance Guru Jeb Miller and Software Release Manager Hema Sridharan as things got very busy. The crowd was really supportive of us, MySQL, and extremely friendly.

MySQL Fabric was a popular topic of discussion. Evidently playing ‘who has the virtual IP address’ is a big problem for DevOps staffs and Fabric solves that issue. Many in attendance were on the verge of needing to shard their data and liked having a tool to manage the work for them.

And Workbench 6.1 is extremely popular. Me, “Have you seen the latest MySQL Workbench in action?” Attendee, “Yes, I use it all the time and ti has really become awesome in the last year!” Many non-DBAs who have to look after MySQL instances love the admin tools over fat finger on the command line.

So next June plan to be in Austin to see the bats come out at midnight, hear some great music on 6th Street, eat yourself silly on South Congress, and attend the best Open Source event in the Lone Star State.

2 Comments

Filed under community team, MySQL Fabric