Database Management

Installation and/or migration of data. Including migration from single node to multinode cluster architecture.

Dealing with your data

We have come across numerous databases whilst working with clients. Applications tend to make many calls to the database to retrieve a varied amount of information.

The problem we come across with databases is that there are many independent applications that make calls to the database without consideration of read/write contention. Such applications then tend to impact each other leading to performance degradation for all application interacting with the database.

"We realised that using the database as a store for data between java processes meant we had a high amount of read/write contention. AnyGateway spotted this and revised the process architecture, such that data was carried over a messaging system (MOM) - resulting in 90% reduction of database read requests"

Mobile messaging company

When we come to assess the working of a database, we always investigate the applications that are using the database, as this is the most likely cause that affects the database performace. Many companies will look to add memory, increase disk performance (RPM) - upgrade CPU. However, performance can usually be improved by using various architecutural approaches to data reading and writing.