31.05.2016

The Importance of Database Mirroring in ERP Systems

ERP Systems are built on data and are not functional without data. Thus, data security is vital. Any slight loss of data may cause your ERP system to lose its functions. This may mean disaster for companies. Thus, database mirroring is one of the most important issues in ERP systems. We discussed Database Mirroring in ERP systems with Mr. Sertaç Kulaksız, IT Specialist of Login Software Help Desk, and Mr. Ahmet Savaş, ERP Solutions Consultant.

Could you inform you about database mirroring? What is Database Mirroring?

Ahmet Savaş Göktürk: Database Mirroring (DM) is the mechanism that enables a database to continue operations over a second copy in case of crash or failure of database continuity via Relational Database Management System (RDBMS). In other words, in case of any problem in database of your vivid ERP system, you can immediately continue to work vividly over its copy. This is one of the methods that we – Login Software - always recommend to our customers.

Database on server may become inaccessible in case of hardware failures, virus infections or human errors. In this case, database available on a second server at the same or different location should be activated and system should run without any interruption on the part of users.

Regardless of protection level of systems that are used today, they are all under potential risk against increasing cyber attacks. We recommend Database Mirroring to prevent any unfortunate incident and business interruption.

What are the minimum requirements for smooth operation of Database Mirroring?

Sertaç Kulaksız: First of all, secondary hardware is needed. The entire structure that is installed on the primary hardware should be installed on this secondary hardware. Two databases are synchronized to each other through Database Mirroring so that such a system runs smoothly.

The same version of database should be available on both servers. It should be created on Principal, FULL Recovery Mode. Both servers need to run on the same network even if they are at a different location.

Their disk partitions and RAM capacities should be the same. Since data transfer between them will be online, they should have a fast speed connection with each other.

Chunk size and number should be the same with those of the primary server.

Please note that system status should be tracked from logs following any connection failure between two servers.

Secondary hardware means extra costs. Do companies agree to make this investment?

Ahmet Savaş Göktürk: In the end, you allocate a higher budget to your ERP software than your hardware costs. The cost that we are talking about is a drop in the bucket, considering the risks. Companies are aware of this. Thus, they definitely make this investment. Think this as an insurance of your ERP investment. You can insure your car, even your mobile phone from home. Companies are now aware of this.

Finally, what do you recommend to companies?

Ahmet Savaş Göktürk: We always tell the same to companies. They absolutely need to secure their ERP systems. The best way to do this is Database Mirroring. In addition to their existing hardware, it will secure their investments against potential risks that may arise in the future by database mirroring to secondary hardware. Business will never be interrupted.