Sitting at the Hilton in San Francisco, listening to
the MySQL Connect opening Keynotes, sparks
interesting thoughts. Thoughts about the future of MySQL, the
Oracle stewardship, the MariaDB alternative and the advantage of
the solutions provided by the MySQL Ecosystem.
But there is something missing. I know something is not part of
this picture, but I can't figure out what it is.
At the end of keynotes and pane,l I turn to the exhibitors area,
an approx 800 sq ft., 50% occupied by Oracle. At the bottom left
corner stands my answer.
The small yellow cubic hive of AWS was at the top of the rollup
that reminds of MySQL and RDS, admittedly the most used version
of MySQL in the cloud so far. And here is the missing
part.
New great features in 5.6 Release Candidate and in MySQL Cluster
7.3
The new features …
Today, during MySQL Connect 2012 keynote, the General Availability of MySQL Connector/Python 1.0 was announced! This is the first GA release of Oracle’s pure Python database driver for MySQL.
MySQL Connector/Python v1.0 works with MySQL 5.5 and 5.6, but older versions of the MySQL servers are known to work. For Python, version v2.6, v2.7 and v3.1 and greater are officially supported. Python v2.4/2.5 are know to work as well.
As always, we welcome your feedback and questions through our bug system or using the MySQL Python forum.
Some useful links:
- Documentation: …
Sitting at the Hilton in San Francisco, listening to the MySQL Connect opening Keynotes, sparks interesting
thoughts. Thoughts about the future of MySQL, the Oracle
stewardship, the MariaDB alternative and the advantage of the
solutions provided by the MySQL Ecosystem.
But there is something missing. I know something is not part of
this picture, but I can't figure out what it is.
At the end of keynotes and pane,l I turn to the exhibitors area,
an approx 800 sq ft., 50% occupied by Oracle. At the bottom left
corner stands my answer.
The small yellow cubic hive of AWS was at the top of the rollup
that reminds of MySQL and RDS, admittedly the most used version
of MySQL in the cloud so far. And here is the missing
part.
New great features in 5.6 Release Candidate and in MySQL Cluster
7.3
The new features packed into …
There’s nothing like hearing directly from the developers. As an Oracle employee, I’ve already learned a lot about MySQL 5.6 and other recent updates. Nevertheless, I was impressed with a few new updates mentioned during the keynote. Here’s a list of items that caught my attention (disclaimer: this is a partial list)
**Performance — with the group commit feature in 5.6 and other 5.6 performance improvements, the overhead of sync_binlog=1 is less than 10%. In fact, with binlog enabled, 5.6 is faster than 5.5 without binlog enabled.
**Audit Extension — Oracle offers a dynamic plugin for enabling auditing for Sarbanes Oxley, PCI Compliance… (note: this is a commercial feature which requires a subscription)
**Foreign Key support in MySQL Cluster — I find it ironic that at the same time NoSQL is becoming more popular; we’re also seeing very high demand for foreign key support in …
[Read more]With Oracle OpenWorld just around the corner & MySQL Connect already underway I can’t believe yet another year has passed. This is my third OOW and I must have a following as folks are already reaching out to me on twitter @pythiansimmons (log buffer lady seems to be a handle I can’t seem to shake). [...]
In MySQL Enterprise Backup 3.6, new option was introduced to support backup to tapes via SBT interface. SBT stands for System Backup to Tape, an Oracle API that helps to perform backup and restore jobs via media management software such as Oracle's Secure Backup (OSB). There are other storage managers like IBM's Tivoli Storage Manager (TSM) and Symantec's Netbackup (NB) which are also supported by MEB but we don't guarantee that it will function as expected for every release. MEB supports SBT API version 2.0
In this blog, I am primarily going to focus the interface of MEB and Symantec's NB. If we are using tapes for backup, ensure that tape library and tape drives are compatible.
Test Setup
1. Install NB 7.5 master and media servers in Linux OS. ( NB 7.1
can also be used but for testing purpose I used NB 7.5)
2. Install MEB 3.8 also in Linux OS.
3. Install NB admin console in your windows desktop and …
In case you have missed any of the recent blog posts about MySQL
5.6 and MySQL 7.3 from MySQL Connect.
MySQL Connect 2012 Table of Contents:
- New Enhancements for InnoDB Memcached
- Helping to Reduce Page Compression Failures Rate
- InnoDB Compression Improvements in MySQL 5.6
- Performance Enhancement in Full-Text Search Query
- …
How do you shutdown mysqld? I tend to use SIGTERM. People where I work tend to use mysqladmin shutdown. When things get bad I use SIGKILL. These three methods will end up with a dead mysqld but the one you choose depends on the situation and can even result in lost data. On Linux the difference between SIGTERM and SIGKILL is significant and often times misunderstood.
Before processes start to die it is important to understand the relationship between mysqld_safe and mysqld. mysqld_safe is the watchdog script for mysqld. It is responsible for starting mysqld and keeping an eye on it. It does this by waiting for mysqld to exit then checking the return code. On a safe shutdown such as one done by mysqldadmin or a SIGTERM mysqld will return zero. When mysqld_safe sees a zero return code it will also exit. If the return code is anything else then mysqld_safe assumes mysqld crashed and starts a new instance of mysqld. This difference can help …
[Read more]I’m excited to be here not only to catch up with old friends and ex-colleagues, but also to witness what seems to be the start of a very significant conference from MySQL.
I really enjoyed the introductions done by Edward Screven and Thomas Ulin. Edward highlighted the fact that MySQL is increasing its presence in the market and in the community. This could be thanks to the unbelievable effort done by Oracle in keeping its production cycle on target. Thomas stressed that point and gave a great description of it. He demonstrated Oracle’s main focus points, which are mainly on InnoDB, with implementation and enhancement of the internal contentions, then on Optimizer improvements and NoSQL integration.
Replication remains a pending issue from my side because if we have the global transaction ID, we still suffer from delay in replication given that parallel replication is still working by, schema and not …
[Read more]For those with an interest in MySQL, this weekend's MySQL Connect conference in San Francisco has gotten off to a great start. On Saturday Tomas announced the feature complete MySQL 5.6 Release Candidate that is now available for Community adoption and testing. This announcement marks the sprint to GA that should be ready for release within the next 90 days. You can get a quick summary of the key 5.6 features here or better yet download the 5.6 RC (under “Development Releases”), review what's new and try it out for yourself! There were also product related announcements around …
[Read more]