Preface: The following post is a backup from a post first published on the Moviepilot Techblog, which is going to be replaced by the Moviepilot Labs Blog. The content is a bit outdated, as the way to go today is … Weiterlesen →

Version 1.5 completely embraces the very nature of the cloud, supporting real-time dynamic scaling for MySQL databases SANTA CLARA, CA and BOSTON, MA – February 14, 2012 – the database elasticity company, announced the release of version 1.5 of The ScaleBase Database Load Balancer. The new release offers real-time elasticity, enabling organizations to dynamically scale their [...] Read More

I will part of a panel discussing “SQL vs NoSQL along with Derick Rethans, Johannes Schlüter and Helgi Thorbjoernsson as the closing session on Saturday the 25th at PHP UK. Johannes and I may have a hard time as MySQL has both SQL and NoSQL support.

…

The new dashboard from the CloudStack 3.0 beta.

Over the last year I have been working on the CloudStack Open Source Cloud Computing project. This month we are getting ready to launch CloudStack 3.0 which really raises the bar for cloud computing platforms.  So what is CloudStack ? short It is an infrastructure-as-a-service(IaaS) platform that orchestrates virtualized servers into an elastic compute environment. The project was originally developed by Cloud.com and is now sponsored by Citrix since they acquired Cloud.com in July of 2011.

CloudStack provides multiple methods for interacting with the …

Read the original article at The Age of the Platform by Phil Simon

I picked up Phil Simon's The Age of the Platform after running into his blog, and some of his writing online. Simon is an interesting guy with an obvious strong technical background. He's also an accomplished speaker and you can find several videos of his speaking online.

The first thing that struck me about this book was how it came to be. The book was funded through Kickstarter, an online platform for people to fund their creative projects. Perhaps it was Simon trying to drive home the point of his book. But it gets better, he self-published the book through Motion Publishing. Furthermore …

I was doing some research on Percona Server, and came across this great tip by Baron: if you are using Oracle’s MySQL and want to test out and learn new/improved features that are present in Percona Server, you can just stop the mysqld instance, extract Percona Server binary from its rpm/deb package or tarball file, swap the binary, and do a successful restart. You can then do a test drive, kick the tires, learn and observe to your heart’s content. Swap the original mysqld back after you are done, as necessary.

I tested it and it worked great for me. Specifically, I did the following:
1. sudo /etc/init.d/mysql(d) stop
2. sudo cp /usr/sbin/mysqld /location/mysqldFromOracleOrWhatever
3. sudo cp /perconaBinaryDirectory/mysqld /usr/sbin/mysqld
4. sudo /etc/init.d/mysql(d) start
5. Test …

In Maximum MySQL Database Size? Nick Duncan wants to find out what the maximum size of his MySQL database can possibly be. He answers that with a list of maximum file sizes per file system type. That is not a useful answer.

While every file system does have a maximum file size, this limitation is usually not relevant when it comes to MySQL maximum database size. But let's start with file systems, anyway.

First: You never want to run a database system on a FAT filesystem, ever. In FAT, a file is a linked list of blocks in the FAT. That is, certain "seek" (backwards seek operations) operations become slower the larger a file is, because the file system has to position the file pointer by traversing the linked list of blocks in the FAT. Since seek operations are basically what a large database does all day, FAT is …

450 revisions after the 6.0 release follows the new 7.0 release of HeidiSQL now. Here are the most noticable changes since the 6.0 release:

- Basic support for Microsoft SQL Server, allowing to execute queries, edit grid data and to do a data-only export
- Introduce a separate dialog for all grid export actions, allowing to set up various options before file is created
- Threaded query execution, including a button to stop long running queries
- Enhanced completion proposal
- Grid editing support for binary primary keys
- Implement multi statements in one go for query tabs, to speed up large scripts with many single queries
- User manager: Random password proposals in dropdown menus
- User manager: Support account resource limits
- User manager: Support SSL settings
- Support pluggable authentication on MariaDB 5.2 and MySQL 5.5.7
- Indicate MariaDB and Percona Server …

450 revisions after the 6.0 release follows the new 7.0 release of HeidiSQL now. Here are the most noticable changes since the 6.0 release:

- Basic support for Microsoft SQL Server, allowing to execute queries, edit grid data and to do a data-only export
- Introduce a separate dialog for all grid export actions, allowing to set up various options before file is created
- Threaded query execution, including a button to stop long running queries
- Enhanced completion proposal
- Grid editing support for binary primary keys
- Implement multi statements in one go for query tabs, to speed up large scripts with many single queries
- User manager: Random password proposals in dropdown menus
- User manager: Support account resource limits
- User manager: Support SSL settings
- Support pluggable authentication on MariaDB 5.2 and MySQL 5.5.7
- Indicate MariaDB and Percona Server …

[Typo3 tt_news] How to fix "No news in this list":

Do you always get “no news in this list” (in German: “Keine News in dieser Ansicht”) although tt_news is correctly set up? Then maybe it’s because you have a LATEST plugin somewhere and the items shown there are not displayed in a LIST anymore. To avoid this, add

plugin.tt_news.excludeAlreadyDisplayedNews = 0

to your template (TypoScript setup).

There is a documentation bug that states it’s off by default, but it’s on…