Tag: Mysql
-
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
-
Postgres: Better message queue than Kafka?
Posted on October 13, 2022, Level intermediate Resource Length long
Today author is going to talk about why they made the unconventional decision to build thier logging system on top of Postgres, what worked well, what didn't work well, and how they did it. By Pete Hunt.
Tags apache mysql app-development database messaging
-
Seven ways to reduce MySQL costs in the cloud
Posted on August 30, 2022, Level beginner Resource Length medium
With the economy slowing down and inflation raging in many parts of the world, your organization will love you if you find ways to reduce the costs of running their MySQL databases. This is especially true if you run MySQL in the cloud, as it often allows you to see the immediate effect of those savings, which is what this article will focus on. By Peter Zaitsev.
Tags mysql cio devops cloud database
-
Data Manipulation with functional programming and queries in Ballerina
Posted on August 18, 2022, Level intermediate Resource Length medium
As an adept at Functional Programming (FP), I feel at ease with expressing my data manipulation logic by chaining high order functions like map, filter, and sort operating on arrays and maps. Ballerina, being designed as a Data-Oriented programming language, supports this FP style of coding. By Yehonathan Sharvit.
Tags app-development programming database functional-programming mysql
-
Scaling up and load balancing your PostgreSQL Cluster using Pgpool-II
Posted on July 12, 2022, Level intermediate Resource Length medium
PostgreSQL's speed, robustness and security makes it suitable for 99% of the new-age applications. Today, let's deep dive into how you can enable scalability and load balancing of your PostgreSQL cluster using Pgpool-II. By Azman Agung Nugraha.
Tags database performance software-architecture mysql
-
Working with a JSONB array of objects in PostgreSQL
Posted on July 7, 2022, Level intermediate Resource Length medium
Get, add and remove JSON objects from an array. By Rob Tomlin.
Tags json database mysql app-development
-
Migrating to utf8mb4: MySQL things to consider
Posted on May 1, 2022, Level intermediate Resource Length medium
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor forces any upgrades. By Sveta Smirnova.
Tags mysql web-development app-development database
-
MySQL 8: Password verification policy
Posted on April 28, 2022, Level intermediate Resource Length medium
The artcicle discusses the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by specifying the existing current password to be replaced. By Brian Sumpter.
Tags mysql database cio infosec devops
-
Tiered datastore solution for high data growth MySQL using Distributed SQL Databases (DSQL)
Posted on December 10, 2021, Level intermediate Resource Length medium
Usually, entities like order, order items etc tend to grow substantially year on year as we scale more and serve large customers. Generally, MySQL is the widely used datastore due to its durable & ACID guarantees. While MySQL is a brilliant tech stack, it comes with the overhead of data maintenance. By Manohar K.
Tags cloud database mysql cio distributed
-
How does an SQL injection attack work? Examples & types
Posted on December 6, 2021, Level intermediate Resource Length medium
A SQL injection (SQLi) attack is one of the most threatening issues for data integrity and confidentiality today, allowing attackers to access secure data where they are not authorized. In this article, we discuss SQLi and how these attacks work, with types and examples. By Al Mahmud Al Mamun.
Tags servers mysql database miscellaneous cloud cio distributed