Relational databases are plenty scalable. I'm sure most of the biggest websites in the world use them.
Non-relational databases are better for doing certain things, but not all. I'd recommend looking at your specific models for your application and decide where relational vs non-relational makes sense. You can use both, just like it's common to use in memory key value stores like Redis in conjunction with any database.
Some Huge companies use SAP, they handle millions of transactions (database records) Yearly. Some probably a lot more. So That has always been good enough for me.
You have to properly handle huge data, i.e., archive old data, properly index, query only whats needed.
@sirbobz Well companies like Facebook and Twitter still use relational databases, so maybe stop worrying about what some person on the Internet said you “should” be using in a blog post and just build your project using well-tested technology.