Industry analysis suggests that Google handles as many as two million pieces of data every minute.
Combine this “fact” with the challenge of managing a transactional workload with big data complexity riddled right through its centre and you can see why data analysis and both macro- and micro-level data management is a pertinent issue today.
The open source community submits that it may have a route to new agility in this space through building functionality on top of MariaDB to keep it from downtime by replicating copies of the database on servers, which are located in different parts of the world.
NOTE: MariaDB is described as an enhanced, backwards-compatible, drop-in replacement of MySQL. Capable of running on virtually all platforms, MySQL is a relational database management system (RDBMS) based on SQL (Structured Query Language).
Oracle has been accused of having an “ambiguous approach” to MySQL by users of MariaDB now that it has shouldered its stewardship in the post Sun-acquisition years.
Enter SkySQL, a provider of open source database solutions. The firm has now connected with Codership and Monty Program to release the latest MariaDB product, the MariaDB Galera Cluster.
NOTE: Monty Program Ab was founded by Michael “Monty” Widenius, the founder and creator of MySQL — the supporting website it intended to be a centre of engineering excellence for MariaDB, the Aria storage engine, MySQL and other associated technologies.
The Galera solution has been created by Codership, which is the home of several experts in clustering technologies for MySQL. They consider Galera their clustering masterpiece.
“It’s a true multi-master solution, where a setup consisting of several nodes accepts writes and reads on any node and synchronously updates the other nodes. DBAs will be able to increase service availability and distribute data automatically over several datacentres,” said the company, in a press statement.
SkySQL CEO Patrik Sallner has suggested that MariaDB Galera is an example of the combination of talent in open source community. He asserts that the importance of having critical systems online cannot be undervalued as it has direct financial impact on a business, therefore the Galera Cluster provides DBAs with confidence that every transaction will be protected.
“There are rival, mostly proprietary products in the market but I believe being open source gives customers a value for money product which frees them up to innovate,” said Sallner.
NOTE: LAMP is an open source web development platform that uses Linux as the operating system, Apache as the Web server, MySQL as the relational database management system and PHP as the object-oriented scripting language. (Sometimes Perl or Python is used instead of PHP.) The acronym LAMP refers to the first letters of Linux (operating system), Apache HTTP Server, MySQL (database software), and PHP, Perl or Python, principal components to build a viable general purpose web server.