The MariaDB JIRA instance that currently is in use for project and issue tracking will change. The current instance is hosted in Atlassian’s cloud and it has worked well, but we have hit the maximum user limit of 2000 users. It’s fantastic to see how many of you actually report bugs and other issues in the MariaDB […]
The post MariaDB JIRA is moving appeared first on MariaDB.org.
With PEP 470 now requiring files to be hosted on
PyPI,
you may have noticed that MySQL Connector/Python is now no longer available
using the pip-tool.
The MySQL Engineering team at Oracle really would like to have the connector available through PyPI and have been talking with the Python Foundation towards that. We know users and developers of OpenStack, for example, have requested this as well as lots of other Python users.
For now we suggest to download the latest Connector/Python directly from the MySQL homepage:
Going forward …
[Read more]Last weekend I had the pleasure to attend the excellent FOSDEM conference in Brussels, Belgium. I indulged aplenty in pancakes with Nutella, a Belgian beer or two, and some truly interesting presentations. MySQL had a lecture hall for itself the whole weekend, and the booth conveniently located outside.…
The main schedule for the Percona Live Data Performance Conference is available. Almost everything has been defined. There are tutorials and plenty of sessions waiting for conference attendees.
One thing that is still undefined is the session of lightning talks. The …
[Read more]Restating MySQL can be really annoying. You just want to disable the goddamn query cache and it takes forever (read 5-10 minutes) to shutdown, not to mention the warm-up time. Yes, with MySQL 5.7 you can do many changes online, so you won’t necessarily be restarting that often, but you still need to do upgrades, occasionally increase redo log size and, admit it, enable skip-grant-tables. Here’s how you can make this process way less painful.
Why is MySQL so slow to restart?
Before we go any further, let me tell you right away that when I’m speaking about MySQL here, I’m actually speaking about InnoDB, or rather, a MySQL server that’s running InnoDB as the main storage engine. And if that’s not your case, do not read any further. You’ve been warned!
Now.. ah yes. Restart. So, restarting MySQL involves two slow stages. I have already mentioned them, but repetition is the mother of skill, so let me say …
[Read more]A few years ago, I wrote the original OmniSQL as a Perl script to automate the execution of queries across many MySQL servers and, in some cases, provide basic aggregation functionality. Shortly after that time, Justin Swanhart released Shard-Query and Domas Mituzas released pmysql, so OmniSQL was retired.
I’m a daily user of pmysql; indeed, we run a heavily patched version. Lately, I find myself needing to extend the functionality even more than we’ve already done. After a bit of evaluation, I decided that C wasn’t the best language to move forward with the new features. Thus, OmniSQL is reborn in Go. While initial testing indicates that it is an order of magnitude slower than pmysql running against 1,000+ instances of MySQL, it’s still well within my tolerance (and there are many areas of …
[Read more]Docker is incredibly popular tool for deploying software, so we decided to provide a Percona Docker image for both Percona Server MySQL and Percona Server for MongoDB.
We want to create an easy way to try our products.
There are actually some images available from https://hub.docker.com/_/percona/, but these images are provided by Docker itself, not from Percona.
In our images, we provide all the varieties of storage engines available in Percona Server (MySQL/MongoDB).
Our images are available from https://hub.docker.com/r/percona/.
The simplest way to get going is to run the following:
docker run --name ps -e MYSQL_ROOT_PASSWORD=secret -d …[Read more]
Correctness of data comes in different forms. One is referential integrity, also known as foreign keys. Another is CHECK constraints. While MySQL supports foreign keys, it doesn’t support CHECK constraints. Today we will look at three ways to emulate them:
This is also relevant to another SQL feature: DOMAIN, which, in short, is a user-defined type composed of a base type (INT, CHAR, …), a default value, and a constraint on acceptable values – the latter being some simple sort of CHECK constraint.…
MEB 3.12.0 and above support cloud backup and restore using OpenStack-compatible object stores ("Swift"). This allows MySQL database users with Oracle Storage Cloud account to take backups and store them directly in the cloud and restore them from there.
The following steps illustrate how to set up and use MEB with Oracle Storage Cloud :
1) Create Oracle Storage Cloud account at https://cloud.oracle.com/storage . Once service gets activated, make a note of the following credentials that will be required in further steps :
Username
Password
Identity domain name
Service Instance Name : Customer-specified name of the service instance
