To whom it may concern - a quick hands-on guide for running the Pentaho BI server behind a proxy
This post assumes you're running Ubuntu linux (or at least a Debian) and that you have both the apache Httpd server as well as the Pentaho BI server installed.
If you haven't got apache installed, this is your line:
$ sudo apt-get install apache2
You can then control the apache2 Http server using the
apaceh2ctl script. For instance, to start it, do:
If you follow what Percona is up to, you might have noticed that I’ve created a set of high-quality monitoring and graphing plugins for MySQL and related systems. Currently they support Nagios and Cacti. I’ll give a free webinar on March 28th discussing these, and more broadly, discussing how to monitor MySQL successfully to avoid common problems like spammy alerts about nonexistent problems.
When I install a MySQL package using MySQL Sandbox, if everything goes smoothly, I get an informative message on standard output, and I keep working.
In the yet to be released MySQL 5.6.6 DMR, there has been a change to the restriction of just one TIMESTAMP column with the DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP syntax. It is now possible for any TIMESTAMP to have either column defintion.
More information at http://dev.mysql.com/doc/refman/5.6/en/news-5-6-5.html
Just a reminder that I will be giving a talk “Percona XtraDB Cluster” on coming San Francisco MySQL Meetup, next Wednesday, March-21, 2012. Along with talk I will give away one full ticket (tutorials + sessions + expo hall) to Percona Live MySQL User Conference 2012 and three copies our new book “High Performance MySQL, 3rd edition”.
As ext4 is a standard de facto filesystem for many modern Linux system, I am getting a lot of question if this is good for SSD, or something else (i.e. xfs) should be used.
Traditionally our recommendation is xfs, and it comes to known problem in ext3, where IO gets serialized per i_node in O_DIRECT mode (check for example Domas’s post)
However from the results of my recent benchmarks I felt that this should be revisited.
We’re giving away three full conference passes (worth $995 each) to the Percona Live MySQL Conference and Expo, and you can win one simply by sharing the conference with your friends and colleagues! Second prize is one of ten copies of the new High Performance MySQL, 3rd Edition (worth $55 each), the recently released update to the popular second edition!
I am writing a specification for updating pt-online-schema-change. The outline of the changes I want to make is here: http://www.percona.com/docs/wiki/ptdev:blueprints:redesign-pt-online-schema-change