Percona announces the release of Percona Server for MySQL 5.7.23-24 on November 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-24 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free.

This release introduces InnoDB encryption improvements and merges upstream MyRocks changes. Also, we’ve improved the usage of column families in MyRocks. The InnoDB encryption …

We are happy to confirm that we are ready for another two shows which will take place this week. One in the US second in Europe. Please find details below:

• PHP[World]

  • Place: Washington DC, US
  • Date: November 14-15, 2018
  • MySQL Community team is a Workshop sponsor here with David Stokes, the MySQL Community Manager as MySQL representative on site. 
• BGOUG
  • Place: Pravets, Bulgaria
  • Date: November 16, 2018
  • MySQL sponsors & attends this show for years. This year Georgi Kodinov, the Senior Software Developer Manager for MySQL will have a talk on "Data Masking in MySQL Enterprise 5.7 and 8". …

We are happy to announce that this Thursday, November 15 at 7:00 p.m., there will be a MySQL meetup in Madrid, Spain. Please find more details below:  

• Date: Nov 15, 2018
• Time: 7:00-9:00pm
• Place: booking.com @ Torre Europa Paseo de la Castellana 95, Planta 11 · Madrid
• Agenda:
  • Morgan Tocker: "TiDB: Distributed, horizontally scalable, MySQL compatible”
  • Simon Mudd: "Vitess and MySQL Cluster" More information & registration can be found on the Meetup website: https://www.meetup.com/Madrid-MySQL-users-group/events/255291731/  

Do not forget to register on the page if you are coming.

DOAG 2018 Conference + Exhibition will be held November 20 - 23, 2018 in Nuremberg. Participants will have the opportunity to attend more than 400 talks and international top speakers, plus a wide choice of workshops and community activities. This is a great opportunity to expand your knowledge and benefit from the know-how of the Oracle community. 
As in the past years we will be present with more than 10+ specific MySQL talks from various MySQL customer and MySQL experts. 
During the 3 conference days, you'll have the chance to meet the MySQL and Cloud experts from 9am-12am at Cloud Café at the Oracle booth (3rd floor, 320) or you arrange a meeting with us: mysql-sales_de@oracle.com.

We have sent requests and also received candidatures for the MySQL, MariaDB & Friends Devroom Committee. Now we are happy to announce you the name of the people who will rate your submissions:

• Daniël van Eeden (for the Community)
• Art van Scheppingen (for the Community)
• Giuseppe Maxia (for the Community)
• Aurélien Lequoy (for the Community)
• Tom de Cooman (for Percona)
• …

This is a quick reminder that this week there are 2 MySQL User Group Meetings (Amsterdam and Madrid) where we will be talking about Scaling MySQL. Guest speaker will be Morgan Tocker from PingCap who will talk about TiDB. More information: MySQL User Group NL  meetup taking place on Monday (presenting: Morgan, Daniël and Simon) … Continue reading Reminder: MySQL User Group NL and Madrid MySQL User Group Meetups presenting Scaling MySQL this week (Monday/Thursday)

The post Reminder: MySQL User Group NL and Madrid MySQL User Group Meetups presenting Scaling MySQL this week (Monday/Thursday) …

Tweet

The other day, I was reading a blog by Magnus Hagander about tracking foreign keys throughout a schema in PostgreSQL. I thought it was a good idea, so I decided to look at how you can track foreign key in MySQL.

The way I decided to do it was to start out with a table, then find all tables referencing the table by a foreign key. From this basic (and simple as it will be shown) query, it is possible to create a chain of relations. The key table for the queries is …

Scenarios:-

I met with requirements where database has to generate business error if users are try to fetch  more than 1000 records from table.

Solutions:-
In MySQL to handle business error , we have to implement SIGNAL/RESIGNAL in code business logic.
This enable us to any time we can break our execution of code flow & generate Business Error as per our Requirements. 
There is no privileges are required to execute SIGNAL/RESIGNAL statement.
To handle normal error block, we have DECLARE CONTINUE/EXIT HANDLER ... Block , what it does is when ever encountered error during code execution HANDLER Block triggered and manage code execution inside of it. it is more flexiable because developers gets flexibility to write multi-statements inside HANDLER blocks.
More Info: https://dev.mysql.com/doc/refman/8.0/en/resignal.html
      …

The old adage that time is money does not give any hints about buying more time. A MySQL Enterprise subscription does allow you to purchase time. Your technical staff has to do more with less time than ever before and operational delays add up extremely quickly.  Having the right tools when things go critical means staff can do what they need to do, when they need to do it.

So how does MySQL Enterprise Edition buy you more time?

When things inevitably go wrong, searching for free answers to problems on web sites with many dubious or flat out wrong solutions is a waste of precious time.  Informational websites like are fine sources of general information for researching technical issues but not when mission critical services are degraded or down.  An online recommendation to do what very large Enterprise Company does may not make sense for your company if you are not …

JSON has proven to be a very import data format with immense popularity. A good part of my time for the last two or so years has been dedicated to this area and I even wrote a book on the subject.  This is a comparison of the implementations of handling JSON data in MySQL and MariaDB. I had requests from the community and customers for this evaluation.


JSON Data Types Are Not All Equal
MySQL added a JSON data type in version 5.7 and it has proven to be very popular.  MariaDB has  JSON support  version 10.0.16 but is actually an alias to a longtext data type so that statement based replication from MySQL to MariaDB is possible.

MySQL stores  JSON documents are …