Global data access can greatly expand the reach of your business. Continuent Tungsten multi-site multi-master (MSMM) solutions enable applications to accept write traffic in multiple locations across on-premises and cloud providers. This includes the following important real-world use cases:
Improve performance for globally distributed users registering hardware devices by permitting updates
We’ll be publishing a series of posts on OpenStack and Trove over the next few weeks, diving into their usage and purpose. For readers who are already familiar with these technologies, there should be no doubt as to why we are incredibly excited about them, but for those who aren’t, consider this a small introduction to the basics and concepts.
What is Database as a Service (DBaaS)?
In
a nutshell, DBaaS – as it is frequently referred to – is a loose
moniker to the concept of providing a managed cloud-based
database environment accessible by users, applications or
developers. Its aim is to provide a full-fledged database
environment, while minimizing the administrative turmoil and
pains of managing the surrounding infrastructure.
Real life example: Imagine you are working on a new application that has to be accessible from multiple regions. Building and maintaining a large multiregion …
[Read more]
MySQL Fabric is a tool included on MySQL Utilities that helps you
to manage your MySQL instances.
It works by basically adding a new layer between your application
and MySQL instances, which can provide an easy way to use
sharding and build a high available system.
For More information about what is MySQL Fabric, please follow the documentation.
To install our Fabric environment, we will have to configure 4 servers, I will use the follow names and IP on this tutorial:
fabric1 (192.168.0.200) - fabric mysql1 (192.168.0.201) - mysql master mysql2 (192.168.0.202) - mysql slave mysql3 (192.168.0.203) - mysql slave
Note: I’m running CentOS 6.5 on all servers.
1. Add mysql repo on all 4 machines, please read …
[Read more]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]