We’re excited to announce that customers & users of Continuent will now receive our expert MySQL™ database solutions, services and support when they use Continuent’s Tungsten Enterprise, a complete clustering and data management solution for the MySQL database. The same applies to customers using Tungsten Replicator, an advanced data replication solution.
Overall, the big news is that our companies will now jointly offer Tungsten Enterprise and Tungsten Replicator-based solutions to help MySQL users in accelerating the deployment and management of clustered MySQL databases, as well as the deployment of complex data replication solutions. We will also together offer MySQL users[Read more...]
The MySQL Developer Tools team is announcing the next maintenance release of it’s flagship product, MySQL Workbench (http://www.mysql.com/products/workbench/" target="_blank), version 5.2.38.
74 bugs were fixed in this version.
MySQL Workbench 5.2 GA
• Data Modeling
• Query (replaces the old MySQL Query Browser)
• Administration (replaces the old MySQL Administrator)
Please get your copy from our Download site. Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.
Workbench Documentation can be found here.
In addition to the new Query/SQL[Read more...]
New feature provides significantly faster insight and root cause analysis
SAN JOSE, Calif., February, 15, 2012 – Monitis, the leading cloud and web application monitoring software provider, today announces that it has added comprehensive MySQL database monitoring to its award-winning Application Performance Management & Monitoring platform. The robust Software-as-a-Service (SaaS) tool enables users to gain significantly faster insight when conducting root cause analysis.
The MySQL monitoring feature includes 246 monitoring variables and more than 21 different metrics to provide one of the easiest to use, yet comprehensive database monitoring tools[Read more...]
INSTALL PLUGIN three_attempts SONAME 'dialog.dll';
CREATE USER test_dialog IDENTIFIED VIA[Read more...]
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...]
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:
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 Releases Database DBT2 Performance Results
Technology achieves unprecedented transaction speed for a MySQL database at a low cost
Boston, Mass., December 12, 2011 – ScaleBase, 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...]
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...]
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.
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 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:
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...]
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.
Probably the most obvious change is in code. There is no way around it – you’ll have to change your code.
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...]
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.
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...]
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.
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...]
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...]
Boston, Mass., August 15, 2011 – ScaleBase, 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...]