Over the last few years there has been an increasing interest in
immutable data management. This is a big change from the
traditional update-in-place approach many database systems
use today, where new values delete old values, which are then
lost. With immutable data you record everything, generally using
methods that append data from successive transactions rather than
replacing them. In some DBMS types you can access the older
values, while in others the system transparently uses the old
values to solve useful problems like implementing eventual
consistency.
Baron Schwartz recently pointed out that it can be hard to get
decent transaction processing performance based on append-only
methods like append-only B-trees. This is not a very
strong argument against immutable data per se. …
Hi Apache Friends!
We are happy to announce a new release of XAMPP for all platforms. This is a minor release that fixes the following issues in both XAMPP versions. You can download new versions at http://www.apachefriends.org/download.html.
v1.8.3-3
- Updated PHP to 5.5.9
- Updated MySQL to 5.6.16
- Updated phpMyAdmin to 4.1.6
- Updated Apache to 2.4.7
- Fixed Mercury issue with queue folder
- Fixed issue with intl on Windows
- Fixed InnoDB issue with hard drives greater than 2TB
- Fixed XAMPP new security concept rules
- Fixed XSS issues in XAMPP web application
v1.8.2-4
- In addition to the previous fixes, PHP is updated to 5.4.25 and MySQL to 5.5.36.
After more than 12 years, we've launched a new …
[Read more]#DBHangOps 02/19/14 -- More Routines. More shard-query. More, more, more!
Hello everybody!
Join in #DBHangOps this Wednesday, February, 19, 2014 at 12:00pm pacific (20:00 GMT), to participate in the discussion about:
- Follow-up discussion on routines, functions, and trigger
- Justin Swanhart to demo more of shard-query and flexviews!
Be sure to check out the #DBHangOps twitter search, the @DBHangOps twitter feed, or this blog post to get a link for the google hangout on Wednesday!
See all of you on Wednesday!
Follow-up discussion on routines, functions, and trigger
-
Testing
- …
Yesterday I’ve put some new features into the ansible’s mysql_replication module, because we are planning to move to GTID based replication from the good old binlog position based one, and the module wasn’t aware of.
gtid_replication
This parameter can be either 0 or 1, defaults to 0. If set to 1 the replication will be threaded as GTID based replication.
warnings_filtered
This parameter threats the warnings, because MySQL 5.6 complaints a lot more than the previous versions. (For example, if the replication is not encrypted with SSL/TLS.) This could break our playbooks, so you can set it to all, warnings, none (defaults none). Speaks for itself, all means all warnings/errors will be shown, if warnings set, then only the errors will be shown, and the warnings supressed, and if none then that means, every message will be show …
[Read more]Big week for Southern California! I will be speaking at the LA MySQL Users Group on Thursday at 7PM in the Oracle Office on 200 N Sepulveda Blvd, El Segundo, CA. We will be in Room 4116 to talk about MySQL 5.7!
SCaLE 12x is THE big opensource show in Southern California and one of the more impressive conference on the planet. It may see a shame to waste temperatures in the low 80s by staying indoor but this show is amazing. So see you the 21st, 22nd, and 23rd at the LAX Hilton.
This week we discuss MariaDB's CONNECT storage engine. Ear Candy is inconsistent behavior with dates, NULLs and collations. At the Movies is a talk about the history and future of MySQL and its variants.
Sheeri:
The 2014 MySQL Community Awards are open for
nominations until Sunday, 23 February 2014
Events
DB Hangops -
every other Wednesay at noon Pacific time. Upcoming dates are
Wednesday February 19th, March 5th and March 19th.
MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to the MySQL protocol and MySQL resources. Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment. Oracle provides a number of these, enabling developers to build database applications in the language of their choice. Among those developed by Oracle are drivers for JDBC and ODBC. Any system that works with JDBC or ODBC can use MySQL. And you can find many more, including drivers for PHP, Perl, Python, Ruby, Tcl and even Eiffel!
To get a head start on developing with MySQL, take the MySQL for Developers training course. This …
[Read more]We recently announced Percona ClusterControl supplied in partnership with Severalnines. This enterprise-grade cluster management and monitoring software is available with a Percona Support contract covering Percona XtraDB Cluster, MySQL Cluster, or MySQL Galera. In this blog post I am going to show you how to use Percona ClusterControl to to create a new 3-node cluster with Percona XtraDB Cluster.
Percona ClusterControl architecture
The software has three main parts:
- Percona ClusterControl UI: This is the web interface from where we can create new clusters and monitor and manage …
As I review with my students, a stored function works like a
standalone program, while a stored procedure runs in the scope of
another program unit. For example, you can compare the result of
a function as an expression in an IF statement,
like:
IF add_numbers(1,3) > 3 THEN
...
ELSE
...
END IF;
|
You can’t call procedures inside an IF statement,
but you can call the procedure and use a single
OUT-mode (pass-by-reference) parameter from
the procedure in a subsequent IF statement. You can
implement a a wait procedure like that with the following
example.
The example first creates two tables, the
road_runner and coyote tables:
-- Drop road_runner table if exists. DROP TABLE IF EXISTS road_runner; -- Create roadrunner table. CREATE … |
MySQL has unfortunate rules for dates with two-digit years, for the date range, for post-decimal digits, for timestamp defaults ... But other DBMSs can be equally bizarre
Two-digit years
Start with two-digit years. Summarizing from the manual:
If the two-digit value is <= 69, add 2000. Else add
1900.
For example, if it's 65, then it's 2065.
It's an arbitrary extra detail that users have to learn. But PostgreSQL has exactly the same rule. And three other DBMSs -- DB2, …
[Read more]