article thumbnail

Database Sharding and Its Challenges

DZone

Database sharding is a powerful technique employed to manage large databases more effectively. It involves partitioning a large database into smaller, more manageable parts, known as shards. The above diagram presents a visual representation of a sharded database.

Database 228
article thumbnail

Understanding the Database Connection Pool (DBCP) Properties

DZone

Recently, I faced an issue related to a very high load on the database layer. The database was having too many connections in parallel. I had to review my application’s database connection pool (DBCP) properties very closely.

Database 245
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

Percona Monitoring and Management Database Overview Dashboard, Simplified

Percona

Percona Monitoring and Management (PMM) overview dashboards were always meant to be a starting point for DBAs to check the overall health of the databases. ” Now, we present a redesigned dashboard focused on simplicity:Where is the simplicity coming from? At first, […]

article thumbnail

Percona Labs Presents: Infrastructure Generator for Percona Database as a Service (DBaaS)

Percona

Let’s look at how you can run Percona databases on Kubernetes, the easy way. Chances are that if you are using the latest Percona Monitoring and Management (PMM) version, you have seen the availability of the new Percona Database as a Service (DBaaS).

article thumbnail

The Ultimate Guide to Database High Availability

Percona

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

article thumbnail

Database Housekeeping in the New Year

Percona

Now it is time to get your databases ready for the rest of the year. Check the versions of database connectors, programming languages, and proceed all the way down to the operating system. Have you been looking at the recent features and changes in your database software? Welcome to 2023! First, how are your backups?

article thumbnail

Identify Active Databases and Users in MySQL

Percona

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 101