Tag: SQL
-
InnoDB Data Locking – Part 1 Introduction
Posted on October 20, 2020, Level intermediate Resource Length long
In this blog series, we would like to introduce you gently to the topic on which we were working over last 2 years. Improving how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, while in reality there is a lot of concurrency. By Kuba Łopuszański.
Tags cloud sql database devops software performance
-
Zero downtime on MySQL schema change
Posted on October 19, 2020, Level beginner Resource Length short
Have you ever deployed a feature which interrupted your application because the schema change on the MySQL database has locked the table? Then I have good news for you! There are some tools like the Percona Toolkit which can apply the operation without a downtime. By Michi Lehr.
Tags cloud sql database devops performance
-
Introduction to Python SQL libraries
Posted on June 12, 2020, Level intermediate Resource Length long
All software applications interact with data, most commonly through a database management system (DBMS). You will develop a straightforward application to interact with SQLite, MySQL, and PostgreSQL databases. By Usman Malik.
Tags python sql database software-architecture
-
How container networking affects database performance
Posted on March 20, 2020, Level intermediate Resource Length medium
An article by Percona team about building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion. They released Percona Server for MongoDB and Percona XtraDB Cluster; they were chosen because they both feature replication systems that can be made to work effectively in a containerized world.
Tags database sql performance devops kubernetes
-
Flexible MariaDB server Query Cache
Posted on March 5, 2020, Level intermediate Resource Length medium
The Server Query Cache (QC) is a well-known feature of MariaDB Server–it caches SQL statements and the corresponding result sets. Today we have faster, solid-state disks and more RAM, so the Query Cache is less important. Reducing reliance on cache alleviates its negative effects, such as mutex blocking. By Anders Karlsson.
Tags sql database devops miscellaneous
-
SQL Injection: A beginner's guide for WordPress users
Posted on January 22, 2020, Level beginner Resource Length medium
SQL injection, or SQLi, is an attack on a web application by compromising its database through malicious SQL statements. As it's a common attack, let's try to learn more about what it is, how it happens, and how to defend yourself from it. By Shaunik Daityari.
Tags sql database miscellaneous cloud
-
A mini-guide: Build a REST API as a Go microservice together with MySQL
Posted on November 10, 2019, Level intermediate Resource Length short
In this mini-tutorial, author creates a simple REST-API with a MySQL database. Author have recently found himself coding and deploying a lot of Go microservices and this is his experience and advice. By Johan Lejdung.
Tags golang apis sql containers docker microservices
-
Managing hundreds of millions of orders with Table Store
Posted on September 16, 2019, Level intermediate Resource Length medium
This article discusses how Table Store can help you store and manage massive amounts of data by using a fictional e-commerce platform as an example.
Tags sql database performance how-to cloud
-
Indexes bad practices
Posted on June 1, 2019, Level beginner Resource Length medium
In this article author will discuss secondary indexes common mistakes and bad practices. While the article is focused on MySQL and the InnoDB storage engine, most of this information applies to any DBMS. Published by Federico Razzoli.
Tags database sql miscellaneous linux
-
Exposing MyRocks internals via system variables: data writing
Posted on May 31, 2019, Level intermediate Resource Length medium
Peter Sylvester wrote this blog post about new storage engine for MySQL that's rising in popularity. MyRocks, the log-structured merge-driven RocksDB engine in MySQL.
Tags database sql miscellaneous
-
MySQL high availability framework explained – part one
Posted on February 24, 2019, Level intermediate Resource Length medium
This is three-part blog series, in which author explains the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semisynchronous replication and the Corosync plus Pacemaker stack. Published by Prasad Nagaraj VP Engineering at ScaleGrid.
Tags sql database software devops
-
Combining Amazon Aurora, Lambda, and SQS to go beyond the native capabilities of MySQL
Posted on November 26, 2018, Level intermediate Resource Length medium
David Yahalom posted on redgate Hub about innovative combination of Amazon Aurora, serverless Lambda and Simple Que Service to strecth MySQL beyond native capabilities.
Tags sql serverless aws devops miscellaneous queues