r3229 implements SSH tunneling via plink.exe on the session manager:



Thanks to all which voted for this issue.

We just announced VaultPress to the world. You can get your invite here. I’m very excited about this service because it is the first step toward my dream of every WordPress, regardless of where it’s hosted, to have best-in-the-world network (cloud? ) services that take all the worry and hassle away. People invest so much time, money, effort, blood, sweat, and tears into their WordPress-powered sites — they deserve for that to be 100% secure.

I’ve been wanting to write a backup script for a while now that does the following: reads the partition information for the directory that you are backing up into and computes the used/available/percentage-available space. Then it reads the total data size from the MySQL tables and ensures that you have enough space on disk (for [...]

Andrew from Sphinx continues to work on improving SQL (or SphinxQL) support and now he published benchmarks comparing arithmetic expression handling in Sphinx to one in MySQL. The result ? Sphinx scored 3x to 20x faster. Andrew goes to explain results are not 100% comparable (as we can see in the table results are even different) and some performance can be attributed to Sphinx using different typing for expression. Though I'm wondering how much of Performance difference that really explain. I doubt it is 20x. Andrew goes on to explain there are further optimizations possible for Sphinx such as JIT compilation and expression optimization which he claims can increase the lead even further

Andrew is kind enough to provide explanations and benchmark results though …

 
 I'm an advisor, investor and board member to several startup software companies including Revolution Computing, Pentaho and most recently Erply a new Software as a Service (SaaS) company.  One of the common threads I look for is the opportunity to disrupt a large market.

One of the things that made MySQL successful was its use of open source technology to disrupt the multi-billion dollar database market.  In Silicon …

Last month I spent two days in Belgium, after I got invited to the MySQL distro meeting. It was a non-public meeting with some people from Sun Microsystems and MySQL maintainers from different Linux distributions. It took place directly after FOSDEM (which I unfortunately could not attend due to personal reasons) at the Sun Microsystems Belgium office in Brussels. It was great to meet with Mathias Gug from the Ubuntu Server team in person. He had some really good ideas on how we could reduce the differences between MySQL in Debian and Ubuntu in the future. As a consequence, Debian will soon switch from Subversion to …

So everyone is blogging about NoSQL like there was just a divine intervention that handed us this epiphany just 2 weeks ago. Well I guess the term has still sort of fresh so everybody is busy making sure Google, Bing and friends get at least one hit on their blog when people search for NoSQL. Now is my turn.

A lot of the following is stating the obvious (though a lot of NoSQL posts from either side of the fence - why is there even a fence on this topic? - are not mentioning them .. so maybe not so obvious:

• use the right tool for the job (yes I still have use cases for MyISAM)
• NoSQL is a sucky name, because while some people also hate SQL, the key change is in dropping the relational model and/or ACID
• So yes you can take away the SQL interface from a MySQL storage engine and its still not what people think of when they say NoSQL
• You could stick an SQL interface in front of a NoSQL …

As I already wrote, I will be speaking at the MySQL Conference & Expo in Santa Clara in two weeks and I am excited to be there again. This year's conference is going to be interesting for a number of reasons, but most importantly I think that the schedule looks great! This is going to be a "drinking from the firehose of MySQL knowledge" event. Afterwards, I'll be on parental leave in May and June, so I likely will miss a lot of great conferences – these months are usually quite packed, as our Open Source Events Calendar can confirm. I just received a notice that my talk submission …

Fig. 1 Java access to MySQL Cluster

ClusterJ is part of the MySQL Cluster Connector for Java which is currently in beta as part of MySQL Cluster 7.1. It is designed to provide a high performance method for Java applications to store and access data in a MySQL Cluster database. It is also designed to be easy for Java developers to use and is “in the style of” Hibernate/Java Data Objects (JDO) and JPA. It uses the Domain Object Model DataMapper pattern:

• Data is represented as domain objects
• Domain objects are separate from business logic
• Domain objects are mapped to database tables

The purpose of ClusterJ is to provide a mapping from the table-oriented view of the data stored in MySQL Cluster to the Java objects used by the application. This is achieved by annotating …

Google Summer of Code is now open for student applications and people (like Ronald Bradford) are noticing that MySQL is not participating this year. (Drizzle otoh is a mentoring organization.)

read more