Planning to run MySQL, and want to safeguard data via replication? There are two main choices - traditional MySQL replication or Galera clusters. Which should you choose? We can help.
- Come see recorded demos of breaking replication. We'll demonstrate and compare the different ways MySQL's replication technologies can be thwarted, threatened and thrashed. A taste of what you'll see: A single writer stopping all transactions on a Galera cluster. Rendering a slave useless by neglecting primary keys or abusing metadata locks. Creating inconsistent schemas on a Galera cluster, and more!
- Attend this presentation if you need to understand the pitfalls of each replication strategy, and want to best match MySQL's features to your Application developers' needs.
Our demos use PXC-release, a Cloud Foundry project. CF is an OSS Platform as a Service. Our project gives Operators a reliable, automated way to spin up single node, master-slave, and Galera deployments of Percona Server. We'll share what we've learned: what's working, and what we'd do differently next time.
A discussion on the changes, trends, and database technologies that are going to impact your business in the next 12-18 months.
Databases provide the foundation for companies' most critical business initiatives and are the key to ensure the success and growth of the company. We will explore the three critical criteria businesses are â€“ and should be â€“concerned with, why so many companies struggle, and what you need to do to secure, scale, and optimize your database infrastructure for the growth your company needs.
In this talk, we'll explore how to build and deploy a geo-scale MySQL / MariaDB / Percona cloud back-end by covering these three key topics:
Overview of Amazon Aurora cross region
Common challenges when using Amazon Aurora
How can multi-region MySQL / MariaDB / Percona deployments be improved?
As part of the discussion, we'll be exploring the following design criteria:
Geographically distributed, low-latency data with a single consolidated view
Fast local response times for read traffic
Local rapid-failover, automated high availability
Ability to deploy masters in multiple regions
No changes to application code
Complex schema changes while keeping applications available
Avoiding provider lock in
In an era where threats and challenges seemingly about protecting your big data and open source workloads, is no longer an optional It is vital to the success of your business. Join Veritas for this information-packed session, where we will discuss the why, how and business impacts of protecting today's business-critical big data and open sources workloads. We will also discuss how to move beyond basic replication to a true data protraction and application recovery strategy.
It's 2019 and there are so many choices for storing your data. There are old players on the market and there are some new kids on the block. Making the wrong choice for your database can effectively sink your product, project, and even your reputation! Should you go with SQL or NoSQL or Document database or something in between? What about polyglot persistence? Reactive, event-driven, non-blocking, async applications? What about the language bindings? What about support? Performance, Tuning, Tooling, Monitoring, Observability, Upgrades, Rollbacks, Migrations, Search & Indexing, Analytics, Availability, Durability, ACID or BASE? Building, running & maintaining storage infrastructure is non-trivial. We will look at the state of databases in 2019 and try to answer some of these questions.
MailChimp has grown from a small company to serving millions of micro-businesses, in addition to SMBs and Enterprises. We have a fairly pedestrian approach to MySQL, but we now run hundreds and perhaps soon to be thousands of MySQL instances. Our present state is thanks to great full-stack engineering teamwork. This is a glimpse into what makes Mailchimp tick. Hint, it's not just technology. This talk is about "Momentum" and "Pragmatism", and creating a great outcome for our mission of empowering the underdog.
As consultants, we are often asked to perform a one-off assessment of existing environments. These requests involve basically three phases: data collection, analysis, and results presentation. In order to reduce the time spent on low-value tasks, we introduced automation to turn collected data into a deliverable and to assist consultants with the analysis and recommendations.
In this session we are going to share the process details, technologies involved, and the benefits introduced to our organization
Audience Takeaways/Take Back to Work:
- Discover a way to construct/manipulate dynamic documents
- Learn about the benefits of introducing automation into documentation processes
- Hear a few lessons learned during the development of the solution
In this presentation, we'll cover the following areas:
1. RDBMS history and landscape (Oracle and MySQL) at PayPal
2. Current and future use cases of MySQL in PayPal
-- back office
-- internally facing applications
-- 3rd party applications
-- PayPal site applications
3. PayPal's effort of making MySQL as a first-class data store. We'll cover the active/active and active/passive architectural choices, managing a large number of application to database connections, enforcing security, backup, and recovery, etc.
4. Outlook of MySQL in PayPal
Technology is ever evolving. New open source databases pop up and fade away.
Even the role of a database administrator changes as DBaaS adoption becomes status quo.
The burden of maintaining your skills and knowledge is on you.
Charles Duhigg, the author of The Power of Habit, writes "If you believe you can change - if you make it a habit - the change becomes real."
Through anecdotes of how a global managed services provider like Pythian enables learning for its employees, this session will provide strategies to make learning a habit.
These strategies will help you thrive in your career, whether you are an individual contributor, or a leader hoping to enable learning for your team.
Would you like MySQL Protocol Compatibility and near real time dashboard analytics with that?
We are hoarding data in the hopes of making meaningful information out of them to make smart business decisions. But we also resort to inflating costs just to satisfy this need (or not). While there have been a number of open source roll your own options, it has been also operationally costly and sometimes stressful to maintain, not to mention the shortcomings of each. If you have been traditionally storing your data with MySQL and have been enduring running your queries from the same set of servers, fret no more - Clickhouse might just be what you need. In this presentation, we will discuss how to deploy, design, and maintain a Clickhouse analytics platform that continuously reads data from your MySQL servers in near real-time*.
* Depends if you have transformations or complex schema.