I use Pingdom's free service to monitor slaptijack.com. Apparently, late Friday night, oom-killer decided that the server needed more memory and took out the MySQL server. To make matters worse, I missed the alarm from Pingdom, and slaptijack.com was down for pretty much all of Saturday. The fact that oom-killer was invoked is annoying, but more on that later.

The beauty of using Pelican rather than Wordpress (or any other database-driven content engine) is one less point of failure for the site. Obviously, I don't have all of slaptijack.com converted to Pelican yet (and perhaps never will), but at least parts of the site were up and working despite MySQL being down. If nothing else, this incident is enough to convince me that moving to Pelican was a good idea.

OOM'ed

…

Not so long ago I had a customer who experienced data loss after MySQL restart. It was really puzzling. MySQL was up & running for many months, but after the customer restarted MySQL server all tables have gone. The tables were still visible in SHOW TABLES output, but they were not readable:

mysql> show tables like 'actor';
+--------------------------+
| Tables_in_sakila (actor) |
+--------------------------+
| actor                    |
+--------------------------+
1 row in set (0.00 sec)

mysql> select * from actor;
ERROR 1146 (42S02): Table 'sakila.actor' doesn't exist
mysql>

To understand what’s happened let make some experiments (WARNING: Don’t do it on production or with valuable data).

Let’s take a healthy MySQL instance with installed sakila database.

While MySQL is …

Saturday I was in my favourite grocery store, standing in the line, browsing the net on my phone. I read Vadim Tkachenko‘s blog post about Measuring Percona Server Docker CPU/network overhead and his findings were the opposite than mine – he didn’t found any measurable difference. Reading his post, he did found huge impact in networking which I didn’t […]

How it feels when you realize that, something going to be scary in term of question – “Wait, why? how?”
Let’s see:

I am trying to allocate 9G buffer pool size with 64 instances:

innodb_buffer_pool_instances=64
innodb_buffer_pool_size=9G

From error log it said that:

InnoDB: Initializing buffer pool, total size = 16G, instances = 64, chunk size = 128M

“Wait, why? how?” N1

From select it is also allocated 16G:

mysql> select @@innodb_buffer_pool_size/1024/1024/1024;
+------------------------------------------+
| @@innodb_buffer_pool_size/1024/1024/1024 |
+------------------------------------------+
| 16.000000000000 |
+------------------------------------------+

Just continue to increase pool size:

If you give 17G:

[Note] InnoDB: Initializing buffer pool, …

Mon, 2016-02-15 07:58mariadb

MariaDB has been selected as Database of the Year in the Members’ Choice awards at LinuxQuestions.org for the third year running. Our thanks goes out to all of the community members who voted for MariaDB and who continue to contribute to the project to make MariaDB the best open source relational database.

The LinuxQuestions.org forum is the largest Linux user forum online, hosting from 100,000 to a million visitors every month. In a resounding show of support, fans gave MariaDB 45% of the vote, more than twice the votes received by the next nearest competitor. MariaDB had also won the award in 2013 and the …

I found this very simple yet very clear list of principles that can be kept in mind while developing for the web.

https://ethicalweb.org/

Excerpt from above link:

"As web developers, we are responsible for shaping the experiences of user's online lives. By making choices that are ethical and user-centered, we create a better web for everyone."

Hope it helps and guides us in creating a better web for everyone :)

MariaDB was voted database of the year for the third year in succession in the LinuxQuestions.org Members Choice awards, winning 45.49% of the vote, up from 34.21% last year. Thanks to everyone from the community that voted for us. 2016 will be a busy year, including the upcoming release of MariaDB 10.2. Take a look […]

The post MariaDB wins LinuxQuestions.org Database of the Year for the Third Year Running appeared first on MariaDB.org.

Whenever you need to get difference between two dates in hours in laravel 5 then you can get easily using Carbon Laravel by default provide Carbon class Carbon class throught you can calculate difference between two dates in hoursIn Following example you can see we have a two dates first to

Whenever you require to add one character or more to each and every key of array then most of the people would like prefer add key using for loop or foreach loop But we can do this without using any kind of loop using arraycombine arraykeys and arraymap through we can add prefix on each

This is a followup from my two previous posts on php and js git pre-commit syntax check where I had mentioned how to check for php and js syntax independently using pre-commit with git.



But what if we wanted to check for both php and js syntax at same time while committing. So, I used the scripts used for both and combined them. …