{"id":1003,"date":"2019-05-27T10:28:49","date_gmt":"2019-05-27T10:28:49","guid":{"rendered":"https:\/\/www.hostinger.com\/blog\/?p=1003"},"modified":"2022-09-26T16:10:25","modified_gmt":"2022-09-26T16:10:25","slug":"sre-daily-life-bleeding-cart","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/blog\/sre-daily-life-bleeding-cart","title":{"rendered":"SRE Daily Life: Bleeding CART"},"content":{"rendered":"

<\/h2>

As you know, we run Hostinger.com<\/a>. It’s a critical component as it’s like our company’s greeting card. Even more, it’s the main gateway for onboarding new clients and making revenue through the \/cart<\/em>.<\/p>

Initially, we only had one instance of our main website provisioned in a single data center located in the United Kingdom which was equipped with an archaic network infrastructure. We were experiencing lots of DDoS attacks.<\/p>

A quick solution was to put the website under Cloudflare<\/a> to mitigate these attacks. It worked well but not for long. As we were treating the symptoms, the actual problem persisted until we suffered a huge blackout when that aforementioned data center went down for more than 4 hours.<\/p>

Scaling Issues<\/h2>

We decided to scale our application across the globe by launching two instances of applications per location. We use our global Anycast<\/strong> at the moment in three locations: Singapore, the United States, and the Netherlands. In total, we launched six instances.<\/p>

Once the code was deployed, we encountered a problem with the database – what should we do to make it easily available and accessible?<\/p>

Our developers determined that the database was mostly receiving read requests, so we decided to start using the Geo Percona XtraDB<\/strong> cluster. We launched one instance per location, in total – three.<\/p>

Later, it turned out that the \/cart<\/strong> endpoint mostly writes to the database. The workload was unexpected and unplanned. We decided to move the \/cart<\/strong> logic to Redis<\/strong>. This raised another question – how to scale Redis to avoid the servers from melting down again? It’s mostly used for caching \/cart<\/strong> for one month and for shared PHP sessions. And of course, it’s not as critical as the database. It would compensate for some write loads to the database.<\/p>

We bootstrapped one Redis instance per location without any shared states between them. If a request comes to Europe, then it will use the European Redis instance. If the US, then the American, and so on.<\/p>

World Domination Tour<\/h2>

Ok, so the solution wasn’t as future-proof as we wanted it to be. Now we had Cloudflare on top and a scaled application in multiple locations. But we ran into another issue. We noticed lots of ‘SQLSTATE MySQL gone away’ errors from our application. I started digging around and noticed that the XtraDB cluster shot timeout errors forming a quorum. As usual, there was no time to investigate it further, so we applied some quick fixes like an increased timeout for a cluster, retries, and window sizes for replication buffers. It worked around 5% better, but we still had timeouts, connection drops, and downtime. Then I checked the latency between XtraDB endpoints. There was a lot of packet loss between Asia and Europe.<\/p>

I contacted the data center staff to re-route our prefixes through another upstream and the service was back online again. The latency between Asia and Europe is around 250ms<\/strong>, so we have 4 requests per second for writes because the XtraDB cluster acknowledges writes only if all the nodes in the cluster confirm.<\/p>

The next day, the packet loss between locations started happening again. We contacted the data center guys and managed to fix the problem temporarily again. Eventually, we decided to get rid of the XtraDB cluster.<\/p>

The next problem was how to keep high availability for database connections if one instance goes down. We launched a custom MySQL cluster solution based on ExaZK<\/a>. The situation changed a lot.<\/p>

\"uptime<\/p>

We monitored how the application performs with the new changes for about a week but still noticed huge spikes in response times. We then created a NewRelic<\/a> account and started monitoring the whole application itself.<\/p>

\"New<\/h2>

We got some really handy metrics related to MySQL<\/strong> slow queries and external resources. It was very clear what the problem was – we dubbed our MySQL instances with unnecessary read requests by receiving translations for a certain language. We settled out to generate translation files in the JSON format and load them quickly instead of querying the database with every request.<\/p>

\"JSON<\/p>

\"GitHub<\/p>

With this change, we cut the latency noticeably when JSON files were adopted for database requests. <\/span><\/span><\/p>

Now we have another problem (not as critical as with the database) – JSON files are each around 500kb in size. They are read with every request and generate approximately 3k `read()`<\/strong> syscalls per second. 500kb \/ 8kb ~= 62 read()s to fully read the language’s file. For those who are interested I got those numbers using the Sysdig<\/strong> command:<\/p>

# sysdig evt.args contains \"json\"<\/pre>
We still noticed a very high rate of timeouts in our monitoring tools. We quickly went through Grafana, Prometheus, and Graylog to double-check what’s going on and cross-reference with StatusCake<\/a>, Pingdom<\/a> stats.<\/p>
The issue was that our top of rack switch was faulty and restarted a few times per day. You can check out the gaps in the graph below.<\/p>
\"CPU<\/p>
When this happened, ExaZK<\/a> started to point to a live MySQL instance and it worked in an HA fashion. Eventually, we replaced our faulty network switch with a new one and we started having 100% uptime.<\/p>
At the moment our website is working as shown in the screenshot below.<\/p>
\"Uptime<\/p>
Improvements in the Roadmap<\/strong><\/h2>
We’re planning to force cache translation JSON files directly in the browser to shift the load to the client-side. We’re also going to implement GeoDNS to pick the nearest location to the client’s source IP address. This is already tested in our development environment, but we’re waiting for a stable release of PowerDNS 4.2.<\/p>
In the future, we would love to implement regional Anycast<\/strong> together with GeoDNS<\/strong> to failover to a live data center in case of failure. One global Anycast plus region allocated prefix. Both are overlapping prefixes that allow having smooth failover if one region goes down completely. For instance, if your GeoDNS server responds to a CNAME record with an IP of 2A02:4780:C3::1<\/em> for the CDN’s resolver and at that moment this region is down, new connections will be redirected to the shortest AS-PATH PoP because of the global Anycast overlapped network.<\/p>\n","protected":false},"excerpt":{"rendered":"
As you know, we run Hostinger.com. It’s a critical component as it’s like our company’s greeting card. Even more, it’s the main gateway for onboarding new clients and making reve\u2026<\/p>\n","protected":false},"author":39,"featured_media":1030,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[82],"tags":[1809,1808,1813,1810,1812,1811],"hashtags":[],"class_list":["post-1003","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-engineering","tag-anycast","tag-bgp","tag-exazk","tag-mysql","tag-percona","tag-php"],"hreflangs":[],"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/posts\/1003","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/comments?post=1003"}],"version-history":[{"count":34,"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/posts\/1003\/revisions"}],"predecessor-version":[{"id":3850,"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/posts\/1003\/revisions\/3850"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/media\/1030"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/media?parent=1003"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/categories?post=1003"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/tags?post=1003"},{"taxonomy":"hashtags","embeddable":true,"href":"https:\/\/www.hostinger.com\/blog\/wp-json\/wp\/v2\/hashtags?post=1003"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}