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 26

Displaying posts with tag: article (reset)

Understanding Tokutek Fractal Tree Indexes
+1 Vote Up -0Vote Down

Download PDF Presentation

Thanks to Tim Callaghan for speaking Tuesday night at the Effective MySQL New York meetup on Fractal Tree Indexes : Theory and Practice (MySQL and MongoDB). There was a good turnout and a full room to learn how the TokuDB storage engine from Tokutek is changing how to handle big data in MySQL.

Also interesting is how the same technology has been applied for use in MongoDB including giving MongoDB transactions; a big change for NoSQL.

Related News: Tokutek Meets Big Data Demand With Open Source TokuDB

MySQL Disasters, and how to avoid yours
+1 Vote Up -0Vote Down

Download PDF Presentation

Organizations are always making improvements for scalability, however disaster preparedness is the poor cousin. This presentation will show you how to easily avoid the most common MySQL disaster situations.
Backup and recovery is critical for business continuity, many websites run the risk of data loss or corruption because existing procedures (if any) are generally flawed. Discussion includes:

  • The essential backup options
  • Why Binary logging for point in time recovery is important
  • How replication changes things
  • Recovery complexities

Presenter: Ronald Bradford
Schedule:




      [Read more...]
    Setting up Google Cloud SQL
    +1 Vote Up -0Vote Down

    You can activate Google Cloud SQL from the Google APIs Console at https://code.google.com/apis/console. NOTE: At the time of this publication this was in limited beta.

    From the Google APIs console, you can create a new instance. You can then use the Web interface to run SQL statements, import and export data. There is also a Google SQL command line client that can be configured with:

    # Java 6 is a dependency of the Google SQL client
    $ [ -z `which java 2>/dev/null` ] && sudo apt-get install -y openjdk-6-jre-headless
    $ [ -z `which unzip 2>/dev/null` ] && sudo apt-get install -y unzip
    $ cd $HOME
    $ mkdir cloud-sql
    $ cd cloud-sql/
    $ wget http://dl.google.com/cloudsql/tools/google_sql_tool.zip
    $ unzip ../google_sql_tool.zip
    $ ./google_sql.sh 
    Please authorize Google SQL Service for your Google Account
      [Read more...]
    Setting up AWS RDS
    +0 Vote Up -1Vote Down

    Amazon Web Services (AWS) provides a managed MySQL solution via Relational Database Service (RDS). The following instructions will enable you to configure and run RDS. Refer to Using Amazon Web Services for initial information about AWS requirements.

    The following instructions are for Ubuntu.

    Pre-requisites

    $ [ -z `which java 2>/dev/null` ] && sudo apt-get install -y openjdk-6-jre-headless
    $ [ -z `which unzip 2>/dev/null` ] && sudo apt-get install -y unzip
    

    Installation

    # See http://docs.amazonwebservices.com/AmazonRDS/latest/CommandLineReference/Welcome.html?r=8890
    $ cd $HOME
    $ mkdir -p aws
    $ cd aws
    $ wget http://s3.amazonaws.com/rds-downloads/RDSCli.zip
    $ unzip RDSCli.zip
    $ ln -s RDSCli-*/ rds
    

    Configuration

    You need to create the

      [Read more...]
    Using Amazon Web Services
    +0 Vote Up -0Vote Down

    After Setting up Amazon Web Services you can follow these steps to use the EC2 CLI tools to manage EC2 instances.

    As per the setup instructions you require the following environment variables to use the tools. It is recommend you add these to $HOME/.bashrc or appropriate shell startup script.

    $ export EC2_HOME=$HOME/aws/ec2
    $ export PATH=$EC2_HOME/bin:$PATH
    # For Ubuntu
    $ export JAVA_HOME=/usr/lib/jvm/java-6-openjdk/
    # For Mac OSX Use
    # export JAVA_HOME=/System/Library/Frameworks/JavaVM.framework/Home/
    

    Necessary Access Controls

    In addition you require the various AWS access keys before running any EC2 commands.

    $ cd $HOME/aws
    $ mv ~/Downloads/cert-EPE36OOAUD6QZZVFJCDJTEWFAG2EPWGA.pem  cert.pem
    $ mv ~/Downloads/pk-EPE36OOAUD6QZZVFJCDJTEWFAG2EPWGA.pem  pk.pem
    $
      [Read more...]
    Setting up Amazon Web Services
    +0 Vote Up -0Vote Down

    This tutorial will help you register and get ready to use Amazon Web Service (AWS). AWS provides a free tier so it is possible to use these services at ZERO cost.

    These instructions are used by the Effective MySQL: Backup and Recovery book examples.

    Step 1: Registration

  • Goto AWS site
  • Register email address
  • Enter Login Credentials
  • Enter Contact Information
  • Enter Credit Card details (while this is required, provided you follow free guidelines you will not be charged)
  • Identity verification by Telephone
  • Activation of account
  • Screenshots

      [Read more...]

    What have I been up to lately?
    Employee +0 Vote Up -0Vote Down

    Despite my best intentions, I haven't posted on this blog for a while, which is a shame! I've become busy writing on so many other places since I moved into my new role in the Oracle Linux product management team in April. I've learned a lot and I am feeling quite at home here! The team is excellent and very nice to work with — I am slowly getting the "Big Picture".

    But even though I've been neglecting this blog, there are a lot of things that are publicly visible and document some of my activites:

    I've created two podcasts for the Oracle Linux podcasts:   [Read more...]
    MySQL tools article
    +1 Vote Up -0Vote Down

    Although I no longer maintain hackmysql.com, I still actively develop MySQL tools. An article I wrote, 10 essential MySQL tools for admin, was published today. I hope no one’s feelings are hurt if their tool isn’t in the list, but it was rather difficult to compile the list given that so many tools are either not actively developed, not tested, or not well documented. Given lag time between writing and publishing, I was not able to write about Yoshinori’s MHA or newer tools. And given length constraints, I was not able to write about more tools. In any case, the world of MySQL tools is alive and well.

    Some friendly advice for bootstrapping your OSS project
    Employee +4 Vote Up -0Vote Down

    So you're a small startup company, ready to go live with your product, which you intend to distribute under an Open Source License. Congratulations, you made a wise decision! Your developers have been hacking away frantically, getting the code in good shape for the initial launch. Now it's time to look into what else needs to be built and setup, so you're ready to welcome the first members of your new community and to ensure they are coming back!

    Keep the following saying in mind, which especially holds true in the Open Source world: "You never get a second chance to make a first impression!". While the most important thing is of course to have a compelling and useful product, this blog post is an attempt to highlight some other aspects about community building and providing

      [Read more...]
    Jeremy's article on MySQL Sandbox in Linux Magazine
    +6 Vote Up -1Vote Down



    Jeremy Zawodny of Craiglist has written a kind article about MySQL Sandbox.
    The article, MySQL Sandbox: Treat MySQL Instances like Virtual Machines, is a practical test of MySQL Sandbox with usage examples and warm appreciation.
    Thanks, Jeremy!

    The article was published in July but I noticed it only today. I guess I should pay more attention to my favorite topics when I travel.
    MySQL community and sushi
    +2 Vote Up -0Vote Down
    Now, relax. This is not haircut blogging. There is actually a true relationship between MySQL Community and sushi. Just bear with me for a while.
    I went to meet Drew in front of a quiet sushi restaurant in Santa Clara, CA. In his latest email, he said "we will meet you there", implying that there was more than one person. He mentioned a wife in one of his email, and so I expected at least two people.
    Curious thing, this meeting. It all started in 2006, when I published an article about replication techniques. In answer to that article, I received dozens of email messages, with comments, congratulations, requests for help, job offers. Drew's message started as a praise, than he asked some questions, and we

      [Read more...]
    Interview with Adam Donnison, web developer at MySQL.com
    Employee +0 Vote Up -0Vote Down

    It has not hit the MySQL DevZone Frontpage yet, but I just finished an interview with Adam Donnison, one of our web gurus behind the mysql.com web site.

    Adam talks about what his work environment looks like, his experiences with MySQL 5.1 on the MySQL web sites and why he enjoys working for a virtual organization like ours. Enjoy!

    Interview with Adam Donnison, web developer at MySQL.com
    Employee +0 Vote Up -0Vote Down

    It has not hit the MySQL DevZone Frontpage yet, but I just finished an interview with Adam Donnison, one of our web gurus behind the mysql.com web site.

    Adam talks about what his work environment looks like, his experiences with MySQL 5.1 on the MySQL web sites and why he enjoys working for a virtual organization like ours. Enjoy!

    Some new MySQL nuggets from blogs.sun.com and elsewhere
    Employee +0 Vote Up -0Vote Down

    Thankfully my RSS reader has builtin-search capability, so I can quickly skim the full RSS feed from blogs.sun.com for keywords of interest. I found the following articles quite helpful:

    • Setting up MySQL Cluster using Solaris Zones by Hashamkha Pathan walks through the steps involved of setting up a virtual MySQL Cluster setup on a single Solaris instance (for evaluation purposes only - this is probably not the best idea for a productive HA environment)
    • Mixing SQL and shell commands in MySQL by Amit Saha explains how to write scripts that execute both SQL statements and unix shell commands using the MySQL command line client
      [Read more...]
    Running Drupal 6 on MySQL 6 using the Falcon Storage Engine
    Employee +0 Vote Up -0Vote Down

    This article describes how to install the Drupal 6.2 CMS on MySQL (http://mysql.com/) 6.0, using the Falcon Storage Engine. The operating system is a default Ubuntu 8.04 "Hardy Heron" (x86) installation.

    I will make a few assumptions here, in order to keep the instructions simple: a fresh OS install, no other MySQL databases or web services are running or have already been installed. Both MySQL and the web server are installed on the same host. You should be able to become root to install packages and to have access to the local file system and

      [Read more...]
    MySQL gems from Sun bloggers
    Employee +0 Vote Up -0Vote Down

    While being subscribed to the full blogs.sun.com feed certainly feels like drinking water from a firehose, every once in a while I stumble over very well-written and useful articles about MySQL. Below is a collection of helpful posts, especially if you run MySQL on Solaris (surprise!). And while I still am an avid Linux user, I must admit that Solaris has a few neat features - particularly DTrace and ZFS are quite intriguing. If only userland would not feel so weird for someone coming from a GNU/Linux background!

    From Jenny Chen's blog:

      [Read more...]
    Community Team interview with Mårten Mickos about the Sun Acquisition
    Employee +0 Vote Up -0Vote Down

    We have just published an interview with our CEO Mårten Mickos on our Developer Zone, where he answers a number of questions from the Community Team about Sun's plans to acquire MySQL AB and what this means for the MySQL User Community and the direction of the product (thanks to Colin for compiling and editing the text). I hope that the comments help to calm the concerns of some people about the future of MySQL with regards to Open Source, support of platforms or language bindings:

    CT: Is MySQL fully committed to free and open source software, and the GPL?
    Mårten: Yes.
    CT: What does the Sun acquisition mean for Linux support? What

      [Read more...]
    Mini-tutorial about using the spatial extensions in MySQL 5.0
    Employee +0 Vote Up -0Vote Down

    While helping a user with some questions about the geospatial extensions of MySQL on the #mysql-dev IRC channel on Freenode, I stumbled over this blog: How to use MySQL Spatial Extensions. There currently is just one post, but it was exactly what we were looking for: "Using Circular Area Selection". Nice work! I hope the author will soon provide more examples of how to make use of this functionality.

    By the way, there is work in progress to improve the GIS functionality in MySQL - if you are looking for new GIS functions that do not use

      [Read more...]
    From Visions to Reality - an interview with David Axmark, Co-Founder of MySQL AB
    Employee +0 Vote Up -0Vote Down
    I am happy to announce that my MySQL Dev Zone interview with David Axmark just went live - if you are curious to hear a few stories about how David and Monty started this whole thing more than 10 years ago, make sure to spend a few minutes and read it here!
    Interview with Andrey ?Poohie? Hristov now available from the MySQL DevZone
    Employee +0 Vote Up -0Vote Down
    Some days ago I had the pleasure to interview Andrey Hristov, who is a developer at MySQL AB. He joined the team after working on a new feature for the MySQL Server as part of his master's thesis. You can read the full interview on the MySQL Developer Zone. Enjoy!
    OSCON Interviews: Solid
    Employee +0 Vote Up -0Vote Down
    It's already a month old, but I just stumbled over this ITtoolbox Interview with Jonathan Cheyer (Open Source Community Manager) and Murat Demiroglu (Senior Product Manager) from Solid Information Technology, in which Dru Lavigne talks with them about Solid (the company) and the solidDB for MySQL storage engine, which is currently in beta testing. I still remember Solid from my times at SUSE Linux, where it used to be a part of the Linux distribution along with MySQL, PostgreSQL, Adabas D and several other DBs...
    OSCON Interviews: Solid
    Employee +0 Vote Up -0Vote Down
    It's already a month old, but I just stumbled over this ITtoolbox Interview with Jonathan Cheyer (Open Source Community Manager) and Murat Demiroglu (Senior Product Manager) from Solid Information Technology, in which Dru Lavigne talks with them about Solid (the company) and the solidDB for MySQL storage engine, which is currently in beta testing. I still remember Solid from my times at SUSE Linux, where it used to be a part of the Linux distribution along with MySQL, PostgreSQL, Adabas D and several other DBs...
    Using Excel to analyze MySQL data
    Employee +0 Vote Up -0Vote Down
    Just stumbled over this article, which might come in handy for our Microsoft Office users out there: "Using Excel to analyze MySQL data" by Jason Gilmore explains how to set up the MySQL Connector/ODBC and connecting to a MySQL database using Microsoft Excel.

    If you're a Linux user, this article on NewsForge covers a similar topic, using OpenOffice.org

    to connect to a MySQL Server.

    Update: Thanks to Guillermo Roditi for pointing out that both links pointed to the same article - now fixed. Sorry about that.

    Article about MySQL and Java installation published
    Employee +0 Vote Up -0Vote Down
    Last week I was notified that my article about how to install and configure MySQL and the MySQL Connector/J was published in the Java Starter Magazine, a special edition of the german Java Magazin. It covers the basic installation of MySQL and Connector/J on Windows and Linux and how to write a small example program to connect to to MySQL with Java using the Eclipse framework. They were kind enough to send me a number of copies that I plan to give away at tonight's Hamburg MySQL User Group Meeting.
    Interview with Paul McCullagh, developer of the PrimeBase XT Storage Engine
    Employee +0 Vote Up -0Vote Down
    Paul McCullagh works on a new pluggable transactional Storage Engine for MySQL, called PrimeBase XT. I met him for an interview a few days ago - you can now read it on the MySQL Developer Zone. Enjoy and have a nice weekend!
    MySQL on Max OS X: An Ideal Development Combination
    Employee +0 Vote Up -0Vote Down
    It's seems that Mac OS X has become the OS of choice for many people that wanted to get away from Windows or got too frustrated with Linux on the desktop. MySQL has been ported to OS X a long time ago and is even shipped as a component of OS X Server. The Apple Developer Connection now has a nice article about using and developing MySQL on OS X, including many quotes from Brian Aker.
    Showing entries 1 to 26

    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.