Beware of ‘virtual columns’ – they may render your backups unusable.

  • peter_laursen
  • November 9th, 2015
  • MySQL
  • Virtual columns have existed in MariaDB since version 5.2 and were recently introduced in MySQL 5.7. The recent MySQL 5.7.9 GA release includes this feature.

    At first look the implementations in MariaDB and Oracle/MySQL do not seem much different. If you compare documentation here and here you will see only that MariaDB uses the keyword PERSISTENT whereas MySQL uses the keyword STORED for same. There are also some minor differences on how virtual columns may be used in indexes. Those are all the differences you will notice from comparing the documentation of each.

    But there is one more and much more important difference – and this simple example illustrates this:

    CREATE TABLE `vc_test`.`t1`(
    `id` INT NOT NULL,
    `id3` INT AS ( id*3 ) VIRTUAL);

    INSERT INTO `vc_test`.`t1` VALUES (1,3);

    Now .. what will happen is:
    1) MariaDB inserts the row and issues a warning “The value specified for computed column ‘id3′ in table ‘t1′ ignored”.
    2) MySQL returns an error and nothing is inserted to the table.
    (for completeness, the described behavior of MariaDB applies to ‘non-strict’ SQL-mode only – what I think makes little sense).

    Further Oracle changed ‘mysqldump’ so that it will now generate INSERT statements like

    INSERT INTO `t1` (`id`) VALUES (1);
    .. and not as before
    INSERT INTO `t1` VALUES (1, 3);

    .. so that a dump of tables with virtual columns from 5.7.9 can be restored. However that only applies to the ‘mysqldump’ version shipped with MySQL 5.7.9 – not earlier versions (and on a side-remark, I wonder how much it slows down ‘mysqldump’ to check for virtuality of every column).

    Also this behavior breaks ‘restorability’ of backups generated by common GUI tools – including our own SQLyog – with such tables. Probably also phpMyAdmin and similar are now broken. You should verify any backup tool you use, generating backups as SQL scripts, carefully, if you upgrade to MySQL 5.7 and if you plan to use virtual columns. If you are using virtual columns with MariaDB you should ensure that backup scripts generated have set a non-strict sql-mode on top of the script.

    I created a bug report about this at I got the reply that the Oracle solution is compliant with SQL standards. Maybe so, but I find it very thoughtless and unfortunate that MySQL breaks 3rd party tools without any notice to users and vendors and with no transition period.

    Is there any community-awareness left in Oracle’s MySQL team at all?

    MONyog MySQL Monitor 6.5 Has Been Released

  • peter_laursen
  • November 4th, 2015
  • MONyog, Releases
  • Changes (as compared to 6.4) include:


    * On Amazon RDS and Aurora, MySQL log files (Slow Query Log, General Query Log and Error Log) can now be read by MONyog. So Error Log monitoring is now possible here, and the Query Analyzer does not require logging to tables anymore. For this the Amazon “REST” API (and not SFTP) is used. Client functionalities for this API have been integrated into MONyog.
    * Added monitors for Galera: “Presence of non-InnoDB tables” and “Tables without a primary/unique key”.

    Bug Fixes:

    * Monitors and Real-time page failed to load on Internet Explorer 8 (highest IE option on WinXP) due to javascript errors.
    * Fixed a rare crash when connected to MySQL 5.7.6+.
    * Accessing Realtime interface could cause a crash if connection to the server was not available.


    SQLyog MySQL GUI 12.16 Released

  • peter_laursen
  • November 3rd, 2015
  • Releases, SQLyog
  • Changes as compared to 12.15 include:


    * Schema Designer may now optionally use ‘portrait’ or ‘landscape’ layout for printing. Before only ‘portrait’ was available. Also page breaks may now be previewed.

    Bug Fixes:

    * With ChallengeResponseAuthentication’ set to “YES” in SSHD configuration, SSH tunnel from SQLyog would fail. This was introduced in 12.13 with the PLINK update here.
    * On Wine the color palette used for customizing colors of the SQLyog interface did not open.
    * In the Connection Manager .. MySQL tab, pressing ALT+V moved cursor to “keep alive interval” setting (last control of the tab) and not “saved connections” (first control of the tab).


    * The Import External Data tool would create indexes on BLOB/TEXT columns with an index prefix length of (only) 6 characters. This has been raised to 255.
    * SQL Server “UNIQUEIDENTIFIER” and Access “REPLICATIONID” data types are now migrated to a CHAR(36) and not CHAR(50) as before. This is for compability with how various applications and environments – including and most notably MS EntityFramework – expect data length of a Unique Identifier.


    MONyog MySQL Monitor 6.4 Has Been Released

  • Chetan
  • October 8th, 2015
  • MONyog, Releases
  • Important notice: With the 6.32 release we changed registration keys. Please have your new key available when upgrading from a pre-6.32-version. As always you will get it from our Customer Portal.

    Features (as compared to 6.34) include:

    Performance Schema is now available in Realtime
    MONyog can now capture all queries and display it in realtime which was not possible earlier with SHOW FULL PROCESSLIST output. To view all queries in realtime, make sure Performance_schema and ‘statements_digest’ table is enabled. If not, MONyog will display the output of SHOW FULL PROCESSLIST in realtime.

    To enable Performance schema, you need to edit the MySQL configuration file and add performance-schema=on under the [mysqld] section. Performance_schema is available with MySQL 5.6.14 and above.

    To enable the statement digests table, execute this query :

    UPDATE performance_schema.setup_consumers 
    SET enabled = 'YES' 
    WHERE name = 'statements_digest’; 

    Bug fixes
    Users with MySQL v5.6.3+ will now see explain plan for Insert, Update and Delete queries in Wayback Machine and Query analyzer.


    SQLyog MySQL GUI 12.15 Released

  • kartik.grover
  • October 7th, 2015
  • Releases, SQLyog
  • Changes as compared to 12.14 include:


    * The search for the connections and databases is now faster and simpler, as it lists all the connections and databases which contain the typed phrase.

    Bug Fixes:

    * Schema synchronisation tool now functions by creating dummy tables in cases where views are built on another views.
    * Earlier SQLyog updated connrestore.db file even when there were no changes in the current session. This is now fixed.


    5 DevOps Conferences You Should Consider Attending

  • Chetan
  • October 7th, 2015
  • MySQL
  • DevOps Conferences-AWS-Reinvent

    We love developer conferences, they are informative, fun and a great way to network with like minded people. The sessions can help you and your organization discuss and address technology challenges, learn how others are solving problems and exchange knowledge. Even if you can’t make it, most of these conferences are streamed online. Here are the 5 DevOp conferences you should consider attending.

    AWS re:Invent

    The annual cloud conference, by market leaders themselves, is an event which is jam-packed and sold out, months before the actual event. Amazon Web Services (AWS) knows the importance of educating and constantly innovating on the cloud and encourages organizations to migrate their IT infrastructure to embrace the cloud. AWS re:Invent 2015 has a mammoth 313 sessions with 491 speakers. This event should top any DevOp’s list.


    DevOpsDays is a two-day conference organized by local teams in each participating country. The highlight of every DevOpsDays is great presentations, open sessions and many amazing conversations to get a grassroot level view of what is going on in big companies. This event has something for everyone, regardless of whether you’re a beginner or an expert.


    PuppetConf, hosted by Puppet Labs is an event that focuses on IT automation. It packs 5 days of keynotes, demos, trainings, track sessions, networking opportunities and a chance to meet, discuss and get hands-on training from industry experts.

    O’Reilly Velocity

    O’Reilly Velocity, hosted at 4 locations across the globe, focuses on hard-core web operations, performance, optimization and more to help you build a faster and stronger business. This conference covers the entire spectrum of skillsets a DevOp needs to have and will leave you with a zillion ideas to improve your business, thanks to the hands-on learning and practical advice you will get, to build resilient systems at scale.

    Cloud Expo

    Cloud Expo is all about Cloud Computing, Big Data, SDDC, WebRTC, DevOps, Internet of Things (IoT), offering a great selection of technical and strategic industry keynotes, breakout sessions, 100+ exhibitors which offer solutions and strategies, 175+ sessions by industry experts, demo sessions, special events, giveaways and much more.

    Yes, this list is not exhaustive as there are many more great conferences, happening out there, like Monitorama, Percona Live, DockerCon to name a few. As it’s impossible to attend conferences, throughout the year, we have only featured the best. Let us know your stories and experiences about any recent DevOp conferences we’ve missed out on in this list.

    MONyog MySQL Monitor 6.34 Has Been Released

  • peter_laursen
  • September 7th, 2015
  • MONyog, Releases
  • Important notice: With the 6.32 release we changed registration keys. Please have your new key available when upgrading from a pre-6.32-version. As always you will get it from our Customer Portal.

    Changes (as compared to 6.33) include:


    * Added more monitors and charts for monitoring a galera cluster. By default, these monitors are hidden. To display these monitors in Monitors page you can enable “Galera” monitor group from Customize -> Manage Monitor Groups. Charts for these new monitors can be enabled from Customize – > Manage charts.
    * Optimized system charts for faster loading.

    Bug Fixes:

    * EXPLAIN option was not available in Wayback Machine.
    * In some rare cases, MONyog logged SQLite errors if deadlock details contained double quotes.
    * In Wayback Machine interface, MONyog showed wrong time in queries tab when a point was selected in the chart.


    SQLyog MySQL GUI 12.14 Released

  • peter_laursen
  • August 26th, 2015
  • Releases, SQLyog
  • Changes as compared to 12.13 include:


    * Added an option in “Export as SQL Dump”, “Export Table Data As..” and “Scheduled Backup” not to write the SQLyog version to SQL dumps. This will reduce ‘noise’ for users comparing dumps for auditing purposes, when SQLyog has been upgraded.
    * In both “Export as SQL Dump”,  and “Scheduled backup” there is now an option to add a linebreak between rows if BULK  INSERTS are written.  This will increase readability and help to prevent truncation of lines if the dump is opened in an editor or similar and saved again from there.


    * Increased contrast for better identification of selected row in GRID as well as increased visibility of which tab is currently selected.


    Monitoring your Amazon Aurora Databases using MONyog

  • Chetan
  • August 19th, 2015
  • MONyog, MySQL
  • We’re excited to announce the general availability of MONyog for Amazon Aurora. Amazon Web Services’ (AWS) latest offering, the Aurora database combines the speed and availability of commercial databases with the cost-effectiveness and simplicity of open source databases. Designed to provide up to 5x improved performance than MySQL at a price that’s one-tenth of any commercial RDBMS, Aurora definitely looks promising.

    Aurora is fault-tolerant by design, since it replicates data into three locations, making it highly available. To monitor your Aurora databases, you can always rely on MONyog to do the job for you.

    Aurora doesn’t allow to install anything on your Aurora database. Since MONyog is built on an agent-less architecture, it can connect to Aurora without any hassle.

    Connecting to Aurora
    Enter the DNS address of your Aurora instance in ‘Add server’ screen, enter your credentials and you’re done. MONyog will start monitoring your Aurora database right away.

    You can download and install MONyog locally or launch the MONyog AMI from the Amazon Marketplace. If you’re new to MONyog, do check out the top features of MONyog.

    Go ahead, download a free trial of MONyog and start monitoring your Aurora instance right away. If you have any feedback or questions, drop a comment below.

    Manage your Amazon Aurora databases with SQLyog

  • Karthik Suroju
  • August 18th, 2015
  • MySQL, SQLyog
  • We are elated to announce the availability of SQLyog for Amazon Aurora Databases. You can now manage Amazon Aurora databases with SQLyog, the most powerful database manager, admin and GUI tool.

    About Amazon Aurora:
    Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

    SQLyog + Amazon Aurora:
    It is very easy to connect Aurora database using SQLyog: just enter the DNS address of the Aurora instance as the host parameter, port number from the endpoint as the port parameter and key in your credentials. You can manage your Aurora databases with powerful tools like Synchronisation, Import External Data, Backup Wizard, Job Scheduler etc.

    Not only these, you get all the top features of SQLyog to work with Amazon Aurora databases.

    Download a free trial of SQLyog and start managing your Aurora databases now!

    If you have any feedback or queries, drop us an email or leave a comment below.

    Page 1 of 4712345...102030...Last »