The author selected the Free and Open Source Fund to receive a donation as part of the Write for DOnations program. Introduction Clustering adds high availability to your database by distributing changes to different servers. In the event that one of the instances fails, others are quickly available to continue …
Read More »How To Optimize MySQL Queries with ProxySQL Caching on Ubuntu 16.04
The author selected the Free Software Foundation to receive a donation as part of the Write for DOnations program. Introduction ProxySQL is a SQL-aware proxy server that can be positioned between your application and your database. It offers many features, such as load-balancing between multiple MySQL servers and serving as …
Read More »How To Manage and Use MySQL Database Triggers on Ubuntu 18.04
The author selected the the Apache Software Foundation to receive a donation as part of the Write for DOnations program. Introduction In MySQL a trigger is a user-defined SQL command that is invoked automatically during an INSERT, DELETE, or UPDATE operation. The trigger code is associated with a table and …
Read More »How To Build an Inspirational Quote Application Using AdonisJs and MySQL
The author selected the Tech Education Fund to receive a donation as part of the Write for DOnations program. Introduction AdonisJs is a Node.js web framework written in plain JavaScript that runs on all major operating systems. It uses the popular MVC (Model – View – Controller) design pattern and …
Read More »How To Implement Pagination in MySQL with PHP on Ubuntu 18.04
The author selected the the Apache Software Foundation to receive a donation as part of the Write for DOnations program. Introduction Pagination is the concept of constraining the number of returned rows in a recordset into separate, orderly pages to allow easy navigation between them, so when there is a …
Read More »