Хай,

The differences between CockroachDB and MySQL are as follows:

    Latency: Since CockroachDB is a distributed SQL database, it will generally not be as low-latency as a single-node SQL database. This holds in the case of CockroachDB-vs-MySQL comparison too.
    SQL capabilities: CockroachDB can’t support some of the complex SQL operations like complex “JOINs”.
    Fitment for Analytics/OLAP: CockroachDB is less suitable for analytics/OLAP than MySQL.
    Popularity: MySQL has been around for much longer than CockroachDB, and it enjoys higher popularity.
    Scalability: CockroachDB scales much better for OLTP workloads than MySQL.
    Operational simplicity: You can start a new CockroachDB cluster by executing just a few commands. CockroachDB offers more operational simplicity than MySQL.

Кароч питання перформанс + фічі + known shitware vs HA + less features + unknown shitware

Спробуй найти людину, яка вміє в таргана. Зараз і по мускулю фіг людей знайдеш.


On 12.03.2024 16:11, Mykola Dzham wrote:


On Mar 12, 2024, at 14:36, Volodymyr Litovka <doka@funlab.cc> wrote:

Cockroach - це NoSQL, column-based. Не всім підходить.

Ем шо?
CockroachDB це RDBMS, яка повноцінно реалізує ANSI SQL.
Причому в деякі речі як то transaction isolation вона реалізує навіть краще, ніж Postgres.

_______________________________________________
uanog mailing list
uanog@uanog.kiev.ua
https://mailman.uanog.kiev.ua/mailman/listinfo/uanog