Ideas, releases, practical guides, and perspectives from the people building with MySQL.
The Connectors team at MySQL has been reorganized and includes additional resources. It seemed fitting to have a meeting for those working on C/ODBC v5.
We had a week long meeting in Germany at a place called Bad Herrenalb (since 4 of the new resources are living in Germany).
By the end of the meeting we had a revised development plan in place with tasks assigned and target dates set.
More resources have been allocated to the Connectors team at MySQL and most of them are focused on either C/ODBC v3 bug fixs or C/ODBC v5 development.
The folks working on C/ODBC v3 have been knocking off bugs at speedy pace. The Engineering team have been lending their time as well by taking over the build-to-release process. Still others are working on improving QA by adding new tests and creating a new automated process to run them.
This work has resulted in a new release of C/ODBC v3.
So far, the MySQL Server RPM packages as provided by MySQL AB used to automatically start the mysqld process after the package has been installed. It has been like that since the very beginning and we think of it as a convenience for our users when they want to get up and running quickly.
However, Kristian raised an interesting point in BUG#27072 where he points out that automatically starting mysqld during the RPM installation might not always be the desired behaviour, especially in automatic installation environments or during a fresh installation (where the system might not be fully configured yet). Therefore he proposes to change this behaviour to not start mysqld as part of the installation.
While I personally agree with his proposal, this is of course a tricky decision: our users are familiar with …
[Read more]These two builds represent a major milestone for Virtual Appliances- they are the first appliances we have released that have shell access enabled!
That’s right! For everybody who asked for shell access, it is now enabled! Tasks such as migrating existing Cacti data, adding/editing cronjobs, or editing the php.ini file in the LAMP VA are now easily possible using the shell.
Other new/improved features include:
This is a distilled version of the talk I gave at the phpug Dortmund in March. I'll concentrate on the High Availability aspect here but I won't leave out Load Balancing completely. Also, this is in English while the talk was in German.
High Availability and Load Balancing
High Availability and Load Balancing are often used in combination if not synonymous which is as wrong as it can get. They certainly do have some things in common (several machines do something) and they are often needed at similar times (when a website becomes more important) but the fundamental ideas are quite different.
While Load Balancing spreads incoming http requests over several machines this is not a highly available setup. High Availability …
[Read more]Proven Scaling will sponsor three people to attend the MySQL Conference and Expo 2007 in Santa Clara, California, April 23-26!
That’s right, we will pay for your airfare and hotel, transport from the airport, and even a stipend for meals! MySQL AB has graciously provided us with conference passes for the Free Ride winners, so the winners will each receive a full conference pass.
Go to Proven Scaling Free Ride to enter. The deadline is midnight PDT (GMT-7), Friday March 23rd (just over a week away), so do it soon!
I look forward to reading your entries — and I hope to see you there!
Today I had a hard time dealing with mysql and transactions.
Somehow my transaction has been committed in the middle of the
statements. A short look into the manual revealed that there are
SQL command that implicit commit a transaction. While I do
understand that CREATE TABLE commits a transaction,
I was surprised that LOAD DATA INFILE does it too!
And since I use the nice REPLACE INTO SELECT ...
workaround found on mysqlperformanceblog (Hint: Always a great
resource!) I had to upgrade my development mysql server because
since version 5.0.28 LOAD DATA INFILE does not
commit a transaction.
Today I spoke on MySQL at PHP Quebec. Here are my slides.. It was a first time giving this
presentation, so feel free to email feedback to morgan [[at]]
mysql.com.
Database migration is an old favorite, so I'm looking forward on
speaking again tomorrow!
Event Information
Topic:
Zmanda Management Console for Amanda Enterprise Edition
Date and Time:
Thursday, March 22, 2007 10:00 am
Pacific Daylight Time (GMT -07:00, San Francisco)
Panelist(s) Info:
Shailen Patel - Professional Services Engineer,
Dmitri Joukovski - VP of Product Management,
Ram “TK” Krishnamurthy - VP of Services and Support
Duration: 1 hour
Description:
The recently released Amanda Enterprise Edition 2.6, contains
Zmanda Management Console [ZMC]. ZMC is a web-based services that
is integrated with the Zmanda Network. This release also includes
Amanda Rapid Installer, a very simple and easy
to use installation mechanism that installs MySQL, PHP, Apache
and all …
Reading last few days worth of planet MySQL and commenting on some entries as you can see. The post by Oli catches my attention. There is also PDF with more details available
Oli is saying you can use MySQL with Active Active Clustering and MyISAM tables if you follow certain rules like enabling external locking, disabling query cache and delayed key writes etc. This is as far as many articles on this point go, and in theory this is what should work. In practice however you should think about what exactly are you looking for with this setup.
Performance ? This configuration adds effectively global table locks besides extra overhead you get from external locking. Plus key cache have to be invalidated with remote writes which makes even less …
[Read more]