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 65 Next 30 Older Entries

Displaying posts with tag: maxdb (reset)

451 CAOS Links - 2008.05.27
+0 Vote Up -0Vote Down

SourceForge announces quarterly earnings. Linux server growth strong, says analyst firm. Talend adds support for MaxDB. (and more)

SourceForge Reports Third Quarter Fiscal 2008 Results, SourceForge (Press Release)

Worldwide Server Market Shows Resiliency with Solid First Quarter Results, According to IDC, IDC (Press Release)

Talend Announces Data Integration for MaxDB, Talend (Press Release)

How everyone wins with open source software, Linux.com, Lisa Hoover (Article)

  [Read more...]
A (round-about) story about Jeffry P. Bezos
+0 Vote Up -0Vote Down

The following is what i wrote on “43people.com” about the boss. I thought it was worth keeping in my own archives, since it’s actually a story about my life as it pertains to Mr. Bezos.



Back a few years ago, I was taking some classes down in Edmonds. The one I’m thinking of in particular was on the care and feeding of unix. We were using red hat linux 6.0 or some crufty version that wasn’t so crufty at the time.

Anyway, the prof didn’t require that we buy any books, but he made some suggestions. And he also suggested that we buy them on this new fangled “Internet” thing through a few of his friends down south in Seattle at this
  [Read more...]

MaxDB series: Transactions
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

we have moved the MaxDB series to the MySQL Developer Zone. The latest issue on Transactions is available on http://dev.mysql.com/tech-resources/articles/maxdb-transactions.html . Additionally you can download a PDF document (1.86MB, 64 pages) with all articles published in the MaxDB series for offline reading and printing.

Feedback on the MaxDB series and on MaxDB in general is always welcome. Please use the MaxDB forum to send in your comments and questions.

MaxDB series: Transactions
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

we have moved the MaxDB series to the MySQL Developer Zone. The latest issue on Transactions is available on http://dev.mysql.com/tech-resources/articles/maxdb-transactions.html . Additionally you can download a PDF document (1.86MB, 64 pages) with all articles published in the MaxDB series for offline reading and printing.

Feedback on the MaxDB series and on MaxDB in general is always welcome. Please use the MaxDB forum to send in your comments and questions.

MaxDB Synchronization Manager User Report
+0 Vote Up -0Vote Down

United Drugs had occasion to use the Synchronization Manager in production at this year’s convention. Mark Thomas (of United Drugs) and the MaxDB team at MySQL have been getting a use case document together to present the experiences. We had a great deal of help from the SyncMan dev team at SAP Berlin and Chris Hall of Just 4 Dental (who, by the way, also uses the Synchronization Manager in production).

I think the document has come together well and does a good job of describing what the industry can expect out of the Syncronization Manager in its current form. It should also be noted that this document has been presented to SAP Berlin and that many of the issues that have been brought to light have been addressed in the most recent

  [Read more...]
New release of MaxDB: 7.6.00.27
+0 Vote Up -0Vote Down

I’m happy to announce new releases of MaxDB 7.6 (http://www.mysql.com/products/maxdb/). The Devs have put a lot of time and energy into this release and it addresses many issues. Take a look through the Change Log for some details.

Grab a copy of the new release here:
http://dev.mysql.com/downloads/maxdb/7.6.00.html


© cjcollier for C.J.'s WordPress of studlyness, 2006. | Permalink | No comment

Add to del.icio.us

Search blogs linking this post
  [Read more...]

Moved blog, took long weekend
+0 Vote Up -0Vote Down

For those of you who want to hear me read this instead of having to do so yourself (no hyperlinks), click here for .ogg and here for .mp3.

I migrated the blogs’ database and code from moonunit to avenger, both of which run Debian Sarge. Y’all should now notice a vast improvement in throughput. The ISP that Moonunit sits on should also see a large decrease in traffic.

Today, I added a campaign to raise funds for hosting. If you have any extra funds, please help me with colocation costs. It’s expensive and y’all use up a bunch of bandwidth. If you find this site useful please

  [Read more...]
MySQL Meetup 2006/05/01
+0 Vote Up -0Vote Down

Hannah, Scarlet and I attended the Seattle Meetup, since we heard Arjen was planning on being in town. We went to the normal location, but the owner told me they were closed due to their entire staff being involved in the civil rights march.

We arrived to a table full of the regulars. Breadsticks,

  [Read more...]
A quick over-view of RDBMSs? general place in the world, and ours in particular
+0 Vote Up -0Vote Down
[1][2][3]

RDBMSs (or for clarity, Databases) are a basic element of any
computer-based appliance in the same way as are an Operating System,
Web Server and software development platform.  As is common for
developers of Open Source software, I am quite familiar with Linux as
the Operating System, Apache as the Web Server, MaxDB and MySQL as
Databases and Perl (and to a lesser degree, PHP) as the software
development platform.  This combination is often called the "LAMP"
stack [4].  Take the following as coming from that background.

Databases are the storage mechanism of the content presented to the
user of any computer-based appliance.  This content may be displayed
via a desktop application or through a web browser.  The main display
mechanisms I think of when writing applications are 1) Through the end
users's computer in real-time via a desktop application, in an
interactive manner.  2) Through a web server,
  [Read more...]
MaxDB series: news but no series posting
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

we have two news for you. The bad one: no MaxDB series posting this week. The good one: german language MaxDB web seminar tomorrow!

My last week has been dominated by preparing the upcoming MaxDB web seminar on MaxDB performance tuning. The web seminar will be held in german tomorrow Thursday, 21.04.2006 at 10 CEST (MEZ). You can still register for the seminar at http://www.mysql.de/news-and-events/web-seminars/maxdb-performance.php (http://www.mysql.de/news-and-events/web-seminars/maxdb-performance.php). Don’t expect too much from the 45-minute talk. In 45-minutes one can’t do much more than talk about the very basics and try to give you an overview on the topic. Due to the web seminar and other duties we did not make it to write the next MaxDB series posting on transactions.

We have more good news for you. My co-worker

  [Read more...]
MaxDB series: news but no series posting
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

we have two news for you. The bad one: no MaxDB series posting this week. The good one: german language MaxDB web seminar tomorrow!

My last week has been dominated by preparing the upcoming MaxDB web seminar on MaxDB performance tuning. The web seminar will be held in german tomorrow Thursday, 21.04.2006 at 10 CEST (MEZ). You can still register for the seminar at http://www.mysql.de/news-and-events/web-seminars/maxdb-performance.php (http://www.mysql.de/news-and-events/web-seminars/maxdb-performance.php). Don’t expect too much from the 45-minute talk. In 45-minutes one can’t do much more than talk about the very basics and try to give you an overview on the topic. Due to the web seminar and other duties we did not make it to write the next MaxDB series posting on transactions.

We have

  [Read more...]
MaxDB series: ?just SQL
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

The previous “please wait” posting was caused by a new guideline on series postings. The new guideline says that postings must be written one week before they get published. The week between the writing and the publication is used for corrections. I’m writing these lines on April, 4th but the article won’t be published before Wednesday April, 12th. We hope that in the time between writing and publishing we can catch most of the Gotchas to further improve the quality of the series. However, this series will continue to be more like a collection of blog postings than a book, a magazine article or any other “official documentation”. We try to do our best, but unfortunately we cannot apply the same amount of quality assurance and proof-reading to the MaxDB series that we do for magazine articles, official documentation or

  [Read more...]
MaxDB series: …just SQL
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

The previous “please wait” posting was caused by a new guideline on series postings. The new guideline says that postings must be written one week before they get published. The week between the writing and the publication is used for corrections. I’m writing these lines on April, 4th but the article won’t be published before Wednesday April, 12th. We hope that in the time between writing and publishing we can catch most of the Gotchas to further improve the quality of the series. However, this series will continue to be more like a collection of blog postings than a book, a magazine article or any other “official documentation”. We try to do our best, but unfortunately we cannot apply the same amount of quality assurance and proof-reading to the MaxDB series that we do for magazine articles,

  [Read more...]
MySQL AB :: The MaxDB series on PlanetMySQL.
+0 Vote Up -0Vote Down

We’ve published the first few episodes of the weekly MaxDB series in .pdf form. Please take a look and let us know what you think!

MySQL AB :: The MaxDB series on PlanetMySQL.


© cjcollier for C.J.'s WordPress of studlyness, 2006. | Permalink | No comment

Add to del.icio.us

Search blogs linking this post with Technorati

Want more on these topics ? Browse the archive of posts filed under

  [Read more...]
Useful MaxDB commands
+0 Vote Up -0Vote Down

To find a list of tables in a schema:

$ sqlcli -u TEST,TEST -d SYNCMANA "SELECT * FROM TABLES WHERE SCHEMANAME = 'TEST'"

To find a list of triggers on a table:

$ sqlcli -u DBSERVICE,SECRET -d SYNCMANA "SELECT * FROM TRIGGERS WHERE TABLENAME = 'T'"

To describe a table’s structure:

$ cat me && echo "-----" && 
   loadercli -d SYNCMANA -u TEST,TEST -b ./me && echo "-----" && 
   cat tabledef.txt
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'

-----
Loader protocol: '/home/cjcollier/.sdb/loader/log/loader.prt'
Loader packages: '/home/cjcollier/sdb/loader/packages'

User TEST connected to database SYNCMANA schema TEST on local host.
dataextract for dataload table T
outstream file 'tabledef.txt'
outstream file 'idontcare'
Successfully executed

-----
//
CREATE TABLE "T"
(
        "I"  Integer
  [Read more...]
Synchronization Manager: MySQL as replication destination
+0 Vote Up -0Vote Down

Earlier this week, I wrote about the Synchronization Manager and gave a step-by-step tutorial on getting an initial scenario implemented. In this article, I’ll expand on the previous tutorial by introducing the concept of uni-directional synchronization.

Uni-directional participants act as destinations for replicated data. These participants are sometimes called “slaves,” because they are not capable of replicating changes to other members of the synchronization scenario. Theoretically, any RDBMS that provides an appropriate JDBC interface can participate as a replication destination with little effort on the part of the DBA. As an example of this, I have documented my experience creating a uni-directional MySQL participant.

One situation DBAs might use databases synchronized as uni-directional participants is when they want to

  [Read more...]
Creating a Synchronization Management Scenario
+0 Vote Up -0Vote Down

This is a follow-up to my earlier article on the MaxDB Synchronization Manager. In the months since my prior article, the Synchronization Manager has proved itself production ready and capable of replicating real-world databases in demanding scenarios.

Take the following as theoretical and emperical examples of such scenarios (not necessarily in that order):

i) For its yearly trade show, a company needs to process user registration. Because of the high volume of attendees, there must be more than one system through which registration takes place. Therefore, the registration software is to run on multiple separate laptops. At the end of each day, the laptops synchronize their registration information with each other and a master registration database.

ii) In order to reduce human error and increase efficiency, a

  [Read more...]
MaxDB series: when do we publish the next article?
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

it happened what we always told you what might happen: we did not make it to write an article for you in this week. Of course, this is not the end of the series. It will continue, but other duties might force us in the future to skip a week again. As a small “excuse” for you, we have written an FAQ like entry.

Can I recover a MaxDB backup on a different version and/or a different system?

It depends: the processor architecture and the MaxDB version must be compatible. Given these two main preconditions you can take a backup from one system and recover it on a different system. This is a common situation when you are planning to upgrade the database software and the server hardware in one step. In general, we do not recommend to do these two steps at once. The simple reason that we do not is, that you should never change

  [Read more...]
MaxDB series: when do we publish the next article?
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

it happened what we always told you what might happen: we did not make it to write an article for you in this week. Of course, this is not the end of the series. It will continue, but other duties might force us in the future to skip a week again. As a small “excuse” for you, we have written an FAQ like entry.

Can I recover a MaxDB backup on a different version and/or a different system?

It depends: the processor architecture and the MaxDB version must be compatible. Given these two main preconditions you can take a backup from one system and recover it on a different system. This is a common situation when you are planning to upgrade the database software and the server hardware in one step. In general, we do not recommend to do these two steps at once. The simple reason

  [Read more...]
MaxDB series: SQL users continued
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

Several co-workers have spoken to me on the length of the MaxDB series postings. I fully agree that most postings are too long for a blog. But we do have a very eager plan to publish a complete online class. This is causing long postings and we can’t make them much shorter. We try to structure the articles in a similar way like a web page to make reading and navigating easier. Every posting has a table of contents, is devided into sections and has a fixed structure. For offline reading, printing and as a reference we will soon publish a PDF document with all postings of the series.

The experiment to use the medium of a blog for a class will continue as long as the readers do not complain. But we will add a “read more” link to the fixed structure of every posting. That means, we will present only the beginning of a posting on

  [Read more...]
MaxDB series: SQL users continued
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

Several co-workers have spoken to me on the length of the MaxDB series postings. I fully agree that most postings are too long for a blog. But we do have a very eager plan to publish a complete online class. This is causing long postings and we can’t make them much shorter. We try to structure the articles in a similar way like a web page to make reading and navigating easier. Every posting has a table of contents, is devided into sections and has a fixed structure. For offline reading, printing and as a reference we will soon publish a PDF document with all postings of the series.

The experiment to use the medium of a blog for a class will continue as long as the readers do not complain. But we will add a “read more” link to the fixed structure of every posting. That means, we will present only

  [Read more...]
Miguel wants me to be MySQL's ambassador to Mono
+0 Vote Up -0Vote Down
This was an honor, but I must decline. We already have such an "ambassador." Thank you, Miguel.

14:15  What is MaxDB?
14:15  http://en.wikipedia.org/wiki/MaxDB
14:16  miguel2: it was written in pascal in the mid 70s.  it's a
            pre-relational database with all sorts of features [added] on
14:16  Wait, is that a different DB?
14:16  miguel2: yep
14:16  So its not MySQL?
14:16  miguel2: nope
14:16  That is crazy talk
14:16  crazy
14:17  I dontbelieve you
14:17  miguel2: heh, okay.  MySQL doesn't have *any* pascal code
in the
            kernel, afaik
14:19  Who uses that?
14:19  So why dont they pay you to hack on Mono?
14:19  miguel2: that's something I'd like to know :)
14:19  We need a firm MySQL commitment to Mono
14:19  Tell your boss I said so
14:19  :-)
14:19  miguel2: alrighty.
14:19  Take me to your leader
MaxDB series: User concept, authorization and schemata
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

a new version of MaxDB (http://www.mysql.com/products/database/maxdb/) 7.5.00 has been released recently: MaxDB 7.5.00.34. Two versions of MaxDB have the status of General Availability (GA). MaxDB 7.5.00 and MaxDB 7.6.00 can be used in production environments. Open Source users should use the latest release which is 7.6.00. Last weeks release of 7.5.00 Build 34 (7.5.00.34) is of interest for all 7.5.00 users. Check the Changelog if it shows “must-have” entries for you.

In this issue

This article is part of a MaxDB series on PlanetMySQL that teaches you how to use MaxDB. We hope that we can write about 40 articles in 2006: roughly one per week, published on wednesdays if time permits. All articles

  [Read more...]
MaxDB series: User concept, authorization and schemata
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

a new version of MaxDB (http://www.mysql.com/products/database/maxdb/) 7.5.00 has been released recently: MaxDB 7.5.00.34. Two versions of MaxDB have the status of General Availability (GA). MaxDB 7.5.00 and MaxDB 7.6.00 can be used in production environments. Open Source users should use the latest release which is 7.6.00. Last weeks release of 7.5.00 Build 34 (7.5.00.34) is of interest for all 7.5.00 users. Check the Changelog if it shows “must-have” entries for you.

In this issue

This article is part of a MaxDB series on PlanetMySQL that teaches you how to use MaxDB. We hope that we can write about 40 articles in 2006: roughly one per week,

  [Read more...]
Customer?s experience with Sync Manager
+0 Vote Up -0Vote Down
14:34 < MThomas> Time to install and configure Sync Manager in development
                 environment: 4 days, one of which was 15 hours long.  Time to
                 install and configure in production: 30 minutes.

I’ve written a bit of documentation that might help you get things running in the same way:


© cjcollier for C.J.'s WordPress of studlyness, 2006. |

  [Read more...]
MaxDB series: DBM GUI and dbmcli, SQL Studio and sqlcli
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

this is the fourth posting in our MaxDB series. The series started about four weeks ago and it will very likely take the rest of the year to complete. All postings of the series together will make kind of an online course for MaxDB. Over the last postings we explained what MaxDB (http://www.mysql.com/products/database/maxdb/) is, we explained about the outstanding features of MaxDB and we taught you how to perform a basic MaxDB installation that serves as a basis for all of the following lessons.

In this issue

The today’s MaxDB lesson is about the two most important tools of MaxDB. The first tool is the Database Manager GUI and it’s commandline counterpart dbmcli. The Database Manager GUI is the main tool to perform administrative tasks like shutting down the database, performing backups or doing some basic monitoring of the

  [Read more...]
MaxDB series: DBM GUI and dbmcli, SQL Studio and sqlcli
Employee +0 Vote Up -0Vote Down

Dear MySQL users, MaxDB users and friends,

this is the fourth posting in our MaxDB series. The series started about four weeks ago and it will very likely take the rest of the year to complete. All postings of the series together will make kind of an online course for MaxDB. Over the last postings we explained what MaxDB (http://www.mysql.com/products/database/maxdb/) is, we explained about the outstanding features of MaxDB and we taught you how to perform a basic MaxDB installation that serves as a basis for all of the following lessons.

In this issue

The today’s MaxDB lesson is about the two most important tools of MaxDB. The first tool is the Database Manager GUI and it’s commandline counterpart dbmcli. The Database Manager GUI is the main tool to perform administrative tasks like shutting down the database,

  [Read more...]
MaxDB: Working around the missing RANDOM function
Employee +0 Vote Up -0Vote Down

MaxDB (http://www.mysql.com/products/database/maxdb/) is a nice database but I’m missing some build-in functions, in particular a function to generate random values. All functions available in MaxDB are listed in the MaxDB manual. In the section MaxDB Library - Basic Information - Reference Manual - Functions: Overview you can find a complete list of build-in functions.

One can argue that a function to create random values is not needed inside a database. You do not need it, because you can use your programming language to generate random values. And it’s likely that your programming language comes with a sophisticated random number generator or has access to such one. For most applications it is true, that you can shift the job of generating a random value to the layer of application programming. But what if you want to use a stored

  [Read more...]
MaxDB: Working around the missing RANDOM function
Employee +0 Vote Up -0Vote Down

MaxDB (http://www.mysql.com/products/database/maxdb/) is a nice database but I’m missing some build-in functions, in particular a function to generate random values. All functions available in MaxDB are listed in the MaxDB manual. In the section MaxDB Library - Basic Information - Reference Manual - Functions: Overview you can find a complete list of build-in functions.

One can argue that a function to create random values is not needed inside a database. You do not need it, because you can use your programming language to generate random values. And it’s likely that your programming language comes with a sophisticated random number generator or has access to such one. For most applications it is true, that you can shift the job of generating a random value to the layer of application

  [Read more...]
MaxDB article 3 - Installation
+0 Vote Up -0Vote Down

Hello MaxDB users, administrators, hobbyists and community!

This, the third of our weekly articles on MaxDB, will cover the installation of the MaxDB server and associated tools. One of the features the team is most proud of is MaxDB's ease of installation and the speed with which it occurs. It's been estimated that a DBA with no prior knowledge of the system can complete a basic installation in less than 15 minutes. Please note that this does not include download time.

More here:
http://wiki.colliertech.org/index.php/MaxDB:Installation

Showing entries 1 to 30 of 65 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.