Monday, March 30, 2020

MidWestPHP Conference -- Online -- this Friday

After six solid weeks on the road earlier this year, I was looking forward to taking most of the month of March at home.  Many shows on my schedule have canceled in the wake pf the Covid-19 virus.  One of those shows, Mid West PHP, has morphed into an online conference this Friday.  And did I mention the keynotes and the beginner tracks are FREE!

I will be speaking on new features in MySQL 8.0 on the Enterprise track.

Details at https://midwestphp.org/schedule

Monday, March 16, 2020

MySQL 5.6 End of Life is February 2021

You will be hearing a lot from me and others about the product end of life (EOL) of MySQL version 5.6 which will be February 2021.

Why?

While MySQL 8.0 is a vast leap forward over previous versions and MySQL 5.7 is fantastic, there are a lot of software still running and still dependent on MySQL 5.6.  And those sites running 5.6 need some encouragement to upgrade.

MySQL 5.6 came out in February of 2013 and will no longer be supported in 2021.  It has had a good run but if you are still running 5.6 then you need to upgrade.  And while I urge you to do so sooner than later, I know that some of you have more than full plates and need to plan for this upgrade.

So what you do you? First --  read this blog by my very clever colleague LeFred.

Second -- read the very fine MySQL Documentation.  Remember you can upgrade directly from MySQL 5.6 to 5.7 but those wanting to go to 8.0 still need to make the 5.7 as an intermediate step.  And I really recommend that 8.0 upgrade as it has so many new features and some really big performance gains too.  Heck - The new MySQL Shell (mysqlsh) has a utility to check your MySQL 5.7 instances for potential issues before you upgrade to 8.0!

Third -- do not forget the MySQL Forums and the MySQL Community Slack channel. They are there for you to ask questions and get answers.

Lastly - Do not neglect Planet.MySQL.com to keep track of the pulse of all things MySQL.

And yes, I will be reminding those out there to upgrade up until next February. 

Friday, February 14, 2020

MySQL Support Engineers Sought For Positions in Australia, Russia, Mexico and Philippines

Oracle, the world's premier database company, is hiring expert technical support staff for MySQL - the world's most popular open source database! By joining this proven team of MySQL professionals, you will assist customers in the resolution of their issues with your wide-ranging skill set. From explaining database internals to reviewing schema design, from application architecture review to client code analysis, from best practices definition to defect analysis - customers will look to you for assistance in addressing their needs in a timely, professional manner. You will continually exercise and grow your diverse skills as you deliver the highest quality support possible to customers. Work location is flexible.



Job duties are varied and complex utilizing independent judgment. May have project lead role. 4 years experience with Core products or five years experience with Applications products and have a technical degree i.e., BS Computer Science/Management Information Systems/Science/ Engineering/Math/Physics/Chemistry with a 3.0 GPA OR (for Applications) proven professional/ technical experience, i.e., demonstrating an understanding of Applications at a functional and technical level (preferably Oracle)

Additional Details: Successful candidates will possess the following characteristics and qualifications:

·       Excellent knowledge of the MySQL server (preferably MySQL Cluster) and utilities

·       Experience managing MySQL in production settings

·       3+ years C/C++ or Java software development experience

·       Practical experience with distributed computing

·       Understanding of high availability, load balancing, and performance

·       Understanding of database engine design and implementation

·       Strong troubleshooting skills

·       Strong experience with Linux development environments

·       Proven skills in solving complex issues

·       Ability to pass all levels of MySQL Certification

·       Excellent spoken and written communications skills in English

·       A desire to serve customers with a passion

·       A desire to be a team player within a small virtual community

·       Ability to manage multiple priorities with limited supervision


Detailed Description and Job Requirements

As a member of the Support organization, your focus is to deliver post-sales support and solutions to the Oracle customer base while serving as an advocate for customer needs. This involves resolving post-sales non-technical customer inquiries via phone and electronic means, as well as, technical questions regarding the use of and troubleshooting for our Electronic Support Services. A primary point of contact for customers, you are responsible for facilitating customer relationships with Support and providing advice and assistance to internal Oracle employees on diverse customer situations and escalated issues.

As a Sr. Support Engineer, you will be the technical interface to customers, Original Equipment Manufacturers (OEMs) and Value-Added Resellers (VARs) for resolution of problems related to the installation, recommended maintenance and use of Oracle products. Have an understanding of all Oracle products in their competencies and in-depth knowledge of several products and/or platforms. Also, you should be highly experienced in multiple platforms and be able to complete assigned duties with minimal direction from management. In this position, you will routinely act independently while researching and developing solutions to customer issues.

Job duties are varied and complex utilizing independent judgment. May have project lead role. 4 years experience with Core products or five years experience with Applications products and have a technical degree i.e., BS Computer Science/Management Information Systems/Science/ Engineering/Math/Physics/Chemistry with a 3.0 GPA OR (for Applications) proven professional/ technical experience, i.e., demonstrating an understanding of Applications at a functional and technical level (preferably Oracle)

As part of Oracle's employment process candidates will be required to successfully complete a pre-employment screening process. This will involve identity and employment verification, professional references, education verification and professional qualifications and memberships (if applicable).

Job: Support
Travel: No
Job Type: Regular Employee Hire
Organization: Oracle
Locations; Australia, Russia, Mexico and Philippines

For more information see Russia Mexico Australia Philippines  

Russia: https://oracle.taleo.net/careersection/jobdetail.ftl?job=20000018&lang=en
Mexico: https://oracle.taleo.net/careersection/jobdetail.ftl?job=200000ZL&lang=en
Australia: https://oracle.taleo.net/careersection/jobdetail.ftl?job=19001JEU&lang=en
Philippines: https://oracle.taleo.net/careersection/jobdetail.ftl?job=190019PY&lang=en



Thursday, February 13, 2020

The MySQL Track at the Southern California Linux Expo 2020

  Friday March 6th you need to be in Pasadena, California for the MySQL Track at the Southern California Linux Expo. SCaLE is the biggest open source show in North America and the only one in the great Los Angeles area. 

  We have been lucky to have a MySQL track for the last several years and this year I think we have the best lineup ever!  We start at 9:30 in room 101 with Michael Marx's presentation on InnoDB Cluster, then switch to Building a Database as a Service on Kubernetes by Lucy Burns and Abhi Vaidyanatha.  Next Alexander Rubin speaks on Protecting Personal and Health Data in MySQL before lunch.

After lunch comes Implementing MySQL Database-as-a-Service using Open Source tools by Matthias Crauwels. That session is followed by sessions on isolation levels by Pep Pla, new MySQL feratures by me, and PMM from Peter Zaitsev.

And we finish with an ProxySQL introduction from the always entertaining Solomon Chang.

So please attend the MySQL track and drop by the MySQL booth in the expo hall.

Thursday, February 6, 2020

MySQL 8.0 DBA Certification Exam Now Available

You can now earn your MySQL 8.0 DBA Certification Exam is now available. It is Oracle Exam 1Z0-908 and I was one of the many question writers.  Some of you may remember when I was the head of MySQL Certification and I can assure you this is a very complete test of all your MySQL DBA skills. And it asks very relevant questions and not trivial facts. So anyone taking this exam and earning this certification really knows their MySQL!

So what do you need to know:

Architecture

  • Configure client connections to the server
  • Understand how MySQL stores data
  • Understand how InnoDB stores data and logs
  • Configure buffers and caches
  • Understand and use the Data Dictionary

Security

  • Create user accounts and roles
  • Use authentication plug-ins
  • Control user and role permissions
  • Recognize common security risks
  • Secure MySQL server connections
  • Provide password and login security
  • Secure the MySQL host environment
  • Prevent SQL injection attacks
  • Encrypt MySQL data
  • Configure MySQL Enterprise Firewall

Query Optimization

  • Examine how MySQL optimizes queries
  • Analyze queries with MySQL Enterprise Monitor
  • Create indexes to improve server performance
  • Monitor and understand index statistics

High Availability Techniques

  • Explain how replication provides high availability and scalability
  • Configure replication
  • Explain the role of the binary log in replication
  • Configure multisource replication
  • Explain the role of replication threads
  • Monitor and troubleshoot replication
  • Describe MySQL InnoDB cluster and Group Replication
  • Configure a MySQL InnoDB cluster
  • Perform an InnoDB cluster recovery

Server Installation and Configuration

  • Install and use the MySQL server and client programs
  • Identify the files and folders created during installation
  • Start and stop MySQL
  • Upgrade MySQL
  • Configure MySQL by using options and option files
  • Configure MySQL variables
  • Launch multiple MySQL servers on the same host

Monitoring and Maintenance

  • Configure and view MySQL log files
  • Monitor MySQL processes and status
  • Configure MySQL Enterprise Audit
  • Use MySQL Enterprise Monitor to view activity in MySQL
  • Monitor database growth and explain capacity planning
  • Troubleshoot problems with locked resources

Backups and Recovery

  • Distinguish between the different types of backup
  • Implement a backup strategy
  • Backup and restore data with MySQL Enterprise Backup
  • Use mysqldump and mysqlpump to perform logical backups
  • Explain when and how to use raw file backups
  • Back up the binary log

You can register for your exam here.

Tuesday, February 4, 2020

DBA Gym -- Free Workouts to Shape Up Your Database Strengths

Need to pump up your form or at least your third normalized form?  If you want to be a better developer, database administrator, or data expert then you need to know about normalizing your data. What is data normalization? Well Wikipedia says it is is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency.

Did you know there is a free GYM that lets you work on forms.  There are even quizzes  to help you test your knowledge.  This is part of the Oracle Gym and I started the Normally Normalized: Third Normal Form workout

The course states Normalizing your data structures is a key step towards high quality database design. This workout introduces you to Third Normal Form, from Wikipedia and the Database Programmer. And I can assure you that the workouts are brief, fun, and will really pack on mental muscle.

You will need an Oracle login which is free and each workout is short. Actually the two supporting documents and the three quizzes are each 5-6 minutes so in a half an hour you can complete the entire workout, or save each part by itself over a longer time period.

Other Courses are available such as deductive logic, PL/SQL, and knowing the difference between RANGE and ROWS in a windowing function.  Now most of these workout are designed for the Oracle database but the concepts usually fir very well with MySQL too. While me MySQL-ers may not need to use PL/SQL the materials on the higher level concepts are invaluable and the quizzes are going to make you think.

So if you are looking for a challenge or need a quick workout, please check out the Oracle Gym.

Friday, January 31, 2020

MySQL Pre-FOSDEM Days - A Quick Review

A sold out, two-day event with over 30 sessions on various aspects of MySQL is a tough thing to organize and accomplish. But the MySQL pre-FOSDEM Days was an amazing success. If you missed this event then you really missed two full days of presentations by MySQL engineers and subject matter experts from the MySQL Community. 


It all started on Thursday January 30th with Geir Hoydalsvik talking about Simplifying MySQL which not a simple talk.  Big efforts are being made to clean up and modernize the MySQL Server Core code.  Work is being undertaken to change to a Volcano Model for extended flexibility. 

This was followed by Kenny Gryp showing how the new InnoDB Replica Set. Previously it was easier to setup InnoDB Cluster Replication than simple primary-secondary replication. 

From that point on there were two different tracks with many talks on indexing JSON Arrays, detailed information on date-time types, the new redo log, hash joins, the big changes in NDB Cluster, and more. 

The audience members I talked to where impressed with the new features, their access to MySQL engineers, and the quality of the talks.  And on Friday it was topped off by the fantastic community dinner. 

Next year you will hear about the 2021 event and I highly encourage you to participate.  This even has become one of the better 'raw' technical content events on the calendar and anyone running MySQL would greatly benefit from attending.

And a big round of applause for my colleagues from the MySQL Community Team - Lenka Kasparova and LeFred -- for all their hard work and on their accomplishments. Lenka routinely makes miracles happen with the various tasks related to funding while Fred brought the various other components together for a stupendous event.