Creating an optimal user experience is often the driving motivation of many developers and coders; after all, if our products and services aren't helping people enjoy their online services as efficiently as possible, what's the point of creating them? As many developers and coders are coming to realize, however, defining a user session to leave a positive impact on those who … [Read more...] about How To Define User Sessions With SQL
sql
PostgreSQL Connection Pooling: Part 2 PgBouncer
When it comes to connection pooling in the PostgreSQL world, PgBouncer is probably the most popular option. It's a very simple utility that does exactly one thing “ it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. A client connects to PgBouncer with the exact same syntax it would use when connecting directly to … [Read more...] about PostgreSQL Connection Pooling: Part 2 PgBouncer
Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup
In a MySQL 5.7 master-slave setup that uses the default semisynchronous replication setting for rpl_semi_sync_master_wait_point, a crash of the master and failover to the slave is considered to be lossless. However, when the crashed master comes back, you may find that it has transactions that are not present in the current master (which was previously a slave). This behavior … [Read more...] about Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup
Best Practice for Creating Indexes on your MySQL Tables
By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries. But, did you know that adding indexes to your tables in itself is an expensive operation, and may take a long time to complete depending on the size of your tables? During this time, you are also likely to experience a degraded performance of queries as your system … [Read more...] about Best Practice for Creating Indexes on your MySQL Tables
What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni – Infographic
Wondering which high availabilityframework to use for your PostgreSQL deployments? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni, in our Managing High Availability in PostgreSQL series. In these blogs, we dove deep into how the frameworks work, their setup requirements, pros and cons, and how they … [Read more...] about What’s the Best PostgreSQL High Availability Framework? PAF vs. repmgr vs. Patroni – Infographic
