Question

Hi there, Could you please help me with the following: Weaknesses of MySQL

Thanks

Answer 1

Answer:

WEAKNESSES:

• Put away strategy and trigger is restricted

Contrast with Postgresql, MySQL has a little options when you have to compose put away methodology and trigger. The put away methodology give you code reuse and embodiment. Be that as it may, in MySQL, you don't get the same number of decisions as in different RDBMS like Postgresql.

• MySQL is difficult to scale

MySQL isn't intended to be versatile, even it's not difficult to influence it to scale, much the same as what Facebook did, however it requires some genuine building push to make it conceivable, normally you require a ton push to influence it to work.

On the off chance that you expect your application will develop to enormous size, you have to think about the choice of utilizing MySQL as your database. It might works fine toward the start, until the point that sometime you have to scale it. You may need to shard the data, that is, to circulate data from one table to various examples and machines, however MySQL don't bolster auto sharding, you have to keeps up the hubs physically. Imagine a scenario in which you need auto failover. You require outer utility or compose your own content.

The challenges of making MySQL versatile are driving individuals to change to NoSQL database like MongoDB.

• MySQL isn't for substantial measured data

MySQL works fine in most little or medium applications, yet when data measure develops, the execution debase. At the point when the data develops, just the basic and filed inquiry get great execution, for an entangled question, it effectively get ease back in some cases even unfit to satisfy the demand in passable timeout. You have to painstakingly outline your SQL inquiry to make it still accessible.

DEAR PLEASE DO RATE IT IF HELPS ELSE LET ME KNOW YOUR DOUBT.

THANK YOU!!