While InnoDB is a rather resilient storage driver, it is still possible it can get corrupted due to a disk failure or power outage. When it does happen, it’s quite possible your database will crash during startup with the following lines in the log: 170821 9:14:58 InnoDB: Assertion failure in thread 140081658566400 in file trx0purge.c […]
TIMESTAMP / DATETIME to Unix Time Unix timestamp handling is a bit different in MySQL and PostgreSQL, so when you’re rewriting SQL queries to work with the other database it’s good to know how to convert Unix timestamps. PostgreSQL postgres=# SELECT EXTRACT(epoch from timestamp with time zone ‘2016-02-25 12:15:17+01’); date_part ———— 1456398917 (1 row) MySQL […]
Master-slave replication can be used to replicate database to another server – as a hot standby backup, but it won’t offer any performance increase (all writes will still happen on one server). Configuring Master Database First, we set up MySQL config file vi /etc/my.cnf Find the following line to make MySQL listen on its network […]