Mercy Bassey in MySQL Replicating MySQL databases in Docker Containers In my prior article, “Running a relational database with Docker”, I showed how to spin up a Docker container with... 13 June 2025 10 min read
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Date and Time Data Types Date and time data types are important because they help track and manage time-based information in databases. This includes things... 03 June 2025 21 min read
Mercy Bassey in MySQL Running a MySQL database in a Docker Container Relational databases provide a structured approach for storing and organizing large volumes of data into tables consisting of rows for... 29 May 2025 14 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 4 – Optimizing MySQL Performance) Welcome back to our journey of understanding MySQL performance tuning using MySQL Shell. So far, we’ve covered essential topics like... 15 May 2025 17 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Hash Indexes Welcome back to the MySQL indexing series! We’ve already covered the nuances surrounding indexes in MySQL as well as walked... 06 May 2025 14 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL – String Datatypes A very common task in creating a database is to store string data. For example, words, paragraph(s) or even documents.... 20 March 2025 22 min read
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Character Sets and Collations When working with strings in a database system, you need to ensure that the data is stored, sorted, and compared... 17 March 2025 18 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 3 – Disk I/O and Storage Optimization) So far, in our previous articles on MySQL optimization, we’ve looked at basic configuration management and memory and CPU tuning... 27 February 2025 15 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Descending B-Tree Indexes Most anyone who works with indexes should be familiar with B-tree indexes. These are the most commonly used data structures... 13 February 2025 11 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 2 – Memory and CPU) In the first part of the series article, we introduced MySQL Shell as a tool for managing and optimizing MySQL... 17 January 2025 17 min read
Lukas Vileikis in Blogs I Wrote a Book on How You Broke Your Database – Here’s Why You Should Read It This blog introduces the book "Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case" by Lukas Vileikis.… 10 January 2025 7 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 1 – Introduction) The database is an important part of any application and setting it up correctly is key to ensuring smooth performance.... 27 December 2024 23 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Clustered B-Tree Indexes If you’re a frequent reader of the Simple-Talk blog, you’re no stranger to indexes as we’ve covered indexes in database... 03 December 2024 10 min read
Aisha Bukar in Databases MySQL vs PostgreSQL: Numeric Datatype Comparison When you think of how to store data in a database, you think of data types. A data type represents... 15 November 2024 18 min read
Lukas Vileikis in MySQL MySQL Index Overviews: FULLTEXT B-Tree Indexes If you’ve been following Simple Talk for a while, you know that we’re fans of databases and everything they involve.... 25 October 2024 17 min read
Lukas Vileikis in Blogs Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024 This blog outlines why you should be coming to see a talk on MariaDB indexes at the MariaDB Server Fest... 13 September 2024 4 min read
Lukas Vileikis in Blogs Devising the Perfect Index for Your Use Case – MySQL Edition This blog will walk you through how to choose the perfect index for your specific use case. It will also... 11 September 2024 7 min read
Lukas Vileikis in MySQL MySQL Index Overviews: Composite B-Tree Indexes Indexes in MySQL are one of the primary ways to enhance query performance and they are especially useful when the... 30 August 2024 16 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL: Which Open-Source Database is right for you? When I joined a growing startup company as a backend developer, we were at crossroads choosing between MySQL and PostgreSQL... 12 August 2024 12 min read
Lukas Vileikis in MySQL MySQL Index Overviews: B-Tree Indexes In this first entry in a multipart series on indexes, I will cover the most important index type in MySQL,... 05 August 2024 19 min read
