Creating an optimal user experience is often the driving motivation of many developers and coders; after … How To Define User Sessions With SQLRead more
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 … Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication SetupRead more
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 … Best Practice for Creating Indexes on your MySQL TablesRead more
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 … How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same CostRead more
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 … 2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot PersistenceRead more