Database

In my opinion SQL Server 2005 is a great database system.  Building on its predecessors, it manages and maintains databases well and allows customization and flexibility for a company.  In order to get the most out of it, you have to fully understand how it works and more importantly, how

Read more

Many testers know how to write SQL queries and how to fetch data from the tables. But only a few understand the internal architecture and how MySQL interacts with storage engines. This blog discusses the MySQL architecture, different layers and journey of SQL statement in MySQL data. MySQL architecture is

Read more

Percona is pleased to announce the release of Percona Distribution for MySQL. Following our recent versions of Percona Distribution for MongoDB and Percona Distribution for PostgreSQL, we have assembled the best and most critical enterprise components for MySQL, designed and tested to work together. This distribution provides the key components

Read more

One of the most common errors encountered in the MySQL world in general is the infamous error 1040: Concretely, this means that a MySQL instance has reached its maximum authorized limit for client connections. Until the connections are closed, no new connections will be accepted by the server. I would

Read more

Businesses expect extreme reliability from the database infrastructure accessible by their applications. Despite your best intentions and careful engineering, database errors do occur, whether it’s a machine crash or network partitioning. Good planning can help you get ahead of problems and recover faster when problems arise. This blog presents an

Read more