A Brief Introduction to MySQL Transactions
In this article, you will learn about transactions, their properties, transactional control commands, and how to use them in MySQL.
2 years ago
Articles
MySQL
public
Temporary Tables in MySQL: A High-level Overview
In MySQL, temporary tables are usually created automatically and only considered when certain types of problems arise. This post outlines when and why MySQL uses temporary tables and how you can avoid them.
2 years ago
Analyzing Scans in PostgreSQL
Understand the different types of Scans in PostgreSQL and why the query planner chooses them in different situations.
By
Zach Naimon
How To Secure MySQL 8 with SSL/TLS on Ubuntu 20.04
By default, MySQL is configured to only allow connections from the local system. If you want to connect to a MySQL server from a remote system, it is recommended to secure it with SSL/TLS. Enabling SSL/TLS will encrypt the data being sent to and from the database.
2 years ago
Set Up MySQL 8 Replication with Linux Nodes
This guide will show you how to set up a 2 node replication server by configuring mysqld.
2 years ago
Why You Need To Backup Your Postgres Database and How To Do It
This article will demonstrate why database backups are crucial and how to back up your PostgreSQL database using pg_dump and pg_dumpall.
2 years ago
Fast Key-Value Store With PostgreSQL
Explore Key-Value store features which augments the already fantastic NoSQL tool set that PostgreSQL offers.
By
Zach Naimon
How to Partition MySQL Tables
Would it be strange to eat a whole pizza, starting from the crust and working your way inward? Similar to slicing a pizza before eating it, table partitioning is the process of dividing huge tables into smaller tables so that data can be more easily and efficiently queried.
2 years ago
