Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 152 Next 30 Older Entries

Displaying posts with tag: Learning (reset)

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

OurSQL Episode 174: CONNECT the world
+1 Vote Up -0Vote Down

This week we discuss MariaDB's CONNECT storage engine. Ear Candy is inconsistent behavior with dates, NULLs and collations. At the Movies is a talk about the history and future of MySQL and its variants.

Sheeri:
The 2014 MySQL Community Awards are open for nominations until Sunday, 23 February 2014

Events
DB Hangops - every other Wednesay at noon Pacific time. Upcoming dates are Wednesday February 19th, March 5th and March 19th.

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

read more

OurSQL Episode 171: Another Round of Toolkit
+1 Vote Up -0Vote Down

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127,

  [Read more...]
OurSQL Episode 171: Another Round of Toolkit
+1 Vote Up -0Vote Down

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127,

  [Read more...]
OurSQL Episode 171: Another Round of Toolkit
+0 Vote Up -0Vote Down

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127,

  [Read more...]
OurSQL Episode 170: Auto-failover, part 2
+1 Vote Up -0Vote Down

This week we discuss administering Percona Replication Manager. Ear Candy is about repository packages from MariaDB and Oracle, and At the Movies presents a Riak engineer talking about "convergent replicated data types" - data structures that tolerate eventual consistency.

Events
DB Hangops - every other Wednesay at noon Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

The call for papers for OSCon 2014 is open until Thursday, January 30th

read more

OurSQL Episode 165: Top Hat Cluster
+0 Vote Up -0Vote Down

This week we talk about how to install and set up Galera Cluster. Ear Candy talks about the new MySQL repos from Oracle and what to know about using them; At the Movies is Michael Stonebreaker talking about how to process today's big data transactional processing needs.

Galera Cluster
Codership documentation of Galera Cluster
Installing Percona XtraDB Cluster on Ubuntu documentation
MariaDB's Galera Cluster documentation

read more

OurSQL Episode 163: Moving Along
+0 Vote Up -0Vote Down

This week we discuss MySQL's Migration Toolkit. Ear Candy is about the replication format as it propagates through multi-tier master and slaves; At the Movies is Distributed Data Analysis with Hadoop and R.

MySQL Migration Toolkit
Episode 161 where we talked about how MySQL Workbench is a replacement for the older MySQL GUI Tools, including the MySQL Migration Toolkit.

New Migration Toolkit in MySQL Workbench.
Installing ODBC Drivers for use with the Migration Toolkit.

read more

OurSQL Episode 162: Exploring Workbench Further
+0 Vote Up -0Vote Down

This week we explore MySQL Workbench further. Ear Candy is Stewart Smith's 'libeatmydata' and At the Movies is a video to help folks familiar with SQL learn how to use Riak's MapReduce.

Events
DB Hangops - every other Wednesay at noon Pacific time

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

MySQL Tech Tour Tokyo Nov 27th 2013
MySQL and Linux tech event in Atlanta Dec 5, 2013

read more

OurSQL Episode 161: The sharpest tool on the bench
+0 Vote Up -0Vote Down

This week we discuss the basics of MySQL Workbench. Ear Candy is using performance schema to find unused accounts, and At the Movies presents XtraDB Cluster.

News
Oracle announced that it is providing yum repositories for MySQL, including MySQL packages, MySQL workbench and MySQL connectors.

MySQL Workbench
features of MySQL Workbench (http://www.mysql.com/products/workbench/features.html) - community vs. standard vs. enterprise

MySQL Workbench 6.0 interface changes with pictures.

read more

OurSQL Episode 157: More Than One Master
+0 Vote Up -0Vote Down

This week we interview Luis Soares about multi-source replication. Ear Candy is about memory allocation with FEDERATED and FEDERATEDX storage engines, and At the Movies is about increasing performance by archiving data.

Download the multi-source replication MySQL server snapshot at labs.
Enabling MySQL multi-source replication on Luis' blog,
A quick introduction to multi-source replication, with an example

read more

OurSQL Episode 155: Weaving with Fabric
+2 Vote Up -0Vote Down

Actually, this is episode 156, sorry about the error in the title!

This week we interview Mats Kindahl, a MySQL Senior Principal Software Engineer, about the open source Fabric framework for transaction-safe, semi-automatic sharding and high availability. Because we recorded this during the MySQL Connect conference there is no Ear Candy, nor At the Movies.

Events
DB Hangops - every other Wednesay at noon Pacific time

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

MySQL Tech Day in Paris Thursday Oct 10th

read more

OurSQL Episode 155: Tooling Around, Part 5
+0 Vote Up -0Vote Down

In this episode, we finish our series about the MySQL Utilities. Ear Candy is pt-stalk, and At the Movies is a fast parallel query engine.

MySQL Utilities part 5

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities

mysqlrplcheck

[bugzilla2]$ mysqlrplcheck --master=root:PASS@bugzilla1 --slave=root:PASS@localhost:/var/lib/mysql/mysql.sock

read more

OurSQL Episode 154: Tooling Around, Part 4
+1 Vote Up -0Vote Down

This week we continue our series exploring the MySQL Utilities. Ear Candy is using the performance schema to find out which accounts fail to properly close connections, and At the Movies has a video about databases and determinism.

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 5 of MySQL Utilities

Events
DB Hangops - every other Wednesay at noon Pacific time

read more

OurSQL Episode 153: Tooling Around, Part 3
+3 Vote Up -0Vote Down

This week we continue our series on MySQL Utilities, talking about replication and failover tools. Ear Candy is a gotcha with poor GRANT syntax that MySQL does not give warnings about, and At the Movies is an open forum from the SkySQL Solutions Day a few months ago.

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

MySQL Utilities part 3
mysqlfailover

read more

OurSQL Episode 152: Tooling Around, Part 2
+1 Vote Up -0Vote Down

This week we continue our series on the MySQL Utilities. In this week's Ear Candy, we talk about a path problem installing MySQL Utilities on Ubuntu, and At the Movies is a preview of the SkySQL data suite.

Part 1 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

Events
DB Hangops - every other Wednesay at noon Pacific time

Percona University is coming to Washington, DC on Thursday, September 12th.

read more

OurSQL Episode 146: License to run
+1 Vote Up -0Vote Down

This week we discuss copyleft, GPL and related licenses. In Ear Candy we discuss INFORMATION_SCHEMA and permissions, and At the Movies is about a columnar database.

Events
DB Hangops - every other Wednesay at noon Pacific time

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

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

read more

OurSQL Episode 143: Biblical Tools
+3 Vote Up -0Vote Down

This week we start to discuss the Openark Toolkit. Ear Candy talks about how to estimate the size of MySQL's working set, and At the Movies is a backup presentation from Open Database Camp.

Openark Kit series:
Part 2
Part 3

Openark Kit
Openark Kit

Episode 80, discussing the Percona Toolkit

read more

OurSQL Episode 142: Great Views
+1 Vote Up -0Vote Down

This week we discuss MySQL Views. Ear Candy is GRANTs and replication and At the Movies is a presentation by Giuseppe Maxia talking about "Creating Multi-Master clusters with Tungsten Replicator".

Events
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

OurSQL Episode 136: Digging for Information
+1 Vote Up -0Vote Down

We discuss INFORMATION_SCHEMA with plenty of examples on useful queries. In this week's Ear Candy, we talk about resident versus virtual memory on Linux, and in At the Movies has a video about MongoDB.

Events
DB Hangops in May will be Wed May 8th and 22nd noon pacific time.
Upcoming MySQL tech tours (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings
Tungsten University trainings

read more

OurSQL Episode 135: Another Kind of Buffer
+1 Vote Up -0Vote Down

This week, we explain the InnoDB and Memcached integration in MySQL 5.6. Ear Candy is about the nonexistent 2-step deadlock detection in MariaDB and At the Movies is Colin Charles talking about the features of MariaDB 10.

InnoDB and memcached in MySQL 5.6
memcached official page
InnoDB integration with memcached MySQL manual page
History of the term NoSQL
setting up the InnoDB memcached plugin in MySQL 5.6

read more

OurSQL Episode 134: When Binary's Not Binary
+1 Vote Up -0Vote Down

This week, we take a lighter topic and talk about the many uses and meanings of "binary". Ear candy is a but about SET GLOBAL SQL_BIN_LOG, and At the Movies is Ariel Weisberg of VoltDB explaining sharding and elastic clustering.

Events
DBA Hangops - an every-other-week hangout for dba's (right now it's mostly MySQL) - The DB hangops sessions for April and May are April 10th, April 24th, May 8th and May 22nd.

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

Call for Papers for MySQL Connect is open! The call closes Friday, April 12th.

read more

OurSQL Episode 131: Fresh Variables
+1 Vote Up -0Vote Down

This week we discuss changed behavior of variables in MySQL 5.6. In ear candy we talk about a cloud-based service to play with SQL on different databases, and At the Movies is Stewart Smith of Percona talking about MySQL in the Cloud as a Service during Linux Conf Australia in Canberra.

Changed behavior of variables in 5.6
boolean variables can be set to ON/OFF 1/0 TRUE/FALSE

Variables with changes:
log_slave_updates

read more

OurSQL Episode 130: Retired Variables
+1 Vote Up -0Vote Down

This week we discuss deprecated, removed and ignored variables in MySQL 5.6. Ear Candy is about innodb_file_per_table enabled by default, and At the Movies is "Different MySQL Forks for Different MySQL Folks".

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

Open Database Camp will be part of the Northeast LinuxFest at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. You can register and submit presentations on the opensqlcamp.org website.

read more

OurSQL Episode 125: New and Improved...And Faster!
+2 Vote Up -0Vote Down

This week we discuss part 1 of the new optimizer enhancements in MySQL 5.6. Ear Candy is a gotcha about persistent replication configuration, and At the Movies is MVCC in PostgreSQL.

Events

Galera, SkySQL and MariaDB are doing a Road Show in Hamburg on February 1st and Stockholm on February 7th.

FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd.

OSCON 2013 will take place in Portland, OR from Monday July 22nd through Friday July 26th. The call for speakers closes at midnight Pacific Time on Monday, February 4th.

read more

OurSQL Episode 124: When Do You Want It?
+1 Vote Up -0Vote Down

This week, we talk about Linux I/O schedulers. Ear Candy is iotop, and At the Movies is learning how to use EXPLAIN.

News
OurSQL is taking the EBU's recommendation for volume for mobile devices. You can find a link to a white paper titled: "On the way to loudness nirvana".

Events
Oracle is doing a small MySQL tech tour, on January 22nd to Pleasanton, CA and on January 23rd to Belmont, CA.

read more

OurSQL Episode 121: Fun with text files
+1 Vote Up -1Vote Down

This week we discuss manipulating text data and the CSV storage engine. Ear Candy is Venn Diagrams visually showing joins, and At the Movies is about how to retain your individuality while being on a team.

Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.

Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify


  [Read more...]
Showing entries 1 to 30 of 152 Next 30 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.