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…
25 August 2016 “Continuous” is one recurring word that can be heard in discussions about DevOps, where almost everything is continuous. Working with DevOps means continuous integration, continuous implementation or continuous software delivery. So how Continuous Integration, Continuous Delivery and Continuous Deployment differ from each other. Let’s take a closer look at the idea of continuity and why…
19 May 2016 For those who have been working with DevOps for years and are heavily involved in this methodology, its growing popularity is as exciting as it will get its first job right after graduation! Well, maybe not as exciting, but still really great. More and more companies of all sizes are opting for DevOps, implementing methodological…
5 May 2016 One reason programmers dislike meetings so much is that they’re on a different type of schedule from other people. Meetings cost them more.
12 February 2016 Nowadays, software is widely delivered as a service (web application or SaaS). The twelve-factor app is a methodology that allows you to build such applications in a scalable horizontal way. It includes experience and observations from building a wide range of SaaS applications.