MariaDB is an open-source relational database made by the original developers of MySQL, supported by the MariaDB Foundation and a community of developers. The community states recent additional capabilities as including clustering with Galera Cluster 4, compatibility with Oracle Database, and Temporal Data Tables, allowing one to query the data as it stood at any point in the past.
N/A
SAP HANA Cloud
Score 8.9 out of 10
N/A
SAP HANA is an application that uses in-memory database technology to process very large amounts of real-time data from relational databases, both SAP and non-SAP, in a very short time. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk which means that the data can be accessed in real time by the applications using HANA. The product is sold both as an appliance and as a cloud-based software solution.
Our installation scenario is a MariaDB cluster composed of 3 nodes to achieve high availability in the service and in this way the application that accesses the backend (MariaDB) is always working and is not down at any time.
To achieve high performance of the application when accessing the database, a MariaDB MaxScale has been mounted that acts as a proxy for queries to the database.
SAP HANA Cloud works effectively with SMBs or small to medium-sized enterprises and requires an affordable, scalable ERP system. Companies that must implement SAP S/4 HANA as soon as possible. Companies looking to take advantage of the newest innovation from SAP are looking to cut expenses on their IT infrastructure. SAP HANA CLOUD is not suitable for 1. Large companies with intricate operational procedures. 2. Companies with stringent policies regarding data residency. 3. Businesses with a sizable SAP landscape on premises 4. Companies must closely integrate SAP HANA CLOUD with non-SAP systems.
MariaDB does well with PHP or Python (django) in a web environment. Developers are able to work quickly.
MariaDB is extremely well documented and has a gigantic support community. If you need ask a question on how to do things you can go to many placces online and find answers quickly.
MariaDB is fast! Queries with tens of thousands of rows are quick.
MariaDB is highly compatible with Oracle's MySQL. Basically the same thing but more open and with a brighter future.
With MariaDB it is so easy to import and export data, and backups are a cinch. This saves me so much time as compared to other RDBMS.
Driver Support - Some third party applications use database drivers that cause unexplained slowness with MariaDB. This can be worked around by using the MySQL drivers, but it's not clear what causes the problem in the first place.
Support - While online communities are helpful in diagnosing problems, there isn't as much professional documentation/support available for MariaDB as some of the other major database options.
Data Visualization - It would be helpful if there were more built in options for analyzing statistics and generating reports.
Requires higher processing power, otherwise it won't fly. How ever computing costs are lower. Incase you are migrating to cloud please do not select the highest config available in that series . Upgrading it later against a reserved instance can cost you dearly with a series change
Lack of clarity on licensing is one major challenge
Unless S/4 with additional features are enabled mere migration HANA DB is not a rewarding journey. Power is in S/4
At this moment we are not focusing on SAP, however would love to in the future. This is primarily because of our limited ability to generate more revenue to fund for SAP partnerships and products. Our initial tryst with SAP Partneredge open ecosystem didn't go as planned and we have shelved that for now. Hope we can revive in the future
MariaDB is very usable and stable to be used in production settings as an alternative to MySQL. The shortcomings of SQL are present but well understood in the community, and if the decision were to be made again, I would choose MariaDB over MySQL on future projects.
SAP HANA Cloud requires significant expertise on technical side to admin and manage it.It surely is lot of improvement over previous versions of SAPThe modern, role-based SAP Fiori interface has enhanced the user experience for applications like S/4HANA, though the complexity of the underlying database remains. For the average business user, the usability of SAP solutions running on the HANA database has seen a major transformation, largely thanks to the Fiori user interface.
Yes, I would recommend MariaDB Platform support because they answer very fast and with detailed information. They also help you with the design of the storage infrastructure, not only with the maintenance problems. On the other hand, this service is a bit expensive.
One specific example of how the support for SAP HANA Cloud impacted us is in our efforts to troubleshoot and resolve technical issues. Whenever we encountered an issue or had a question, the support team was quick to respond and provided us with clear and actionable guidance. This helped us avoid downtime and keep our analytics operations running smoothly.
Professional GIS people are some of the most risk-averse there are, and it's difficult to get them to move to HANA in one step. Start with small projects building to 80% use of HANA spatial over time.
It did not always compete against these technologies. Most of the time, it was complementing these databases for certain use cases to help provide a much more complete database. This makes more users want to use it to explore new solutions that help users. This is our target and how [we] work with MariaDb.
It enables preview and better cloud service than other cloud platforms. Easy document transfer and faster document transfer are the key points for the selection of the HANA cloud server. The preview of data before its execution is also one of the factors in the selection of the HANA server.
MariaDB has saved us enormously on licensing compared to our previous DB software vendor.
In service, it has enabled us (speaking as the internal DB team here) to provide better service to the other teams in the company as well as our customers, with less staff.
The level of hardware required for adequate performance, in our environment, has been much lower. Those savings have been substantial, above and beyond savings on licensing and DBA staffing levels.
