Dbasquare - dbasquare.com - dba square | A resource on MySQL
General Information:
Latest News:
Diagnosing problems with SQL imports 17 Apr 2013 | 11:38 am
Importing a text file containing a list of SQL commands into MySQL is a straightforward task. All you need to do is simply feed the file contents through pipe into MySQL command line client. For examp...
Granting privileges may break replication in MySQL 5.6.10 9 Apr 2013 | 08:35 pm
MySQL lets database administrators define access rights on many levels – from the ability to run global commands down to access to individual columns. Some rights can be applied to many different obje...
MySQL Security: Overview of MySQL security features 6 Feb 2013 | 09:13 pm
In a world driven by computers, most companies rely on systems that are entirely built around databases. Losing data, or even as little as losing the full control over it, could bring any business dow...
Hardening MySQL, FOSDEM 2013 – Improving MySQL security 3 Feb 2013 | 05:18 pm
If for any reason you couldn’t attend my talk at FOSDEM earlier today on improving MySQL security, I have already uploaded the slides. You can download them from here.
How slow can SSD be or why is testing a new server performance important? 28 Jan 2013 | 10:23 pm
Recently we have helped our customer to migrate their entire application stack from one data center to another. Before we were brought on-board, customer had already placed an order for a new set of s...
MySQL security issue — Heap Based Overrun, testing. 4 Dec 2012 | 08:36 pm
Without going into unnecessary details about CVE-2012-5612 bug; an authenticated database user could use this flaw to crash MySQL instance or even try executing some code. Is it a serious problem? Do ...
Recent security woes in MySQL 4 Dec 2012 | 03:27 am
For those who don’t know, several security vulnerabilities in MySQL were discovered recently and published to the security mailing lists. Yet another time, remote attacker can badly hit your productio...
FOSDEM 2013 conference, Call for papers 15 Nov 2012 | 01:40 am
For those who do not read opensqlcamp group — CfP for FOSDEM 2013 conference is open! Original email from lefred: “2013 is near… and so is the next FOSDEM edition ! This year again, MySQL will be repr...
Tip: how to save 10 minutes a day? 7 Aug 2012 | 07:49 pm
For any person actively working with MySQL databases on the command line level, logging in, logging out for a few moments, and then logging in again, all repeated many times, not only eventually becom...
Amazon EC2 now powered by high performance storage (benchmark) 20 Jul 2012 | 11:53 pm
A while ago I had a discussion with someone about the future of server infrastructure. Among other things, we were wondering whether companies will continue to run on dedicated servers or if eventuall...
