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 61 to 90 of 270 Next 30 Older Entries

Displaying posts with tag: News (reset)

New feature: Pluggable authentication
+1 Vote Up -0Vote Down
Starting with MySQL 5.5.7 or MariaDB 5.2, the server allows the client to authenticate via plugin. HeidiSQL now fully supports establishing such connections, by providing an exported method called mysql_authentication_dialog_ask, which is automatically invvoked by libmysql.dll, if the server says so during the connection handshake.

Curious how that works? Here's a simple example:

1. Be sure to have the "plugins" directory in C:\Program files\HeidiSQL\, and the dialog.dll. This is done automatically when installing a newer beta build from the download page.

2. On your server, install the plugin "dialog.dll":

INSTALL PLUGIN three_attempts SONAME 'dialog.dll';


3. On your server, create a new user which authenticates via this plugin:

CREATE USER test_dialog IDENTIFIED VIA










  [Read more...]
New feature: Pluggable authentication
+0 Vote Up -0Vote Down
Starting with MySQL 5.5.7 or MariaDB 5.2, the server allows the client to authenticate via plugin. HeidiSQL now fully supports establishing such connections, by providing an exported method called mysql_authentication_dialog_ask, which is automatically invvoked by libmysql.dll, if the server says so during the connection handshake.

Curious how that works? Here's a simple example:

1. Be sure to have the "plugins" directory in C:\Program files\HeidiSQL\, and the dialog.dll. This is done automatically when installing a newer beta build from the download page.

2. On your server, install the plugin "dialog.dll":

INSTALL PLUGIN three_attempts SONAME 'dialog.dll';


3. On your server, create a new user which authenticates via this plugin:

CREATE USER test_dialog IDENTIFIED VIA three_attempts USING










  [Read more...]
New feature: SSL settings in user manager
+0 Vote Up -0Vote Down
In MySQL you can restrict users to connect only via SSL settings. HeidiSQL's user manager now adds support for these settings, which include cipher, subject and issuer. You can also select X509 certificate, in which case cipher etc. do not matter. To get this new feature, you just need to update to the latest build (see Help > Check for updates).

New feature: SSL settings in user manager
+0 Vote Up -0Vote Down
In MySQL you can restrict users to connect only via SSL settings. HeidiSQL's user manager now adds support for these settings, which include cipher, subject and issuer. You can also select X509 certificate, in which case cipher etc. do not matter. To get this new feature, you just need to update to the latest build (see Help > Check for updates).

Merry Xmas
+2 Vote Up -0Vote Down

We wish all our customers, users and partners a Merry Xmas and a Happy New Year.

The year of 2011 has been a terrific year for us.  But first let us have a look at where we started 10 years ago. The first version of SQLyog was released in the spring of 2002 – what will mark our 10 year anniversary as a company early next year. In the period since then we have seen quite a lot of other MySQL clients come and go. We are happy to see most of our existing customers upgrade regularly, to see our user base increase, and we are happy to do our best to provide the solutions requested by users and to keep pace with MySQL development.

And also 4½ years ago we added MONyog to our portfolio. So there will be another important anniversary to celebrate in 2012 as well. MONyog has also proved to

  [Read more...]
Working with ScaleBase and NOSQL
+0 Vote Up -0Vote Down

There is a huge amount of buzz around NOSQL, and we at ScaleBase are happy to see companies making the move to NOSQL. Despite what some people might think, we consider it a blessed change. It is time for applications to stop having a single data store – namely a relational database (probably Oracle) – and start using the best tool for the job.

In the last couple of years, since NOSQL technologies broke into our world, a lot of experience has been gathered on how to use them. Mainly, we see NoSQL technologies used for one of the following scenarios:

  • Queries that require a very short response time
  • Storing data without a well-defined schema, or storing data with a frequently modified schema

Now, I’m not in any way saying that NOSQL solutions are not used for other scenarios as well; I’m only saying that from our experience here at ScaleBase ,

  [Read more...]
ScaleBase achieves 180K NO-TPM DBT2 results on Amazon RDS
+1 Vote Up -0Vote Down

ScaleBase Releases Database DBT2 Performance Results

Technology achieves unprecedented transaction speed for a MySQL database at a low cost

 

Boston, Mass., December 12, 2011ScaleBase, Inc. today announced the results of its MySQL database benchmark, based on the industry-standard DBT-2 test. ScaleBase has achieved an unmatched 180,000 Transactions per Minute – the highest result for a MySQL database – while running on an Amazon RDS environment. Cost per Transaction was reported to be 50 cents, which demonstrates the cost-effectiveness of the ScaleBase solution on the Amazon EC2 cloud. Full details of the benchmark

  [Read more...]
Automated installer creation
+0 Vote Up -0Vote Down
On the download page you will find the executable for each SVN commit in the HeidiSQL repository. The executables are processed in conjunction with a SVN post commit hook. I just extended this process so it also creates the installer with that executable, using a InnoSetup command line. This way, users who need a full installer and also want to use the latest build can do that in one download.

Thanks to Jordan Russell for that excellent, free InnoSetup.
Making the case for Database Sharding using a Proxy
+2 Vote Up -0Vote Down

There are several ways to implement sharding in your application. The first and by far the most popular, is to implement it inside your application. It can be implemented as part of your own Data Access Layer, database driver, or an ORM extension. However, there are many limitations with such implementation, which drove us, at ScaleBase, to look for an alternative architecture.

As the above diagram shows, ScaleBase is implemented as a standalone proxy. There are several benefits to using such an architecture.

First and foremost, since the sharding logic is not embedded inside the application, third party applications can be used, be it MySQL Workbench, MySQL command line interface or any other third party product. This translates to a huge saving in the day-to-day costs of both

  [Read more...]
Black Friday / Cyber Monday Deal – 50% off on all products (expires Dec 2nd, 23:59 PST)
+16 Vote Up -5Vote Down

Update: Thank you all for making this campaign a colossal success. We are extending this offer till Dec 2nd, 23:59 PST. Many corporate users requested us to extend the offer as they require time to get official approval. Pick your copy right now! Use coupon code blkfrdy11 to get 50% off.

Happy Thanksgiving!

Black Friday is back with a bang. Get a flat 50% discount on all Webyog products. Yes, you read it right, a flat fifty percent discount. Hurry, this offer expires Nov 28th Dec 2nd, 23:59 PST. Use coupon code blkfrdy11 to avail the discount on any purchase. Buy Now.

Still using SQLyog Community Edition?

Upgrade to the feature rich SQLyog

  [Read more...]
MySQL Workbench 5.2.36: What’s New
Employee_Team +0 Vote Up -0Vote Down

MySQL Workbench 5.2.36 is now out and brings a lot of improvements across the board, with special focus on the Query Editor. We’ll cover some of that here:

Redesigned Query Editor

    • The log of executed commands and server responses is now always visible while resultset grids and the query editor can be resized according to your needs. Resultsets are also grouped in the same tab as the query editor that generated them.
    • SELECT queries are now analyzed as in the old MySQL Query Browser tool and, if possible, its resultset can be edited in the grid. If the resultset cannot be edited, you can place the mouse over the ReadOnly label and view the reason.

  • Improved snippets manager and editor, allows having snippets list always at hand, while editing can be done
  [Read more...]
Windows authentication on SQL servers
+1 Vote Up -2Vote Down
Users of MS SQL servers may find it useful to connect to their server via Windows authentication. The login dialog disables username + password in that case, as these are not required (indeed ignored by the server). The old option "Prompt for credentials" is now mutually exclusive to the new checkbox option "Windows authentication". Makes no sense to prompt for user+pass which then are ignored by the server. The connection dialog has grown a bit in its minimum height, as now the mentioned two checkboxes need vertical space. Well, features need space.



For MySQL sessions this checkbox is disabled. Although there is a MySQL server plugin which allows Windows authentication, the difference to MS SQL is



  [Read more...]
Windows authentication on SQL servers
+0 Vote Up -0Vote Down
Users of MS SQL servers may find it useful to connect to their server via Windows authentication. The login dialog disables username + password in that case, as these are not required (indeed ignored by the server). The old option "Prompt for credentials" is now mutually exclusive to the new checkbox option "Windows authentication". Makes no sense to prompt for user+pass which then are ignored by the server. The connection dialog has grown a bit in its minimum height, as now the mentioned two checkboxes need vertical space. Well, features need space.



For MySQL sessions this checkbox is disabled. Although there is a MySQL server plugin which allows Windows authentication, the difference to MS SQL is that



  [Read more...]
Black icons on Wine fixed
+0 Vote Up -1Vote Down
Wine users reported this a couple of times in HeidiSQL's bug tracker, and also on WineHQ there were several reports for the same thing found: black color on icon areas which should be transparent. Cosmetic though quite annoying for a GUI which provides important buttons on a main toolbar. Wine 1.3.33 says this is fixed now, as stated on WineHQ.
Your web platform runs on an Oracle database? You must be Nuts! Part 3
+3 Vote Up -0Vote Down

This is the third blog post in a series designed to assist companies who wish to migrate their code from Oracle to MySQL. You can read the previous post here.

I went over some of the difficult topics you’ll face when migrating from Oracle to MySQL. However, I left out the topic of database scalability (after all – this is a ScaleBase blog).

Oracle users are used to having a very clear scalability path. You start with an Oracle Standard edition, and if your budget allows, you increase hardware (memory, CPU), improve your storage speed, buy Oracle Enterprise edition and use portioning. If all that fails, you move to a distributed RAC environment. If you’re really on the high end, you buy ExaData2. This is where your

  [Read more...]
Your web platform runs on an Oracle database? You must be Nuts! – Part 2
+2 Vote Up -0Vote Down

This is the second blog post in a series designed to assist companies who wish to migrate their code from Oracle to MySQL.

In the first post of the series I tried to explain why you would like your web platform to run on a MySQL database, and not on an Oracle database. In this post, I’ll try to focus on the changes that you need to plan for when migrating from an Oracle environment.

Code

Probably the most obvious change is in code. There is no way around it – you’ll have to change your code.

  • SQL statements.
    While ANSI SQL 92 is a standard, Oracle offers extensions to the spec – and those are used by most developers, sometimes without their being aware of it.
    Of course, when moving to MySQL,

  •   [Read more...]
    Your web platform runs on an Oracle database? You must be Nuts!
    +5 Vote Up -0Vote Down

    This is the first blog post in a series designed to assist companies who wish to migrate their code from Oracle to MySQL.

    During the World War II “Battle of the Bulge”, General McAuliffe said to the German forces who asked for his surrender: “Nuts!” The rest is history – he won the battle, and the allied forces won the war.

    Some things are like that. So absurd that “Nuts” is the only possible reaction. And frankly – running your web infrastructure on an Oracle database is one of those things.

    Now, the pricing issue is very well covered. Just see here. And for most people, this should be enough. We had a customer migrating from a 7M USD environment to a 200K yearly environment (licensing and support)

      [Read more...]
    Jet Profiler for MySQL 2.0 released
    +0 Vote Up -0Vote Down
    Jet Profiler for MySQL 2.0 is now available!

    Multi-language Support

    We are pleased to announce that multi-language support is now available via this release, responding to feedback and user requests. Support is now available in three languages including English, German and Swedish. If you would like Jet Profiler translated into your language, please let us know. And if you feel you can help us with translation, even better!

    Adjustable data retention timeframe

    Adjustable data retention timeframe is another exciting feature. The feature itself allows you to specify how long the application will keep the data before discarding it. This feature enables extended profiling over days or weeks without sacrificing a great deal in performance or disk space. You can access this setting via the recording settings dialog.

    Top IP  [Read more...]

    ScaleBase at Percona Live in London – Come see how to transparently shard your MySQL
    +0 Vote Up -0Vote Down

    ScaleBase is happy to sponsor the Percona Live London MySQL Conference. If you plan to attend, you can catch our booth on the expo floor or attend Liran’s session – “The Benefits of Database Sharding” at 2PM, October 25th at the Bishopsgate Suite.

    Join Liran’s lecture on the Benefits of Sharding MySQL at Percona Live London
    +0 Vote Up -0Vote Down
    How to Implement MySQL Sharding – Part 2
    +2 Vote Up -0Vote Down

    In the previous post of this series (which can be found here) I discussed how to identify tables that can serve as good candidates for sharding.

    Once you have decided which tables should be sharded (all the rest should be global tables), the choice of sharding keys is rather straightforward, as most will use the table primary key as the shard key. Of course, if multiple tables are sharded, and there is a foreign key relationship between these tables, then the foreign key will serve as the shard key for some tables.

    Many people attempt to shard based on customer_id or a resource id, but I have seen how this usually fails in production environments. It is very hard to know in advance which customers belong together in the same database, and since customers can suddenly increase their traffic,

      [Read more...]
    Database Sharding lecture on Boston MySQL Meetup
    +1 Vote Up -0Vote Down

    Yeah, we know it’s 6 month from now – but we’ll give a lecture titled “Database Sharding on MySQL” at the Boston MySQL Meetup. Register here.

    Old GUI tools repositories on Launchpad
    Employee_Team +1 Vote Up -0Vote Down

    You might remember that MySQL was aquired by Sun, which later went into Oracle (who won’t? ). As usual in such a process network infrastructure is being merged to ease managing it. Such a merge is currently in process with the effect that previously publicly available servers are now behind Oracle’s firewalls. From a security point of view this is good news, not so for services that relied on this access. One of them is our copy of all old GUI tools repositories on Launchpad. These repositories have been made available 3 years ago when we prepared the switch to MySQL Workbench as our main product. The idea behind it was that anybody who is interested can work on the code and propose patches.

    As you can see there this hasn’t worked out well. No merges

      [Read more...]
    MySQL Workbench 5.2.35 pre-release binaries
    Employee_Team +2 Vote Up -0Vote Down

    It has been quite a while since the last release, but we’ve been quite busy. One of the reasons was that we were required to make a relatively major core change in the Workbench codebase, which unfortunately did not add anything new from a user’s point of view. There’s potential for new bugs having been introduced by that, and while the program has been undergoing testing for a while, it’s possible there are more bugs in the hiding.

    Because of that, we are releasing test binaries for trial by the community. If no regressions are found, this will be the the next version to be released and the foundation for what will be the next major release, which will contain exciting changes that we know many people have been expecting since some time.

    Additionally, 44 bugs have been fixed so far in this release.

    If you

      [Read more...]
    Scale your MySQL Webinar
    +0 Vote Up -0Vote Down
    Interested in scaling MySQL? Read our new white paper
    +0 Vote Up -0Vote Down
    ScaleBase Launch Coverage
    +0 Vote Up -0Vote Down

    Wow. Our launch was picked up by many news sites. Here’s just a partial list. Thanks guys.

      [Read more...]
    ScaleBase 1.0 is now AVAILABLE!
    +1 Vote Up -0Vote Down

    Boston, Mass., August 15, 2011ScaleBase, Inc. today announced the general availability of ScaleBase 1.0 for unlimited scalability of MySQL databases. ScaleBase 1.0 delivers MySQL performance and high availability, without the need to change a single line of application code. Users of MySQL can download and easily deploy the software by visiting http://www.scalebase.com/solution/download/.

    ScaleBase utilizes two techniques for scaling: read-write splitting and transparent sharding (a technique for massively scaling-out relational database). The software enables MySQL to scale

      [Read more...]
    Standard Query Language (SQL) for NoSQL databases?
    +0 Vote Up -0Vote Down

    I recently came across an interesting blog post on RedMonk (not surprising, as I read most of their posts). It’s called It’s Beginning to Look a Lot Like SQL and basically it talks about query language for NoSQL databases. It seems that as NoSQL becomes more popular, users want to do more with it – a good level of querying, for example, is needed.

    Now of course, since NoSQL is a family of products that work in radically different ways, it’s not certain that this is possible (or even desirable – read Alex Popescu’s post on the subject).

    But my question is – why do you even need a query language for NoSQL data stores? After all, running queries on distributed data might be complex to

      [Read more...]
    Oracle Exadata “technology that most changed his life” – says Oracle ACE & Pythian DBA Fahd Mirza.
    +0 Vote Up -0Vote Down

    Pythian’s Oracle ACE, Fahd Mirza appears in this month’s Community: Peer-to-Peer review “In With the New“, as published in the September/October 2011 issue of Oracle Magazine.

    Fahd states that “Oracle Exadata Database Machine” has most changed his life – changing the game, and setting very high standards of performance, support, scalability, reliability and unification.

    Shout out to Fahd from your peers at Pythian!

    I guess there might be just a little truth to Pythian’s growing reputation as an “Oracle ACE Factory” ;), as recently mentioned by Justin Kestelyn in the May 11, 2011 OPN PartnerCast:

      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 270 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.