PHP Developer News

Choose a category: Blogs CMS Database Frameworks Web View All

Database News

Easy-to-use Perl scripts to backup your MySQL database with mysqldump and then FTP the files to a remote server

Easy-to-use Perl scripts to backup your MySQL database with mysqldump...

6th January, 2017 by in Database

Most users of MySQL utilize the mysqldump utility to backup their database. While mysqldump is handy and easy-to-use (and free), if you have...

Faster MySQL replication with group commit and delay

Faster MySQL replication with group commit and delay

4th January, 2017 by in Database

We’ve been having a problem with MySQL replication at work. Replicas periodically tend to fall behind and we couldn’t really figure out...

Tips and Tricks - How to shard MySQL with ProxySQL in ClusterControl

Tips and Tricks - How to shard MySQL with ProxySQL in ClusterControl

5th January, 2017 by in Database

Related resources  Sharding MySQL with MySQL Fabric and ProxySQL  MySQL Load Balancing with ProxySQL - an Overview  How to set up read-write...

Powerful MariaDB exports using MyMDBDump

Powerful MariaDB exports using MyMDBDump

5th January, 2017 by in Database

You can export data from MariaDB using mysqldump and a bunch of other tools, but if you need really flexible output format, this might not be...

Duplicate Indexes in MySQL

Duplicate Indexes in MySQL

5th January, 2017 by in Database

Why do we sometimes want to keep duplicate indexes?I’ve done dutiful DBA work in the past to identify and remove what are commonly called...

Caching and crashing in lm2

Caching and crashing in lm2

3rd January, 2017 by in Database

Background lm2 is my ordered key-value storage library. You can read my post about it here. There’s a lot to say about this little library,...

ToDoList 7.1 - An effective and flexible way to keep on top of your tasks

ToDoList 7.1 - An effective and flexible way to keep on top of your tasks

3rd January, 2017 in Database

A hierarchical task manager with native XML support for custom reporting.

Angular2 & WebApi (SPA) for Enterprise App - Part 8 - Build & Deploy Application

Angular2 & WebApi (SPA) for Enterprise App - Part 8 - Build & Deploy Application

3rd January, 2017 in Database

In this article, we will learn how to build and deploy the code

The mysql client, and some improvements

The mysql client, and some improvements

1st January, 2017 by in Database

The mysql client is a tool which I use every day as a DBA. I think it's a great tool. When I used a client of several other SQL and NoSQL databases...