In this article, we will discuss the Docker image databack/mysql-backup, its configuration using Docker Compose, and some of the key features and parameters it offers for efficient MySQL database backups.
Post Category → Web Development
Ensuring Up-to-date Cloudflare IP Addresses in Nginx Configuration
When operating a web server, the reliability and performance of your server configuration can be heavily impacted by how well it handles traffic. One key aspect of this is managing IP addresses, particularly when dealing with reverse proxies like Cloudflare. Although Cloudflare’s IP addresses are not expected to change frequently, it remains crucial to stay synchronised with their most current IP ranges. This is where the cloudflare-nginx-snippets project steps in to automate the process.
Continue readingNginx 80 is blocked in Oracle Cloud Server?
The Oracle Always Free plan is an excellent option, but I found myself struggling with their firewall settings while attempting to run an Nginx web server. Despite enabling port 80 in both the network security groups and security lists, it was still being blocked for unknown reasons.
Firstly I checked the ufw settings and it was disabled definitely. However, when I looked at the iptable rules by executing sudo iptables -L, I was surprised by lots of existing rules there.
Continue readingDeal with Delivery acknowledgement timeouts of RabbitMQ
Sometimes we have to run background tasks with a quite long duration time. However, the RabbitMQ has a default time limitation for waiting the ack. If the execution time is exceed, you will got an error message like “Delivery acknowledgement timeouts” and your channel will be broken.
Continue readingLaravel MySQL Query Return Empty When there is a Deadlock
Suppose you have two processes executing the following PHP code at the same time, what results will be printed?
|
1 2 3 |
\DB::transaction(function (){ dump(User::where('id',1)->lockForUpdate()->first()); }); |
Surprisingly, one process prints the query results, while another process prints an empty collection (array). The code that returned an empty collection did not trigger a deadlock exception as expected.
Continue reading