The MySQL Development team is happy to announce our 8.0.2 development milestone release (DMR), now available for download at dev.mysql.com. (8.0.2 adds features to 8.0.1 and 8.0.0). The source code is available at GitHub. You can find the full list of changes and bug fixes in the 8.0.2 Release Notes.…

Dear MySQL users,

MySQL Connector/Python 8.0.4 dmr is the fifth development release of the
MySQL Connector Python 8.0 series. This series adds support for the new X
DevAPI. The X DevAPI enables application developers to write code that
combines the strengths of the relational and document models using a
modern, NoSQL-like syntax that does not assume previous experience
writing traditional SQL.

To learn more about how to write applications using the X DevAPI, see
http://dev.mysql.com/doc/x-devapi-userguide/en/.

For more information about how the X DevAPI is implemented in
MySQL Connector/Python, and its usage, see
http://dev.mysql.com/doc/dev/connector-python

Please note that the X DevAPI requires MySQL …

Introduction I either have time for reading or writing, but not both. Now that the first edition of High-Performance Java Persistence is done, I can catch up on the many books I planned on reading but didn’t have time to do so. In this post, I’m going to review High Performance MySQL by Baron Schwartz, … Continue reading Book Review – High Performance MySQL (3rd edition) →

Today i am going to share with you how to create custom contact form in PHP and store in mysql database You can simply create enquiry form or feedback form with validation using bootstrap designContact US Or Feedback form is a very basic feature of every website because that way customer can co

Today i am going to share with you how to create custom contact form in PHP and store in mysql database You can simply create enquiry form or feedback form with validation using bootstrap designContact US Or Feedback form is a very basic feature of every website because that way customer can co

I am starting a series of videos on the MySQL Document Store. The Document Store allows those who do not know Structured Query Language (SQL) to use a database without having to know the basics of relational databases, set theory, or data normalization. The goal is to have sort 2-3 minute episodes on the various facets of the Document Store including the basics, using various programming languages (Node.JS, PHP, Python), and materializing free form schemaless, NoSQL data into columns for use with SQL.

The first Episode, Introduction, can be found here.

Please provide feedback and let me know if there are subjects you would want covered in the near future.

MySQL 5.6 introduced  the fractional second precision for temporal data types – TIME, DATETIME, and TIMESTAMP,  with up to microseconds (6 digits) precision. Along with providing fractional second precision, the new implementation for temporals is disk efficient.

What is an “Old Temporal”?…

In this blog post, I’ll look at a trick we use at Percona when upgrading to MySQL 5.7.

I’ll be covering this subject (and others) in my webinar Learning MySQL 5.7 on Wednesday, July 19, 2017.

We’ve been doing upgrades for quite a while here are Percona, and we try to optimize, standardize and improve this process to save time. When upgrading to MySQL 5.7, more often than not you need to run REPAIR or ALTER via mysql_upgrade to a number of MySQL tables. Sometimes a few hundred, sometimes hundreds of thousands.

One way to cut some time from testing or executing mysql_upgrade is to combine it with mysqlcheck. This identifies tables that need to be rebuilt or repaired. The first …

I’m using MariaDB 10.1.21, with the mha 0.56. I tried everything, and it showing the below error.

Fri Jul 14 06:18:52 2017 – [error][/usr/share/perl5/vendor_perl/MHA/ServerManager.pm, ln492] Server 10.16.14.224(10.16.14.224:3306) is dead, but must be alive! Check server settings.
Fri Jul 14 06:18:52 2017 – [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations. at /usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm line 399
Fri Jul 14 06:18:52 2017 – [error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers.
Fri Jul 14 06:18:52 2017 – [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

Can you help on fixing this?

ps: MySQL replication is working fine.

…

MySQL is proud to announce that we are going to support and actively attend a very unique event BuzzConf in Australia. It’s hold on December 1-3, 2017 in Phoenix Park, AU.
BuzzConf is a family-friendly technology festival with a really unique atmosphere – all participants and presenters spend the weekend together in country Victoria, learning and playing with tech during the day and being entertained by live music all night!
Whether you want to give a talk, run a workshop, lead a kids track session, or entertain the masses during the festival, BuzzConf wants to hear from you!

The Call for Presenters runs until August 4, so there’s not long to get an idea in – but plenty of time to nut out all the final details should an idea from your community be selected for the program.
Find out what makes BuzzConf different at  …