article thumbnail

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Percona

Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Your MySQL connection id is 256 Server version: 8.0.32-24.2

article thumbnail

Dealing With “Too Many Connections” Error in MySQL 8

Percona

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 94
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Stuff The Internet Says On Scalability For November 30th, 2018

High Scalability

The scalability of a native graph database. swardley : First up at #AWSreInvent is McKinsey revisiting their 2009 report on Cloud Computing with their talk "We were so wrong, you'd have been a muppet to follow our advice". Me : Clearing the Air on Cloud, 2009. damn, daydreaming again. X : What did McKinsey do?

article thumbnail

Should You Use ClickHouse as a Main Operational Database?

Percona

What if we use ClickHouse (which is a columnar analytical database) as our main datastore? Well, typically, an analytical database is not a replacement for a transactional or key/value datastore. However, ClickHouse is super efficient for timeseries and provides “sharding” out of the box (scalability beyond one node).

article thumbnail

What Adrian Did Next?—?Part 3?—?eBay?—?2004 to 2007

Adrian Cockcroft

Their database model later become known as NoSQL, although it was implemented on top of Oracle, each database held one table and indexes, and there were many sharded Oracle databases for each data set so it could be scaled horizontally as well.

Google 52
article thumbnail

MariaDB vs MySQL: Key Differences and Use Cases

Percona

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

article thumbnail

Top Redis Use Cases by Core Data Structure Types

High Scalability

Redis , short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker.