Black Friday & Cyber Monday

The Black Friday–Cyber Monday shopping rush is no longer unique to the United States. Since 2013, sales on Black Friday have grown by 187% in the Nordic countries, and by 66% elsewhere in Europe.[1] Double-digit annual increases are common in the United States, as well.

Preparing databases for increased workloads

Online retailers and payment processors must prepare their database infrastructure for the increased workloads. By taking the right measures, you can provide an exceptional customer experience, ensuring your database is not only available but delivers the same performance for millions of users as it would for dozens.

4 principles of holiday database preparedness

Performance

The opportunity cost of slow data access is massive. In fact, a one-second delay in page load time has been shown to decrease conversions by 7% and customer satisfaction by 16%,[2] resulting in the potential loss of millions in revenue. Fortunately, it’s relatively easy to tune your database for optimal performance.

High availability

Outages can be extraordinarily costly. For instance, analyses show that, even outside peak holiday shopping periods, downtime at Amazon can cost the company $203,000 per minute![3] MariaDB offers a variety of solutions to help you ensure availability during peak load times such as Black Friday–Cyber Monday. This not only includes moving to an HA deployment if you haven’t already done so, but also creating automated failover and accelerated backup/restore processes, and deploying standby database servers for low-impact disaster recovery.

Scalability

Planning for scalability makes you ready for both anticipated growth and unexpected spikes. This may entail any of the following:

  • Analyzing current database workloads and hardware resources/utilization
  • Identifying the scalability requirements and hardware limitations of individual database workloads
  • Allocating hardware to support higher database storage and concurrency requirements
  • Creating automated processes for adding database servers on demand

Security

Data breaches are becoming alarmingly commonplace. The number of lost, stolen or compromised data records increased 164% from the second half of 2016 to the first half of 2017 alone.[4] Locking down your database is important at any time of year, but with a heightened risk of malicious attacks during the holiday season, it is more critical than ever. Essential security measures include updating databases to the latest supported version, deploying a database proxy, encrypting personal data and more.

MariaDB solutions

Principle Definition Solution
Performance Handling of peak loads without compromising performance
  • Performance tuning
  • Performance monitoring
  • Query result caching
  • Load balancing
  • Read/write splitting
High Availability Minimal downtime and fast recovery
  • Replication and clustering
  • Manual/scripted failover
  • Point-in-time rollback
  • Backup and restore
Scalability Additional capacity on demand
  • Topology detection
  • Distributed partitions (i.e., sharding)
Security Data encryption and breach prevention
  • Firewall and data masking
  • Result and connection limiting
  • End-to-end encryption
  • Pluggable authentication
  • Role-based access control

 

Upcoming webinar

Black Friday & Cyber Monday:
preparing databases for success

Black Friday and Cyber Monday are just a few weeks away, bringing the opportunity for record-setting sales – or bleak disappointment. Your database configuration can make all the difference!
 
Join us to learn about …

  • Performance tuning — provide a great user experience for everyone
  • High availability strategies — ensure you don’t miss a single sale
  • Scalability options — prepare for growth and short-term spikes
  • Security measures — protect your database from attacks

 

Tuesday, October 31

MariaDB Black Friday/Cyber Monday Webinar

10 a.m. PT / 4 p.m. CET

REGISTER NOW