KristiMKE

KristiMKE on Hacker News

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

Posted by KristiMKE on Wednesday July 29, 2020 @01:13PM
from the scalegrid.io dept.

https://scalegrid.io/blog/postgresql-connection-pooling-part-4-pgbouncer-vs-pgpool/

( Read More... | no comments | on HN )

Using Jsonb in PostgreSQL: How to Effectively Store and Index JSON Data

Posted by KristiMKE on Monday July 20, 2020 @01:30PM
from the scalegrid.io dept.

https://scalegrid.io/blog/using-jsonb-in-postgresql-how-to-effectively-store-index-json-data-in-postgresql/

( Read More... | no comments | 3 points | on HN )

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use and Functionality

Posted by KristiMKE on Monday July 13, 2020 @04:22PM
from the scalegrid.io dept.

https://scalegrid.io/blog/postgresql-vs-oracle-difference-in-costs-ease-of-use-functionality/

( Read More... | no comments | on HN )

Redis Transactions and Long-Running Lua Scripts

Posted by KristiMKE on Wednesday July 08, 2020 @12:40PM
from the scalegrid.io dept.

https://scalegrid.io/blog/redis-transactions-long-running-lua-scripts/

( Read More... | no comments | on HN )

MongoDB Index Builds – Preventing Users from Triggering New Builds

Posted by KristiMKE on Tuesday June 30, 2020 @01:25PM
from the scalegrid.io dept.

https://scalegrid.io/blog/mongodb-index-builds-preventing-users-from-triggering-new-builds/

( Read More... | no comments | on HN )

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean

Posted by KristiMKE on Monday June 22, 2020 @04:24PM
from the scalegrid.io dept.

https://scalegrid.io/blog/best-mysql-digitalocean-performance-scalegrid-vs-digitalocean-managed-databases/

( Read More... | no comments | on HN )

Re:ScaleGrid DigitalOcean Support for MySQL, PostgreSQL and Redis Now ... on Wednesday June 10, 2020 @09:45AM (#23476934)

Definitely, you can see the performance benchmark comparing workloads in this post: https://scalegrid.io/blog/comparing-postgresql-digitalocean-...

ScaleGrid DigitalOcean Support for MySQL, PostgreSQL and Redis Now Available

Posted by KristiMKE on Tuesday June 09, 2020 @10:30AM
from the scalegrid.io dept.

https://scalegrid.io/blog/scalegrid-digitalocean-support-for-mysql-postgresql-and-redis-now-available/

( Read More... | 3 comments | 2 points | on HN )

Comparing PostgreSQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean

Posted by KristiMKE on Thursday June 04, 2020 @03:44PM
from the scalegrid.io dept.

https://scalegrid.io/blog/comparing-postgresql-digitalocean-performance-pricing-scalegrid-vs-digitalocean-managed-databases/

( Read More... | no comments | 2 points | on HN )

Exploring MySQL Binlog Server – Ripple

Posted by KristiMKE on Friday May 22, 2020 @03:07PM
from the scalegrid.io dept.

https://scalegrid.io/blog/exploring-mysql-binlog-server-ripple/

( Read More... | no comments | 2 points | on HN )

Re:Ask HN: What PostgreSQL client do you use? on Monday May 18, 2020 @10:53AM (#23223073)

1. pgAdmin 2. DBeaver 3. Navicat 4. DataGrip 5. OmniDB

This article breaks down the pros and cons, features, and pricing for each of the top PostgreSQL GUI tools: https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2...

What Is Greenplum Database? Intro to the Big Data Database

Posted by KristiMKE on Wednesday May 13, 2020 @02:59PM
from the scalegrid.io dept.

https://scalegrid.io/blog/what-is-greenplum-database-intro-to-the-big-data-database/

( Read More... | no comments | 2 points | on HN )

Re:Reducing Your Database Hosting Costs: DigitalOcean vs. AWS vs. Azure on Thursday April 30, 2020 @03:09PM (#23034844)

Note the entire sentence:

ScaleGrid’s Dedicated Hosting service with 2 Replicas + Arbiter for MongoDB® database on DigitalOcean saves you on average 122% on your monthly AWS hosting costs, and 140% on your monthly Azure hosting costs.

This is sentence is about AWS vs Azure vs DigitalOcean hosting costs at ScaleGrid. Earlier in the article you can compare instance costs across the cloud providers by RAM.

Reducing Your Database Hosting Costs: DigitalOcean vs. AWS vs. Azure

Posted by KristiMKE on Tuesday April 28, 2020 @03:50PM
from the scalegrid.io dept.

https://scalegrid.io/blog/reducing-your-database-hosting-costs-digitalocean-vs-aws-vs-azure/

( Read More... | 6 comments | 22 points | on HN )

Bring Your Own Cloud (BYOC) vs. Dedicated Hosting at ScaleGrid

Posted by KristiMKE on Thursday April 16, 2020 @04:32PM
from the scalegrid.io dept.

https://scalegrid.io/blog/bring-your-own-cloud-byoc-vs-dedicated-hosting-at-scalegrid/

( Read More... | no comments | on HN )

Re:PostgreSQL is the worlds’ best database on Friday April 03, 2020 @11:32AM (#22770260)

Check out ScaleGrid's BYOC plans. They are similar to RDS, but give you the option to host in your own AWS or Azure account. ScaleGrid supports MongoDB, Redis, MySQL and Postgres. https://scalegrid.io/pricing.html#section_pricing_byoc

PostgreSQL Connection Pooling: Part 3 – Pgpool-II

Posted by KristiMKE on Monday March 23, 2020 @05:40PM
from the scalegrid.io dept.

https://scalegrid.io/blog/postgresql-connection-pooling-part-3-pgpool-ii/

( Read More... | no comments | 3 points | on HN )

Important Health Checks for Your MySQL Master-Slave Servers

Posted by KristiMKE on Monday February 17, 2020 @03:49PM
from the scalegrid.io dept.

https://scalegrid.io/blog/important-health-checks-for-your-mysql-master-slave-servers/

( Read More... | no comments | 2 points | on HN )

Follower Clusters – 3 Major Use Cases for MongoDB, MySQL and PostgreSQL

Posted by KristiMKE on Monday January 20, 2020 @03:18PM
from the scalegrid.io dept.

https://scalegrid.io/blog/follower-clusters-3-major-use-cases-for-syncing-sql-and-nosql-deployments/

( Read More... | no comments | 2 points | on HN )

How to Monitor MySQL Deployments with Prometheus and Grafana at ScaleGrid

Posted by KristiMKE on Friday January 03, 2020 @04:32PM
from the scalegrid.io dept.

https://scalegrid.io/blog/how-to-monitor-mysql-deployments-with-prometheus-and-grafana-at-scalegrid/

( Read More... | no comments | on HN )

PostgreSQL Connection Pooling: Part 2 – PgBouncer

Posted by KristiMKE on Thursday December 19, 2019 @04:42PM
from the scalegrid.io dept.

https://scalegrid.io/blog/postgresql-connection-pooling-part-2-pgbouncer/

( Read More... | no comments | 3 points | on HN )

Way to Host MongoDB on DigitalOcean

Posted by KristiMKE on Monday December 16, 2019 @03:27PM
from the scalegrid.io dept.

https://scalegrid.io/blog/the-best-way-to-host-mongodb-on-digitalocean/

( Read More... | no comments | 2 points | on HN )

Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup

Posted by KristiMKE on Monday December 09, 2019 @04:58PM
from the scalegrid.io dept.

https://scalegrid.io/blog/re-slaving-a-crashed-mysql-master-server-in-semisynchronous-replication-setup/

( Read More... | no comments | 2 points | on HN )

ScyllaDB Trends – How Users Deploy the Real-Time Big Data Database

Posted by KristiMKE on Monday November 25, 2019 @03:54PM
from the scalegrid.io dept.

https://scalegrid.io/blog/scylladb-trends-how-users-deploy-the-real-time-big-data-database/

( Read More... | 1 comment | 4 points | on HN )

Best Practice for Creating Indexes on Your MySQL Tables

Posted by KristiMKE on Wednesday November 20, 2019 @02:12PM
from the scalegrid.io dept.

https://scalegrid.io/blog/best-practice-for-creating-indexes-on-your-mysql-tables/

( Read More... | no comments | 3 points | on HN )

Making It Easier to Manage a Production PostgreSQL Database

Posted by KristiMKE on Wednesday November 13, 2019 @10:50AM
from the scalegrid.io dept.

https://scalegrid.io/blog/making-it-easier-to-manage-a-production-postgresql-database/

( Read More... | no comments | 2 points | on HN )

What’s the Best PostgreSQL High Availability Framework – Infographic

Posted by KristiMKE on Thursday October 31, 2019 @12:53PM
from the scalegrid.io dept.

https://scalegrid.io/blog/whats-the-best-postgresql-high-availability-framework-paf-vs-repmgr-vs-patroni-infographic/

( Read More... | no comments | 2 points | on HN )

How to Improve MySQL AWS Performance 2X over Amazon RDS at the Same Cost

Posted by KristiMKE on Thursday October 24, 2019 @01:15PM
from the scalegrid.io dept.

https://scalegrid.io/blog/how-to-improve-mysql-aws-performance-2x-over-amazon-rds-at-the-same-cost/

( Read More... | no comments | 3 points | on HN )

PostgreSQL Connection Pooling: Part 1 – Pros and Cons

Posted by KristiMKE on Thursday October 17, 2019 @01:03PM
from the scalegrid.io dept.

https://scalegrid.io/blog/postgresql-connection-pooling-part-1-pros-and-cons/

( Read More... | no comments | 2 points | on HN )

PostgreSQL Trends: Most Popular Languages, Vacuum, Query and Cloud vs. On-Prem

Posted by KristiMKE on Monday October 07, 2019 @02:25PM
from the scalegrid.io dept.

https://scalegrid.io/blog/postgresql-trends-most-popular-cloud-providers-languages-vacuum-query-management-strategies-deployment-types-in-enterprise/

( Read More... | no comments | 2 points | on HN )