Answering Monty's Challenge: Advanced Replication for MySQL (2)
share
digg
by
Robert Hodges (3)
on
Planet MySQL (223)
1 day, 4 hours
ago
permalink
Today Continuent is publishing the Tungsten Replicator, which provides advanced open source master/slave replication for MySQL. Publishing code is the first step to creating a robust alternative to current MySQL replication and will be followed by similar support for Oracle, PostgreSQL, and many other databases.We started with master/slave replication on MySQL for a very simple reason: we know it well. And we know that while MySQL replication has many wonderful features like simple set-up, it ...
A global Chinese software company in the next 20 years? (1)
share
digg
by
infoworld (4)
on
Planet MySQL (223)
1 day, 17 hours
ago
permalink
As China's appetite for technological advancement through acquisition grows, will we see a global Chinese-based software vendor emerge? READ MORE
MySQL Source cross-referencing with 'cscope' (1)
share
digg
by
Amit K. Saha (6)
on
Planet MySQL (223)
1 day, 22 hours
ago
permalink
IDEs like NetBeans has made life easier and more productive. But, you may as well use utilities like 'cscope' when all you have is a console login. Here is how you would set up MySQL sources for easy cross-referencing using 'cscope': Build the cross-reference: Go the MySQL sources top-level directory and build the cross-reference (-R is used to descend recursively into the directories, and -b builds the cross-references): /home/as227057/dev-tools/mysql-5.1.25-rc" 24 $ cscope -Rb Search for ...
Building MySQL Cluster on Windows (for Windows) (5)
share
digg
by
Stewart Smith (6)
on
Planet MySQL (223)
2 days, 23 hours
ago
permalink
You will need: CMake (at least 2.4.7) Bazaar (the newer the better - 1.6 was just released - at least use that) Gnu Bison Visual Studio (Express works, but I’m talking about 2005 here) … and all this installed on a Microsoft Windows machine. … and to hate yourself, you are going to be using Windows after all. Then, get and build it: Get the source: bzr branch lp:~mysql/mysql-server/mysql-5.1-telco-6.4-win Run CMake. the CMake GUI can ...
OpenSQL Camp 2008 (14-16 Nov 2008) (1)
share
digg
by
Arjen Lentz (2)
on
Planet MySQL (223)
3 days
ago
permalink
OpenSQL Camp 2008 is coming! When and Where: Charlottesville, Virginia, USA November 14, 15, and 16 2008!Organised by Baron Schwartz & others, and attended by loads of cool and interesting people (Brian, Monty and Baron are already on the attendee list!) you'd better get ready for a dynamite weekend of learning, contributing, and having fun! I'm hoping to be there too.Some Key facts:It is of, by and for the community (you).At this event, all Open ...
MySQL Query Analyzer: DBA Task #1: Finding Bad Queries (4)
share
digg
by
Rob Young (5)
on
Planet MySQL (223)
4 days, 6 hours
ago
permalink
One of the biggest problems I faced as a field DBA was defending my production databases against poorly performing SQL code. Talking to folks at the MySQL UC, during customer visits and trolling the MySQL forums/blogs confirms that this is a common problem and even more challenging when a performance problem pops up during times when no code promotions have taken place.Traditional/popular way of finding bad SQL codeFor MySQL DBAs the challenge to identify and ...
Typical automated MySQL maintenance jobs (3)
share
digg
by
Oli Sennhauser (4)
on
Planet MySQL (223)
4 days, 17 hours
ago
permalink
The following maintenance jobs are typically run against a MySQL database: ?Backup? Clean-up binary logs. Optimize tables Purge query cache Rotate binary logs Backup A backup is not a typical maintenance job. But it behaves more or less like one. The backup should be done regularly depending on the restore/PITR (Point in Time Recovery) requirements. Make sure, that in the backup all the necessary files (data files, transaction log files, configuration files and binary log ...
Slides of my FrOSCon presentations (1)
share
digg
by
Giuseppe Maxia (5)
on
Planet MySQL (223)
5 days, 3 hours
ago
permalink
Thanks to all who attended my talks at FrOSCon 2008. It was a pleasurable experience, as it has always been in the past.The slides of my two sessions are published in the MySQL Presentation RepositoryMySQL Community How ToMySQL Sandbox
A Contributor's Guide to Launchpad.net - Part 1 - Getting Started (2)
share
digg
by
Jay Pipes (9)
on
Planet MySQL (223)
1 week
ago
permalink
This post is the first in a series of articles which serves to highlight the services of the Launchpad platform which hosts the MySQL Server, MySQL Forge, MySQL Sandbox and Drizzle Server projects. I will be walking you through the various pieces of the platform and provide examples of using each of the services. I will cover in depth the source code management services which all three projects now rely upon. The code management services ...
Getting a Working C/C++ Development Environment for Developing Drizzle (3)
share
digg
by
Jay Pipes (9)
on
Planet MySQL (223)
1 week, 1 day
ago
permalink
This article explains how to set up a properly functioning C/C++ development environment on Linux. The article is aimed at developers interested in contributing to the Drizzle server project, but the vast majority of the content applies equally well to developers wishing to contribute to the MySQL server or any other open source project written in C/C++ IMPORTANT: This article doesn't get into any religious battles over IDEs or particular editors. IDEs and editors are ...
MySQL, Memcache, Replication and Delay | ruturaj.net (3)
share
digg
by
Ruturaj Vartak (4)
on
Planet MySQL (223)
1 week, 2 days
ago
permalink
An interesting article on Facebook, Which deals with MySQL's replication system, Memcache and the replication delay. ... by setting a cookie in your browser with the current time whenever you write something to our databases. The load balancer also looks for that cookie and, if it notices that you wrote something within 20 seconds, will unconditionally send you to California. Then when 20 seconds have passed and we're certain the data has replicated to Virginia, ...
-
Brian said:
Pretty cool solution for multiple datacenters, MySQL and Memcache.
Another article on Telecommuting. The Ugly, The Bad and The Good (1)
share
digg
by
Vidyut Luther (2)
on
Planet MySQL (223)
1 week, 2 days
ago
permalink
Computer World has an article about Telecommuting . So, I thought I’d chip in my inflated $0.02. Telecommuting, doesn’t mean working from home. This is one of the biggest myths, and truths people will realize over time. What makes me such an expert? I’ve been telecommuting for the past 3 years, straight, full time. I’m not talking about moonlighting, and doing part time work for companies who post on craigslist. I’m talking multi million dollar ...
What Makes a Good DBA? (1)
share
digg
by
Keith Murphy (3)
on
Planet MySQL (223)
1 week, 2 days
ago
permalink
A few days ago I had a new idea for a blog post. A post about what it really takes to be a good database administrator. I began by researching what others had done on the topic. At the end of this post you will find links to six of the posts I found that provided some insight into this question. Even after uncovering this information, I thought I could add something to the mix ...
Curl Functions for MySQL, v 0.1 released! (3)
share
digg
by
Patrick Galbraith (4)
on
Planet MySQL (223)
1 week, 3 days
ago
permalink
I was looking for an example of how to write a MySQL UDF for my upcoming book "Writing Web Applications in Perl, Memcached, MySQL and Apache", and decided using Curl would be fun. Maybe there are some philosophical issues of why not to do it. But I can do it, and I did do it. So be it ;) Once I started the idea, I had to at least finish it. I hate not finishing ...
