MySQL Adrien Payong in MySQL Exploring MVCC and InnoDB’s Multi-Versioning Technique In the realm of relational databases, MySQL stands out as one of the most popular choices. Maximizing its performance is... 20 May 2024 33 min read
Lukas Vileikis in MySQL Optimizing MySQL: Deleting Data In the previous parts of these MySQL optimization series, we told you how query optimization works on a high level,... 17 May 2024 14 min read
Blogs Aisha Bukar in Blogs A Beginners Guide to MySQL Replication Part 3: Multi-Source Replication Welcome back to the world of MySQL Replication! If you’ve been following this series, thank you for your support! And... 18 July 2023 11 min read
Featured Aaron Bertrand in Featured Build a Better WordPress Archives Page Using MySQL I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data... 10 March 2023 15 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 7: MySQL Enterprise Backup In this blog, we walk you through the primary way to take enterprise-level backups in MySQL: MySQL Enterprise Backup. Have... 03 December 2022 7 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 6: Physical vs. Logical Backups In this blog, we compare two of the most popular types of backups in MySQL - backups of a physical... 01 December 2022 9 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 5: Backing Up Big Data This blog will guide you through backing up big data sets in MySQL with ease. Have a read!… 26 November 2022 14 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 4: mydumper In this blog, we walk you through one of the most prominent MySQL logical backup solutions - a CLI-based tool... 22 November 2022 4 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 3: mysqlpump In this blog, we walk you through the brother of mysqldump - mysqlpump - and tell you everything about it.... 19 November 2022 6 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 2: Percona XtraBackup In this blog, we walk you through one of the flagship backup offerings by Percona - XtraBackup.… 16 November 2022 7 min read
Lukas Vileikis Optimizing MySQL: The Basics of Query Optimization In this blog, we will walk you through the basics of query optimization in MySQL. Have a read!… 10 November 2022 4 min read
MySQL Robert Sheldon in MySQL Introducing the MySQL INSERT statement In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that... 07 October 2022 22 min read
MySQL Robert Sheldon in MySQL Introducing the MySQL SELECT statement Use SELECT statements to query a MySQL database. In this article, Robert Sheldon explains how. … 15 June 2022 18 min read
MySQL Lukas Vileikis in MySQL Security in MySQL: Part Two There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of... 27 May 2022 10 min read
Tools Michael Sorens in Tools MySQL Compare: The Manual That Time Forgot, Part 1 Although SQL Compare, for SQL Server, is one of Redgate's best-known products, there are also 'sister' tools that allow you... 03 May 2013 14 min read
