Tag: MySQL 8.0

Feed: Planet MySQL; Author: Chandan Kumar; How to Deploy MySQL InnoDB Replica Set in Production? Before i talk about Deployment process of MySQL InnoDB Replica Set , it is more important to know below details:- What is MySQL InnoDB Replica Set? What is prerequisite and limitation of using MySQL Replica Set?  In what kind of scenarios MySQL Replica Set is not recommended.  How to configure and deploy MySQL Replica Set- (step by step guide ) How to use InnoDB Replica Set? What if Primary goes down? Does select query re-routed to another server? What if Secondary goes down while executing ... Read More

Feed: Planet MySQL; Author: Olivier Dasini; February 17, 2020 Presentation of some of the new features of MySQL 8.0.19 released on January 13, 2020. Agenda InnoDB ReplicaSet SQL Improvements Table Value ConstructorsLIMIT in recursive CTEALTER TABLE… DROP/ALTER CONSTRAINTMore information to Duplicate Key Error Account Management Enhancements Time zone offset for Timestamp & Datetime Information Schema views for SQL Roles MySQL Document Store Enhancements MySQL Shell Enhancements MySQL Router Enhancements MySQL InnoDB Cluster Enhancements MySQL Replication Enhancements MySQL NDB Cluster Enhancements MySQL Enterprise New Features Thanks to the Contributors Download this presentation and others on my SlideShare account. Thanks for using MySQL! ... Read More

Feed: Planet MySQL; Author: Corrado Pandiani; This is the second part of a two-articles series. In the first part, we introduced the Common Table Expression (CTE), a new feature available on MySQL 8.0 as well as Percona Server for MySQL 8.0. In this article, we’ll present the Recursive Common Table Expression. SQL is generally poor at recursive structures, but it is now possible on MySQL to write recursive queries. Before MySQL 8.0, recursion was possible only by creating stored routines.What is a Recursive Common Table Expression?A recursive CTE is one having a subquery that refers to its own name. It ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; What a great event ! I got very positive feedback for this extended preFOSDEM MySQL Day 2020. Before my summary, I wanted to thank again all speakers and attendees. Without you this event won’t even exist. And thank you to ICAB for hosting us yet another time ! As you may know, we had 2 parallel tracks for 2 consecutive days. We had very valuable technical content from the MySQL developers and also from the external community members who talked about their favorite database. There was a large interest in MySQL NDB Cluster and ... Read More

Feed: Planet MySQL; Author: Corrado Pandiani; This blog is the first part of a two-articles series. In this article, I’m going to introduce the Common Table Expression (CTE), a new feature available on MySQL 8.0, as well as Percona Server for MySQL 8.What is a Common Table Expression?We can define a CTE as an alternative to a derived table. In a small way, CTE simplifies complex joins and subqueries, improving the readability of the queries. CTE is part of ANSI SQL 99 and was introduced in MySQL 8.0.1. The same feature is available even on Percona Server for MySQL 8.0.The ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; The MySQL 8.0 DBA Certification is now available. 85 questions to get the first MySQL 8.0 certification ! You can find details on the Oracle Exam 1Z0-908 page. This exams covers mostly all relevant topics for all MySQL 8.0 Administrator and you can register for it on Pearsonvue’s website. Good luck if you are taking the exam ! Artwork credits: student by Wilson Joseph and Certificate by Berkah Icon from the Noun Project ... Read More

Feed: Planet MySQL; Author: Dave Stokes; 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:ArchitectureConfigure client connections to the server Understand how MySQL stores ... Read More

Feed: Planet MySQL; Author: Frazer Clement; My post-FOSDEM detox has started - despite preparing by reading some survival guides, I hadn't really fathomed the variety and quantity (and quality) of beer that would flow over four days.  On reflection however, the beer flow has been far exceeded by the flow of tech content and conversation.On Thursday and Friday I attended the pre-FOSDEM MySQL Days fringe event, where there were two tracks of talks and tutorials on MySQL including sessions on : - MySQL Server simplification - MySQL replication tooling improvements - Configuring group replication - Troubleshooting group replication - Using DNS for loadbalancing and failover - ... Read More

Feed: Planet MySQL; Author: MinervaDB; Table of Contents How to interpret “MySQL error 1040 – Too many connections ! ” ? When a client tries to log into MySQL it may sometimes be rejected and receive an error message saying that there are “too many connections“. This means that the maximum number of clients that may be connected to the server has been reached. Either the client will have to wait for another client to log off, or the administrator will have to increase the maximum number of connections allowed. Information about connections to a server can be found using ... Read More

Feed: Planet MySQL; Author: Dave Stokes; i was working on some example code for using check constraints and was fairly happy with my first bit of of code.CREATE TABLE c1 (x INT                    CONSTRAINT x_gt_0 CHECK (x > 0));it worked well and did what I wanted which was to reject data where the value for x was not one or greater. MySQL has allowed you to have constraint checks for many years but they only came to life in 8.0.16.  Before that version the checks were simply ignored.So I was writing some more ... Read More