The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.11. This is a Stable (GA) release.
See the Release Notes and Changelog for detailed information on this release and the What is MariaDB 10.0? page in the MariaDB Knowledge Base for general information about the MariaDB 10.0 series.
[Read more]The PHP UnConference is taking place on May 17-18, 2014 on the Island of Majorka. MySQL team is going to be presented by Ulf Wendel at this event. As usual for all UnConferences there is no sessions/talks schedule announced prior the conference, attendees might vote for the most interesting topics at the event. So, do not miss to come to PHP UnConference at lovely Island of Majorka!! (in the case you still do not know whether come or not, maybe the price of tickets, weather forecast and/or flight ticket from several locations might convince you...).
The Solutions Linux & OpenSource …
[Read more]
DROP DATABASE IF EXISTS `gtid_test`;
CREATE DATABASE `gtid_test`;
USE `gtid_test`;
CREATE TABLE `tab1` (
`a` INT
) ENGINE=MYISAM ;
CREATE TABLE `tab2` (
`b` INT
) ENGINE=INNODB;
SET autocommit=0;
INSERT INTO `tab1` VALUES (1);
INSERT INTO `tab2` VALUES (1);
UPDATE `tab1` SET `a` = 5 WHERE `a` = 1;
– Error Code: 1785
— When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1, updates to
non-transactional tables can only be done in either autocommitted
statements or single-statement transactions, and never in the
same statement as updates to transactional tables.
This happens with MySQL 5.6 GTIDs (Global Transaction IDs) enabled and it is documented here: …
[Read more]Achieving the best possible MySQL Performance doesn’t have to be complicated. It’s all about knowing which tools are designed for the task at hand – along with some basic (yet often overlooked) best practices.
Join me Wednesday, May 14 at 10 a.m. Pacific for a free webinar titled, “Practical MySQL performance optimization.” I’ll be sharing the main areas for improving MySQL performance – along with what to specifically focus on in each. These will include:
And as I mentioned earlier, I’ll also show you the best tools for the job and how …
[Read more]The Perfect Server - OpenSUSE 13.1 x86_64 (Apache2, Dovecot, ISPConfig 3)
This is a detailed description about how to set up an OpenSUSE 13.1 64bit (x86_64) server that offers all services needed by ISPs and hosters: Apache web server (SSL-capable) with PHP, CGI and SSI support, Postfix mail server with SMTP-AUTH, TLS and virtual mail users, BIND DNS server, Pureftpd FTP server, MySQL server, Dovecot POP3/IMAP, Quota, Firewall, Mailman, etc. Since version 3.0.4, ISPConfig comes with full support for the nginx web server in addition to Apache; this tutorial covers the setup of a server that uses Apache, not nginx.
When you use MySQL and PHP, a PHP script can retrieve data from a MySQL database to display on the web page before the page is returned to the client. Such pages are known as dynamic web pages and can perform multiple actions including sending e-mails, embedding other web page content and interacting with databases.
To learn more about developing on the web with MySQL and PHP, take the MySQL and PHP: Developing Dynamic Web Applications course. You can take this 4-day live instructor-led course as a:
This week we discuss more Percona tools: pt-online-schema-change and pt-slave-find. Ear Candy is using the CONNECT storage engine to read GPX files, and At the Movies is Performance at Scale with TokuDB.
Events
DB Hangops -
every other Wednesay at noon Pacific time
OSCon 2014 at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.
Training
SkySQL Trainings
A while ago I wrote about some of the things that can make MySQL unreliable or hard to operate. Some time after that, in a completely unrelated topic, someone made me aware of a set of principles called 12-factor that I believe originated from experiences building Heroku.
That’s been over a year, and I’ve come to increasingly agree with the 12-factor principles. I guess I’m extremely late to the party, but making applications behave in 12-factor-compliant ways has solved a lot of problems for me.
This experience has repeatedly reminded me of one of the applications that continues to cause a lot of the kinds of pain that the 12-factor principles have solved for me: MySQL.
Example: configuration files. I initially thought MySQL’s technique of multiple configuration files …
[Read more]A while ago I wrote about some of the things that can make MySQL unreliable or hard to operate. Some time after that, in a completely unrelated topic, someone made me aware of a set of principles called 12-factor that I believe originated from experiences building Heroku.
That’s been over a year, and I’ve come to increasingly agree with the 12-factor principles. I guess I’m extremely late to the party, but making applications behave in 12-factor-compliant ways has solved a lot of problems for me.
This experience has repeatedly reminded me of one of the applications that continues to cause a lot of the kinds of pain that the 12-factor principles have solved for me: MySQL.
SELF14′s Zero to DBA track is back and starts with MySQL 5.7 – What is new, what is changing, and what we are breaking. The SouthEast Linux Fest has had amazing sessions and a strong database track in previous years. This year is more great content and you really need to plan on attending June 20th through the 22nd on Charlotte, NC. The social events around this show are fun and relaxed. And, after a short delay, you can see all sessions on SELF’s Youtube channel so you can really see sessions that conflict with your primary choices. This year the venue has changed to a more central location near the airport and their are lots of activities in the area for your family to enjoy in the beautiful surrounding while you get your tech itch scratched.
…
