Certified Power Solutions Prepares to Plow Through Snowstorms with MariaDB SkySQL Cloud Database

Rhea-AI Summary

MariaDB Corporation announced Certified Power Solutions has adopted its SkySQL cloud database via Amazon Web Services to enhance snowplow efficiency for winter road maintenance. The new system collects real-time data from 5,000 vehicle sensors, optimizing de-icing salt usage and improving environmental responsibility. Following the migration to SkySQL, CPS experienced over a 3,000% increase in user support and reduced database costs by more than 60%. This shift enables quicker responses to customer needs and aligns with CPS's commitment to safety and sustainability.

Positive

• CPS increased user support by over 3,000% after switching to SkySQL.
• CPS saved over 60% on database costs by migrating to SkySQL.
• Enhanced data collection and analytics improve road safety and reduce environmental impact.

Negative

• None.

IoT enabled snowplowing vehicles powered by SkySQL allows local agencies to be more efficient and keep roads safe during winter months

REDWOOD CITY, Calif. & HELSINKI--(BUSINESS WIRE)-- MariaDB^® Corporation today announced that Certified Power Solutions (CPS), a leader in the engineering, manufacturing and distribution of hydraulic systems and controls, is well-equipped to safely clear snowbound winter roads by choosing MariaDB SkySQL as its cloud database running on Amazon Web Services (AWS). While summer was unbearably hot around the country, winter is coming and is expected to be brutally cold with record-breaking lows, according to Farmers’ Almanac. Powered by SkySQL, CPS’s winter road maintenance system for snowplow trucks collects data every five seconds from 5,000 vehicle sensors to better inform local agencies about their salt use for de-icing roads and keeping communities safe.

By moving away from its homegrown on-premises solution to MariaDB in the cloud with SkySQL, CPS is able to answer and resolve their customers’ needs quicker by being able to store and access data faster. Offering an improved customer experience with better uptime and reliability, CPS increased the number of users they could support by over 3,000% overnight after switching to SkySQL. CPS also saved over 60% of its total cost for databases by migrating to SkySQL.

Fleet managers of snowplowing vehicles are accountable for keeping roads safe for winter travelers. They need to control costs and, at the same time, be environmentally responsible by reducing the amount of salt applied to roadways. Salt has been used to de-ice roads for decades, in fact, more than 20 million metric tons of salt are poured on U.S. roads each winter, according to an estimate by the Cary Institute of Ecosystems Studies in New York.

By integrating vehicle sensors, an automated electronic spreader control system and wireless data transfer offered by CPS on their snowplowing trucks, fleet managers are able to leverage the Internet of Things (IoT) telematics to build maps and reports from the data collected resulting in reduced salt used on roads. The data is automatically compiled and downloaded into the snowplowing truck’s spreader control system and then streamed to SkySQL once the snowplowing truck returns to headquarters.

“MariaDB SkySQL allows us to collect and record more data coming in from the IoT sensors on our snowplowing trucks, which lets cities, counties and state governments reduce water and salt use, saving them millions of dollars while also being more environmentally friendly,” said Jeremy Miller, R&D manager and senior principal electrical engineer at Certified Power Solutions. “We evaluated other cloud databases, including Amazon RDS, but ultimately chose MariaDB SkySQL because it gives us the flexibility to run in any cloud and not get locked into one cloud system. Plus, being a busy team, we rely on MariaDB’s expert support which is simply the best in the industry.”

MariaDB SkySQL provides all the features and functionality of MariaDB Enterprise Server as a fully managed cloud database service. Saving customers up to 90% of their legacy database costs, SkySQL takes care of everything from provisioning the cloud infrastructure to installing and deploying the database, configuring the database for production environments, and automating failover in just a few clicks. It is capable of scaling out a single database to hundreds of nodes with ease using distributed SQL and can deploy modern data warehouses for ad hoc analytics on massive data sets to meet enterprise demands.

Additional Resources

• Get started with MariaDB in the cloud with MariaDB SkySQL
• Visit mariadb.com
• Follow @mariadb on Twitter
• Read MariaDB’s blog
• Earlier this year MariaDB announced the intent to become a publicly traded company via combination with Angel Pond Holdings Corporation (NYSE:POND). To learn more, go to https://mariadb.com/IPO.

About MariaDB

MariaDB frees companies from the costs, cloud lock-in, constraints and complexity of proprietary databases, enabling them to reinvest in what matters most – rapidly developing innovative, customer-facing applications. MariaDB uses pluggable, purpose-built storage engines to support workloads that previously required a variety of specialized databases. With complexity and constraints eliminated, enterprises can now depend on a single complete database for their needs, whether on commodity hardware or their cloud of choice. Deployed in minutes for transactional, analytical or hybrid use cases, MariaDB delivers operational agility without sacrificing key enterprise features, including real ACID compliance and full SQL. Trusted by organizations such as Bandwidth, DigiCert, InfoArmor, Oppenheimer, Samsung, SelectQuote, SpendHQ – MariaDB meets the same core requirements as proprietary databases at a fraction of the cost. No wonder it’s one of the fastest-growing database management systems companies. Real business relies on MariaDB™.

View source version on businesswire.com: https://www.businesswire.com/news/home/20221115005382/en/

James Meredith

pr@mariadb.com

Source: MariaDB Corporation

FAQ

What is MariaDB SkySQL and how does it benefit Certified Power Solutions?

MariaDB SkySQL is a cloud database service that allows Certified Power Solutions to collect and analyze data from snowplow vehicles, increasing efficiency and reducing costs.

How much did Certified Power Solutions save on database costs by migrating to SkySQL?

Certified Power Solutions saved over 60% on their database costs after migrating to MariaDB SkySQL.

What improvements did CPS see after adopting MariaDB SkySQL?

After adopting MariaDB SkySQL, CPS experienced a more than 3,000% increase in user support and improved data handling for winter road maintenance.

How does CPS’s snowplow system contribute to environmental conservation?

CPS’s system uses IoT telematics to optimize salt usage, significantly reducing the environmental impact of de-icing roads.

What role does real-time data from vehicle sensors play in CPS's operations?

Real-time data from vehicle sensors helps CPS monitor and optimize salt application, enhancing road safety and environmental responsibility.