Percona is glad to announce the release of Percona Server 5.5.49-37.9 on May 19, 2016.
Based on MySQL 5.5.49, including all the bug fixes in
it, Percona Server 5.5.49-37.9 is now the current stable
release in the 5.5 series.
Percona Server is open-source and free. Details of the release can be found in the 5.5.49-37.9 milestone on Launchpad. Downloads are available here and from the Percona Software Repositories.
Bugs …
[Read more]This tutorial describes the installation of a clustered web, email, database and DNS server to be used for redundancy, high availability and load balancing on Debian 8 with the ISPConfig 3 control panel. MySQL Master/Master replication will be used to replicate the MySQL client databases between the servers, Unison will be used to Sync the /var/www (websites) and the Mails will be synced with Dovecot.
Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.
|
Download the new ClusterControl 1.3 for MySQL, MongoDB &
PostgreSQL
This week we were excited to announce the release of ClusterControl 1.3. This release contains key new features, such as Key Management for MySQL, MariaDB, Percona Server and PostgreSQL, improved security, additional Operational Reports, along with performance improvements and bug fixes. Do check it out if you haven’t downloaded it yet, and let us know your feedback. … |
Some time ago, I published the article “AWS Aurora Benchmarking - Blast or Splash?”. In which I was analyzing the behavior of different solutions using synchronous replication in AWS environment.
After I published it, I received a lot of comments and feedback, from the community and from Amazon engineers.
Given that I had decide to perform another round of tests, keeping into account the comments received and the suggestions.
I had presented some of the results during the Percona conference in Santa Clara last April 2016. The following is the transposition into an article of that presentation with more details.
{autotoc enabled=yes}
Why new test?
Very good question, with an easy answer. …
[Read more]In this blog, we’ll discuss how to find the MySQL 5.7 root password.
While new MySQL software security features are always welcome, they can impact use and performance. Now by default, MySQL 5.7 creates a password for the root user (among other changes) so the installation itself can be considered secure. It’s a necessary change, but it has confused some customers and users. I see a lot of people on social networks (like Twitter) asking about this change.
Where is my root password?
The answer depends on the way you have installed MySQL 5.7 or Percona Server 5.7. I am going to show where to find the password depending on the installation method and the distribution used. For all these examples, I assume this is a new installation and you are using the default my.cnf.
Centos/Redhat – …
[Read more]Please join Alexander Rubin, Percona Principal Consultant, for his webinar MongoDB administration for MySQL DBA on Thursday, May 19 at 10 am PDT (UTC-7).
If you are a MySQL DBA and want to learn MongoDB quickly – this webinar is for you. MySQL and MongoDB share similar concepts so it will not be hard to get up to speed with MongoDB.
In this talk I will explain the following MongoDB administration concepts:
In this post, we’ll look at the results from some MySQL 5.7 read-write benchmarks.
In my past blogs I’ve posted benchmarks on MySQL 5.5 / 5.6 / 5.7 in OLTP read-only workloads. For example:
Now, it is time to test some read-write transactional workloads. I will again use sysbench, and my scripts and …
[Read more]A few weeks ago my friend Frank de Jonge told me he managed to improve an import into a MySQL server down from more than 10 hours to 16 minutes. According to him it had to do with several field types (too long fields to really small data), the amount of indexes, and constraints on the tables. We were talking about 1 million records here. He wondered if it was possible to make it even faster.
The basics
Turns out there are many ways of importing data into a database, it all depends where are you getting the data from and where you want to put it. Let me give you a bit more context: you may want to get data from a legacy application that exports into CSV to your database server or even data from different servers.
If you are pulling data from a MySQL table into another MySQL table (lets assume they are into different servers) you might as well use …
[Read more]The Severalnines team is pleased to announce the release of ClusterControl 1.3.
This release contains key new features, such as Key Management for MySQL, MariaDB, Percona Server and PostgreSQL, improved security, additional Operational Reports, along with performance improvements and bug fixes.
Join us next week on Tuesday, May 24th, for a live demo!
Highlights
ConFoo Vancouver: December 5th-7th 2016
We are happy to open the call for papers of ConFoo Vancouver 2016! If you are interested in speaking about web development and related topics, please submit until June 6th. We will cover travel and hotel for the speakers who require it if you want to know the quality of a great check stub maker.
ConFoo Vancouver will be held on December 5-7, 2016. For those who are familiar with ConFoo Montreal, that conference will still be running annually in addition to Vancouver. Visit our site to learn more about the event and …
[Read more]
