Tag: mysql client

Feed: Planet MySQL. Author: MySQL Server Dev Team. In a world moving towards Unicode and UTF-8, a lot of applications still use some one-byte character set. And since one-byte characters usually accepts any byte in the range 0x00-0xFF it often works well to store and retrieve any data in such character strings, e.g. UTF-8 encoded data. At least as long as you don’t expect any semantics with regards to ordering and comparisons that will not cause any apparent problems. The MySQL latin1 character set is such a one-byte character set for Western Europe, and it is the default character set ... Read More

Feed: Planet MySQL. Author: HowToForge. This tutorial explains how to setup and configure MySQL multi-master replication on Oracle Linux. As you all may already know, MySQL is a well known top notch database product that has proven to be enterprise ready. As data is crucial for every organization, most database administrators are looking for a suitable solution to setup high availability to ensure user are able to access their data 24/7. MySQL replication is a solution that can ensure a high availability policy. On top of that, MySQL replication is also able to help database administrators to distribute the load on multiple database servers ... Read More

Feed: Planet MySQL. Author: RoseHosting. In this tutorial, we will explain how to create a new user and grant permissions to that user in MySQL. MySQL is an open source relational database managed system(RDBMS) that enables users and applications to store, organize, and retrieve their data. It has an access control system that consists of permissions that the users can have within tables and databases, we will take a look at some of the options this access control system offers later in this tutorial. Let’s start by logging in To log in to our MySQL system we use the following ... Read More

Feed: Planet MySQL. Author: Webyog. Many organizations have MySQL or MariaDB databases at the core of their business—for processing and storing product sales, collecting information related to services offered, or just providing essential information to customers. As a result, keeping these databases running continuously can be critical for the success of an organization.There are many components of a database system that a database administrator will need to consider for maintaining high availability. We considered server equipment (e.g., memory) in a previous introductory article. Now let’s look at using multiple servers for your MySQL and MariaDB databases—let’s look at replication. Replication ... Read More

Feed: Planet MySQL. Author: Yngve Svendsen. We’re constantly working to improve packaging and distribution of MySQL products. We have official Docker images for MySQL Server and we use Docker images to provide easy to use previews of upcoming and experimental setups and features in our products. Today we’re dockerizing another major product by releasing preview Docker images for MySQL Cluster. In this blog post, we’ll see just how easy it is to have your own dockerized cluster up and running in less than five minutes. Just a brief but important note on the status of these images first: While the ... Read More

Feed: Google Cloud Big Data and Machine Learning Blog. Author: Google Cloud Big Data and Machine Learning Blog Team. By Gus Class, Developer Programs Engineer, Google Cloud By connecting R to Cloud SQL, you can take advantage of all R features on top of a scalable, fully-managed MySQL service. Many developers working with relational data store aspects of business logic, customer metrics and other business data in a MySQL database. When data scientists or analysts outside the software development team analyze the data for insights, they may well choose the popular R programming language for creating statistical summaries and publication-quality ... Read More

Feed: Google Cloud Big Data and Machine Learning Blog. Author: Google Cloud Big Data and Machine Learning Blog Team. Innovation in data processing and machine learning technology Wednesday, March 22, 2017 By Gus Class, Developer Programs Engineer, Google Cloud By connecting R to Cloud SQL, you can take advantage of all R features on top of a scalable, fully-managed MySQL service. Many developers working with relational data store aspects of business logic, customer metrics and other business data in a MySQL database. When data scientists or analysts outside the software development team analyze the data for insights, they may well ... Read More

Feed: Planet MySQL. Author: MariaDB. This week’s webinar with Alvin Richards on getting started with MariaDB on Docker was extremely popular but unfortunately we weren’t able to get to all the audience questions at the end. We sat down with Alvin after the webinar to review the questions and get his responses. Check out the conversation below. If you missed the webinar or would like to watch it again, you can access the recording here and slide deck here. Alvin Richards is Field CTO at MariaDB Corporation where he connects the dots between practitioners, innovators and MariaDB products. In his ... Read More

Feed: Planet MySQL. Author: InsideMySQL.com. Dear MySQL Users, MySQL Connector/J 5.1.42, a maintenance release of the production 5.1branch has been released. Connector/J is the Type-IV pure-Java JDBCdriver for MySQL. MySQL Connector Java is available in source and binary form from theConnector/J download pages at http://dev.mysql.com/downloads/connector/j/5.1.htmland mirror sites as well as Maven-2 repositories. MySQL Connector Java (Commercial) is already available for download on theMy Oracle Support (MOS) website. This release will be available on eDelivery(OSDC) in next month’s upload cycle. As always, we recommend that you check the “CHANGES” file in thedownload archive to be aware of changes in behavior that ... Read More

Feed: Planet MySQL. Author: Vicki Boykis. Edvard Munch, Building The Winter Studio. Ekely Although there has been a huge backlash against traditional programming paradigms, particularly relational databases, over the past several years, SQL is still one of the most popular programming languages. First, it’s proven (working in production settings for over forty years). Second, its human-language-like syntax and declarative nature make it a perfect stepping stone for people who have zero programming knowledge and get overwhelmed by having to start learning by understanding data types and loops. When I started working in analytics, it was the first language I learned ... Read More