June 18, 2013

Comment: MariaDB 5.3 is released as GA!

… distros would only want to patch security issues whereas MySQL also fixes non-security bugs like server crash, wrong result or just performance…

Post: Data Corruption, DRBD and story of bug

…), you screwed, as DRBD mirroring physical data, and MySQL keeping crashing on both instances – active and passive. So DRBD can’t… have access to bug #55543.”, because it is marked as “Security problem”. And I actually tend to agree that bug can be considered as “security“. If you running public hosting or your public users can…

Post: Should MySQL and Web Server share the same box ?

… and Web Servers is rather good practice. It is more secure – Compromising your web server does not directly give access to… is less expensive – You typically want database boxes to be secure, using good hardware with ECC memory to avoid database corruption… boxes memory failure, more likely you’ll have web server crashes and this sort of things. You can ether clone web…

Comment: Jeremy Cole on MySQL Replication

… you have battery backed up cache it is not 100% secure is someone is tricking you as drive can’t write that fast. It however could be reasonably secure – ie it will survive MySQL crash and even OS cache as the data is…

Comment: What to tune in MySQL Server after installation

… less secure as you can lose transactions even in case MySQL Server crashes. Value 2 only cause data loss with full OS crash

Post: What to tune in MySQL Server after installation

… less secure as you can lose transactions even in case MySQL Server crashes. Value 2 only cause data loss with full OS crash

Post: MySQL 5.6: Improvements in the Nutshell

…Optimized ROW Based Replication – Multi-Threaded Slave – Global Transaction Identifiers – Crash Safe Slave and Binlog – Replication Event Checksums – Time …Innodb – Microsecond TIME precision – Precise spatial operations in GIS Security – Password hashes instead of plain passwords in Query Logs …

Post: Traffic Tricks by Hosting Providers.

… have rather quick and automated fail over if it ever crashes we do not get into too much trouble. There is…, mainly to keep it isolated from everything else and be secure, while for our other projects such as ClickAider as development…

Post: Even minor upgrades are not always safe

… – newly added bugs do not have to Make MySQL to crash or make queries return complete nonsense. Such cases when query… long while if there are no problems with it (including security problems which would affect me)

Post: Using LVM for MySQL Backup and Replication Setup

… is as fast as putting data back and standard MySQL crash recovery, and it can be reduced even further. More on… it as snapshot while still having your data safe and secure. There are two types of snapshots – some of them are…