English
| Previous 30 Newer Entries | Showing entries 61 to 90 of 29831 | Next 30 Older Entries |
Recently, I was working with a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with a different schema name on the same server. It caught me off guard because I’d never really thought about it – typically, I’ve used Xtrabackup simply to clone a server (for replication or migration) or migrate an existing schema to a new server. However, given the import/export functionality of Xtrabackup combined with Percona
MySQL continues to improve in terms of performance. To get the best out of MySQL, you must learn to analyze your system and use tools to monitor, evaluate and tune the MySQL Server.
The MySQL Performance Tuning training is a 4-day instructor-led course which teaches you to configure the database for performance, tune application and SQL code, tune the server, examine storage engines and assess the application architecture.
You can take this course through the following event types:
-0
A fascinating post-mortem on high profile network failures:
This post is meant as a reference point–to illustrate that, according to a wide range of accounts, partitions occur in many real-world environments. Processes, servers, NICs, switches, local and wide area networks can all fail, and the resulting economic consequences are real. Network outages can suddenly arise in systems that are stable for months at a time, during routine upgrades, or as a result of emergency maintenance. The consequences of these outages range from increased latency and temporary unavailability to inconsistency, corruption, and data loss. Split-brain is not an academic concern: it happens to all kinds of systems–sometimes for days on end. Partitions deserve serious consideration.
The two conservative ways of getting the number of rows in an InnoDB table are:
You can get a good estimate by calculating the total number of rows in steps. Walk the table 1,000 rows
[Read more...]The new release of the MySQL Performance Monitor (mpm) is out!
New additions and improvements
and much more (see below).
The MySQL Performance Monitor (mpm) for MySQL, Galera Cluster, Percona Server and MariaDB is a Monitoring Solution based on the Enterprise open source Monitor Zabbix.
It provides all the necessary modules to monitor MySQL performance metrics in detail and you can display them
[Read more...]The onslaught of the blogs is hard to ignore and underestimate. It is the blogging which has become part of the technologists everywhere including the database professionals and evangelists. This Log Buffer Edition appreciates that and consists of blogs from Oracle, SQL Server and MySQL.
Oracle:
Dass Oracle in Version 11 unter bestimmten Umständen große serielle Full Table Scans (FTS) mit Hilfe von Direct Path Reads durchführen kann, ist schon häufig erwähnt worden (hier im Blog mindestens in drei Artikeln) – zuletzt hatte Tanel Poder darauf hingewiesen, dass die Entscheidung für diesen Zugriff seit 11.2.
[Read more...]
Thanks to everyone who was in attendance on 05 June 2013 for my “Choosing a MySQL HA Solution” webinar. If you weren’t able to make it but are interested in listening to the presentation, it’s currently up and available for viewing over at percona.com.
My apologies if we weren’t able to get to your question during the initial session, so I’ll address those lingering questions in this post, along with providing a bit more detail on some of the questions that I did cover during the session.
Q: What
[Read more...]
Recently I had some time to do some clenaups/changes/updates in server:database repo regarding MySQL (and MariaDB). Nothing too big. Well actually, there are few little things that I want to talk about and that is the reason for this blog post, but still, nothing really important…
MySQL 5.6 is stable for some time already, so it’s time to put it in the action. So I sent the request to include it in Factory and therefore in openSUSE 13.1. There is off course a list of
[Read more...]
Alexei Rodriguez presenting at PLMCE13
During the Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can watch a video of his presentation on YouTube.
Alexei said he values having Percona tailor training to their needs, the expert delivery by our practitioner-trainers, and the ability to speak freely about operational issues during private training.
If you would like to talk with our team about private custom training, please contact Sally Martinez at (855) 55TRAIN or
(925)
Towards the end of last year, I was asked to investigate the Red Hat Software Collections by someone that popped by one of my talks. SkySQL has been working heavily with Red Hat, and with Fedora 19 shipping MariaDB as a default, it seems like MariaDB is getting even more distribution. The Red Hat Software Collections 1.0 Beta is now available for users of Red Hat Enterprise Linux 6.
From a database standpoint, users now get MariaDB 5.5. I encourage all to try it, as it is an in-situ upgrade. It is described as:
[Read more...]MariaDB version 5.5, which introduces an easy-to-adopt
+3
-0
How-To configure your MySQL to use PAM and/or Active Directory authentication with percona-pam-authentication plugin.Continuing articles about Two-Factor authentication or integrating Linux services with Active Directory, this How-To is one of my recent works that I have done these days, so I hope it may help the community with this guide to configure MySQL with PAM and subsequently using Active Directory to authenticate. If you are new here, please refer to SSH Two-Factor authentication, which explains how to install likewise and integrate your Linux with AD. However, we will have few exceptions to get MySQL working [Read more...]
Tokutek created the iiBench benchmark back in 2008. The point of the benchmark is to measure the performance of indexed insertions over time. It uses an extremely simple schema, one table with a sequential insertion pattern for the primary key along with three integer fields storing random values. The table maintains 3 secondary indexes, each including several of the random integer fields. The iiBench application itself is currently maintained on Launchpad.
B-tree implementations generally require maintenance operations to update leaf nodes (an insertion is one such operation). When the entire B-tree index does not fit in RAM an IO is required, and performance drops dramatically. Fractal Tree
[Read more...]
Now that June has arrived it is time to plan what you will do over the summer months. In addition to your summer vacation plans, give thought to MySQL training for you and your team.
Summer is the time to brush up on those critical skills needed to ensure all systems are ready for the holiday shopping season.
In addition to our revised courses, that I talked about in a previous post, we are also running our new Moving to MySQL 5.6 class. This class covers new features in MySQL 5.6, migration planning, and application
[Read more...]I’m interested in meeting up and sharing experiences about using MySQL and managing MySQL servers with people here locally in Madrid. I had a quick look around and could see no MySQL user groups locally, so it might be nice to create such a group and exchange ideas over a beer, coffee or cola every once in a while. If you’re in Madrid and are interested please let me know. I’ve created a temporary email address: madrid-mysql-users-2013 AT wl0.org (careful with the domain), which you can contact me on to confirm an interest. Oh and I’d expect these meet ups to be in Spanish, but that’s not a requirement.
Estoy interesado en reunirme y compartir experiencias sobre el uso de MySQL y administración de servidores de MySQL con la gente aquí en Madrid. He echado un vistazo en Internet y no he visto ningún grupo de usuarios de MySQL a nivel
[Read more...]When looking at high availability for any CMS, and particularly for Drupal, the list of contenders for part or all of the solution is growing and can be daunting. We'll take a look at the various parts of a solution and what options we have.
It seems nearly every answer to every problem in IT these days is "The Cloud", but is it?
Engine condition pushdown is a MySQL internal mechanism that is intended to avoid to send non matching rows from the storage engine to the SQL layer. This is very important when the storage engine involves traffic over the network. This mechanism was initially created to optimize MySQL Cluster (NDB) behavior. For the NDB storage engine [...]
It’s been written about everywhere, but since we keep spotting installations in the wild where people don’t know about it, it probably deserves another mention.
By default, Linux uses the atime option on a disk mount, which means it writes a timestamp (e.g. a write to the drive) every time it reads anything. So in this case, reads cause writes – and also disk seeks, because a read from a file will then trigger having to write to the directory that contains the file. This even occurs if a file is read from the file system’s page cache (reading from the machine’s memory rather than the drive).
Unless you require an audit trail of users reading files, you generally you don’t want this. Thus, you want to add the noatime option to the disk mount in /etc/fstab. If you have just the defaults in there, you just make it
[Read more...]
-9
Ever wondered how a database cluster ticks? Here’s how! During my talk at the International PHP Conference (#ipc13) I tried to build a cluster. I brought a soldering iron, sold, pink, orange and brown cables with me. Then, I tried to sold the thick (reliable, high throughput) brown cable at my company notebook (video coming). Eventually, I failed. Probably, I lacked the theoretical background?! Luckily, I got very theoretical slides with me…
DIY: A distributed database cluster, or: MySQL Cluster from Ulf Wendel
[Read more...]
OblakSoft is pleased to announce the release of ClouSE Beta version 1.0b.1.8. This is a minor maintenance release that addresses a couple pain points, while we’re working on a release candidate that will bring the built-in point-in-time recovery and other major features.
Here is the summary of changes:
Now ClouSE sets the cache control headers for Weblobs. The cache control headers specify the max-age directive that allows caching content for one year. This makes proxies and content delivery networks (CDN) more efficient. The change resolves this support issue.
Now database requests
[Read more...]Read the original article at Five More Things Deadly to Scalability
Join 6000 others and follow Sean Hull on twitter @hullsean. 1. Slow Disk I/O – RAID 5 – Multi-tenant EBS Disk is the grounding of all your servers, and the base of their performance. True with larger and larger main memory, much is available in cache, a server still needs to constantly read from disk [...]
For more articles like these go to Sean Hull's Scalable Startups
Related posts:
Or: how to make it work in TokuDB version 7.0.1. This is a follow up on a discussion on the tokudb-user group.
I wanted to test TokuDB's compression. I took a staging machine of mine, with production data, and migrated it from Percona Server 5.5 To MariaDB 5.5+TokuDB 7.0.1. Migration went well, no problems.
To my surprise, when I converted tables from InnoDB to TokuDB, I saw an increase in table file size on disk. As explained by Tim Callaghan, this was due to TokuDB interpreting my compressed table's "KEY_BLOCK_SIZE=4" as an instruction for TokuDB's page size. TokuDB should be using 4MB block size, but thinks it's being instructed to use
[Read more...]Updating ClouSE can now be done with one command
With more than a thousand registered users worldwide, guiding customers through the upgrade process is getting hard, so we decided to automate the servicing steps. Now the update-clouse script can be used to update ClouSE binaries to the current version. This script ships with the ClouSE binary distribution.
Here is an example of updating ClouSE using the Webmin console.
First, download ClouSE 64-bit binaries from http://www.oblaksoft.com/downloads/. Then upload and extract the binaries to the /home/ec2-user directory. In
[Read more...]I love Percona’s XtraBackup utility. It’s basically a GPL answer to Oracle’s proprietary (and expensive) MySQL Enterprise Backup. Percona claims that it has even more features that Enterprise Backup. I do not have access to Oracle’s product, though, so I cannot evaluate that claim.
I have my backups set up in a particular way, for convenience and security. I have a backup machine that has ssh access to the backup user on other machines. It has terrabytes of spare disk space, and runs a script that uses rsync and other utilities to take backups of my other servers.
Since my backup server is where all backup scripts are run, I have previously used mysqldump to
[Read more...]| Previous 30 Newer Entries | Showing entries 61 to 90 of 29831 | Next 30 Older Entries |
