3 ms·
It seems like you're asking, "Is MySQL 8 magic?" No database will inherently do everything you need it to do (as a first class function), guarantee no loss of d
by relaunched 4y ago
It seems like you're asking, "Is MySQL 8 magic?" No database will inherently do everything you need it to do (as a first class function), guarantee no loss of data, be secure and require only a working knowledge to keep up and running as expected, all the time.
Now, in terms of requirements, it sounds like you need a DB that:
- Is highly available
- replicated (easily?)
- Secure
- Open Source (free?)
- Well documented / supported
Whatever your requirements are, you need to prioritize them and do some discovery work. Typically, you can rank the technology across categories and pick the one that best suits your needs. No DB is perfect for your application and they all require some level of expertise to keep working as expected. Lastly, and oftentimes, you use other layers in the stack and architectures to bridge any gaps in the core technology.
Good luck