Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 158 10 Older Entries

Displaying posts with tag: Learning (reset)

OurSQL Episode 189: Syncing Both Ways
+1 Vote Up -0Vote Down

This week we discuss advanced pt-table-sync, including bidirectional sync. Ear Candy is starting MySQL on low-memory virtual machines, and At the Movies is "What's New With MySQL and MariaDB?"

pt-table-sync
Episode 188, where we talked about pt-table-sync basics
pt-table-sync documentation

Options discussed:
--bidirectional
--chunk-column
--conflict-column
--conflict-comparison - greatest, least, newest, oldest, equals, matches
--conflict-value
--conflict-error

read more

OurSQL Episode 188: Back in Sync
+0 Vote Up -0Vote Down

This week we discuss pt-table-sync basics. Ear Candy is about how MyISAM can seem transaction-aware, and At the Movies is MySQL and NoSQL at Craigslist.

Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming SkySQL events
Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

OSCon 2014 will be held at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.

read more

OurSQL Episode 187: Hanging Out
+0 Vote Up -0Vote Down

This week, we discuss DB Hangops with special guest, Geoffrey Anderson. Ear Candy is that GTIDs in MariaDB and MySQL are different, and At the Movies is Jonathan Levin talking about deduplicating your data with MySQL.

DB Hangops
DB Hangops - blog and videos of previous hangouts
YouTube DB Hangops channel
DB Hangops twitter account

Anemometer, a tool for reporting on and graphing slow queries, developed by Box.

read more

OurSQL Episode 185: Getting in Sync
+0 Vote Up -0Vote Down

This week we discuss pt-table-checksum for keeping data in sync. Ear Candy is a rational look at why one company chose MySQL; At the Movies is using MySQL in a practical way for Big Data.

pt-table-checksum
pt-table-checksum
pt-table-sync

Episode 151, where we talked about Oracle toolsmysqldbcompare and mysqldiff
Options discussed:
--replicate, --no-create-replicate-table

read more

OurSQL Episode 184: Digging Through the Tool Chest
+1 Vote Up -0Vote Down

This week we discuss more Percona tools: pt-online-schema-change and pt-slave-find. Ear Candy is using the CONNECT storage engine to read GPX files, and At the Movies is Performance at Scale with TokuDB.

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

OSCon 2014 at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.

Training
SkySQL Trainings

read more

OurSQL Episode 183: Map Our Way Around
+0 Vote Up -0Vote Down

This week we discuss MySQL and Geographical Information Systems (GIS). Ear candy is how MVCC in InnoDB relates to undo logging and how you can write better queries based on this information. At the Movies is a demo of GIS.

MySQL and MariaDB geographic information
Geographic features in MariaDB
Spatial Extensions in MySQL
The SQL part of the OpenGIS Implementation Standard for geographic information, from the Open Geospatial Consortium's website.

read more

OurSQL Episode 181: MariaDB Goodies
+0 Vote Up -0Vote Down

This week we discuss more features of MariaDB 10. Ear Candy is how to avoid downtime when switching to GTIDs and At the Movies is Managing Hundreds of MySQL Servers Efficiently.

News
MySQL Community Awards 2014: the Winners

MariaDB 10
MariaDB 10.0.1 features
Other MariaDB podcasts:
OurSQL Episode 89, where we talk about an overview of MariaDB

read more

OurSQL Episode 179: MySQL's Materialized Views
+0 Vote Up -0Vote Down

This week, we interviewed longtime community member and Percona principal support engineer Justin Swanhart about Flexviews, a tool for Materialized Views in MySQL. Ear Candy is about the EXPLAIN analyzer, and At the Movies is about "Advanced MySQL Replication Architectures and Latest Developments".

Flexviews
Justin Swanhart's open source tools
ABOUT Flexviews - "Flexviews is a unique toolkit for the creation and upkeep of MATERIALIZED VIEWS for MySQL."

read more

OurSQL Episode 177: Artistic License
+0 Vote Up -0Vote Down

This week, we sat down with Luis Villa about non-software licenses. Ear Candy is and At the Movies is Sheeri talking about Percona Replication Manager at the Boston MySQL User Group a few years ago.

Non-software Licenses
Luis Villa's Wikipedia page.

Back in episode 146, we talked about the GPL open source license, and its versions and derivatives.

Database directive at Wikipedia. In the EU, you can license a database.

read more

OurSQL Episode 176: Replication Everywhere
+0 Vote Up -0Vote Down

This week we talk about replication features in MariaDB 10. Ear Candy is a gotcha about PIVOT tables in MariaDB, and At the Movies is about the viability of transactions.

Percona Live
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings
Tungsten University trainings

read more

Showing entries 1 to 10 of 158 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.