I got tired of MySQL headaches and needed something faster and more scalable. So we ditched MySQL, Redis and DynamoDB, moved everything to SingleStore, and are now able to achieve hyper-scale and performance we’d never imagined.
Great question. Well let's take a look at a query.
SELECT SUM(pageviews) FROM pageviews
Let’s run it over a sample data set of 5 billion rows.
It takes just 1.49 seconds to complete.
Incredible, right?
I've built a course to show you how to use SingleStore with Laravel. As with my previous course, Serverless Laravel, I will save you time and help you skip past all of the gotchas. And whilst this course is specifically for using SingleStore in the Laravel ecosystem, everyone can benefit because we do focus on SingleStore itself.
This course is for people with growing databases who want to keep them fast, people who aren't getting the performance needed with their current solution, and those who are tired of the headaches MySQL brings.
For those using RDS at scale, you've likely run into IOPS headaches, connection limits, slow time to add indexes to tables, slow aggregations, slow migrations, slow filtering and performance degradation over time. Many people keep increasing their spending on RDS, but they're just not seeing a valuable performance jump.
This course is for you if you want a faster & more scalable database, and either of the following apply:
SingleStore’s managed service, which we use, is unlike any managed database software you’ve ever used.
Keep in mind that you can drop Redis, DynamoDB and MySQL when moving to SingleStore.
That would be me, Jack Ellis. I’m the cofounder and CTO of Fathom Analytics and I brought awareness of SingleStore to the Laravel community by writing about my experiences scaling Laravel with SingleStore.
My courses have been downloaded by over 1,300 software engineers and have helped solve many challenges.
My story about how I ended up using SingleStore to power Fathom Analytics.
A dive into who this course is for and what OLTP and OLAP actually are.
Introducing the playground application we're creating.
How we built Acme Bank.
The headaches you will run into when you use MySQL and how SingleStore compares.
Installing SingleStore on your local machine.
Setting up the SingleStore driver in your application.
Running into the nuances of SingleStore with Laravel so that you don't have to.
How we split up our data and ensure long-term scalability.
Reviewing our migration files and choosing shard keys.
An alternative way to shard your data.
How to really drive rapid performance with SingleStore.
An important note about auto increments with distributed databases.
The difference between the two types of database SingleStore offers.
Choosing a sort key is everything, and in this video we learn about how they work and dive into segment elimination.
Quick reminder on primary keys.
How to correctly use hash keys (don't make the same mistake I did).
Using skiplist indexes (replacement for MySQL btree) on rowstore tables.
Full-text indexes are here, so you can drop that additional database for searching.
Goodbye my Varchar, goodbye my friend, you have been the one. You have been the one for me.
You will learn how SingleStore is different from MySQL, how to bring it into your application and how to scale your queries and data.
Absolutely. We use Gumroad for payment processing, so you can pay with your card or Paypal.
You most definitely can. Gumroad sends you an email when you make a purchase, and there's a link in the email for you to print an invoice.
Yes, the software is 10+ years old and is used by companies such as Siemens, Akamai, Dell, Cisco, Disney, Goldman Sachs, Hulu, Kelloggs, Uber, Sony and, of course, my company Fathom Analytics.
No problem. I'll refund you in full if you email jack@jackellisweb.com within 7 days of purchase, no questions asked.
The price displayed here is exclusive of VAT. Depending on your location, Gumroad may add VAT to your purchase.
I'm pleased to say that I absolutely do.
That's all for now.