1. |
Derby was developed by Apache Software Foundation. |
MYSQL was developed by Oracle Corporation. |
2. |
Derby is implemented in Java programming language. |
MYSQL is implemented in C/C++ programming Languages. |
3. |
The language supported by derby is Java. |
The languages supported by MYSQL are C, C#, C++, Python, Ruby, Java, PHP, Javascript and others. |
4. |
Derby was launched in August 2004. |
MySQL was launched on 23 May 1995. |
5. |
The Replication method used here is Master-Slave Replication. |
The Replication methods used here are Master-Master Replication and Master-Slave Replication. |
6. |
Derby suits well when there is need of small RDBMS in an application. |
MYSQL suits well for both small and large organizational data storage for an application. |
7. |
Derby is not well established in the market as compared to MYSQL. |
MYSQL is well established in the market and is used by organizations ranging from small to large. |
8. |
The speed provided by derby is fast. |
Derby is fast but C/C++ is faster as compared to Java, thus making MYSQL faster. |
9. |
The operating systems supported by Derby are Windows, macOs, Linux, Unix, BSD and z/OS. |
The operating systems supported by MySQL are Windows, macOs, Linux, Unix, AmigaOS, BSD, z/OS and Android. |
10. |
Derby does not support any partitioning methods. |
MySQL supports partitioning methods like hash, list, range and composite partitioning. |
11. |
Derby supports ACID properties. |
MySQL also supports ACID properties. |
12. |
No secondary database model is used. |
The secondary database model supported is Document Store. |
13. |
APIs and other access methods used by Derby is JDBC. |
APIs and other access methods used by MySQL are ADO.NET, JDBC and ODBC. |