Technical Specification

BME is written using cutting edge industry leading technologies such as ReactJS and is deployed to a MariaDB database.

ReactJS was developed by Facebook and is used by WhatsApp, Instagram, Medium Netflix, Amazon Prime, PayPal, Twitter, Walmart, Bloomberg, Tesla, the BBC and many more.

React Native is also used to build Mobile Apps, which is very useful for extending your operations to a mobile platform.

MariaDB Server is one of the most popular database servers in the world. It was created by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.

MariaDB turns data into structured information in a wide array of applications, ranging from banking to websites. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools which make it extremely versatile.

MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data. The latest versions of MariaDB also include GIS and JSON features. See their website for more. https://mariadb.org/about/

As MariaDB is open source, we have full control over the licensing, the hosting environment and development processes and therefore, we are able to manage ongoing costs, as we are not beholding to any provider.

Since MariaDB is a fork of MySQL, the database structure and indexes of MariaDB are the same as MySQL. This allows you to switch from MySQL to MariaDB without having to alter your applications since the data and data structures will not need to change.

MariaDB provides several improvements over running the standard MySQL instance. MariaDB aims for a drop-in replacement to MySQL, which makes the switch painless and straightforward. Combine the simplicity of switching with a long list of improvements, MariaDB brings both performance and cutting-edge features to the table. Below are some of its benefits over standard MySQL.

More Storage Engines Options

There are 12 new storage engines built into MariaDB. Among these are CONNECT, Spider, and SphinxSE. Visit their Storage Engines page for a complete list of these engines, how they function, and ways to leverage them to optimize your database.

Speed improvements

MariaDB sports many new speed improvements compared directly with standard MySQL. This improved performance makes MariaDB stand apart from the baseline performance of traditional MySQL servers. Like MySQL, MariaDB has dozens of features for speed optimization including disk access, JOIN and EXPLAIN improvements, subquery, derived tables/views, execution control, and optimizer control.

Faster Indexes/Cache

When using the MEMORY storage engine, MariaDB can complete INSERT statements up to 24% faster than traditional MySQL servers, along with CHECKSUM TABLE and MyISAM Segment Key Cache being 4x faster.

Speedier and Larger Connection Pool

MariaDB benefits from an improved pool of threads that run faster and support up to 200,000+ connections where standard MySQL falls short.

Improved Replication

MariaDB sports faster and safer replication with updates being up to 2x faster than with traditional MySQL Replication setups. Now possible, parallel replication allows the existence of Active/Active or Master/Master configurations. MariaDB replication is backward compatible with MySQL servers, so migrating your cluster to MariaDB is possible by utilizing one node at a time.

New Extensions/Features

There are several new extension and features, to name a few, the WITH, JSON and KILL statements. DECIMAL sees an increased from 30 to 38 decimals while KILL ALL queries for a specified user.
MariaDB is being used by more than 5,000 companies. This includes large Linux distributions Arch Linux, RedHat, CentOS, and Fedora, plus corporations such as Google, Fiat-Chrysler, Carrefour, Craigslist, Wikipedia, WordPress and many more.

So, considering the platforms as described above, scalability will never be in question.