Zierzoware is a development company founded in Zaragoza and mainly dedicated to the development of 'Organízate', a web management application for SMBs (centers, dental clinics, physiotherapy, etc.).

'Organízate' groups a set of management tools in SaaS mode with the objective of simplifying the management processes of small businesses with needs to comply with GDPR, automate their workflows, record relevant information and enjoy the basic functionality of Agenda, ERP and CRM.

Zierzoware:
Migración de infraestructura a la plataforma de AWS

What challenge was the company facing?

The client came from a traditional hosting where the technical support was quite poor:

  • They did not have instant phone contact for critical incident resolution
  • They received responses to open cases 2 or 3 days after opening, with no information on the incidence or how to resolve it

Its main impact was the temporary blocking of the database, which left all its clients out of service for hours.

Implemented solution

apser performed a complete migration of its infrastructure, helping to give visibility to, and at the same time solve, your application’s bottleneck issues. Some of the tasks that were carried out were:

  • Uncoupling between app and BBDD
  • Use of RDS performance insight to visualize the intensive use of BBDD
  • Implement AWS Web Application Firewall (AWS WAF) service to enhance protection against the most common web attacks

In order to improve security and prevent AWS WAF crashes with application-specific behaviors, some modifications were made. Zierzoware, meanwhile, implemented some changes at the application code level, while apser took care of creating custom rules in AWS WAF to prevent certain requests from the application itself from being detected such as SQL Injection or XSS (Cross-site scripting).

Ultimately, AWS WAF was adapted to the use of the application, taking advantage of the additional layer of perimeter security offered, to protect against the most frequent web attacks and vulnerabilities.

In addition, a study was carried out for the optimization of infrastructure resources and costs based on the behavior of the migrated application. Coming from traditional monolithic hosting, we initially designed an oversized infrastructure for hosting both the web application (AWS EC2) and the uncoupled database (AWS RDS) to avoid possible bottlenecks and/or performance.

With an environment already stabilized, during the first month we analyzed the behavior of the app using Amazon CloudWatch metrics. Thanks to this analysis, we achieved a reduction in infrastructure costs of about 15%, reducing the resources of the instance – including family change – for both EC2 and RDS.

Technical support was also provided for the various incidents reported as part of our MSP service, both in Platform Layer and OS Layer. Some of the most common were:

  • Increases in service limits
  • Problems of access to services
  • Account configuration and IAM users
  • Changes in configuration of Security Groups for accesses
  • Load/stress tests
  • Changes of type of instances
  • Storage increments of EC2 or RDS disks

Results

Zierzoware no obtuvo una fotografía de lo que realmente estaba ocurriendo en la base de datos de su aplicación hasta que no se migró a Amazon Web Services, punto estrechamente relacionado con el comportamiento intensivo de escritura de la propia app.

La aplicación tenía picos de operaciones de escritura por segundo en el disco de RDS (IOPS) de entre 4000 y 5000. Esto ocasionaba que el burst balance del disco EBS se agotara y se redujera el rendimiento del propio disco, haciendo que la aplicación se ralentizara.

Los problemas relacionados al rendimiento se solucionaron gracias a un incremento de disco para mejorar el burst balance, y al uso de Performance Insights, que dio visibilidad a qué tipo de escrituras se realizaban en RDS -se almacenaba cualquier clic de usuario en tiempo real- y propició una modificación a nivel de código de la aplicación.

Adicionalmente, se implementaron alarmas asociadas a las métricas más críticas, con notificaciones al cliente, cosa que les ofrece una mayor seguridad, a la par que visibilidad. Con un acceso completo en modo lectura a la consola de la cuenta, el cliente tiene la máxima información y transparencia posible, lo que añade un plus de confianza con su proveedor, apser.

0 %

Reducción de Costes de Infraestructura

Next steps

Currently, the infrastructure is designed to comfortably absorb the growth of the application (in terms of users and required performance), in addition to being fully monitored to detect possible failures or incidents in the service.

Possible next steps would be to implement a cloud development environment with EC2 and RDS.

Why apser

apser is the AWS Advanced Consulting Partner specializing in companies, public administrations, startups and non-profit.

The apser team provides a customized, easy-to-understand and agile approach with the goal of contributing to the widespread adoption of the cloud paradigm.

Our team operates through two business units: Cloud Solutions (acting as a managed services provider) and Cloud Professional Services (acting as a consulting firm).

In 2018 we had our first experience with AWS. Since then, we have not stopped incorporating knowledge and experience that, day by day, help us improve the effectiveness of our clients’ platforms. You can consult our AWS Validated Qualifications here.

Other success stories of Professional Services on AWS

Cerebriti success story

Cerebriti.com is the most important portal for educative games and Spanish knowledge. One of its strong points is that the games are created by their own users, [...]

Polygon Education success story

Polygon Education arises from a need for educational innovation, to accompany both teachers and students in the search for new didactic experiences. Its purpose is to assist [...]

Avanzir success story

With more than 10 years in the market, Avanzir is a company specialized in the implementation of process management and document management solutions. They are responsible for [...]

Contacta con nosotros

We would love to know your goals and collaborate with you to achieve them. Rellena el siguiente formulario y en breve contactaremos contigode encabezado personalizado

Email: info@apser.es

Telephone 902 02 62 13

Monday to Friday from 09h to 18h.

Service Center

Coso Street, 46 1st Floor

50004 Zaragoza

Marketing & Sales

Prat de la Riba, 31 2º

43201 Reus

Euskadi Office

C/María Díaz de Haro, 43

48010 Bilbao