Tag: MySQL 8.0

Feed: Recent Announcements. You can launch new instances in the Amazon RDS Management Console or using the AWS CLI. Upgrading a database instance to Graviton2 requires a simple instance type modification, using the same steps as any other instance modification. If you are currently on a relevant major version that is supported by Graviton2, such as RDS for MySQL 8.0.17, then you can move to Graviton2 by stopping the existing instance and changing the instance type to R6g or M6g instance using the AWS Management Console or AWS CLI. Your applications will continue to work as normal as you will ... Read More

Feed: Planet MySQL; Author: David Yeager; In this post I describe the various steps that allowed me to reach 3.6 million queries per second on a single VM instance using MySQL 8.0 with the help of Dynimize.It's not every day that you get to break a record. So when I discovered that you can now rent by the hour massive instances within Google Compute Cloud that support 224 virtual cores based on AMD EPYC 2 Rome processors, I had to jump at the opportunity to see what kind low hanging fruit might be out there. Low and behold I found ... Read More

Feed: Planet MySQL; Author: Mike Frank; The Challenge Often with sensitive information, you need to have an audit log. Not just that a table had a select run, but that specific cells within the table were accessed.  Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc. Sensitive Data such as that might be labeled as –  Highly Sensitive  Top Secret  Classified  Restricted  Clearance Required  Highly Confidential  Protected Data that is categorized or labeled in some manner is typically covered by regulations requiring your compliance. Compliance ... Read More

Feed: Planet MySQL; Author: Joshua Otwell; I recently watched a fantastic Python Pandas library tutorial series on YouTube. Without a doubt, Pandas is great for all sorts of data stuff. On the same token, MySQL Shell in Python mode is quite powerful in the sense that Python and the MySQL Shell (version >= 8.0) are somewhat united in the same environment. Although Pandas is in a league all its own when it comes to data analysis, between the power of MySQL and Python, we can also perform some basic analysis easily in MySQL Shell Python mode. In this blog post, ... Read More

Feed: Clustrix Blog. Author: Peter Friedenbach. What we tested: Relative performance of MariaDB vs MySQLHow we tested: Multi-statement, transaction processing workload (Sysbench 90:10)Where we tested: Amazon AWS EC2 and RDS, large to 12xlarge instancesWhat we conclude: MariaDB provides superior performance on commodity cloud hardware for real business workloads. Looking back in MariaDB Server’s family tree, we find its ancestor, MySQL Server. MariaDB Community Server and MySQL Server Community Edition, both Open Source, have over the years been packaged for many of the same Linux distributions, powering application stacks behind hundreds of popular websites and applications. And both are available in ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; MySQL 8.0 General Availability release was launched in April 2018, and since then there have been ten versions of MySQL 8 and Percona Server for MySQL released. The MySQL Community expressed a high opinion of the MySQL 8.0 advantages, so a lot of databases have been successfully upgraded to the new version. But many of them still need to be up to date.Percona has prepared a free course “How to Upgrade to MySQL 8.0” that helps you with this task.It is a series of useful videos for 3-4 minutes. At the end of ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; In a previous blog post on Data Consistency for RDS for MySQL, we presented a workaround to manage run pt-table-checksum on RDS instances. However, if your instance is running a MySQL 8.0.X version, there’s a simpler way to check data consistency.Starting with 8.0.1, MySQL introduced something called “Dynamic Privileges” which is a solution to grant more granulated privileges to the users, instead of the almighty SUPER privilege.So what was the issue with pt-table-checksum and RDS again? Since there’s no SUPER privileges for any user, there was no way for the tool to change the ... Read More

Feed: Planet MySQL; Author: Dave Stokes;      If you are running MySQL 5.6 please note that it will hit support End of Life status in February 2021!  MySQL 5.7 has been Generally Available for almost five years and MySQL 8.0 has been out for over two  years.   You need to upgrade as soon as possible.      Upgrading to 5.7 is pretty easy. And I heartily suggest that after upgrading to 5.7 that you also upgrade to 8.0  using the upgrade checker utility.    MySQL 8.0 has a lot of improvements including CTEs, Windowing Functions, Histograms, Multi-value indexes, upgraded JSON support, a contention ... Read More

Feed: Planet MySQL; Author: Chandan Kumar;  How to do selective schema Restore Using “Load Dump” Features Introduced in MySQL 8.0.21 ?In this Blog I will cover below topic:- 1.      What is Dump Load features all about. 2.      How to take Restore particular database from Complete Backup? 3.      Conclusion.What is Dump Load features all about? Dump Load Utility introduced in 8.0.21 version of MySQL Shell , which will do Import of backup files to MySQL Instance. Make sure back up files should be created with utility called Instance Dump/Schema Dump Utility. More Info :- https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-load-dump.html In case if you wanted to ... Read More

Feed: Planet MySQL; Author: Chandan Kumar;  Using Instance Dump and Schema Dump features introduced in MySQL 8.0.21 Version.In this Blog I will cover below topic:- 1.       What is Instance Dump/Schema Dump features all about? 2.       What are advantage? 3.       What is Disadvantage of using Instance Dump? 4.       Performance Benchmarks? 5.       Conclusion What is Instance Dump/Schema Dump features all about? MySQL Instance Dump is another logical back up option where backup can be processed in multi-threaded with file compress which will help users to improve performance of overall backup process and also save disk space. This features is introduced in MySQL ... Read More