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

Displaying posts with tag: software (reset)

Architecture of data warehouse which is based on MQ
+0 Vote Up -0Vote Down

Recently, we create a mysql data warehouse which is based on message queue.

Most companies must prepare for particular queries in their systems if they consider to split their databases or tables into many pieces.

some problems should be solved in this situation:

1. how to get correct results in-time
2. how to build strong data warehouse for future analyst

These policies were used by YHD

They have already deployed a middle-ware …

  [Read more...]
MHA with binlog server
+0 Vote Up -0Vote Down

In this post ,we mainly talk about MHA GTID behavior, we test different cases and find something is different from previous versions .

we have four machines for this test.


master server:
slave server :
port : 3306 


we first do normal failover .

kill master server

we find MHA outputs:

Tue Dec 30 13:32:14 2014 - [warning] Got error on MySQL connect ping: DBI …
  [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.

DB Hangops - every other Wednesay at noon Pacific time
Upcoming SkySQL events
Upcoming MySQL events

OSCon 2014 will be held at the Oregon Convention Center in Portland, Oregon from Sunday July 20th …

  [Read more...]
siamang: a web-based command-line client for mysql
+0 Vote Up -0Vote Down

because i have many more important things to be doing, i procrastinated by whipping up a little web-based command-line client for mysql. what does that mean? you load the webpage, start typing in sql commands, and it presents the results to you. it is just a weekend hack at this point, and has a lot of rough edges. it does have some cool features, though, like a persistent command-line history using Web Storage.

probably the biggest limitation is because it not …

  [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

DB Hangops - …

  [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

  [Read more...]
NPR on Software Patents
+0 Vote Up -0Vote Down

A few years back, along with some folks at MySQL and in the open source community, we helped kick off a campaign against software patents in Europe.  This was a hot topic and surprisingly, it seemed no large companies were willing to step up the fight.  As a relatively young company, MySQL had a lot to lose if someone went on the attack against us using patents.  While we had a very small number of patents in our portfolio (mostly through acquisitions), we help them only for defensive …

  [Read more...]
Thanks for the Drupalcon Thank Yous — Texas Linux Fest and Southeast Linuxfest
Employee +2 Vote Up -0Vote Down

Thank you for all of you who dropped by the MySQL booth at Drupalcon to say ‘Thank you’ for MySQL. At every show there are several folks who do this but at Drupalcon it seemed like half the 3,000 attending dropped by to say ‘thanks’, grab MySQL stickers, OurSQL Poscasts disks, and talk about MySQL 5.6. I’ll see all y’all next year in Austin.

Speaking of Austin, the is this weekend. I will be talking Saturday in Track D at 11:25 on the …

  [Read more...]
Keeping your Drupal from Drooping — part 1
Employee +2 Vote Up -0Vote Down

This is the first screen after a sucessful Drupal 7.22 install.

Drupal is a content management system that runs at least 2.1% of all websites(1). It is easy to use, extensable with over 20,000 add-ons, and runs beautifully with a LAMP stack.

At the heart of most Drupal sites is a MySQL database with, as of Version 7.22, 76 tables. Recently I was asked what needs to be done to a ‘generic’ Drupal to get it running on MySQL 5.6. It is a very easy update that provides better performance, security, and allows access to the …

  [Read more...]
Saving $1,100 Simply by Clicking Faster – Collaborate 13 IOUG Forum Discounts exp. 3/6/2013
+0 Vote Up -0Vote Down

Take 50% Off COLLABORATE 13 Now Through Wednesday But you’ve got to act fast! If you’re not already one of the many joining the IOUG at COLLABORATE 13 – IOUG Forum, sign up today for your chance at attending for … Continue reading →

Showing entries 1 to 10 of 368 10 Older Entries

Planet MySQL © 1995, 2015, 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.