Section 2: "COMPILE MARIADB IN ECLIPSE"
2.1 Download and prepare sources folder/>
We will need a directory to use as our playground, if you create
the user yoda in Section 1:
$ su - yoda
$ mkdir -p ~/playground
Download latest MariaDB 10 sources tar.gz and copy the archive into the above directory, you can latest sources from:
MySQL Fabric is a distributed framework that has high
availability and sharding as targets. It organizes the servers in
groups which use the standard MySQL Replication to providing
fault-tolerance. Shards are assigned to different groups thus
allowing applications to distribute both reads and writes and
exploit resilience to failures as well.
Information on groups, servers and shards are stored in a MySQL
Instance called state store or backing store. This instance is a
repository for all this information and the engine used might be
any supported by MySQL, although a transactional engine must be
picked to truly provide fault-tolerance. Note though that we have
been testing MySQL Fabric with Innodb and currently this the only
official engine supported.
Built upon the repository there are several functions that,
besides being used to retrieve information from and update the
repository, are responsible for the execution of …
I was interested to hear about semi-sync replication improvements in MySQL’s 5.7.4 DMR release and decided to check it out. I previously blogged about poor semi-sync performance and was pretty disappointed from semi-sync’s performance across WAN distances back then, particularly with many client threads.
The Test
The basic environment of these tests was:
As you might have noticed in the press release, we just released MySQL Utilities 1.4.3, containing MySQL Fabric, as a General Availability (GA) release. This concludes the first chapter of the MySQL Fabric story.
It all started with the idea that it should be as easy to manage and setup a distributed deployments with MySQL servers as it is to manage the MySQL servers themselves. We also noted that some of the features that were most interesting were sharding and high-availability. Since we also recognized that every user had different needs and needed to customize the solution, we set of to create a framework that would support sharding and high-availability, but also other solutions.
With the release of 1.4.3, we have a range of features that are now available to the community, and all under an open source license and wrapped in an …
[Read more]
MySQL Fabric is a new framework that automates High Availability
(HA) and/or sharding (scaling-out) for MySQL and it has
just been declared Generally Available.
This post focuses on MySQL Fabric as a whole – both High Availability and scaling out (sharding). It starts with an introductions to HA and scaling out (by partitioning/sharding data) and how MySQL Fabric achieves it before going on to work through a full example of deploying HA with MySQL Fabric and then adding sharding on top.
Download and try MySQL Fabric now!
This post focuses on MySQL Fabric as a whole – both High Availability and scaling out (sharding). It starts with introductions to HA and scaling out (by partitioning/sharding data) and how MySQL Fabric achieves it …
[Read more]Today marks a milestone in terms of the MariaDB project – going forward, the MariaDB project plans to use Github and git for source code management. The migration happens from Launchpad and the bzr tool.
The 10.1 server development (under heavy development now) will happen on Github. You can check it out here: https://github.com/MariaDB/server. Feel free to watch, star or even fork the code, and send us contributions!
Previous maria-captains should now provide their Github IDs so that they can be accorded similar status. Send the IDs to the maria-developers mailing list.
The project eventually wants to move the 10.0, 5.5, 5.3, …
[Read more]This guide will help you in compiling and debugging MariaDB (MySQL, Percona) within the Eclipse IDE on Linux and using cmake for source project preparation. It will be split in parts to keep each post lightweight and with a finite objective. At the end of reading this series of blog posts you should be able to:
Recently, I’ve had reason to poke at MySQL performance on some pretty cool hardware. Comparing MySQL 5.6 to MySQL 5.7 is a pretty interesting thing to do when you have many CPU cores.
The improvements to creating read views in InnoDB is absolutely huge for small statements with large concurrency – MySQL 5.7 completely removes this as a bottleneck – as much as doubling maximum SQL queries per second, which is a pretty impressive improvement.
I haven’t poked at the similar improvements in Percona Server on this hardware setup – so I can only really guess as to the performance characteristics of it… If comparing to older MySQL versions, Percona Server 5.5 is likely to outperform MySQL 5.5 thanks to this optimization.
But I have to say… MySQL 5.7 is impressive …
[Read more]Installing Apache2 With PHP5 And MySQL Support On Ubuntu 14.04LTS (LAMP)
LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on anUbuntu 13.04 server with PHP5 support (mod_php) and MySQL support.
Very welcome to the MySQL High Availability blog. In the last year we have increased the effort on developing high availability solutions for MySQL and there is many new things upcoming. We will report about such things on this blog, including new development of MySQL Replication, MySQL Fabric, and other parts of the MySQL software. Enjoy!
