• drapeau français
  • System administration (8)
  • Database (12)
  • Diverse (1)
  • Development (21)

Backup shell script for MySQL databases

  • Dec 5, 2018
  • System administration
  • Linux, MySQL, Backup, Shell
MySQL logo

Having a strategy of backup information is really important. We tend to neglect it and think about it after the first loss of information. Here is my backup script of my MySQL databases. Read the post

Manipulate JSON in command line thanks to JQ example with cURL

  • Oct 31, 2018
  • Development
  • Debian, Linux, Shell
Shell logo

I almost use only the command line to make calls on APIs using cURL. It's convenient and fast, easily scriptable if needed and the history of bash saves me time. But the response provided by cURL is not always readable especially when it comes to JSON. In this article I will introduce JQ that I use to display a pretty readable JSON and more. Read the post

Alter table in MySQL and MariaDB without locking table with Percona Toolkit

  • Oct 17, 2018
  • Database
  • Linux, MariaDB, Performance, MySQL
MySQL logo

Alter table operation can be a very long task, depending on your database. It's often that database administrator wait too run these operations and do it late in the night to avoid disturbing user. But solutions exist to allow alter table without locking table, pt-online-schema-change from Percona Toolkit is one of these solutions. Read the post

Newer posts

Share

Search

Recent posts

  • Index document in Elasticsearch using PHP library: elasticsearch-php
  • Manage Elasticsearch indices with elasticsearch-php library
  • Using Behat to write functional test of a Symfony command

Tags

Debian Doctrine Fail2ban Jenkins Linux MariaDB Security MySQL Performance PHP PhpMyAdmin OOP RabbitMQ Backup Shell Symfony VIM Elasticsearch Ansible