Founded in 2006, PaGaLGuY started as a forum that enabled students, typically aged between 20 and 30 to discuss and seek advice on academic issues. By 2011, PaGaLGuY had increased its traffic to about 250,000 page views per month. The business is now one of India’s largest education networks and provides an app that users can download to their Android and iOS devices.

Over the past six years, PaGaLGuY has extended its service to include video advice from experts on education topics and grown the number of views of its pages to 1.5 million per day. As Head of Technology for the business, Sandeep Kalidindi has played a key role in ensuring PaGaLGuY is as engaging as possible to users. “Because the product is advertising based, the greater the user engagement, the greater the advertising revenue,” Kalidindi explains.

Google Cloud Platform Results

• Supported growth to 1.5 million page views per day and demand spikes that see requests increase from about 90 per second to about 1,200 per second
• Reduced API latency from about 1 second to about 40 milliseconds
• Reduced system administration time from three to four days per week to 30 minutes every two weeks

In 2015, PaGaLGuY’s senior management team decided to deliver an even more relevant experience for users of the education network. “The core thing we had to do was personalise the experience for each and every student that visited PaGaLGuY,” Kalidindi says. “So we had to capture each student’s data to customise what they see when they open the site.”

The business also found traffic to the network was straining its infrastructure. During demand peaks, created by exams involving as many as 5 million students, PaGaLGuY would be inaccessible for periods of 30 minutes to one hour. Furthermore, average API latency had climbed to an unacceptable 1 second, compromising performance.

PaGaLGuY needed to access extensive compute resources to undertake its planned change. Had the business relied on a physical technology architecture to undertake the transformation, it would have had to purchase capacity equivalent to 16 new servers. “There was no way with a small team we could grow to that extent in a short time,” Kalidindi says. “This was the right moment for us to explore cloud services.”

The business established two primary requirements the selected cloud service needed to meet. First, PaGaLGuY had to be able to scale the platform with costs rising only in proportion to the increase in resources consumed. Accordingly, the business would have to minimise the number of employees required to manage the cloud environment. Second, the platform had to give PaGaLGuY easy access to student data and the ability to undertake prompt, granular analysis.

PaGaLGuY reviewed available public cloud services and determined that Google Cloud Platform (GCP) was the best fit for its business. “Google Cloud Platform was considerably more mature than the alternatives, with a high degree of automation and a suite of managed services,” Kalidindi says. PaGaLGuY management then discussed with Google how to optimise cost, performance and availability of its personalised education network on GCP.

With assistance from Google and business transformation specialists Searce, PaGaLGuY was able to deliver the platform into production on GCP in 10 months. “Searce was very proactive in ensuring the environment met our needs and allowing us to gain priority access to Google services in development,” Kalidindi says. “Their team was integral to the success of the migration.”

PaGaLGuY has been running in production in GCP for two years. The education network’s GCP architecture comprises a scalable back-end built on Google App Engine; a managed environment for its containerised applications in Google Kubernetes Engine; messaging-oriented middleware through Google Cloud Pub/Sub; a relational database in Google Cloud SQL; a managed data analytics warehouse running in Google BigQuery; stream and batch data processing through Google Cloud Dataflow; and object storage in Google Cloud Storage.

PaGaLGuY has leveraged GCP services to break down its platform application from a monolithic build to a series of microservices running in Google App Engine that enable independent deployment cycles, minimise test and quality assurance overheads and provide clearer monitoring and logging.

Running on GCP has enabled PaGaLGuY to add new personalisation features and grow fourfold without having to add any new engineers or administrators to accommodate the increased traffic. The business has also used the platform to seamlessly collect and aggregate students’ data for analysis, reporting and delivering a more targeted user experience. Furthermore, PaGaLGuY has been able to provide its management team with direct access to Google BigQuery to scrutinise data rather than require them to wait at least a day to view reports created by the product or technology teams.

Support demand peaks of 1,200 requests per second

“Thanks to Google Cloud Platform, we can easily support demand peaks that see requests per second rise from an average 90 per second to about 1,200 per second for as long as 45 minutes,” Kalidindi says. Due to GCP’s scalability, PaGaLGuY can ensure its education network remains available and performance remains consistent during those periods.

Latency cut to 40 milliseconds

The business has also reduced average API latency from 1 second to about 40 milliseconds. Furthermore, using GCP has enabled PaGaLGuY to automate most of its processes and reduce system administration requirements from three to four days a week across its team members to about half an hour per week.

The performance of GCP has transformed PaGaLGuY’s culture and processes. “Once our team was exposed to Google Cloud Platform and understood the superiority of the platform, our mindset changed from ‘let us do everything on our own’ to ‘let us do what we do best’ and delegate the remainder,” Kalidindi says. The quality of the service provided by GCP means PaGaLGuY effectively considers the cloud provider as part of its team. “We are always eager to see what new services are being launched and are extremely excited about what Google Cloud Platform can provide as part of its roadmap.” he concludes.

Editor’s note: 5G is much more than a network—it’s a platform for innovation with the ability to provide immediate global scale and enable use cases that we haven’t even dreamed of yet. But to achieve this, industry players must come together to drive this growing ecosystem. Today, Erik Ekudden, CTO of Ericsson, and Bikash Koley, VP of Global Networking at Google Cloud, share their insights into the potential of edge and 5G.

Experts consider 2021 to be the year that serves as the inflection point between network readiness and 5G availability. However, communications service providers (CSPs) are still faced with the task of modernizing their networks, systems, and infrastructure to maximize the potential of 5G for themselves and for the enterprise customers they serve. As you weigh whether to tackle this challenge, let’s first examine what’s different about 5G and how CSPs can best leverage 5G and the edge together as an even stronger platform for innovation than just 5G alone.

With 5G, applications and mobile networks are no longer isolated

Let’s first address what 5G brings to the table. Faster speeds and lower latency are expected of course, and throughout the evolution from 2G to 3G to 4G, there’s been a step function in performance improvements with each of these. However, with every generation, applications and networks have been like ships passing in the night. Networks have been unaware of what the applications have been doing and applications have been guessing what the network was capable of. 

What’s different this time around is that there is some real innovation happening with the development and rollout of 5G itself. The network is on a path to become more accessible via APIs so that applications can call on and consume what they need from the networks in a more programmable way. This sets us up for more open architectures and ecosystems.

5G leverages a more open architecture 

One key difference with 5G as compared to prior generations is that it’s the most open and flexible network architecture the CSP industry has seen. This is thanks to its service-based approach and the decoupling of hardware and software components. CSPs are now running core network elements in the public cloud, private cloud, hybrid cloud, and even multi-cloud, which was unthinkable even five years ago.

The flexibility of this more open architecture allows us to push the cloud to the edge while still being able to manage it from a single pane of glass. This is a huge leap forward from traditional networks, which have been domain-specific, managed in silos, and with slow service creation and delivery. Now, hyperscale cloud vendors and network equipment providers are offering solutions that help CSPs break down these silos to enable more flexible, automated networks with improved orchestration, visibility, and control across multi-vendor, multi-cloud and hyperscale cloud-provider environments. In addition, the separation of hardware and software provides a much more flexible and cost-effective way to upgrade from one network generation to the next.

To provide solutions that are relevant to enterprises, CSPs must offer capabilities beyond connectivity. Enterprise service orchestration, including exposure of network assets and network slicing, are foundational capabilities to provide value to the application ecosystem and be in control of the network and the delivered services.

Combining 5G and edge to help industries reimagine user experiences

This convergence of compute, storage and networking at the edge coming together for the first time will enable CSPs and enterprises to offer their customers completely reimagined user experiences. Consider, for example, how the automotive industry might enhance how customers shop for a car. As part of Fiat Chrysler Automobiles’ Virtual Showroom at the recent CES 2021 event, consumers were able to experience the innovative new 2021 Jeep Wrangler 4xe by scanning a QR code with their phones, and then see an Augmented Reality (AR) model of the Wrangler right in front of them—virtually placed on their own driveway or in any open space.

By rendering the model in Google Cloud, then streaming it to mobile devices, visitors could also see what the car looked like from any angle, in different colors, and even step inside to see the interior in incredible detail. That is the true digitization of an industry segment and highlights the device-to-network-to-edge-to-cloud application relationship and how it can impact the user experience.

A programmable network unlocks more application use cases

The programmability of the 5G network will truly enable application developers to utilize all the benefits of the underlying network. Programmability supports ease of use and enables CSPs, integrated software vendors (ISVs) and the ecosystem to have the right network-level APIs exposed so that applications can be optimized based on the network behavior and vice versa. Imagine, for instance, automatically pushing applications from a cloud region to the edge based on network latency and performance metrics.

Finally, 5G’s programmability is also about having the right tools available for developers to build and integrate applications on the network with zero-touch onboarding and validation. With this, we’ve come to the point where the network is now a “platform” for application innovation. 

5G and edge will be all about the ecosystem

One thing is for certain: the shift to 5G will place tremendous focus on the ecosystem, and it needs to be an ecosystem that includes CSPs, public cloud providers, application developers and technology providers, all coming together to optimize the user experiences across industry applications. For instance, Google Cloud and Ericsson recently announced our partnership to deliver 5G and edge cloud solutions for CSPs and enterprise.  In addition, Google Cloud is also teaming up with popular ISVs to deliver more than 200 edge applications from 30-plus partners, all running on our cloud.  

With collaboration across ISVs, cloud providers and network equipment providers, we are enabling the rapid delivery and deployment of new vertical services and applications, leveraging capabilities like Anthos, artificial intelligence (AI), and machine learning (ML), as well as multi-vendor, multi-cloud and hyperscale cloud provider service orchestration and global edge networks such as those provided by Google and telecom service providers.

As members of the technology ecosystem, we talk about compute, storage and networking, but when it comes down to it, it’s about optimally placing these resources—whether in the cloud, at the provider core, at the edge or anywhere in between—to maximize the end-user experience. The openness and programmability of 5G lends itself to collaboration like never before. We predict that in 2022 and beyond, it will be all about the ecosystem coming together to leverage 5G and the edge to build innovations that we can’t yet imagine.

To learn more, watch the full Ericsson 5G Things CTO Focus fireside chat, where we discuss these topics and more.

If you’re managing a crucial application that has to be fully fault-tolerant, you need your system to be able to handle every fault, no matter the type and scope of failure, with minimal downtime and data loss. Protecting against these faults means juggling numerous variables that can impact performance as well as recovery time and cost.

Today’s managed database services take over the operational complexity that used to exist for database administrators. Growing your organization’s tolerance required adding machines, compute, and storage, plus the operational costs of IT management: performing backups, writing scripts, creating dashboards, and carrying out testing to make sure your platform is ready when problems arise–all in a secure way.

At Google, our Cloud SQL managed database service offers three fault tolerance mechanisms —backup, high availability, and replication—and there are three major factors to consider for each of them:

• RTO (recovery time objective): When a failure happens, how much time can be lost before significant harm occurs?
• RPO (recovery point objective): When a failure happens, how much data can be lost before significant harm occurs?
• Cost: How cost-effective is this solution?  

We’ve heard from customers like Major League Baseball, HSBC, and Equifax that they have strict data-protection needs and require highly fault-tolerant multi-region applications—and they’ve all chosen Cloud SQL to meet those needs. 

Let’s take a closer look at how the decision-making process plays out for each recovery solution.  

High availability (HA)

If your application is business critical, you require minimum RTO and zero RPO— a high availability configuration ensures that you and your customers are protected. If the primary instance fails, there’s another standby instance ready to take over with no data loss. There’s an additional cost here, but doing this manually brings a great operational cost, since you have to detect and verify the fault, do the failover, and make sure it’s correct—you can’t have two primary instances or you risk data corruption—then finally connect the application to the new database.

Cloud SQL removes all that complexity. Choose high availability for a given instance and we’ll replicate the data across multiple zones, synchronously, to each zone’s persistent disk. If an HA instance has a failure, you don’t have to think about when to fail over because Cloud SQL detects the failure and automatically initiates failover, for a full recovery and no data loss within minutes. Cloud SQL also moves the IP address during failover so your application can easily reconnect. MLB, for example, uses Cloud SQL high availability to serve prediction data to live games with minimal downtime. Dev/test instances don’t need those same guarantees, but can use local backups to recover from any potential failure.

Cross-region replica

If a whole Google Cloud region goes down you still need your business to continue to run. That’s where cross-region replication comes in, a hot standby replica in another Google Cloud region provides RTO of minutes and RPO typically less than a minute . If you create a read replica in a region separate from your primary instance and you get hit with a regional outage, your application and database can start serving customers from another region within minutes. But this solution can be complex and enabling it yourself can be difficult and time-consuming. Securing cross-geography traffic demands end-to-end encryption and can bring connectivity issues too. 

This is where the fully managed Cloud SQL solution shines. We offer MySQL, PostgreSQL and SQL Server database engines as a cross-region replication solution that’s easily configured and bolstered by Google’s interconnected global network. Just say, “I’m in U.S. East, I want to create a replica in U.S. West,” and it’s done, reliably and securely.

Backup

When you suffer data loss because of an operations error (for example, a bug in a script dropped your tables) or human error (for example, someone dropped the wrong table by accident), backups help you restore lost data to your Cloud SQL instance. Our low cost backup mechanism features point-in-time, granular recovery, meaning that if you accidentally delete data or something else goes wrong, you can ask for recovery of, for example, the state of that database down to the millisecond, such as Monday at 12:53pm. Your valuable data is replicated multiple times in multiple geographic locations automatically. This enables the automatic handling of failover in cases of major failure. You can always rest assured that your database is available and data is secure, even in the times of major failure crises. 

Cloud SQL provides automated and on-demand backups. With automated backups, Google manages the backups so that you can easily restore them when required. Also, the scheduled backing is automatically taken by default. With on-demand backup, you can create a backup at any time. This could be useful if you are about to perform a risky operation on your database, as Cloud SQL lets you select a custom location for your backup data. When the backup is stored in multiple regions, and there’s an outage in the region that contains the source instance, you can restore a backup to a new or existing instance in a different region. This is also useful if your organization needs to comply with data residency regulations that require you to keep your backups within a specific geographic boundary.

Putting it all together

For critical workloads, MLB configures their Cloud SQL instances with backups, high availability, and cross-region replication. Doing so ensures they can recover from many failure types.

• To recover from human error (“Oops, I didn’t mean to delete that”), MLB uses backups and point-in-time recovery to recovery to a millisecond or specific database transaction
• To automatically recover from primary instance failures and zonal outages, MLB uses Cloud SQL’s high availability configuration
• To protect against regional outages, MLB uses cross-region replication

Creating a robust configuration, like MLB did, takes just a few minutes. Get started in our Console or review documentation.