Both MySQL 5.6 and MariaDB 5.3 introduced advanced game changing optimizer features. In this presentation we will look in details and comparison on these changes as well as perform benchmarks to show which version is able to handle complex queries better. If you're working with application using complex queries with MySQL this presentation is for you.
MySQL Plugins aren't exactly a new feature, still they are poorly understood and rarely used.
But if used appropriately, they can take MySQL to new heights, easily doing what was impossible just yesterday.
This talk will introduce the attendees into the world of MySQL Plugins. You will learn what they are and how to use them.
More importantly, you will see what plugins are available, both official and third-party, and when it is beneficial to use them,
what real life problems they can solve.
This is a introductory talk for MySQL users and DBAs.
Most mission-critical databases are deployed across multiple datacenters, both for disaster recovery and for load distribution. Maintaining consistency across two datacenters and writing scripts for failover and recovery has always been a real pain in MySQL. Slave lag is another big problem.
In this session we’ll discuss the pros and cons of different types of replication in MySQL and the tradeoffs associated with each.
In 2004 we designed and developed a distributed online loyalty marketing system with a large sharded MySQL network using version 4.1 and MyISAM. We've not been able to upgrade MySQL since then for various reasons. We tried to upgrade three times in the last 3 years with no luck first two attempts. From what we learned in the first two attempts and a lot of planning we've now succeeded with this upgrade. In the process we also made a major jump by upgrading from a 32-bit architecture, MySQL 4.1, MyISAM to a 64-bit architecture, MySQL 5.5, Innodb.
When web applications take off and gain traction, the database infrastructure is often one of the most difficult components to scale horizontally. In this talk we present a step-by-step description of our transition from one monolithic MySQL database to a fully sharded MySQL architecture. This transition was made over the course of several months, all the while continuously serving over 1.7B queries per day.
Migrating to MySQL might seem attractive from a cost perspective, but is your application really a good candidate for this?
What will you need to change?
What features of your current database do you rely on, and which features in MySQL might be a good replacement or substitute?
What is the likely cost and effort of a typical migration project?
We will go through several aspects like:
1) Why use MySQL,
2) What are the most common cases,
3) What kind of reporting is useful to produce for good migration planning,
4) What needs to be done to...
This talk is about the new High Availability solution in MySQL arena: Percona XtraDB Cluster.
Percona XtraDB Cluster provides:
1. synchronous replication
2. supports multi-master replication
3. parallel applying AKA “parallel replication”,
4. automatic node provisioning.
5. primary focus on data consistency
I will cover how to install it, add nodes to cluster and make it running.
For many applications, significant (seconds to minutes) replication delay is not acceptable. In this session, the speaker will cover practices to avoid or minimize replication delay. The following topics will be covered. - How to check replication delay correctly Using "replication clock table" is a common practice. Seconds_Behind_Master often tells lies. Probably the most annoying case is Seconds_Behind_Master returns 0 and SQL/IO_Running return Yes even though I/O thread is not actually running. The speaker will show some interesting examples.
Hear from three leading MySQL users on their experiences managing their MySQL deployments. We’ll discuss some of the challenges they faced and the novels methods they used to fight their battles and win with innovative solutions and good old hard work. Topics include upgrading MySQL, sharding, building out a new data center, benchmarking, and root-cause analysis for performance problems.
Databases contain the information crown jewels of organizations, so it's no wonder that they are the highly sought after targets of hackers seeking to exploit sensitive information for profit and wreak havoc within the organization itself. McAfee's Slavik Markovich, one of the foremost experts in database security, will take you through a series of hacks and attacks aimed at applications sitting on top of MySQL databases, and will discuss strategies for building a robust database security program that will protect your sensitive and valuable information from external and internal threats...
Percona Playback is a new tool for taking a general or slow query log produced by one database server and replaying that load against another. It is designed to help evaluate new server versions, patches and hardware against existing setups to allow users to make an informed choice about delpoying changes to their database infrastructure.
In this session we will:
- Go over ways to capture database load
- Examine the flaws in each way to capture load
- Cover basic use of Percona Playback
- Cover how the load generated by Playback may differ from the original...
It is a myth that website that hosts more than the tiniest amount of visitors must run on dedicated hardware. More often than not, servers are completely misconfigured to make the optimal use of their available hardware resources. When your web server, your scripting language and your database are all on the same server, and that server has limited resources, it's even more important to tune things correctly.
In this talk about scaling real-world mysql operations, Sebastian Stadil, founder of the open source cloud management tool Scalr, talks about how the cloud makes mysql operations easier. From automatic read scaling to create just-in-time capacity provisioning, to tooling that lets you clone cluster configuration for use as a new shard, the cloud can imbue you with godly powers.
Pinterest.com has grown to 2.5 billion page views per month in just under a year, and the number one question we're asked at parties is "what's in your stack?" Sit back while we take you on a tour of our current architecture, the lessons learned along the way, and the successes. We'll focus on how we sharded our MySQL database, the process of splitting a shard, caching mechanisms, and server management. We'll also touch on the conveniences and challenges of building today's most modern web infrastructures on Amazon's EC2.
Very busy web sites are starting to connect to huge MySQL clusters over nonblocking sockets in order to handle many more concurrent requests than ever. The Nginx community has created an Nginx upstream module named ngx_drizzle that uses the libdrizzle library to talk to MySQL backends in a nonblocking and streaming manner. The LuaJIT engine has also been embeded directly into the Nginx core via the ngx_lua module. And web developers can now use the Lua language to script ngx_drizzle and dozens of other Nginx modules to build high performance MySQL backed web applications.
When you ask a MySQL DBA about security, they will usually tell you one or more of these three things: 1) strong MySQL passwords; 2) proper user@host grants and 3) SSL connectivity. However in reality MySQL is not deployed in an isolated secure room with no network access like the CIA computer room in the ‘Mission Impossible’ movie (even then you have to protect against Tom Cruise), but connected to a vast array of other computers through a complex network and even eventually the world wide Internet.
This session will explain how Spil Games has grown in a short time from an internet startup to a global online gaming company and how we currently are building a global cross datacenter storage solution with MySQL as its backend.
The most massive crime of identity theft in history was perpetrated in 2007 by exploiting an SQL Injection vulnerability. This issue is one of the most common and most serious threats to web application security. In this presentation, you'll see some common myths busted and you'll get a better understanding of defending against SQL injection.
Problem: you want to test many different builds of MySQL.
There is a proliferation of MySQL versions and builds. Working as a DBA or as a consultant, you will find large installations of MySQL 5.0 to 5.5, with subtle variations among them. In the same company there may several versions of MySQL 5.1, or you may find a mix of vanilla MySQL and Percona or MariaDB builds. For all these version, you often need to reproduce a problem using the same version being used in production, and often you need to install several test servers in the same host for this purpose.