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 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 61 Next 1 Older Entries

Displaying posts with tag: Other (reset)

Severalnines at Percona Live London 2013: MySQL Cluster Performance Tuning, exhibitor space with live demos, discount code...
+1 Vote Up -0Vote Down
November 4, 2013 By Severalnines

Percona Live London MySQL Conference - 11-12th November, 2013

We’re particularly excited about this year’s Percona Live London MySQL Conference. The line-up of speakers & topics looks excellent and it’s good to see speakers from Oracle, Percona, the MariaDB Foundation (amongst others) scheduled at the same event. It demonstrates not just the diversity of the ever broadening MySQL ecosystem, but also the fact that there really is room for everyone to contribute, participate in and advance MySQL in manifold directions while still retaining a certain amount of uniformity.

And this is how we will be contributing to the event ...

  [Read more...]
Point-in-time Recovery in MySQL Galera Cluster
+1 Vote Up -0Vote Down
October 28, 2013 By Severalnines

Data protection is vital for DB admins, especially when it involves data that is accessed and updated 24 hours a day. Clustering and replication are techniques that provide protection against failures, but what if a user or DBA issues a detrimental command against one of the databases? A user might erroneously delete or update the contents of one or more tables, drop database objects that are still needed during an update to an application, or run a large batch update that fails midway. How do we recover lost data? 

 

In a previous post, we showed you how to do a full restore from backup. Great, now you’ve

  [Read more...]
Webinar Replay and Q&A: Galera 3.0 Introduction and Cluster Management - with MySQL 5.6, Global Transaction IDs and WAN
+3 Vote Up -1Vote Down
October 23, 2013 By Severalnines

 

Last week, the Severalnines & Codership teams came together to co-host two webinar sessions on Galera 3.0, MySQL 5.6, Global Transaction IDs and WAN. The sessions were held during EMEA/APAC as well as NA/LATAM timezones, which worked out quite nicely. Our speakers were Seppo Jaakola from Codership & Vinay Joosery from Severalnines

 

Webinar topics:

  • Galera Cluster
  [Read more...]
Understanding gcache in Galera
+1 Vote Up -0Vote Down
October 16, 2013 By Severalnines

Galera uses a preallocated file with a specific size called gcache, used to store the writesets in circular buffer style. By default, its size is 128MB. In this post, we are going to explore how to leverage gcache to improve the operation of a Galera cluster.

 

Test Case

 

We have a four node Galera cluster, using the latest release 23.2.7(r157). We have a table called t1 that is replicated by Galera on all nodes. The cluster nodes have allocated the default 128MB gcache.size, and we’ll try to execute a large writeset to see how gcache responds.

mysql> 
  [Read more...]
Resources for HA Database Clusters: Latest Updates
+0 Vote Up -0Vote Down
September 24, 2013 By Severalnines

For those of you who know Severalnines and maybe use some of our tools & products, you’ll know that we provide our users with a monthly summary of all the resources & tools that we’re publishing. Since this is publicly available material, we thought it’d be useful also for the broader open source database community.

In the past month, we’ve made the following resources & tools available: 

  • Troubleshooting MySQL Cluster (free online MySQL Cluster Training)

  [Read more...]
Avoiding Deadlocks in Galera - Set up HAProxy for single-node writes and multi-node reads
+0 Vote Up -0Vote Down
September 17, 2013 By Severalnines

Galera cluster has known limitations, one of them is that it uses cluster-wide optimistic locking. This may cause some transactions to rollback. With an increasing number of writeable masters, the transaction rollback rate may increase, especially if there is write contention on the same dataset. It is of course possible to retry the transaction and perhaps it will COMMIT in the retries, but this will add to the transaction latency. However, some designs are deadlock prone, e.g sequence tables. In this blog we present how you can minimize the risk for deadlocks due to the

  [Read more...]
How to Scale Joomla on Multiple Servers
+0 Vote Up -0Vote Down
July 2, 2013 By Severalnines

Joomla! is estimated to be the second most used CMS on the internet after WordPress, with users like eBay, IKEA, Sony, McDonald’s and Pizza Hut. In this post, we will describe how to scale Joomla on multiple servers. This architecture not only allows the CMS to handle more users, by load-balancing traffic across multiple servers. It also brings high availability by providing fail-over between servers.

 

This post is similar to our previous posts on web application scalability and high availability:

  [Read more...]
Replicate from a MySQL Server into a Galera Cluster
+0 Vote Up -0Vote Down
June 28, 2013 By Severalnines

This article describes how to setup replication between a regular MySQL server and a Galera Cluster. The regular MySQL Server is the MASTER , and one of the Galera nodes will be the SLAVE:

 

In this example we have the following hosts:

  • REGULAR MASTER: 10.0.1.10
  • GALERA NODE #1 (SLAVE): 10.0.1.11

read more

How to Cluster Magento, nginx and MySQL on Multiple Servers for High Availability
+0 Vote Up -0Vote Down
June 17, 2013 By Severalnines

Magento is an open-source e-commerce platform built on Zend PHP and MySQL. It is widely adopted by online retailers with some 150,000 sites known to use it. Single server setups are easy to set up, but if your store is a huge success, then you probably need to think about clustering your environment with multiple servers. Clustering is done at the web, database and file-system level, as all web nodes need access to catalog images. 

 

This post is similar to our previous posts on scaling Drupal and

  [Read more...]
Scaling Wordpress and MySQL on Multiple Servers for Performance
+0 Vote Up -0Vote Down
June 11, 2013 By Severalnines

Over the years, WordPress has evolved from a simple blogging platform to a CMS. Over seven million sites use it today, including the likes of CNN, Forbes, The New York Times and eBay. So, how do you scale Wordpress on multiple servers for high performance? 

 

This post is similar to our previous post on Drupal, Scaling Drupal on Multiple Servers with Galera Cluster for MySQL but we will focus on Wordpress, Percona XtraDB Cluster and GlusterFS using Debian Squeeze 64bit.

read more

Scaling Drupal on Multiple Servers with Galera Cluster for MySQL
+0 Vote Up -0Vote Down
April 26, 2013 By Severalnines

This post shows you how to move from a single instance Drupal/MySQL to a multi-server environment. A well designed multi-server deployment not only allows Drupal to scale, but will also enhance redundancy by removing single points of failure. Components used are Apache, PHP, csync2, lsyncd, Keepalived, HAproxy, MySQL Galera Cluster and ClusterControl.

read more

[MySQL][Spider][VP][Other]Spider-2.22 VP-0.11 BKA-for-ha_partition-0.3 released
+0 Vote Up -0Vote Down
I'm pleased to announce the release of Spider storage engine version 2.22(beta), Vertical Partitioning storage engine version 0.11(beta) and BKA-for-ha_partition version 0.3.
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.
http://launchpad.net/vpformysql
BKA-for-ha_partition is a patch file of supporting "Batched Key Access" for table partitioning feature.
http://launchpad.net/partitionmrrformysql

The main changes in this version are following.
Spider
- MS Windows support.
- Add UDF "spider_copy_tables".
  Spider HA feature is now available!













  [Read more...]
[MySQL][Spider][VP][Other]Spider-2.20 VP-0.10 BKA-for-ha_partition-0.2 released
+0 Vote Up -0Vote Down
I'm pleased to announce the release of Spider storage engine version 2.20(beta), Vertical Partitioning storage engine version 0.10(beta) and BKA-for-ha_partition version 0.2.
Spider is a Storage Engine for database sharding.
http://spiderformysql.com/
Vertical Partitioning is a Storage Engine for vertical partitioning for a table.
http://launchpad.net/vpformysql
BKA-for-ha_partition is a patch file of supporting "Batched Key Access" for table partitioning feature.
http://launchpad.net/partitionmrrformysql

The main changes in this version are following.
Spider
- "spider_multi_split_read" supports dividing condition count.
From this release, there is "install_spider.sql"










  [Read more...]
[MySQL][VP][Other]Start creating Engine Independent Test & VP-0.7 released
+1 Vote Up -0Vote Down
I started creating "Engine Independent Test".
http://launchpad.net/engineindependenttestformysql

This test aims to be testable with all storage engines.
There is following wiki but test was not created yet.
http://forge.mysql.com/wiki/EngineIndependentTestSuite
I think this test is need for Storage Engine Developers(including me).
Additionally, I already released 2 Storage Engines so I felt needing this test strongly.
So I started creating "Engine Independent Test".

Please tell me without hesitate if you have a demand.


I'm pleased to announce the release of Vertical Partitioning storage engine version 0.7(alpha).
Vertical Partitioning is a Storage Engine for vertical













  [Read more...]
Solaris Cluster 3.2 11/09 is now available
Employee +0 Vote Up -0Vote Down

Solaris Cluster is a multi-system, multi-site high availability and disaster recovery solution that manages the availability of applications services and data across local, regional and geographically dispersed data centers. The Solaris Cluster environment extends the Solaris Operating System into a cluster operating system.

If you are following the Solaris Cluster product and features, you would have noticed extreme innovation by Sun in the high availability and disaster recovery space since the time we released our first HA product many years ago. For well over a decade, Solaris Cluster has been a market leader for providing business continuity and disaster recovery solutions to all mission critical business applications, spanning all the major industry segments.

Continuing with our tradition of innovation, we are pleased to announce another release - "Solaris



  [Read more...]
Solaris Cluster 3.2 11/09 is now available
Employee +0 Vote Up -0Vote Down

Solaris Cluster is a multi-system, multi-site high availability and disaster recovery solution that manages the availability of applications services and data across local, regional and geographically dispersed data centers. The Solaris Cluster environment extends the Solaris Operating System into a cluster operating system.

If you are following the Solaris Cluster product and features, you would have noticed extreme innovation by Sun in the high availability and disaster recovery space since the time we released our first HA product many years ago. For well over a decade, Solaris Cluster has been a market leader for providing business continuity and disaster recovery solutions to all mission critical business applications, spanning all the major industry segments.

Continuing with our tradition of innovation, we are pleased to announce another release - "Solaris



  [Read more...]
Solaris Cluster 3.2 11/09 is now available
Employee +0 Vote Up -0Vote Down

Solaris Cluster is a multi-system, multi-site high availability and disaster recovery solution that manages the availability of applications services and data across local, regional and geographically dispersed data centers. The Solaris Cluster environment extends the Solaris Operating System into a cluster operating system.

If you are following the Solaris Cluster product and features, you would have noticed extreme innovation by Sun in the high availability and disaster recovery space since the time we released our first HA product many years ago. For well over a decade, Solaris Cluster has been a market leader for providing business continuity and disaster recovery solutions to all mission critical business applications, spanning all the major industry segments.

Continuing with our tradition of innovation, we are pleased to announce another release - "Solaris



  [Read more...]
Who knew Ingres had it in them?
+2 Vote Up -1Vote Down
VectorWise has emerged from stealth mode. Even more interesting is that Ingres is collaborating with them on Ingres VectorWise. And most interesting is the video made to promote the work. In the interest of disclosure, I have friends who work on this at Ingres and VectorWise.

I have read many of the papers on X100 and MonetDB and believe the performance claims they make. Within the MySQL community, this is most similar to Kickfire in terms of the query workloads it can support. The difference is that VectorWise writes their software to run at full speed on a modern CPU and maintain a high IPC rate while Kickfire uses custom hardware (and a lot of really good software that they probably cannot describe

  [Read more...]
[MySQL][Other]Condition Pushdown for ha_partition 0.1 released
+3 Vote Up -0Vote Down
I'm pleased to announce the release of Condition Pushdown for ha_partition version 0.1.
http://launchpad.net/partitionconditionpushdownformysql

This release is a patch file for MySQL's table partitioning feature. (ndb is excluded)
This patch file works to add methods("cond_push" and "cond_pop") to ha_partition. As a result, every storage engine's table that use table partitioning can get condition-pushdown through ha_partition.

There was no problem because only ndb supported engine-condition-pushdown up to now.
This patch was needed because the Spider storage engine supported engine-condition-pushdown recently.

Enjoy!
Redefining Spam, in the age of Twitter
+0 Vote Up -1Vote Down

For the past few months, I’ve been helping my friend develop and market Philtro .
We’ve gone through various iterations of the elevator pitch for it, and the one that seems to be kinda working, is: “It’s like a spam filter for your Twitter account.”

At SXSW, I got the opportunity to talk to Guy Kawasaki about this tool, and he said “There is no spam on twitter, if you don’t like it, don’t follow them”.


  [Read more...]
Leaving to Brussels for FOSDEM 09
+0 Vote Up -0Vote Down

I will be at FOSDEM - Free and Open Source Software Developers’ European Meeting - in Brussels, tomorrow Saturday 02/07 and the day after.

This year MySQL™ has a Project Stand and a Developer Room, with many interesting talks scheduled.

For me, that’s a nice occasion to meet the European part of the MySQL™ Community Team as well as other SUN™ employees and developers.

Here’s a Google map of my way to Brussels:



  [Read more...]
Testing ‘Cover it Live’ for liveblogging
+0 Vote Up -0Vote Down

I was looking for some info on liveblogging art this am because I never did a similar activity and was wondering if I am able to do it in the next confs I’m gonna taking.

Liveblogging means taking notes about a conference session you are listening and share the main concepts of the talk with people who are not present in the room.

I’ve found some tips on how to start a successful liveblogging session and tested a cool platform: http://www.coveritlive.com.

You know, liveblogging at a conference is very important for people who can’t attend it. It helps, among with pics and videos, to smell the great atmosphere you can breathe in a community event.

I think things are evolving well from this side.

If I am not mistaken, the most easy way to liveblogging is

  [Read more...]
First login on iCloud OS
+0 Vote Up -0Vote Down

On August 22 2008, after reading a post by Lewis Cunningham, I did for the first time a quick evaluation of iCloud, an Internet Operating System by Xcerion.

From a User prospective, an O.S. is a set of applications and a kernel - i.e. the basis on which other applications run. An Internet O.S. is an O.S. that runs in the cloud. You have to image a Desktop with its own icons and a “start” toolbar - running on your browser.

When you double-click on an icon the application linked by that icon will be opened. You can move the window, resize it, maximize it and minimize it - all within your

  [Read more...]
In Santa Clara for MySQL conference
+0 Vote Up -0Vote Down

It was a clear sky in LA, but looking down, the city seemed to be covered in smog. After working on Sql Server 2008 material in LAX airport for a while, I boarded a turbo-prop for San Jose. Landing time was windy, so it was a bit bumpy. The only flight attendant, Cindy K, joked that “United throw in a few rides free of charge”. She was helpful with my luggage, with an easy smile.

So I checked in Radisson Hotel around San Jose airport afterwards. I booked the hotel through HotWire. It was a sweet deal, around 60 dollars per night. HotWire is a great site, especially for hotels. I’ve used it three times, all pretty satisfied.

Google map is awesome. It even provided me with information on how to get to Santa Clara convention center via public transportation. So I walked to the Gish station, saw Mexican, Moroccan, Japanese, and Chinese restaurants

  [Read more...]
IT Skills Shortage - fact or fiction ?
+0 Vote Up -0Vote Down

There?s no shortage of smart, employable IT workers. There is a shortage of flexible employers who are willing to hire people who don?t match an exact, niche profile or have a very specific skill or type of experience.”

I’m not sure I agree with her, just like there really is no shortage for skilled workers, there are a lot of companies that are willing to train and mentor. What’s happening is that the people who need to be trained/mentored are asking for salaries that would say they don’t need to be trained and mentored. The companies that are crying about the shortage, usually don’t pay well enough, or are in not so prime locations anymore. A company wants to pay 2001 prices for someone with 10 yrs of experience, in an area that is over priced real estate wise, or the commute to the office is horrible,

  [Read more...]
A new blog ... and my employer is hiring...
+0 Vote Up -0Vote Down
It's been a while since I've written. Sorry to all 1 of my fans :). I am just very busy with work. So, two things.


First is a blog my friend Joel started: http://www.browserlessweb.com/ . I suggest reading it, it's not PHP or MySQL centric, but the things he talks about should affect anyone who reads this blog.


Second item: My Employer is looking to hire some people

  • You need to be in Herndon, Virginia, or within driving distance. (no telecommuters, no relocation package)
  • You must have good working experience with PHP in an enterprise environment (very high visibility site).
  • We will not hold your hand in a linux environment. You must be comfortable with vim, emacs nano, joe,jed, pico whatever.
  • Some experience










  [Read more...]
New Look, New Feel, New Server, New Clothes...oh and a new year.
+0 Vote Up -0Vote Down
Ok, if you're reading this.. you'll notice the new look. Things that have changed.


  • New Server : Single processor, less powerful than before.. but this has less traffic.
  • RHEL 4 : Redhat Enterprise Linux 4
  • PHP 5.1 : Custom built version of PHP 5.1
  • MySQL 5 : Upgraded to MySQL 5
  • S9y : Changed backend from Wordpress to Serendipity.


    Why did I do this ? Because I can, and because my other server is being used for mail. It's also close to a new year, so I wanted to turn a new leaf, try something new, and have some fun. Resolutions for next year (in no particular order)

    • Learn more JavaScript so I can do more "AJAX"y stuff.














  •   [Read more...]
    Tragedy strikes home. This my Eulogy.
    +0 Vote Up -0Vote Down
    This sucks. I don't know how else to put it. My friend Wyatt Ammon is no more. Gone. He left in July, to do some good for the world. He joined the PEACE Corps. So, today I get a call, saying Wyatt Ammon is no more. It's strange, I think he was two years younger than me. One of the nicest guys I ever met, a kindred spirit. He tried very hard to beat me at tennis, we had agreed to play again in two years, once he was back from Zambia. When he left, I figured it was just a temporary thing, we all thought, we'd see him again in two years. But, I guess we won't. This blog belongs to one of his friends. I guess it's good that atleast he didn't die a horrible tortured death, nor did he suffer in bed for a long time, that should be some consolation I guess. But.. Wyatt.. is gone.. no more  [Read more...]
    Tragedy strikes home. This my Eulogy.
    +0 Vote Up -0Vote Down

    This sucks. I don’t know how else to put it. My friend Wyatt Ammon is no more. Gone. He left in July, to do some good for the world. He joined the PEACE Corps. So, today I get a call, saying Wyatt Ammon is no more. It’s strange, I think he was two years younger than me. One of the nicest guys I ever met, a kindred spirit. He tried very hard to beat me at tennis, we had agreed to play again in two years, once he was back from Zambia. When he left, I figured it was just a temporary thing, we all thought, we’d see him again in two years. But, I guess we won’t. This blog belongs to one of his friends. I guess it’s good that atleast he didn’t die a horrible tortured death, nor did he suffer in bed for a long time, that should be some consolation I guess.

      [Read more...]
    Just because it?s open source.. it?s better for consumers ?
    +0 Vote Up -0Vote Down

    IE More Secure Than Mozilla? Just reading this thread on our favorite unbiased source of “news” for nerds. The poster would like us to examine some valid points, namely IE’s integration with the OS, and the higher “caliber” if you want to use that term, of bugs or flaws. Secondly, the point about the ability to uninstall firefox. He goes on to say that the report uses extremely flawed logic, and that Symantec is shilling for MS. I’d say a little bit of both is happening, and it’s happening by Symantec AND the poster.

    My beef, I guess is with the statement that because it’s open source, the large number of eyeballs will make the code more secure. Sure, for the next version.. but who will upgrade ? How do you force someone to

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 61 Next 1 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.