I inherited of a system when my company bought another company. This system is a mix of LAMP and .NET.
- 1 Windows server running asp.net that controls third-party validation used only for apis and webservice - (let's call it WIN)
- 8 LAMP servers (web, reports, cron, repositories etc...) - (let's call it NEW)
Our current environment:
14 LAMP servers (web, mail, repositories, etc...) - (let's call it CURRENT)
The good news is the NEW code is pretty straigt foward. A few millions lines of code (which most are apis, third party) and I can convert it to the CURRENT system. The NEW and CURRENT use both CentOs which will make the transision easy, except the Windows server that I have no idea what to do now.
Now the bad news. The NEW system database schema is not good at all. It is not normalized and the queries are slow (database queries and the code too). My first idea is to redesign them to a more normalized structure that matches the CURRENT code but I don't work. The tables from the NEW system are gigantic. The NEW system has 7 databases, over 10000 tables, the smallest tables have over 100k rows and some tables have over 500 millions rows. One of the database has most of the tables with over 25 millions rows each.
Is it safe to migrate or should I keep both running? If I should migrate I want to know what will the safest solution for me in order to migrate the Windows and NEW system into my CURRENT system?