Even in times of a growing market of specialized NoSQL databases, the relevance of traditional RDBMS doesn't decline. Especially when it comes to the calculation of aggregates based on complex data sets that can not be processed as a batch like Map&Reduce. MySQL is already bringing in a handful of aggregate functions that can be useful for a statistical analysis. The best known of this type are certainly:
Jul
14
2012
Jul
14
2012
If you read my blog from time to time, you know I am a huge
advocate of automating tasks. If I have to do something more then
once I might was well automate the task.
Currently at my new gig, we are using opennms. OpenNMS is a combo
of Nagios, Ganglia talking over SNMP Java goodness. They recently
released a REST API that is less then adequately documented
making integration rather difficult. But, I am jumping ahead
let's talk about the problem.
Backing up an INNODB Slave is rather easy with Percona's
xtrabackup program. It's free, works, offers better features than
its paid counter part. Additionally its opensource.
In my environment my algorithm is as follows:
Mount A Huge Disk over NFS which gets snapshotted
At the Start of the day (00:00:00 UTC) do a full backup.
The command used: innobackupex --user=root …
Jul
13
2012
This week we present the 100th episode (yes, we started at episode 0), which is part 1 of a 2 part interview with XKCD's Randall Munroe.
OurSQL Podcast history
Episode 0 was on November 26, 2006.
Episode 26 on December 16, 2010 added Sarah
Novotny as the first co-host and we hired our audio engineer and
producer, Rich Goyette, due to the support of Justin Kestelyn
and the Oracle Technology Network.
…
[Read more]
Jul
13
2012
After several months of hard work we are proud to announce a new
release of XAMPP for Windows and Linux.
The most important updates are: Apache 2.4.2, MySQL 5.5.25a, PHP
5.4.4, and phpMyAdmin 3.5.1.
After this release we will focus again on the Mac OS X version of
XAMPP. Sorry, for the delay, we're simply short on man
power.
Get the downloads and more details on the platform specific
XAMPP project page.
Jul
13
2012
Come joins us at a Birds of a Feather Session at OSCON
Moderated by: Dave Stokes
7:00pm Wednesday, 07/18/2012
D136
MySQL is the most popular web database and last years MySQL BOF
at OSCON attracted fifty people and ran well past the scheduled
hour (so please put us early on the night and do not book the
room right after). We had several big names in attendance as well
as general users of the product. This was a valuable question and
answer system for the MySQL developers and the community where
both groups received lots of valuable information.
And we will have some free goodies to hand out!
I can not promise that all the MySQL Engineers and Staff at OSCON will be in attendance as 7PM PDT is too late/early for some of them. But please attend if you are in the area!
…
Jul
13
2012
The following is an evaluation of various compression utilities that I tested when reviewing the various options for MySQL backup strategies. The overall winner in performance was pigz, a parallel implementation of gzip. If you use gzip today as most organizations do, this one change will improve your backup compression times.
Details of the test:
- The database is 5.4GB of data
- mysqldump produces a backup file of 2.9GB
- The server is an AWS t1.xlarge with a dedicated EBS volume for backups
The following testing was performed to compare the time and % compression savings of various available open source products. This was not an exhaustive test with multiple iterations and different types of data files.
|
Compression Utility |
Compression Time (sec) |
Decompression Time … |
|---|
Jul
13
2012
Meet The SkySQL Team At OSCON 2012!
“I remember my first OSCON in 2001 and the passionate debates we had on the impact the open source movement was going to make …”
This is a quote from a conversation that some SkySQLers were having this week in Paris, where we met to discuss the future - ours and that of the MariaDB & MySQL databases as well as open source technologies in general!
Jul
13
2012
I’ve written before about how you can monitor the last wait per connection with Performance Schema in MySQL 5.5.
That solution joined the performance_schema.events_waits_current with the performance_schema.threads and INFORMATION_SCHEMA.PROCESSLIST tables.
Joining to INFORMATION_SCHEMA.PROCESSLIST is a necessary evil within MySQL 5.5, to be able to get the user and host information etc. – however it is certainly not optimal, because using …
[Read more]
Jul
13
2012
There were few prominent SQL Injection attacks lately.
Such breakages could be possible when an attacker finds that user
data, sent to a SQL server, not properly sanitized.
Usually successful attack is preceded by queries which cause
parse errors.
mysql> select thread_id, sql_text from events_statements_history_long where event_name='statement/sql/er'ror;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ror' at line 1
Easiest test to find out if website can be attacked is to send, using web form or address bar, a value which contains special symbol, say "'", like in the word "D'Artagnan", then analyse if it was properly handled.
There are practices which web developer should use to avoid …
Jul
13
2012
One of the more notable success stories of the open source world is in the field of databases. A company with a strong commitment to open source has seen tremendous growth and success in the enterprise while contributing to a hugely respected open source code base. Who is that? Maybe your first thought was MySQL, now owned by Oracle. But unlike MySQL, this company is actually taking business away from Oracle so effectively that it's seen an 80 percent revenue growth in the last year.