Tweet

Today 23 May 2020, it is 25 years since the first release of MySQL. So, I would like to take the opportunity to wish MySQL – and Sakila – a happy birthday.

My own MySQL journey started in 2006 when I at a job interview was told that if I got the job, I would need to learn MySQL before starting. Since the job involved PHP coding, I got the book Web Database Applications with PHP and MySQL as well as Managing and Using MySQL. Around a week later, I started in my first job involving MySQL at Noggin Pty Ltd.

The two first MySQL books, I studied.

This was in the days of MySQL 5.0 when stored functions, procedures, and triggers were new, and statement based replication was the only binary log format around. The job evolved into including …

How to Prepare for MySQL Certification Exam

Here I am going to suggest MySQL DBA, student or any newbie that how they can prepare for "Oracle's MySQL 5.x Database Administrator" certification exam. 
Step 1: Lab
-- Prepare your local MySQL lab environment and make sure to install the respective MySQL version on your lab. (i.e., if you are going to appear on MySQL 5.6 DBA exam 1Z0-883 then install MySQL 5.6 on your lab) 
-- You can follow my below blog post to create your local MySQL lab …

This is the third post in the series on Write Set in MySQL.  In the first post, we explore how Write Set allows to get better parallel replication in MySQL 8.0.  In the second post, we saw how the MySQL 8.0 improvement is an extension of the work done in MySQL 5.7 to avoid replication delay/lag in Group Replication.  In this post, we will see how Write Set is used in Group Replication to detect

MySQL Replication allows servers to copy changes from one instance to another. Take the MySQL for Database Administrators course to learn about replication, including:

• How to set up a replication environment
• Complex topologies
• Replication types
• Global transaction IDs (GTIDs)
• MySQL Utilities
• Logs and threads

Replication is one of the many topics covered in the MySQL for Database Administrators course. You can take this 5-day instructor-led course as  

• Training-on-Demand: Start …

Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.

Training helps you acquire product expertise. Certification proves this expertise to your future employers.

There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.

For more information about the authentic MySQL curriculum, go to …

MySQL Utilities provide a collection of command line utilities that make it easy for database administrators to maintain and administer MySQL servers. The utilities perform a range of otherwise complex operations via a simple command, making DBAs more efficient and productive.

There are utilities for copying databases, comparing databases running on different servers, checking disk usage and for redundant or duplicate indexes, automatic failover, verifying replication configuration, cloning a running server, and working with audit logs. You can use all these utilities either standalone or with MySQL Workbench.

You can learn about MySQL Utilities and much more by taking the …

The MySQL 5.6 certification exams (Developer and DBA) are now GA!  A big thanks to all those who sat for the extended length beta exams – and subsequently waited for several months for your results.  Your feedback and the data collected from many beta testers helped ensure the final exams are high quality. A huge thanks also goes to the MySQL staff at Oracle who produced, edited and verified exam questions, in addition to their normal job responsibilities.  In particular, these exams would have never materialized …

Demonstrate your expertise with MySQL 5.6, and improve your career prospects, by taking the new MySQL 5.6 certifications:

• Oracle Certified Professional MySQL 5.6 Database Administrator
• Oracle Certified Professional MySQL 5.6 Developer

These certifications give you a competitive advantage, by proving you have a skill set that is in demand, worldwide, while demonstrating your commitment to continuous learning.You can sign up now for these certifications via PearsonsVue.

To pass these certifications you need to have a good knowledge of the relevant areas of MySQL and significant hands-on …

MySQL is an excellent choice for a low cost embedded database. Over 3,000 ISVs, OEMs and VARs choose MySQL for this purpose and benefit from significant cost savings when compared to using a competing database product.

The MySQL for Developers training course teaches you how to plan, design and implement applications using MySQL. Expert Oracle University instructors teach you through realistic examples, interactive instruction and hands-on exercises.

This course brings you lots of interesting facts. For example, the 'libmysqld' library is effectively a MySQL server in its own right. it is shipped as part of the standard MySQL installation. Developers with C/C++ ability can embed this library easily within their applications and it can do most of what a …

Thousands of people have testified to the value of the Oracle Certification Program as follows:

• 97% said they have benefited from certification.
• 96% would recommend the program to a professional colleague.
• 89% said they gained more confidence in their expertise after becoming certified.

You have until December 21st to take the new MySQL Server 5.6 Certification exams in their beta form. A reminder of what is on offer:

• Oracle Certified Professional, MySQL 5.6 Developer
• Oracle Certified Professional, MySQL 5.6 Database Administrator

Until December …