Tag: collation

Feed: Planet MySQL; Author: Krunal Lathiya; Laravel Stripe Payment Gateway Integration Tutorial With Example is today’s leading topic. We will use the Cashier package to integrate Stripe Payment Gateway in Laravel. The demand for Saas based platform is increasing day by day and nowadays building a subscription-based system is universal. So to make it easy on the backend like Laravel, we do need some packages that can help us build scalable, securable, and reliable web applications. Laravel Cashier makes it very simple to integrate Payment Gateway like Stripe. So let us see how we can integrate stripe in Laravel on ... Read More

Feed: Planet MySQL; Author: MyDBOPS; Partitioning is a way of splitting the actual data down into separate .ibd files (data compartments) in the file system based on the defined ranges using the partitioning key. It can help us with maintaining the enormous amount of data in different partitions without much hassle. In this blog post, we are going to see how to manage table partitioning using yahoo partition manager. Needs for partitioning: Enhanced data retrieval ( reduced IO ) with smaller B+Tree. Easy Archival or Purge by dropping or truncate  of partition Lesser fragmentation, hence avoiding frequent table optimization. Partitions management ... Read More

Feed: Planet MySQL; Author: Yves Trudeau; PREVIOUS POST Very often, database performance is affected by the inability to cache all the required data in memory. Disk IO, even when using the fastest devices, takes much more time than a memory access. With MySQL/InnoDB, the main memory cache is the InnoDB buffer pool. There are many strategies we can try to fit as much data as possible in the buffer pool, and one of them is data compression. With regular MySQL, to compress InnoDB data you can either use “Barracuda page compression” or “transparent page compression with punch holes”. The use ... Read More

Feed: SQL Server Release Services. Author: SQL Server Engineering Team. The SQL Server team is excited to bring you SQL Server 2014 Service Pack 3 (SP3). SQL Server 2014 SP3 contains 25+ improvements centered around performance, scalability and diagnostics based on the feedback from customers and SQL community. These improvements enable SQL Server 2014 to perform faster and scale out of the box on modern hardware design. It also showcases the SQL Product Team’s commitment to provide continued value into in-market releases. Additional Release information found in KB4022619. Following is the detailed list of improvements introduced in SQL 2014 SP3 ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, MySQL Connector/Node.js is a new Node.js driver for use with the XDevAPI. This release, v8.0.13, is a maintenance release of theMySQL Connector/Node.js 8.0 series. The X DevAPI enables application developers to write code that combinesthe strengths of the relational and document models using a modern,NoSQL-like syntax that does not assume previous experience writingtraditional SQL. MySQL Connector/Node.js can be downloaded through npm (seehttps://www.npmjs.com/package/@mysql/xdevapi for details) or fromhttps://dev.mysql.com/downloads/connector/nodejs/. To learn more about how to write applications using the X DevAPI, seehttp://dev.mysql.com/doc/x-devapi-userguide/en/. For more informationabout how the X DevAPI is implemented in MySQL Connector/Node.js, andits ... Read More

Feed: Planet MySQL; Author: InsideMySQL.com; Dear MySQL users, Version 8.0.13 is the latest General Availability release of the 8.0series of MySQL Connector/J. It is suitable for use with MySQL Serverversions 8.0, 5.7, 5.6, and 5.5. It supports the Java DatabaseConnectivity (JDBC) 4.2 API, and implements the X DevAPI. This release includes the following new features and changes, alsodescribed in more detail on https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-13.html As always, we recommend that you check the “CHANGES” file in thedownload archive to be aware of changes in behavior that might affectyour application. To download MySQL Connector/J 8.0.13 GA, see the “Generally Available(GA) Releases” tab at ... Read More

Feed: Planet MySQL; Author: MyDBOPS; In our work, We used to get a lot of requirements for replicating data from one data source to another.Previously I wrote replication from MySQL to Red-shift. In this blog I am going to explain about replicating the data from MySQL to Oracle using Tungsten replicator. 1.0. Tungsten Replicator : It is an open source replication engine supports data extract from MySQL, MySQL Variants such as RDS, Percona Server, MariaDB and Oracle and allows the data extracted to be applied on other data sources such as Vertica, Cassandra, Redshift etc. Tungsten Replicator includes support for ... Read More

Feed: What's New. Amazon Aurora with PostgreSQL Compatibility now supports PostgreSQL major version 10.4, and is available in US East (N. Virginia, Ohio), US West (Oregon), and Europe (Ireland) Regions. PostgreSQL 10 includes various new features including native table partitioning, support for improved parallelism in query execution, ICU collation support, column group statistics, enhanced postgres_fdw extension, and many more. Additionally, this release includes updated versions of the PLV8, ip4r, and pg_repack extensions. This release includes all patches from the PostgreSQL 10.1, PostgreSQL 10.2, and PostgreSQL 10.3 minor versions. It also includes all extensions that are supported in the Amazon Aurora ... Read More

Feed: AWS Government, Education, & Nonprofits Blog. Author: publicsector. Adoption of cloud computing is critical to maintaining our military’s technological advantage. Our nation’s warfighters deserve the most innovative and secure solutions. The AWS Snowball Edge is designed for rugged deployments in unfriendly physical environments. For the military, that may mean using the cloud in the middle of the desert, on board ships, and on the front line of the battlefield.The strategic advantage of making accurate decisions is in the ability to gather, retain, and process data into qualitative information. This allows the military to clear the fog of war faster ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; Borys Belinsky and Dmitriy Kostiuk | September 12, 2018 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software PREVIOUS POST Percona announces the release of Percona Server for MySQL 5.7.23-23 on September 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-23 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free. New Features The max_binlog_files variable is deprecated, and the binlog_space_limit variable should be used instead of it. The ... Read More