PHP Developer News

Choose a category: Blogs CMS Database Frameworks Web View All

Database News

Moving persistent data out of Redis

Moving persistent data out of Redis

9th January, 2017 by in Database

Historically, we have used Redis in two ways at GitHub: We used it as an LRU cache to conveniently store the results of expensive computations...

What MySQL 8.0.1 means to you as a Developer

What MySQL 8.0.1 means to you as a Developer

10th January, 2017 by in Database

This post will be updated as soon more information comes along. This developer version wasn’t released yet, when it does, use at your own...

MySQL Connector/C 6.1.9 GA has been released

MySQL Connector/C 6.1.9 GA has been released

10th January, 2017 by in Database

Dear MySQL Users, A new GA (general availability) version of MySQL Connector/C has been made available: MySQL Connector/C 6.1.9 GA. The MySQL...

How to Move a MySQL Partition from One Table to Another

How to Move a MySQL Partition from One Table to Another

10th January, 2017 by in Database

In this blog post we’ll look at how to move a MySQL partition from one table to another, for MySQL versions before 5.7. Up to version 5.7,...

Galera Cluster: adding a primary key to a  MySQL table which lacks it...  without downtime

Galera Cluster: adding a primary key to a MySQL table which lacks it......

10th January, 2017 by in Database

OK, let me start with saying that a table without a primary key shouldn't be something that a DBA should ever stumble into.  Sure, InnoDB will...

PHP and MySQL Basics

PHP and MySQL Basics

10th January, 2017 by in Database

PHP and MySQL have had a long intertwined path together. I have been talking with a lot of newbies in the past several months who are trying...

AngularJS Event Calendar/Scheduler

AngularJS Event Calendar/Scheduler

9th January, 2017 in Database

Day/week AngularJS event calendar/scheduler with drag and drop support. PHP and ASP.NET MVC backends.

What is the default sharding key in MySQL Cluster?

What is the default sharding key in MySQL Cluster?

9th January, 2017 by in Database

MySQL Cluster does an automatic sharding/partitioning to the tables across data nodes, enabling databases to scale horizontally to serve read...

Cédric Bruderer: Reset MySQL 5.7 password on macOS over the command line

Cédric Bruderer: Reset MySQL 5.7 password on macOS over the command line

9th January, 2017 by in Database

This one is for all MySQL-DBA's, which are working on macOS. Since the Apple OS has a rather peculiar way of starting and stopping MySQL, compared...