Tag: MySQL 8.0

Feed: Planet MySQL; Author: Frederic Descamps; With this post we are reaching the end of our journey to HA for WordPress & MySQL 8.0 on OCI. If you have not read the two previous articles, this is just the right time. We started this trip using the MySQL InnoDB ReplicaSet where only 2 servers are sufficient but doesn’t provide automatic fail-over. In this article we will upgrade our InnoDB ReplicaSet to InnoDB Cluster. Therefor we will also need another compute instance for the 3rd recommended node. Architecture Our architecture will be like this: The creation of mymysql03is something you should ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; This article is the second part of our journey to WordPress and MySQL 8.0 High Availability on OCI. The first part can be read here. We ended part I with one webserver hosting WordPress. This WordPress was connecting locally to MySQL Router using HyperDB add-on. This add-on allows to split the reads & writes on MySQL Servers using replication. And finally we had one MySQL InnoDB ReplicaSet of two members serving the database. In this article, we will upgrade our architecture by adding an extra webserver (with MySQL Router) and a load balancer in ... Read More

Feed: Planet MySQL; Author: Valeriy Kravchuk; In my previous post in this series I've commented on some interesting MySQL bug reports that were added during the second half of April. Time to move on to bugs reported in May, 2020, as we are quickly approaching MySQL Bug #100000 soon and I want to write a separate post for this great achievement :) Here is the list:Bug #99432 - "Improving memory barrier during rseg allocation". Nice contribution by my former colleague in Percona, Krunal Bauskar, who now works on making MySQL better for ARM processors. According to his findings, the use ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Today’s article is again related to WordPress and MySQL 8.0. We will see how we can setup MySQL InnoDB ReplicaSet and configure WordPress to split the load using both MySQL Instances: we will split reads and writes between the Primary and the Secondary member of our ReplicaSet. This will be the first part of our journey to achieve HA for our WordPress site on OCI and using all MySQL Servers we have deployed. We don’t want to have a server idle just waiting to take over in case of an incident. MySQL InnoDB ReplicaSet ... Read More

Feed: Planet MySQL; Author: Olivier Dasini; May 26, 2020 Presentation of some of the new features of MySQL 8.0.20 released on April 27th, 2020. Highlight Hash JoinsNew InnoDB Doublewrite BufferIndex-Level Optimizer HintsSHOW_ROUTINE PrivilegeMySQL Shell EnhancementsMySQL Router EnhancementsMySQL InnoDB Cluster EnhancementsMySQL Replication EnhancementsMySQL NDB Cluster EnhancementsMySQL Enterprise New FeaturesThanks to the Contributors Slides Download this presentation and others on my SlideShare account. Video Watch this video and others on my YouTube channel. Thanks for using MySQL! Follow me on twitter Filed under:MySQL, New, Video by Olivier DASINI ... Read More

Feed: Planet MySQL; Author: Codership; Codership is proud to announce the first Generally Available (GA) release of Galera Cluster 4 for MySQL 8 and improve MySQL High Availability a great deal. The current release comes with MySQL 8.0.19 and includes the Galera Replication Library 4.5 with wsrep API version 26. You can download it now (and note that we have packages for various Linux distributions).  Galera 4 and MySQL 8.0.19 have many new features, but here are some of the highlights: Streaming replication to support large transactions by splitting transaction replication then applying them in smaller fragments. You can use ... Read More

Feed: Planet MySQL; Author: Olivier Dasini; When thinking about security within a MySQL installation, you can consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications. MySQL provides many tools / features / plugins or components in order to protect your data including some advanced features like Transparent Data Encryption (TDE), Audit, Data Masking & De-Identification, Firewall, Random Password Generation, Password Expiration Policy, Password Reuse Policy, Password Verification-Required Policy, Failed-Login Tracking and Temporary Account Locking, Connection-Control Plugins, Password Validation Component, etc… TL;DR Dual-password capability makes it possible to ... Read More

Feed: Planet MySQL; Author: Oracle MySQL Group; This week MySQL turns 25 - - - on May 23rd to be exact. Join us in celebrating 25 years of great success. Early on MySQL became the “M” in the LAMP stack that powered the open source revolution. It became and continues to be the most popular open source database. Early this year it earned the DB-Engine award for most popular database. The most successful applications and websites we all know and use today, such as Twitter, Facebook, Booking but also Uber, Airbnb and many more, started with MySQL, grew up with ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; During this webinar, Tyler Duzan, Product Manager for MySQL and Cloud at Percona, will discuss Percona’s decision to delay Percona XtraDB Cluster 8.0 to ship it with Galera 4 instead of Galera 3, and why that matters. In addition, he’ll talk about the work done to integrate MySQL 8.0 features with Galera as well as how Percona is treating Kubernetes as one of its primary target platforms with this release. This webinar will provide an overall view of the current state of best-in-breed MySQL clustering as well as the Percona roadmap for the ... Read More

Feed: Planet MySQL; Author: Dimitri Kravtchuk; This post was remaining in stand-by for a long time, specially that I was expecting that observed issues will be fixed soon. But time is going, and the problems are remaining. And I'm constantly asked "why, Dimitri, you're suggesting now to use XFS, while in the past you always suggested EXT4 ??" -- hope the following article will clarify you the "why" and maybe motivate you to do your own evaluations to see how well the things are working for you on your own systems under your own workloads.. NOTE : this will also ... Read More