Tag: Mysql
-
The system design cheat sheet: Relational databases
Posted on March 14, 2024, Level beginner Resource Length long
In system design, relational databases are a traditional choice for data storage, offering structured schema and powerful query capabilities, contrasted with NoSQL databases' flexible schemes and scalability. By Aleksandr Gavrilenko.
Tags mysql database miscellaneous cloud software-architecture
-
Eleven good resources to learn SQL and NoSQL
Posted on January 20, 2024, Level beginner Resource Length medium
SQL and NoSQL are in demand, and learning these tech skills can help improve one's career prospects. These skills are essential for developers, data scientists, business analysts, or anyone working in related fields with data. By Durga Prasad Acharya.
Tags nosql app-development event-driven open-source mysql database
-
Dynamic table partitioning in Postgres
Posted on October 29, 2023, Level intermediate Resource Length medium
We helped a customer recently who was storing 500 million chat messages in a single Postgres table. As the table was growing, their queries were slowing down. By Michel Pelletier.
Tags database mysql software performance
-
Bridging the gap between SQL and NoSQL in PostgreSQL with JSON
Posted on October 10, 2023, Level beginner Resource Length medium
PostgreSQL, a popular open-source relational database system can be used as a hybrid database to handle both structured and semi-structured data. PostgreSQL's support for JSON and JSONB object types allows for flexible data modelling and can solve many of the same problems that NoSQL databases are made to address. By Leslie S. Gyamfi.
Tags mysql big-data teams database nosql json
-
Discussing PostgreSQL: What changes in version 16
Posted on September 15, 2023, Level beginner Resource Length long
The article discusses the new features and improvements in PostgreSQL 16, the latest version of the open source relational database. By Amit Kapila.
Tags mysql json cio database web-development
-
Working with Postgres JSON query
Posted on September 14, 2023, Level beginner Resource Length long
The article explains how to work with Postgres JSON Query, which is a feature that allows you to store and query JSON data in PostgreSQL. By Pratibha Sarin.
Tags mysql json microservices database web-development
-
How to use systemd in Linux to configure and manage multiple MySQL instances
Posted on September 9, 2023, Level beginner Resource Length short
Systemd is a system and service manager for Linux systems. It provides a consistent way to start, stop, and manage system services. Systemd can also be used to manage multiple MySQL instances on a single server. By Mughees Ahmed.
Tags linux servers learning devops mysql
-
Character sets and collations in MySQL
Posted on June 28, 2023, Level intermediate Resource Length medium
Understanding the differences between character sets and collations in MySQL. Character sets and collations are fundamentally important concepts to understand when dealing with string columns in MySQL. A slight misunderstanding of either can lead to poor performance or unexpected errors when inserting data. By planetscale.com.
Tags web-development app-development mysql database how-to
-
Building and deploying MySQL Raft at Meta
Posted on May 19, 2023, Level intermediate Resource Length medium
At Meta, we run one of the largest deployments of MySQL in the world. The deployment powers the social graph along with many other services, like Messaging, Ads, and Feed. Over the last few years, we have implemented MySQL Raft, a Raft consensus engine that was integrated with MySQL to build a replicated state machine. By Anirban Rahut, Abhinav Sharma, Yichen Shen, Ahsanul Haque.
Tags mysql database cloud software-architecture app-development
-
Comparisons of proxies for MySQL
Posted on April 11, 2023, Level intermediate Resource Length long
HAProxy, ProxySQL, MySQL Router (AKA MySQL Proxy); in the last few years, I had to answer multiple times on what proxy to use and in what scenario. When designing an architecture, many components need to be considered before deciding on the best solution. By Marco Tusa.
Tags mysql database performance how-to devops
-
Build your own command-line replica with GTID aware mariadb binlog
Posted on February 24, 2023, Level advanced Resource Length medium
This blog post begins a three part series to create and customize your own asynchronous MariaDB replication client. With the release of MariaDB Community Server 10.8.1, the mariadb-binlog command line utility now supports both 1) filtering events by GTID ranges, and 2) validating a binary log's ordering of Global Transaction IDentifiers (GTIDs). By Brandon Nesterenko.
Tags app-development mysql database performance
-
Azure PostgreSQL Flexible Server exciting new backup and restore enhancements
Posted on October 17, 2022, Level beginner Resource Length medium
Backup and restore are key pillars for business continuity and disaster recovery offerings for Azure Database for PostgreSQL Flexible Server. We're excited to announce new features including Fast Restore, Geo Restore and Custom Restore Points to allow you more fine-grained control on your DR plan to achieve the RPO and RTO objectives. In this post we'll share an overview of each of these new features. By Varun Dhawan.
Tags database azure mysql devops