Tag: MySQL

Feed: Planet MySQL; Author: Dave Stokes; I received a lot of good feedback Building the PHP MySQL XDevAPI PECL Extension on MySQL 8.0.11 and PHP 7.2 for the MySQL Document Store including a few folks asking if I could document that it takes to get the MySQL X DevAPI working with an RPM based Linux distro.Well I'd really like to.  But I can't. Redhat Linux 4 I still remember getting my copy of Redhat Linux 4.0 (not RHEL -- no enterprise thoughts in those days)  It was January 1997 and I installed it the week before Rehaht 4.1 came out.  I thought ... Read More

Feed: Planet MySQL; Author: The Pythian Group; { "Debug": true, "EnableSyslog": false, "ListenAddress": ":3000", "MySQLTopologyUser": "orchestrator", "MySQLTopologyPassword": "****", "MySQLTopologyCredentialsConfigFile": "", "MySQLTopologySSLPrivateKeyFile": "", "MySQLTopologySSLCertFile": "", "MySQLTopologySSLCAFile": "", "MySQLTopologySSLSkipVerify": true, "MySQLTopologyUseMutualTLS": false, "MySQLOrchestratorHost": "127.0.0.1", "MySQLOrchestratorPort": 3306, "MySQLOrchestratorDatabase": "orchestrator", "MySQLOrchestratorUser": "orc_server_user", "MySQLOrchestratorPassword": "orc_server_password", "MySQLOrchestratorCredentialsConfigFile": "", "MySQLOrchestratorSSLPrivateKeyFile": "", "MySQLOrchestratorSSLCertFile": "", "MySQLOrchestratorSSLCAFile": "", "MySQLOrchestratorSSLSkipVerify": true, "MySQLOrchestratorUseMutualTLS": false, "MySQLConnectTimeoutSeconds": 1, "DefaultInstancePort": 3306, "DiscoverByShowSlaveHosts": true, "InstancePollSeconds": 5, "UnseenInstanceForgetHours": 240, "SnapshotTopologiesIntervalHours": 0, "InstanceBulkOperationsWaitTimeoutSeconds": 10, "HostnameResolveMethod": "default", "MySQLHostnameResolveMethod": "@@hostname", "SkipBinlogServerUnresolveCheck": true, "ExpiryHostnameResolvesMinutes": 60, "RejectHostnameResolvePattern": "", "ReasonableReplicationLagSeconds": 10, "ProblemIgnoreHostnameFilters": [], "VerifyReplicationFilters": false, "ReasonableMaintenanceReplicationLagSeconds": 20, "CandidateInstanceExpireMinutes": 60, "AuditLogFile": "", "AuditToSyslog": false, "RemoveTextFromHostnameDisplay": ".mydomain.com:3306", "ReadOnly": false, "AuthenticationMethod": "", "HTTPAuthUser": "", "HTTPAuthPassword": "", ... Read More

Feed: Planet MySQL; Author: MyDBOPS; In this blog, we will see the very basic thing “I” of “ACID” and an important property of Transaction ie., “ISOLATION” The isolation defines the way in which the MySQL server (InnoDB) separates each transaction from other concurrent running transaction in the server and also ensures that the transactions are processed in a reliable way. If transactions are not isolated then one transaction could modify the data that another transaction is reading hence creating data inconsistency. Isolation levels determine how isolated the transactions are from each other. MySQL supports all four the isolation levels that SQL-Standard defines.The ... Read More

Feed: Planet MySQL; Author: HowToForge; Pimcore is a free and open-source enterprise content management system written in PHP language and uses MySQL/MariaDB for databases. It is fast, flexible, and designer and developer-friendly that allow us to manage and share all of our digital assets across any channel. Pimcore comes with an easy to use administrative backend interface for managing data and system configuration. Pimcore is fully flexible and editable, so you can personalize the site as per your needs. In this tutorial, we will be going to learn how to install Pimcore CMS on Ubuntu 18.04 (Bionic Beaver). Prerequisites A ... Read More

Feed: Planet MySQL; Author: Yves Trudeau; Yves Trudeau | June 21, 2018 |  Posted In: MySQL, Percona XtraDB Cluster, Security PREVIOUS POST Why do I spend time blogging about security frameworks? Because, although there are some resources available on the Web, none apply to Percona XtraDB Cluster (PXC) directly. Actually, I rarely encounter a MySQL setup where SELinux is enforced and never when Percona XtraDB Cluster (PXC) or another Galera replication implementation is used. As we’ll see, there are good reasons for that. I originally thought this post would be a simple “how to” but it ended up with a push request to ... Read More

Feed: Liquid Web. Author: Terry Trout; For the 3rd year, Cloud Spectator affirms Liquid Web’s Server-Side Performance Tops Amazon, Rackspace and DigitalOceanLANSING, Mich. – June 21, 2018 – A study by performance analyst firm Cloud Spectator finds that Liquid Web LLC, a managed hosting provider focused on SMBs – and the designers, developers and agencies who create for them – beats rivals Amazon, Rackspace and DigitalOcean when it comes to website and cloud application performance. Liquid Web’s virtual machines (VMs) exhibit faster processing and disk speeds, while performing more transactions and sustaining more requests per second. The results show that ... Read More

Feed: Planet MySQL; Author: Alena Subotina; We would like to take this moment to thank the Oracle company for continuous development of the popular MySQL database! As you all might know, Oracle has recently released  MySQL Server, v8.0. In its turn, Devart decided to get a move on and release the new dbForge Studio for MySQL, 8.0! Support for MySQL Server 8.0 dbForge Studio for MySQL provides full support for all features of MySQL Server, v.8.0. Thus, you can connect, manage, develop, and administer MySQL databases on the latest server version straight in your favorite MySQL tool! Connectivity Support for ... Read More

Feed: Blog. Author: Beth Chauvin; As of today, IDERA Uptime Cloud Monitor (UCM) now supports monitoring for more Microsoft Azure services including Azure Virtual Machines, Azure MSSQL, Azure database for MySQL and Azure database for PostgreSQL. This is the first blog post in a series of 5 that will give you an overview of how to configure the UCM Azure monitoring, alerting and viewing of monitoring data.  Part 1 explains how to add Azure account(s) and setup alerts.  Stay tuned for Part 2: Details of All Azure Monitored Services of this series of blog posts coming very soon! Support for four Azure ... Read More

Feed: Planet MySQL; Author: Severalnines; As we saw in the first part of this blog, a strongly consistent database cluster like Galera does not play well with container orchestration tools like Kubernetes or Swarm. We showed you how to deploy Galera and configure process management for Docker, so you retain full control of the behaviour.  This blog post is the continuation of that, we are going to look into operation and maintenance of the cluster. To recap some of the main points from the part 1 of this blog, we deployed a three-node Galera cluster, with ProxySQL and Keepalived on ... Read More

Feed: R-bloggers. Author: Bob Muenchen. Introduction BlueSky Statistics’ desktop version is a free and open source graphical user interface for the R software that focuses on beginners looking to point-and-click their way through analyses.  A commercial version is also available which includes technical support and a version for Windows Terminal Servers such as Remote Desktop, or Citrix. Mac, Linux, or tablet users could run it via a terminal server. This post is one of a series of reviews which aim to help non-programmers choose the Graphical User Interface (GUI) that is best for them. Additionally, these reviews include a cursory description of the ... Read More