Microservices architecture for ERP systems

Traditional enterprise resource planning (ERP) systems built on the principle of monolithic architecture are becoming less and less effective in a modern business environment. The growing complexity of production processes, the increase in data volumes and the need to adapt quickly to changes pose significant challenges for such systems. The study aimed to analyse and develop methods for transitioning from a monolithic architecture to a microservice architecture in ERP systems to ensure their scalability, flexibility and security. A comprehensive analysis of the clientserver architecture of ERP systems and their main components, including relational databases and structured query language (SQL) queries, was conducted. The principles of functions and procedures, interaction between tables, and query creation in systems with many users were investigated. The study also addressed modern strategies for decomposing monolithic systems into microservices, including methods of data synchronisation and component management. Security aspects and risks of transition to microservice architecture were emphasised. Approaches to the transformation of ERP systems based on microservice architecture were developed, which reduces management complexity, increases productivity and reduces risks in business processes. Mechanisms for effective synchronised data exchange between components and ensuring their reliability were proposed. The study determined that microservice architecture enables independent scaling of individual system elements, increasing fault tolerance and performance under high loads. Common issues, including incorrect balances and errors in reports, were investigated and resolved. The developed approaches can be used to modernise ERP systems of large enterprises, especially in the manufacturing sector, where high performance and accuracy of data processing are important