Category Archives: MySQL
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
sudo pacman -S mysql
sudo systemctl start mysqld
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! 🙂
Sometimes it’s very useful to skip well-known master-slave replication scenario and focus on master-master possibility 🙂
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
As Debian is still using MySQL in default, there are very few steps to install MariaDB 10.x…
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.
„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.
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!