PeterZaitsev

39 ms·

1. 451.▲
   by PeterZaitsev 8y ago

   If you need Advanced SQL Support ClickHouse is not there (Yet) but if you need high performance for relatively basic queries ClickHouse is great. It is developed mostly by ClickHouse staff but there is at least one company https:/&#x2
2. 452.▲
   Prometheus TSDB Storage Benchmark(percona.com)

   12 points by PeterZaitsev 8y ago|0 comments
3. 453.▲
   Scaling MySQL with ProxySQL(proxysql.com)

   19 points by PeterZaitsev 8y ago|7 comments
4. 454.▲
   by PeterZaitsev 8y ago

   Thanks! Same instructions should work for plain MySQL. Not sure if MariaDB is supported
5. 455.▲
   PostgreSQL MVCC Bloat and VACUUM Explained(percona.com)

   11 points by PeterZaitsev 8y ago|1 comments
6. 456.▲
   by PeterZaitsev 8y ago

   I am big fan of ClickHouse to supplement MySQL for some of the analytics needs. While ClickHouse does not have full SQL support, for many simple queries it 100 times faster than MySQL on the single system and with linear multi server scal
7. 457.▲
   Realtime replication from MySQL to ClickHouse(altinity.com)

   2 points by PeterZaitsev 8y ago|1 comments
8. 458.▲
   Faster Recovery for PostgreSQL with Delayed Standby(percona.com)

   8 points by PeterZaitsev 8y ago|3 comments
9. 459.▲
   by PeterZaitsev 8y ago

   If you're looking for high level of compression and outstanding insert performance RocksDB/MyRocks is a way to go
10. 460.▲
    MySQL 8 is getting INSTANT “add column”(mysqlserverteam.com)

    3 points by PeterZaitsev 8y ago|0 comments
11. 461.▲
    MySQL 8 vs. Percona Server 5.7(percona.com)

    2 points by PeterZaitsev 8y ago|0 comments
12. 462.▲
    RadonDB – Cloud Native MySQL Compatible Distributed Database(github.com)

    3 points by PeterZaitsev 8y ago|0 comments
13. 463.▲
    JSON and JSONB in PostgreSQL(tapoueh.org)

    1 points by PeterZaitsev 8y ago|0 comments
14. 464.▲
    by PeterZaitsev 8y ago

    Wait to see when Percona Server 8 comes out :)
15. 465.▲
    by PeterZaitsev 8y ago

    What do you see as the difference ? Under SQL engine there tend to be some lower level API
16. 466.▲
    by PeterZaitsev 8y ago

    MyRocks is LSM based. The LSM is different from BTREE in what you need to do multiple "physical" lookups and merge result to perform one logical lookup. There are some tricks like Bloom Filters are employed to optimize it but it
17. 467.▲
    by PeterZaitsev 8y ago

    This is common misconception. The larger there is a cost of sub-optimal performance. If you spend $1000/month on your infrastructure, halving infrastructure cost will save you $500/month which can't justify a lot of investm
18. 468.▲
    by PeterZaitsev 8y ago

    Yeah. Innodb is heavily optimized for PK lookups.
19. 469.▲
    by PeterZaitsev 8y ago

    The benefit of LSM for Write workloads is a lot higher with large data sets. Optimizing BTREE in memory is cheap, BTREE on disk requires a lot of IO LSM however does not require as much disk IO for inserts even if data is much larger tha
20. 470.▲
    by PeterZaitsev 8y ago

    There is another side to MyRocks/RocksDB Story - Compression With a lot higher compression than possible with Innodb MyRocks can be in memory (File Cache) when Innodb workloads are already IO bound. Plus you can save a lot on disk st
21. 471.▲
    by PeterZaitsev 8y ago

    Thank you (Percona Founder)
22. 472.▲
    by PeterZaitsev 8y ago

    Thanks. Fixed. Can't ever figure out when apostrophe is needed :)
23. 473.▲
    by PeterZaitsev 8y ago

    Note MyRocks really excels when data set is larger than memory. For mostly in-memory workloads many smaller users have Innodb is better.
24. 474.▲
    A Look at MyRocks Performance(percona.com)

    134 points by PeterZaitsev 8y ago|38 comments
25. 475.▲
    Free and Open Source Hot Backup for MongoDB(percona.com)

    1 points by PeterZaitsev 9y ago|0 comments
26. 476.▲
    by PeterZaitsev 11y ago

    There are many approaches to data consistency, including for example Eventual consistency, not only in databases but in any parallel programming. Different CPU architectures for example for years provided different memory consistency model
27. 477.▲
    by PeterZaitsev 12y ago

    Hi Rudmk, Thank you for using Percona Server!