SSL certificates have been a determinant of a properly configured hosting service for many years. Thanks to them we can be sure that the transmission between two computers is fully secure and impossible to decrypt. A few years ago we published an article: Secure SSL configuration on Apache server, where we described how to generate…
19 September 2017 Many server administrators have to face the problem of backing up their files when creating their architecture. This is a very important activity, because if something goes wrong, you can quickly restore your system to its pre-crash state with such files. The simplest tools for making basic backups are tar, gzip and lftp. The first…
28 June 2017 One of the most important activities in working with IT systems is the release of code for production or software update. Not so long ago, new versions of the software were available on CDs released several times a year in the form of newsletters. With the advent of agile software development, cyclical releases appeared at…
26 April 2017 Many Linux users know the Tail tool, which prints the number of last lines of text or stream. It is used as a diagnostic tool for checking changes in files. In today’s article we will present a much improved version of this tool – MultiTail.
Backup of a small database is not a problem. A few seconds of downtime in the application or at night is not a big problem for us. The difficulty arises when we really have a lot of records to archive. Such an example can be MySQL 5.5 database, which contains about 83 973 092 records,…
25 April 2017 What to do when we accidentally run a bad query based on MySQL? Is it possible to recover deleted data from MySQL? If we use binlogs, which we use for example in MySQL replication, we can do something about it.
18 April 2017 Generation of certificates SSL certificates for over 20 years have been the basic component of a properly configured website hosting service. A critical parameter determining the strength of SSL encryption is the length of the keys used. The longer it is, the more difficult it is to decrypt the transmission between two computers without a…
Which database engine to choose when creating a new database? This question is very often asked at the stage of designing a new application or system that will use MySQL database. There are usually two engines to choose from: MyISAM and InnoDB. The first engine is the default mechanism for storing data in older MySQL…
7 February 2017 MySQL is very popular as a database for many websites. Over time the database can grow to colossal size. Apart from storing page content (articles, comments, list of users), it also contains settings of the page or application itself. In this case, regular backup becomes a necessity. A large database is also a greater burden…
9 December 2016 Many organizations decide to migrate their services and infrastructure to the cloud. In this way, they want to reduce server maintenance costs and, above all, ensure scalability and high availability of applications. Unfortunately, the process of moving services to the cloud may prove to be very costly and laborious. Sometimes it turns out that it…