Mysql vs postgresql performance 20159/27/2023 Source-replica replication Source-replica replication other methods possible by using 3rd party extensions Multi-source replication with Redis Enterprise Pack Lua Redis Functions coming in Redis 7 ( slides and Github) Triggers yes yes publish/subscribe channels provide some trigger functionality RedisGears Partitioning methods Methods for storing different data on different nodes horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric partitioning by range, list and (since PostgreSQL 11) by hash Sharding Automatic hash-based sharding with support for hash-tags for manual sharding Replication methods Methods for redundantly storing data on multiple nodes Multi-source replication Visual Basic Server-side scripts Stored procedures yes proprietary syntax user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc. Streaming API for large objects proprietary protocol RESP - REdis Serialization Protocol Supported programming languages Ada no Secondary indexes yes yes yes with RediSearch module SQL Support of SQL yes with proprietary extensions yes standard with numerous extensions no APIs and other access methods ADO.NET yes yes specific XML-type available, but no XML query functionality. support for XML data structures, and/or support for XPath, XQuery or XSLT. Data scheme yes yes schema-free Typing predefined data types such as float or date yes yes partial Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes XML support Some form of processing data in XML format, e.g. ![]() Windows ported and maintained by Microsoft Open Technologies, Inc. Implementation language C and C++ C C Server operating systems FreeBSD
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |