Author Archives: OpenSorceDBA

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

Fabric Webinar with Andrew Morgan June 19th.

MySQL Fabric – High Availability & Automated Sharding for MySQL

MySQL Fabric is built around an extensible and open source framework for managing farms of MySQL Servers. Currently two features have been implemented – High Availability (built on top of MySQL Replication) and scaling out using data sharding. These features can be used in isolation or in combination. MySQL Fabric aware connectors allow transactions and queries to be routed to the correct servers without the need for a proxy node, so operations run as quickly as ever. MySQL FabricIn this webinar you will learn what MySQL Fabric is, what it can achieve and how it is used – by DBAs, Dev-Ops and developers. You’ll also be exposed to what is happening under the covers. In addition to the presentation, there will be live on-line Q&A with the engineering team. This is a great opportunity to learn about the latest developments directly from the people building them.

WHO:
Andrew Morgan, Principal MySQL Product Manager
Mats Kindhal, Senior Principal Software Developer
WHEN:
Thu, Jun 19: 09:00 Pacific time (America)
Thu, Jun 19: 10:00 Mountain time (America)
Thu, Jun 19: 11:00 Central time (America)
Thu, Jun 19: 12:00 Eastern time (America)
Thu, Jun 19: 13:00 São Paulo time
Thu, Jun 19: 16:00 UTC
Thu, Jun 19: 17:00 Western European time
Thu, Jun 19: 18:00 Central European time
Thu, Jun 19: 19:00 Eastern European time
Thu, Jun 19: 21:30 India, Sri Lanka
Fri, Jun 20: 00:00 Singapore/Malaysia/Philippines time
Fri, Jun 20: 00:00 China time
Fri, Jun 20: 01:00 日本
Fri, Jun 20: 02:00 NSW, ACT, Victoria, Tasmania (Australia)

The presentation will be approximately 60 minutes long followed by Q&A.
WHERE:
Simply access the web seminar from the comfort of your own office.

Register

Leave a comment

Filed under MySQL Fabric, Uncategorized, Webinar

Recruiters Looking for MySQL DBAs and MySQL Developers

Good MySQL talent is hard to find. Each day I get several ‘I am looking for a MySQL DBA’ or ‘MySQL Developer needed’. Long story short, post your opening on http://forums.mysql.com as it catches the most eyes of MySQL Professionals.

1 Comment

Filed under MySQL

MySQL at Texas Linuxfest

MySQL is proud to repeat our sponsorship of Texas Linuxfest

MySQL is a proud sponsor of the Texas Linuxfest and yes we will have Boogiebots at the booth!

MySQL is a proud sponsor of the Texas Linuxfest and yes we will have Boogiebots at the booth!

and we will again be in Austin at the convention center with BoogieBots, heavy duty luggage tags, and the latest MySQL stickers. Last week Drupalcon was in the same hall and we are returning. Plus many local MySQL employees will be in the booth to talk MySQL. So drop by to say ‘howdy’, grab a BoogieBot, and let us know your view on who has the best BBQ(1) or beer(2) in Austin.

  1. The Salt Lick
  2. Jester King

2 Comments

Filed under community team

MySQL 5.7 & Fabric in Sunnyvale May 22nd

MySQL Fabric and 5.7 will be the topics of presentations this Thursday (5/22) at the Plug and Play Tech Center in Sunnyvale, California. Lee Stigile is presenting: What’s new in MySQL 5.7, and Sastry Vendantam is presenting MySQL Fabric.

Agenda is as follows:

5:00-5:30 Networking/Socialize over food and drinks
5:30-6:00 Lee will present MySQL 5.7
6:00-6:30 Sastry will present Fabric
6:30-7:00 Q&A and Socialize over food and drinks

Here is the link to register/RSVP

Plug and Play Tech Center
Thursday, May 22, 2014 from 5:00 PM to 7:00 PM (PDT)
440 N Wolfe Rd
Sunnyvale, CA 94085

1 Comment

Filed under Uncategorized

Triggers — MySQL 5.6 and 5.7

MySQL Triggers are changing in 5.7 in a big way. Triggers have been around since 5.0 and have not changed much up to 5.6 but will gain the ability to have multiple triggers on the same event. Previously you had ONE trigger maximum on a BEFORE UPDATE, for example, and now you can have multiple triggers and set their order.

So what is a trigger? Triggers run either BEFORE or AFTER an UPDATE, DELETE, or INSERT is performed. You also get access to the OLD.col_name and NEW.col_name variables for the previous value and the newer value of the column.

So how do you use a trigger? Let say you are updating the price of an inventory item in a product database with a simple UPDATE statement. But you also want to track when the price change and the old price.

The table for products.
CREATE TABLE products (id INT NOT NULL auto_increment,
price DECIMAL(5,2) NOT NULL,
PRIMARY KEY (id));

The table for price changes on the product table.
CREATE TABLE products_log (id INT NOT NULL,
price DECIMAL(5,2) NOT NULL,
change_date timestamp);

Now to define a trigger that will log price changes. We do this when a price is updated. Now the use od OLD.price to avoid confusion between the old price or the new price being saved in the log.
DELIMITER |
CREATE TRIGGER product_price_logger
BEFORE UPDATE ON products
FOR EACH row
BEGIN
INSERT INTO products_log (id, price)
VALUES (id, OLD.PRICE);
END
|
DELIMITER ;

Add in some data.
INSERT INTO products (price) VALUES (1.10),(2.24),(.99),(.01),(.34);

So UPDATE a record.
UPDATE products SET price='1.11' WHERE ID = 1;

So did it work? Yes, and no. Running SELECT * FROM products_log; Provides us with a time stamp of the change and the OLD.price. But I forgot to also record the id!! Challenge: Correct my mistake and compare it to an update I will make in a few days.

Now 5.7 introduces multiple triggers for the same event. Lets add yet another log this time recording who made the change;

The ‘who made the change table’.
CREATE table who_changed (
id INT NOT NULL,
who_did_it CHAR(30) NOT NULL,
when_did_it TIMESTAMP);

And the second trigger.
DELIMITER |
CREATE TRIGGER product_price_whom
BEFORE UPDATE ON products
FOR EACH ROW
FOLLOWS product_price_logger
BEGIN
INSERT INTO who_changed (id, who_did_it)
VALUES (OLD.id, user());
END
|
DELIMITER ;

So UPDATE products SET price='19.99' WHERE id=4; is run and we see that both triggers execute. Note that SHOW TRIGGERS from schema; does not provide any information on trigger order. But you can find all that as action_order in PERFORMANCE_SCHEMA.TRIGGERS

Being able to order triggers makes it easy to make logical steps when processing data. Can you get into trouble with this? I am certain someone will manage to make a mess with this. But I think most of us will enjoy being able to use this great new functionality.

4 Comments

Filed under Basics, DBA Tools, MySQL, MySQL Certification, Uncategorized