Tag: MySQL

Feed: Planet MySQL; Author: Continuent; Run highly available MySQL database clusters in the AWS cloud from as little as $0.70 per node / per hour with the new Tungsten Cluster (AMI) Continuent is pleased to announce the availability of our new Tungsten Cluster (AMI) - the complete continuous operations solution for MySQL database clusters - on the AWS Marketplace! What Is It? The Continuent Tungsten Cluster (AMI) is a complete, fully-integrated, fully-tested MySQL HA, DR and geo-clustering solution on the AWS Marketplace for business-critical MySQL, MariaDB, & Percona Server applications. It includes all of the features and benefits provided by ... Read More

Feed: Planet MySQL; Author: David Yeager; In this post I describe the various steps that allowed me to reach 3.6 million queries per second on a single VM instance using MySQL 8.0 with the help of Dynimize.It's not every day that you get to break a record. So when I discovered that you can now rent by the hour massive instances within Google Compute Cloud that support 224 virtual cores based on AMD EPYC 2 Rome processors, I had to jump at the opportunity to see what kind low hanging fruit might be out there. Low and behold I found ... Read More

Feed: Planet MySQL; Author: Dave Stokes; DescriptionJoin this virtual meetup featuring WePay and Oracle MySQL! They will review three great talks on MySQL Compatibility Check, Running MySQL on Kubernetes and Scalable Bookkeeping.Talk 1: MySQL Compatibility CheckTalk 2: Running MySQL on KubernetesTalk 3: Scalable BookkeepingDate & Time Oct 1, 2020 10:00 AM in Pacific Time (US and Canada)Register here ... Read More

Feed: Planet MySQL; Author: Kristian Köhntopp; A question to the internal #DBA channel at work: »Is it possible to change a column type from BIGINT to VARCHAR ? Will the numbers be converted into a string version of the number or will be it a byte-wise transition that will screw the values?«Further asking yielded more information: »The use-case is to have strings, to have UUIDs.« So we have two questions to answer: Is ALTER TABLE t CHANGE COLUMN c lossy? INTEGER AUTO_INCREMENT vs. UUID Is ALTER TABLE t CHANGE COLUMN c lossy? ALTER TABLE is not lossy. We can test ... Read More

Feed: Planet MySQL; Author: Continuent; Cloud-Based Active/Active Tungsten MySQL Clusters @ Bluefin Payments Please join us on Wednesday September 30th at 10am PT for a discussion about geo-distributed active/active MySQL replication for Financial Services SaaS Providers based on a case study of Continuent customer Bluefin Payments, and on how to guarantee credit card transaction availability with geo-distributed Tungsten MySQL clusters. Financial Services typically require two or more active data centers to provide their customers with continuous availability along with quick response times. Bluefin Payments uses co-located data centers with active/active replication between each MySQL cluster, which provides a complete, local ... Read More

Feed: Planet MySQL; Author: Krunal Bauskar; Percona Monitoring and Management (PMM) is an effective tool in tracking stats of the running MySQL servers. Especially, the timelines capability helps users to get the picture of how the given stats changes over tenure of the workload. PMM official packages are not yet available on ARM but part of the PMM (importantly the stats collector aka exporter) could be compiled on ARM that would facilitate reporting stats of the MySQL instance running on ARM to PMM-Server there-by allowing it to track MySQL on ARM. Background Few days back Agustin from Percona tried compiling ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Deploying WordPress on OCI with MySQL Database Service: the easy way ! – lefred's blog: tribulations of a MySQL Evangelist During the MDS webinar on how to deploy WordPress on OCI using MDS (slides & video), I briefly explained how to deploy the full architecture on OCI using Resource Manager and Stacks. The Stack for that architecture is now available on my github: https://github.com/lefred/oci-wordpress-mds/releases/tag/0.0.1 To deploy it, it’s very easy. In OCI’s Dashboard, go on “Resource Manager” and then choose “Stacks“: Create a new stack and just drop the stack_wordpress_mds.zip : On the next ... Read More

Feed: Planet MySQL; Author: Keith Larson; This is just a note to help out anyone that might want to use the mysql_config_editor command in their automation tools. the mysql_config_editor does not take a password argument so automation tools that might have before set your password in the .my.cnf file trying to use mysql_config_editor fails. It is possible and quite simple though with the expect tool.  yum -y install expect  it works for apt-get also. So in this example, I will show a simple bash script version. 1st.. my login path does not work... mysql --login-path=localERROR 1045 (28000): Access denied for userSet this with expect You would execute this via your bash ... Read More

Feed: Planet MySQL; Author: RoseHosting; Today we gonna guide you through how to show all users in the MySQL users Database. A common question that most beginner MySQL users ask is “How do I see all of the users in my MySQL server?” Most of them assume that there is a show users command in MySQL, but there isn’t one. This is a common mistake because there are other MySQL commands for displaying information about the database. For example, SHOW DATABASES will show us all of the databases that are present in our MySQL Server, and SHOW TABLES will show us all the tables ... Read More

Feed: Planet PostgreSQL. Date: 21.09.2020 Tags:   postgresql    pgcon    freebsd    bsdcan    Category:   Interviews    Interviewed by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I am Canadian. Born in Nova Scotia and attended high school and university in Ottawa. I moved to New Zealand shortly after graduation. After 16 years in Wellington, NZ, where I got into Open ... Read More