We have been doing a lot of testing around JDBC connection performance and we have found a lot of interesting overheads in the various implementations.

Background

In our setup, we can have long geographical connections (ie. North America to Europe) which involve high latency.  In these geographical distributed setups, we have to work very hard to minimize the roundtrips to the database.  

In some setups, connection pooling isn’t possible and then a big pain point will be in connection creation.  We use a database proxy in order to maintain a pool of database connections to avoid creating new TCP connections, but the JDBC drivers available all issue queries after connection creation, which still need to make a roundtrip to the MySQL server to resolve.  Due to this our goal is to minimize the number of roundtrips to the DB during …

A legend is born: PHP Unconference Europe, Majorca. Nearly one hundred witnesses exist. The #phpuceu combines the proven concept of an unconference with the beauty of the island of majorca. Within a day after the end of the event, one third had bought a ticket for next years issue (May 9-10, 2015)! We all knew for years, unconferences work. We finally have one at a place that is easy to get and is just about perfect for any kind of visitor. Goal accomplished. Just a detail, PHP (partner happieness program) was missing…

The power of the people

Unconferences give power to the people. Participants gather in the morning to propose sessions and vote on an agenda for the day. Sponsors and participants never …

Ever had this nightmare of your system crashing, or you accidentally closing SQLyog and losing all your open tabs and queries? Don’t worry, we have you covered!

Introducing Session Restore. You can now restore your previous session along with all queries and history tab the way you left it. Here’s a quick video:

Session Restore is available for all SQLyog users. Existing customers can download the latest build from Customer Portal. To evaluate SQLyog, please download a 30-day trial.

We are very excited about this release, and hope that you will like it. We would love to hear your feedback.

Cheers,
Team SQLyog

Tweet

The post …

[ this is a re-posting of what I published on the MySQL server team blog a few days ago ]
 
When the MySQL server receives a SELECT query, the query goes through several consecutive phases:

• parsing: SQL words are recognized, the query is split into different parts following the SQL grammar rules: a list of selected expressions, a list of tables to read, a WHERE condition, …
• resolution: the output of the parsing stage contains names of columns and names of tables. Resolution is about making sense out of this. For example, in “WHERE foo=3“, “foo” is a column name without a table name; by applying SQL name resolution rules, we discover the table who contains “foo” (it can be complicated if subqueries or …

If you couldn’t attend the MariaDB & MySQL Community Event in April 2014, held at the Hilton Santa Clara, fret not as there are slides and videos uploaded for you to watch at your leisure. There is likely to be at least one more community event later this year, so watch the space.

Currently on the page, you’ll find most of the talks with slides and the videos are professionally done – with slide overlays. The audio could be better on some, but for an event that was pulled together by Monty in less than 3 weeks, it’s not too shabby. You can learn What’s new in MariaDB 10, a little more about the SPIDER storage engine, more about the …

I’ve had the opportunity to train lots of people on Percona XtraDB Cluster (PXC) over the last few years the product has existed.  This has taken the form of phone calls, emails, blog posts, webinars, and consulting engagements. This doesn’t count all the time I’ve spent grilling Codership on how things actually work.  But it has culminated in the PXC tutorial I have given annually at Percona Live MySQL Conference and Expo in Santa Clara, California for the last two years.  Baron even attended this year and had this say:

“Jay Janssen’s tutorial on Percona …

Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On OpenSUSE 13.1

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on an OpenSUSE 13.1 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi.

Welcome to the MySQL High Availability Blog. This blog is maintained by the High Availability team at Oracle to give our readers a bit of inside information regarding various topics around the MySQL high availability features.

A series of related discussions triggered by difficulty in setting passwords via scripts using the mysql command-line client when an account has an expired password caused me to look into the interaction between expired passwords and batch mode, and this blog post resulted.  I hope it’s a useful explanation of the behavior and the workaround to those troubled by it, and amplifies the excellent documentation in the user manual.

The ability to flag accounts as having expired passwords first appeared in MySQL 5.6, with further …

With MariaDB and MySQL we have always taken security seriously.

In MariaDB 10.0 we added roles to make it easier to administrate many users.

MariaDB and MySQL has also many different encryption functions, but what has been neglected in the past is to make encryption easy to use.

This is now about to change.

I recently had a meeting with Elmar Eperiesi-Beck from eperi about simplifying the usage of encryption. We agreed to start a close collaboration around encryption for MariaDB with an …