Category Archives: MySQL

Flashback @MariaDB 10.3.8

Neverending story. Commited changes need to be rollback. Some vendors are not resolving this situation at all (stupidity of user is not their problem, indeed), some are providing solutions (Oracle). One of the latest news from MariaDB (10.2) was adding … Continue reading

Posted in MySQL | Leave a comment

Lightning MariaDB install (Manjaro openbox 0.8.11)

-a-

Posted in MySQL | Leave a comment

TokuDB 7.5.3 (MySQL 5.5.40) on Oracle Linux 6.6

Fascinated by fractal trees? Astonished by TokuDB storage engine? Watching new trends where MySQL/MariaDB serves as baseline and competitive advantages are based on storage engines? Welcome! 🙂

Posted in MySQL | Leave a comment

Master-master replication (MariaDB on Manjaro)

Sometimes it’s very useful to skip well-known master-slave replication scenario and focus on master-master possibility 🙂

Posted in MySQL | Leave a comment

Change data directory – MariaDB 10.0.x

One of most valuable thing is good documentation – for common database actions. I didn´t find any well documented step-by-step guide to change data directory in MariaDB, Debian environment. Please be aware that this one guide is not perfect and … Continue reading

Posted in Databases, MySQL | Leave a comment

MariaDB 10.x install – Debian 7.4 x64

As Debian is still using MySQL in default, there are very few steps to install MariaDB 10.x…

Posted in Databases, MySQL | Leave a comment

How MySQL (MariaDB,TokuDB) stores data

3rd part of my investigation how databases stores data in data file / container on disk. Oracle Databse and DB2 proved that plain text for saving tables is common. Let´s see opinion from most spreaded community database.

Posted in Databases, MySQL | Leave a comment

TokuDB installation (Debian 7.2 x64)

„Pure“ MySQL is dead. Thanks to Oracle approach, thanks to very few inventions in last years (=versions). Among MariaDB there are few other players trying to attract customer. TokuDB is from my opinion the best choice for mature storage engine.

Posted in Databases, MySQL | Leave a comment

Percona server in Manjaro linux

Percona  server, „less-known“ MySQL drop-in replacement for enterprises stands for high quality software. Percona is offering a lot and I really do recommend to test it!

Posted in Databases, MySQL | Leave a comment