m Other DB Servers

Owned by jim mason
Last updated: Jan 29, 2020
2 min read

Key Points

  1. Compare DB servers on features, performance for specific use cases
  2. MariaDB is a GPL server only limited by directly including the server IN a commercial app distribution
  3. MariaDB has some advanced security concepts over MySQL - a security proxy managing connections
  4. MariaDB supports 3 types of tables - relational, document, geospatial and wide column tables ( MySQL does not support wide column tables yet
  5. MariaDB is 95% compatible with MySQL
  6. MariaDB supports Oracle PL/SQL so migrations are easy
  7. MariaDB does not yet have array columns ( like Mongo, CouchDB for NoSQL repeating elements )


References

Reference_description_with_linked_URLs_______________________Notes______________________________________________________________


Compare Servers and Architecture
database-types-review-2018-dzone.com-The Types of Modern Databases.pdf
compare-MySQL vs. CouchDB vs. Couchbase comparison _ vsChart.pdf
compare-mongo-couchbase-cassandra-no-sql-technical-com-2020.pdfCompare couchbase - mongo - cassandra servers
disributed-db-sharding-strategies1.pdfCompare distributed database sharding strategies


Postgres
https://blog.couchbase.com/postgres-jsonb-and-nosql/Compare Postgres and Couchbase for NoSQL support
https://info.enterprisedb.com/rs/enterprisedb/images/EDB_White_Paper_Using_the_NoSQL_Features_in_Postgres.pdfPostgres - using NoSQL data - old 2015

https://www.slideshare.net/MarkusWinand/standard-sql-features-where-postgresql-beats-its-competitors?ref=https://modern-sql.com/blog/2018-02/standard-sql-features-where-postgresql-beats-its-competitors

postgresql-beats-others-features-2018-180203144337.pdf

Postgres improved features - 2018 - Wigand




MariaDB
https://mariadb.com/MariaDB
https://mariadb.com/kb/en/library/licensing-faq/MariaDB license FAQS - generally GPL unless server distributed with an app

https://mariadb.com/wp-content/uploads/2019/06/enterprise-open-source-database-comparison_whitepaper_1033.pdf?aliId=eyJpIjoiemZuRG84aloxUTY0TTBTaiIsIn
QiOiJcLzZQUkJ3N2w5eFBIZWFIQjBISk40QT09In0%253D

compare-Enterprise Open Source Database Comparison.pdf

compare MariaDB w MySQL DB - 2019
https://maxscale.readthedocs.io/en/stable/Documentation/About/About-MaxScale/MariaDB MaxScale has added security, network features
https://mariadb.com/kb/en/maxscale/MariaDB MaxScale docs


Apache Derby
http://db.apache.org/derby/Apache Derby - Java db that can be normal or local to JDK
http://db.apache.org/derby/docs/10.15/tools/rtoolsoptsimplejson.htmlApache Derby JSON support
http://db.apache.org/derby/papers/DerbyTut/Apache Derby Tutorial







Key Concepts


MariaDB has added features over MySQL Db



MaxScale

https://mariadb.com/kb/en/maxscale/


MariaDB MaxScale is a database proxy that extends the high availability, scalability, and security of MariaDB Server while at the same time simplifying application development by decoupling it from underlying database infrastructure.

MariaDB MaxScale is engineered with an extensible architecture to support plugins, extending its functionality beyond transparent load balancing to become, for example, a database firewall. With built-in plugins for multiple routers, filters and protocols, MariaDB MaxScale can be configured to forward database requests and modify database responses based on business and technical requirements — for example, to mask sensitive data or scale reads.

= Guardium + more

https://mariadb.com/kb/en/mariadb-maxscale-24/

includes support for

  1. multiple authentication methods
  2. data anonymization
  3. data masking
  4. advanced security filters
  5. REST api to manage request and responses - not an application interface
  6. CDC - change data capture events for apps to subscribe to db events
  7. Both row and column storage formats
  8. Supports PL/SQL with parameters etc
  9. Support JSON same as MySQL
  10. Support aggregate pipelines


CDC is a new protocol that allows compatible clients to authenticate and register for Change Data Capture events. The new protocol must be use in conjunction with AVRO router which currently converts MariaDB binlog events into AVRO records. Change Data Capture protocol is used by clients in order to interact with stored AVRO file and also allows registered clients to be notified with the new events coming from MariaDB 10.0/10.1 database.




Potential Value Opportunities



Potential Challenges



Candidate Solutions



Step-by-step guide for Example



sample code block

sample code block



Recommended Next Steps