Re: [uanog] galera vs postgresql replication

Хай, 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 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

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