Correct tuning of MySQL NDB Cluster can have dramatic impact on performance.
As a distributed shared-nothing system, it is quite sensitive to tuning of communication buffers, or correct partitioning of the schema.
In this session we will look at different tuning aspects of MySQL Cluster.
- Application design guidelines
- Schema Optimization
- Index Selection and... [read more]
If you are an experienced MySQL DBA and want to get started with MySQL in the Amazon cloud? This is what this talk is about. But how difficult can it be, really? Frankly, not that difficult and here we look at the options you have, including, but not limited to:
- Setting up instances for MySQL.
- Why you want to use EBS disks and how to get started with them.
- Using EBS... [read more]
This session will explain how Spil Games migrated from available MySQL performance monitoring systems to their new internal standardized system using Statsd and Graphite. It will cover its architecture and functional basics.
There are some types of queries can become a bottleneck in your MySQL instance as your dataset and traffic increases. Not only full text and wildcard search, but also full table and large dataset scans and sorts. In this talk I will share hands-on experience with identifying these and moving them to an appropriate tier in the stack such as Sphinx. Advanced techniques such as sharded indexes... [read more]
Is MySQL training a cost or an investment? Some companies view training as a cost, one that takes employees away from work. Percona views MySQL training as an investment. The employee that attends our MySQL training will return to their job equipped with new knowledge of best practices catered to address their unique MySQL challenges, reducing downtime while avoiding unnecessary costs by... [read more]
Whether adding indexes, altering enums, changing datatypes or reorganizing tables - there are right and wrong ways when production is involved. In this session, we will go over common operations implemented in production, discuss their impacts, and appropriate strategies for minimizing downtime and customer impact to systems.
* Fast operations including index adds and enum list changes... [read more]
Facebook has a large MySQL deployment with thousands of instances. Online shard migration (OLM) is a utility for moving a logical database from one MySQL instance A (master) to another MySQL instance B (also a master) with near zero downtime. When the database is moved from one master A to another master B, it also moves from slaves of A to slaves of B.
There are at least two use cases... [read more]
From tracking customers in online stores to tweets and blog posts, unstructured data is rapidly growing and businesses are looking for ways to analyze it.
In this presentation, I will explain why storing and processing unstructured data is a challenge best answered by specialized systems such as Hadoop, I will quickly review how Hadoop works and why it is such a scalable solution for... [read more]
This session will cover what is new and different in Percona Server 5.6 and how it can help you in production and development environments.
Over years Percona has helped more than 1,800 customers be more successful with MySQL, achieving breakthrough results: cost savings, faster time to market, higher system up-time, and long-term scalability. In this session Percona CEO Peter Zaitsev will provide an overview of the open source software Percona has created and continues to enhance for maximum competitiveness, performance and... [read more]
MySQL has had Stored Procedures for a long time but since it is Standards based, it is quite restrictive in what may be done with it. Writing Stored Procedures in Perl has a lot of advantages, partly owing to the extensive available CPAN library, and would allow more sophisticated processing to be performed from within the database.
Writing Perl Stored Procedures is as simple as writing... [read more]
Minimizing downtime is apparently important. Longer downtime will hurt revenues and bland images. Automation is certainly effective to minimize downtime and reduce operational costs, but without certain cares it easily causes much more serious problem such as split brains.
These days, it seems like all the "cool kids" are using trendy NoSQL solutions for data storage. Unfortunately, many of these solutions come with relaxed transaction, durability and recovery guarantees. In this presentation, we provide tips for using MySQL efficiently to provide SQL functionality and reliability with NoSQL design and performance.
Database storage costs (Flash, SAS drives, etc) are still not cheap, so fighting against rapidly growing database size is important. Reducing datasize can be done from both application standpoint and database internal standpoint. Typical examples for application tuning are such as archiving, deleting, aggregating records. Examples for database internal tuning are such as using InnoDB... [read more]
HP, Rackspace and several other companies are developing cloud products such as Database as a Service using Openstack technology. OpenStack is a global collaboration of developers and cloud computing technologists producing the ubiquitous open source cloud computing platform for public and private clouds. Reddwarf is an Openstack project that allows an organization to have their own DBaaS... [read more]
Oracle is the most powerful database system in the world. However, Oracle's expensive and complex replication makes it difficult to build highly available applications or move data in real-time to data warehouses and popular databases like MySQL.
In this session you will learn how Continuent Tungsten solves problems with Oracle replication at a fraction of the cost of other solutions... [read more]
There has been lots of work going into MariaDB replication. In fact, group commit in the binary log first made it to MariaDB before it made it to any other variant of the MySQL server.
Learn about new features including:
* multi-source replication
* selectively skipping replication of binary log events
* binlog event checksums
* row based replication with no... [read more]
A fast-paced list of one-liners -- MySQL Tips, RoTs, Hints, and Best Practice.
These are distilled from watching MySQL users -- from newbies to experts -- successfully (or unsuccessfully) tune, index, optimize, and query.
Some you already know; some you have been wondering about; and some will surprise you.
The database is notorious for being one of the most challenging web-architecture components to scale horizontally. In this talk we will take an in-depth look at how to tackle designing a custom sharded MySQL database architecture, and the challenge of pulling off a smooth transition from legacy infrastructure and code. As a basis for our discussion, we will use the story of how Box's database... [read more]
Pinterest's traffic has grown 10x since we gave this talk last year. Sit back and relax while we take you on a tour of the next stage of our architectural evolution. We'll focus on the issues we faced, lessons learned, and resulting solutions put in place to handle our continued rapid growth and expansion. In particular, we'll cover modifications to the architecture to accommodate higher... [read more]
DBA work is repetitive and thus boring. When you need to repeat the same task many times, you lose patience and the job loses its initial appeal. Worse yet, you need to do repetitive tasks when you are in a hurry, or near a deadline, or under stress because you need to fix something urgent, and you feel an unpleasant breath on the back of your neck.
If all the above sounds unpleasant, it... [read more]
MySQL database security is essential for today’s businesses that store sensitive records on their databases. It includes processes, procedures and tools that protect a database from unwelcome activity such as authenticated misuse, malicious attacks, and inadvertent mistakes made by authorized individuals or processes.
GreenSQL will present latest best practices in securing MySQL... [read more]
At SugarSync we selected MySQL due to it's popularity and it originally met our needs. As our customers grew, we have had to investigate and use other tools to allow us to scale MySQL.
In this talk, we'll describe how we solved our replication bottleneck in MySQL Version 5.1 (Percona-Server-server-51-5.1) by installing Continuent Tungsten. This included:
• Using parallel... [read more]
Increasingly location based features are becoming an important part of apps and websites. Do you want to show me which of my friends are close, or perhaps what interesting places or events I might find nearby? This is where spatial functions and indexes enter the discussion. MySQL 5.6 finally brings us so called exact GIS functions. This is a big deal because it makes all the difference... [read more]
Sphinx is a free, open-source search server that integrates nicely with MySQL in particular. It lets you search and it lets you scale.
And it gets better over time, as we add constantly features. This talk will cover the newly added ones and their practical usage in MySQL/Sphinx applications.
Some highlights are: creating custom ranking formulas, improved morphology support, HA... [read more]
Multi-master replication has been an enduring feature request in the MySQL Community for many years. In this talk we will delve into the different approaches used by Galera, Tungsten, MySQL Cluster, and MySQL replication to understand how they work, then show how to apply them. You'll learn about obvious gotchas like primary key and locking conflicts. We'll work through issues like data... [read more]
MySQL Plugins are a vital part of the MySQL project. They allow users to extend the database server itself quickly and easily. But the database server is being constantly developed, and the Plugin API is too - new features are being added to it all the time!
In this talk I will talk about newer Plugin API extensions - what was implemented in MySQL and MariaDB in this area, how you can... [read more]
High profile break ins as of late all have one thing in common: the database was the target. Databases are unprotected when compared to the rest of the operating system, and once the host operating system is compromised, the thief can do whatever he wants to the Database service. Usually this is a smash and grab operation, stealing a snapshot of interesting tables and trying to decrypt at one'... [read more]
Whether assisting you with a MySQL meltdown or simply helping your ecosystem run at its best, Percona has MySQL support experts that are highly accessible for those in need—24X7 online or by phone. Join Peter Farkas, Percona’s Director of Support, as he explains how highly responsive, effective, and affordable Percona MySQL Support Solutions can ensure your MySQL deployment performs... [read more]
Percona Toolkit is a collection of more then 30 command-line tools for MySQL that automate a variety of MySQL and system tasks. With so many choices, it can be difficult knowing where to start: is pt-archiver safe? what is the relationship between pt-table-checksum and pt-table-sync? how does pt-online-schema-change work? etc.
Continuent run all of their systems on the Amazon AWS platform. This includes all R&D resources, source control and issue tracking systems. As well as external Marketing websites. Many of these services had grown in importance as the company grew and developed into new areas.
After the AWS failures in Mid-2012 a series of reviews were carried out to ensure that we had no single... [read more]
Once MySQL users discover dual-master replication, they are often tempted to allow their applications to write to both at the same time. This talk will explore the dangers of doing so as well as the (limited) possibilities it allows.
Illustrated examples will be used to show how this breaks down ACID compliance at fundamental levels.
This talk would be targeted to beginner/... [read more]
Percona services thousands of clients world wide, and handles hundreds of consulting engagements every month. Come hear some of the war stories from the world of Percona Consulting and learn about what Percona Consulting can do for you.
This session will give an overview of a new feature in development in XtraDB and XtraBackup: tracking of changed InnoDB data pages to understand your workload, write patterns, and to enable fast incremental backups.
Debugging MySQL performance issue is not easy. MySQL still lacks some crucial metrics to analyse and detect performance bottlenecks.
Many DBAs have to rely on sparse information available from server and OS or sometimes just a wild guess. Decisions made as a
result of such analysis are often wrong and result in further issues and frustration.
Performance Schema is a MySQL... [read more]
RedDwarf is a project to provide database-as-a-service (DBaaS) as part of the OpenStack open source cloud project.
HP Cloud Services is a leading contributor to OpenStack and to RedDwarf. HP Cloud Services runs a public cloud, and uses Percona Server as the database server enabled by it's DBaaS service.
In this session, you will learn how to sign up for for HPCloud and how to... [read more]
The Percona Toolkit includes pt-query-digest, which can distill queries into a fingerprint. It is possible to use the tool to mark fingerprints as having been 'reviewed'. Most applications have a small number of query fingerprints, and thus new fingerprints can indicate SQL injection attacks. This talk will explain how to use pt-query-digest over logs and in real-time via a proxy to detect... [read more]
pt-table-checksum is a free tool which safely and efficiently verifies that data on MySQL replicas is identical to the master. Having inconsistent data on MySQL replicas is a well-known and rather common problem, yet many people who depend on MySQL replication never check for it. Moreover, inconsistent data can be an expensive problem, but the solution is free: pt-table-checksum.
If you... [read more]
The MySQL ecosystem is more vibrant than ever. There are new tools and storage engines, improvements in performance and scalability, new features that have been required for long time.
In parallel to the MySQL world, a large number of NoSQL technologies approach and solve problems in a very different way.
In this session we will analyse the most relevant architectures that... [read more]
Sharding-splitting data for a single database server onto many database servers is a method to scale horizontally and is needed to get more disk IOPS from a mechanical harddrive server architecture. Its a method that works yet has pitfalls which this session talks about. The main focus is what happens when Solid State Disk Drives replaces traditional mechanical harddrives (spinning metal) in... [read more]
