Ashisuto greatly expands support services for Enterprise users of MySQL & MariaDB open source database software
So, this is exciting news and something that my colleague Daniel Saito had been working on for years: enterprise-ready, 24/365 Japanese support for the MySQL and MariaDB databases!
Yesterday at the first Swedish MySQL User Group real meeting here
in Stockholm, I presented a talk on character sets, collations
and stuff like that. If you read this blog, you know that I have
written about this before, but the presentation I did yesterday
was a fair bit more detailed. You can view the full presentation
on slideshare:
One thing I talked a lot on was
collations and how they affect matters, and this has more of an
impact than you think, in particular when using UTF-8. You would
think that using UTF-8 most character set problems are …
PHP MySQL developers are confronted with three PHP MySQL APIs. That is confusing. Since mid 2012 the PHP manual suggests not to use the oldest and original PHP MySQL extension any more to cure the situation. Please, swap out ext/mysql in favour of either ext/mysqli or PDO_MySQL. Why to upgrade is below. Read on, if you are a PHP beginner, your PHP application is still using mysql_* functions of ext/mysql or you are a PHP trainer.
As a PHP consumer, tease your software vendors by asking whether they use the state of the art APIs! Here is a cut&paste test question to ask your vendor: do you support secure SSL connections to MySQL?
…
[Read more]I am seeking the help of the community. I am working on an evaluation project about schema design in open source applications. While it’s possible for me to download the software of many popular apps, and install the software and then do a mysqldump, it takes time. Quite often there is no simple schema.sql file, but a process for creating the schema. If you are using an open source project, would you take a moment and run the following.
$ mysqldump -u[user] -p --skip-lock-tables --no-data --databases [schema] > [schema].sql
This will only dump the table definitions, and should therefore contain nothing company specific. I have at this time:
I am open to any projects, and it doesn’t matter if the version is not the most current, what I am seeking is …
[Read more]
So a couple of blogs posts have come out recently that got me
curious to do a little more digging on how I might actually use
"SHOW PROCESSLIST". Btw those blogs posts are:
So we all know how this works:
Server version: 5.6.8-rc-log MySQL Community Server
(GPL)
MySQL 5.6.8 RC> show processlist\G
*************************** 1. row
***************************
Id: 20007
User: root
Host: localhost
db: test
Command: Query
Time: 0
State: …
MySQL Workbench 5.2.41 introduced the new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. As of Workbench 5.2.44 you can migrate databases from Microsoft SQL Server, PostgreSQL and Sybase Adaptive Server Enterprise. It also provides for generic migrations, i.e. migrations from other RDBMSes that are not explicitely supported, provided that they have a well behaved ODBC driver. More on this in an upcoming post…
Additionally, you can use the Migration Wizard to perform MySQL to MySQL database migrations, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL.
We have already described in a previous post how to use the Migration Wizard to migrate a Microsoft SQL Server database to MySQL. In this post we are going to …
[Read more]The Winter season for conferences is catching up speed.
DOAG
As I write this the DOAG conference in Germany is happening. It is one of the biggest (or the biggest?) Oracle user group conferences outside of USA. Many of my European friends in the MySQL space are talking there. As you know I have been a big fan of Galera Cluster for MySQL for over a year now, but I was perhaps a bit of an early adopter. Lo-and-behold, I was surprised to see the DOAG related press-release from SkySQL puts the creators of Galera first in their headline: Codership, SkySQL und weitere Top-Experten rund um das Thema ‘MySQL Datenbanken” in Nürnberg versammelt. Talk about crossing the chasm! Ralf Gebhardt, my other mentor …
[Read more]Une soirée de conférence et networking intitulée: "MySQL, le Cloud et MariaDB" Invitation - Meetup SkySQL
Mercredi 12 décembre 2012 de 19h à 22h30
SkySQL Ab vous invite à une soirée de conférence et networking intitulée :
If you are interested by a great and revolutionary HA solution for MySQL or even if you already have some experience with PXC and/or Galera, I invite you to attend the tutorial I will deliver in Percona Live MySQL Conference London 2012 (PLUK2012), December 3rd : Percona XtraDB Cluster in a nutshell.
Small amount of theory and a lot of exercises and examples to really tame the beast that PXC is !
A Codership engineer will also be present and happy to help me answering your questions.
Note to attendees: please bring your laptop with a recent Virtual Box installed and enough free space to store 3 VMs (+/-2G per VM). As said …
[Read more]Dawnstar Australis (yes, nickname – but I know him personally – he speaks with knowledge and authority) updates on The Real Victims Of The Click Frenzy Fail: The Australian Consumer after his earlier post from a few months ago.
Colourful language aside, I believe he rightfully points out the failings of the organising company and the big Australian retailers. From the Open Query perspective we can just review the situation where sites fall over under load. Contrary to what they say, that’s not a cool indication of popularity. Let’s compare with the real world: