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
MySQL
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
How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost
AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. As organizations continue to migrate to the cloud, it's important to get in front of performance issues, such as high latency, low throughput, and replication lag with higher distances between your users and cloud infrastructure. While many AWS users default to their … [Read more...] about How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost
2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence
Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular? We found all the answers you … [Read more...] about 2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence
