In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, a new advanced option was added to the Export Data dialog to show all available MySQL data types on its Data Type combo-box to override its default behavior that shows only the most commonly used data types.
Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.
If you try to install the TokuDB storage engine on a modern Linux distribution it might fail with following error message:
2014-07-17 19:02:55 13865 [ERROR] TokuDB will not run with
transparent huge pages enabled.
2014-07-17 19:02:55 13865 [ERROR] Please disable them to
continue.
2014-07-17 19:02:55 13865 [ERROR] (echo never >
/sys/kernel/mm/transparent_hugepage/enabled)
You might be curious why TokuDB refuses to start with Transparent HugePages. Are they not a good thing… allowing smaller kernel page tables and less TLB misses when accessing data in the buffer pool? I was curious, so I asked Tim Callaghan this very question.
This problem originates with TokuDB using jemalloc memory allocator, which uses a particular trick to deal with memory fragmentation. The classical problem with memory allocators is fragmentation – if you allocated a say 2MB chunk from the operating system (typically using …
[Read more]Im giving some talks this year:
MySQL Hochverfügbar mit Galera
Location: FrOSCon
About: Learn about Galera and deploy it using LXC and Ansible
LBaaS-Loadbalancer as a Service
Place: GUUG Frühjahrsgespräche
Topic: It is a workshop ( together with Jan Walzer and Jörg Jungermann). We are going to show how to use LXC to provide slim loadbalancers.
Medley der Containertechniken
Place: GUUG Frühjahrsgespräche
Topic: Learn about all the basic techniques vanilla based Container technology uses/shares (Namespaces, Cgroups und Chroot). Have a look at some of them (LXC, Libvrit, systemd-nspawn and Docker)
MySQL Replikation: Von den Anfängen in die Zukunft
Place: DOAG 2014
Topic: Learn about the past and the future of MySQL (and MariaDB) replication.
We designed Percona Cloud Tools (both hardware and software setup) to handle a very high-intensive MySQL write workload. For example, we already observe inserts of 1bln+ datapoints per day. So I wanted to share what kind of hardware we use to achieve this result.
Let me describe what we use, and later I will explain why.
Server:
July 22, 2014 By Severalnines
We just wanted to make it official: Severalnines ClusterControl now supports MariaDB 10!
As most of you know will know by now, MariaDB 10 is the newest and most advanced version of the popular MariaDB relational database system. Whilst remaining application-compatible with the MySQL database, it adds many new capabilities to address the most challenging web and enterprise application use cases. Cluster deployments would be based on MariaDB Galera Cluster 10, which is a complete merge of MariaDB 10.0.12 and Galera Cluster.
ClusterControl for MariaDB Clusters
ClusterControl gives you the power to deploy, manage, monitor and scale entire MariaDB Galera clusters efficiently and …
[Read more]
Dear MySQL users,
MySQL Connector/Net 6.9.2 a new version of the all-managed .NET
driver for MySQL has been released. This is a RC release for
6.9.x and is not recommended for production environments.
It is appropriate for use with MySQL server versions
5.5-5.7.
It is now available in source and binary form fromhttp://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites
(note that not all mirror sites may be up to date at this
point-if you can't find this version on some mirror, please try
again later or choose another download site.)
Enjoy and thanks for the support!
On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.
Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on July 21st 2014. Binaries are available from downloads area or from our software repositories. We’re also happy to announce that Ubuntu 14.04 LTS users can now download, install, and upgrade Percona XtraDB Cluster 5.6 from Percona’s software repositories.
Based on Percona Server …
[Read more]
Dear MySQL users,
MySQL for Visual Studio is a product including all of the Visual
Studio integration. The 1.2.2 version is a release candidate
release of this product which is feature complete but still can
contain minor bugs and is not suitable for production
environments.
This version is appropriate for use with MySQL server versions
5.5-5.6.
How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7
Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on a CentOS 6.5 server with PHP support (through PHP-FPM) and MySQL (Mariadb) support.
I recently worked on a case where one node of a Galera cluster had its schema desynchronized with the other nodes. And that was although Total Order Isolation method was in effect to perform the schema changes. Let’s see what happened.
Background
For those of you who are not familiar with how Galera can perform schema changes, here is a short recap:
wsrep_OSU_method setting. Both have benefits and
drawbacks, it is not the main topic of this post.