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 … [Read more...] about PostgreSQL Connection Pooling: Part 2 PgBouncer
database
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
5 Ways Small Businesses Can Maximize the Benefits of Automation
Owning a small business is challenging; between the government regulations, your competitors, and dealing with externals like the economy, it's a wonder anyone manages to survive the experience. One way to help your business is to take advantage of the technology available today and automate as much of your company's processes as you can. Here are five suggestions for … [Read more...] about 5 Ways Small Businesses Can Maximize the Benefits of Automation
ScyllaDB Trends How Users Deploy The Real-Time Big Data Database
ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. Released just four years ago in 2015, Scylla has averaged over 220% year-over-year growth in popularity according to DB-Engines. We've heard a lot about this rising database from the DBA community and our users, and decided to become a sponsor for this … [Read more...] about ScyllaDB Trends How Users Deploy The Real-Time Big Data Database
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
