* Security and Scalability * I have used Oracle technologies for last two decades apart from other similar vendors like MS SQL Server, IBM DB2, etc. * Power of Oracle combined with robust Unix platforms like Linux or AIX makes it powerful and... more»

Support and Patching. I found MS SQL Server support more helpful in many cases where in they internally rope in technology experts from different layers rather than pushing back on the clients, something Oracle can incorporate for sure.

We design and implement DW solutions with SS 2016 Dev Ed tools. This solution has given us high levels of productivity, which has allowed us to use an Agile approach to the design and implementation of DW solutions for our customers, and this... more»

We do not have much to complain about SS 2016 Dev Ed in itself, we do have some complaints regarding licensing for SQL Server 2016 Enterprise Ed. In an emerging market like Argentina, it is very steep for our customers to pay U$S 28,000 or... more»

Information Technology Technician at a tech vendor with 51-200 employees

Feb 14 2018

What do you think of MySQL?

Primary Use Case
We use MySQL and MariaDB for most part of our mission critical applications
This as it is so simple to integrate with web applications, and other well known applications.
• Improvements to My Organization
Since it has many integrations to web applications, it is very easy to install and deploy open source web applications.
• Valuable Features
How it uses clustering.
The API's to PHP, ruby, perl, java, python, and many more high level programming languages makes it easy for us to deploy new features fast.
• Room for Improvement
How to scale out with shard clusters.
The way how to handle replications needs to be improved, as we noticed that there are some performance drop of (using only one core for example)
• Use of Solution
More than five...

1. The ability to create multiple databases without using any additional memory and CPU, and reallocating resources among these databases as needed, dynamically, without restarting. 2. The marriage of snapshot technology with this alleviating... more»

Database development along several parallel projects used to be nightmarish when trying to keep the various tracks of development separate in a single database. With this, it is really easy to spin up a container for each project and then... more»

Initially, we used a relational database, MySQL along side Hadoop to create summary tables to produce our reports. Infobright allowed us to reduce the number of moving parts and complexity that we had while providing good performance to... more»

We ran into some quirks that Infobright had. We interacted with Infobright's support and were able to resolve them. There still are issues with data replication - Infobright is currently for one server (unless you buy the Infobright... more»

Ours is a DW environment, ETL extracts data from SAP and loads into the reporting database. The DBA objective was optimal performance for both nightly batch and reporting. We used the below features which significantly helped improve he... more»

This data is of our BI reporting. This reporting is open for all the warehouse managers to know all their financial status.The period end . We have very tight schedules. Every report has to complete in milli seconds seconds. The SLA are very... more»

For some reason, the stats optimizer doesn't work well. We actually disabled some of these features, such as the optimizer adaptive features. On the fly, the optimizer actually changes the explained plan, and that feature is really not... more»