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
database
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
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 years Scylla … [Read more...] about ScyllaDB Trends How Users Deploy The Real-Time Big Data Database
