Percona

2

Solutions

20

Content

i
The collection of articles, videos, and posts on this topic.

19

Contributors

Percona is the only company that delivers enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms that maximize application performance while streamlining database efficiencies. Our global 24x7x365 consulting team has worked with over 3,000 clients worldwide, including the largest companies on the Internet, who use MySQL, Percona Server, Amazon® RDS for MySQL, MariaDB® and MongoDB.

Percona consultants have decades of experience solving complex database and database performance issues and design challenges. We consult on the full LAMP stack, from hardware to operating systems and right up through the database and web tiers. Because we are both broadly and deeply experienced, we can help build complete solutions. Our consultants work both remotely and on site. We can also provide full-time or part-time interim staff to cover employee absences or provide extra help on big projects.

Percona was founded in August 2006 by Peter Zaitsev and Vadim Tkachenko and now employs a global network of experts with a staff of over 125 people. Our customer list is large and diverse and we have one of the highest renewal rates in the business. Our expertise is visible in our widely read Percona Database Performance blog (https://www.percona.com/blog) and our book High Performance MySQL. To put Percona's expertise to work for you, please contact us (https://www.percona.com/about-percona/contact).

Share tech news, updates, or what's on your mind.

Sign up to Post

We have to serve 50,000,000,000 requests per day, our app can handle that, but we're not sure if our database skills are there to pick this up. We have a database server with 256gb of ram and 512GB SSD RAID using percona edition. Some of the data needs to stay on the database for 30 days, the transaction table where all requests are stored. what approach do we need to scale this horizontally? each endpoint requests runs about 4 queries...
0
11 Comments
Introducing the "443 Security Simplified" Podcast
LVL 1
Introducing the "443 Security Simplified" Podcast

This new podcast puts you inside the minds of leading white-hat hackers and security researchers. Hosts Marc Laliberte and Corey Nachreiner turn complex security concepts into easily understood and actionable insights on the latest cyber security headlines and trends.

Check it out!
Task availableI have found that this Dell PowerEdge T110 II that has two disks with Raid 1 configuration seems that one of the disk has failed. I have screen shots that I took from OpenManage Server Configuration for you to review. I believe that Disk 0:1 is the one has failed and I must first assigned it to be Global Hot spare and then re create the Raid1. Please review the attached file and advise if this is how I have to do it either from here or from Raid Bios.

Regards,
Change 2009
Fig-1
Storage Dashboard

Fig-2
Health
Fig-3
Connector
Fig-4
Task available
Fig-5

Task available4--Physical-Disks-On-PERC-S100.JPG
0
5 Comments
Dear Experts,

I deploy a Database System using Percona XtraDB ver.5.7 (3 Nodes) and 1 HaProxy as DB Load Balancer with Read/Write splitting config. Write on 1 Node, 2 nodes remain is back up. And Read will load balance between 3 nodes.
All 3 Node have 6CPU, 16GB RAM, and run on a local network.

My issue is when run queries, specially alter query, Node Write become conflict and cannot select data.
Percona Log: 

2017-12-30T11:23:36.595013Z 624933 [Note] WSREP: --------- CONFLICT DETECTED --------
2017-12-30T11:23:36.595128Z 624933 [Note] WSREP: cluster conflict due to high priority abort for threads:

2017-12-30T11:23:36.595143Z 624933 [Note] WSREP: Winning thread: 
   THD: 624933, mode: total order, state: executing, conflict: no conflict, seqno: 2819156
   SQL: ALTER TABLE `sales_flat_order_address` ADD INDEX (`address_type`)

2017-12-30T11:23:36.595157Z 624933 [Note] WSREP: Victim thread: 
   THD: 630854, mode: local, state: executing, conflict: no conflict, seqno: -1
   SQL: SELECT `main_table`.*, COUNT(*) as count_item, ( SUM(main_table.row_total_incl_tax) + IFNULL( sfois.shipping_amount, 0 ) ) AS `sum_row_total_incl_tax`, `sfo`.`increment_id` AS `order_increment_id`, `sfo`.`delivery_date`, `sfo`.`delivery_time`, `sfo`.`entity_id` AS `order_id`, `sfo`.`increment_id` AS `order_increment_id`, CONCAT(sfoas.street, ' ', sfoas.city) AS `s_address`, CONCAT(sfoas.firstname, ' ', sfoas.lastname) AS `s_fullname`, `sfoas`.`telephone` AS `s_telephone`,

Open in new window

…
0
0 Comments
MySQL Hot backup for 60GB database.

First I've read that mysql dump is can be slower than another enterprise app so that is where I'm exploring now.  
Trying to find a solution for a hot backup of a 60GB database.  It needs to be encrypted because of sensitive data so looking for the software to use, commands, and tips.

MySQL Enterprise Backup - Is what I'm looking at 30 day free trial but cannot find how much it cost?
If I wanted this recoverable up to the closet time like 15 minutes/1hour how can that be acomplished?  Which command?

I've also seen Percona XtraBackup 2.4.8 but seems to be Linux based and I would have to spin up and pay for another Linux server.  I know the db is small but the nightly backups we take would be bad if I could recover 23 hours ago.  I need a smaller window.  

Also since the DB is so small is it faster to backup to same server and then have an ftp script send or copy it somewhere else.
The fear is with this application it says there are reasons for a table to become corrupt.  So  I also won't know the time it does become corrupt is backing up every hour or every change just going to overwrite that?  How do I achoomplish the simple goal of Daister Recovery up to the minute of incident.  If it is a corrupt table or an entire database that needs to be restored for some reasons.
0
7 Comments
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
0
0 Comments
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
0
0 Comments
Some Basic Differences Between MySQL and MongoDB
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.

To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/webinars/mongodb-administration-mysql-dba
0
1 Comment

Expert Comment

by:Globalnetech India
Nice Article and thanks for sharing information
0
How Do You Implement High Availability in a Database Environment?
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.

To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastructure, please call us at +1-888-316-9775 (USA), +44 203 608 6727 (Europe), or have us contact you (http://learn.percona.com/contact-me)
0
0 Comments
Percona Server for MongoDB
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.


How Percona can help

Percona can help you determine if Percona Server for MongoDB is the right solution for your company and if it is, help with your deployment, while ensuring optimal performance. Enterprise-class Percona Support is available 24/7 to answer all your questions, ensure your deployment runs as expected, and help you in a crisis.

To discuss how Percona can help you make your Percona Server for MongoDB deployment a success, please call us at +1-888-316-9775 (USA), +44 203 608 6727 (Europe), or have us contact you (http://learn.percona.com/contact-me).
0
0 Comments
Why Use Three Nodes in a Database Cluster?
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.

To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastructure, please call us at +1-888-316-9775 (USA), +44 203 608 6727 (Europe), or have us contact you: http://learn.percona.com/contact-me
0
0 Comments
Get Certified for a Job in Cybersecurity
Get Certified for a Job in Cybersecurity

Want an exciting career in an emerging field? Earn your MS in Cybersecurity and get certified in ethical hacking or computer forensic investigation. WGU’s MSCSIA degree program was designed to meet the most recent U.S. Department of Homeland Security (DHS) and NSA guidelines.  

Learn More
In this article, we’ll look at how to deploy ProxySQL.
0
0 Comments
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
1
0 Comments
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
1
0 Comments
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
0
0 Comments
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
2
0 Comments
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
1
0 Comments
Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication Join Percona’s MySQL Practice Manager Kenny Gryp and QA Engineer, Ramesh Sivaraman as they present Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication on Wednesday, June 21, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7).  Register here: http://hubs.ly/H07QMYT0

What are the implementation differences between Percona XtraDB Cluster 5.7, Galera Cluster 5.7 and MySQL Group Replication?

    How do each of these work?
    How do they behave differently?
    Do these methods have any major issues?

This webinar will describe the differences and shed some light on how QA is done for each of the different technologies. Register here: http://hubs.ly/H07QMYT0
Percona-XtraDB-Cluster-certification.png
Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication
0
0 Comments
Webinar - Percona Software News and Roadmap Update
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL and MongoDB, Percona XtraBackup, Percona Toolkit, Percona XtraDB Cluster and Percona Monitoring and Management.

During this webinar Peter will talk about newly released features in Percona software, show a few quick demos and share with you highlights from the Percona open source software roadmap.

Peter will also talk about new developments in Percona commercial services and finish with a Q&A.

Want to get weekly updates on the latest Percona updates, trends in open source, and more? Subscribe now and we'll send you an update every Friday at 1pm ET.
0
0 Comments
Webinar - Best Practices Migrating to Open Source Databases
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have.

In this webinar, we will look at how to address such concerns to help get a migration commitment. We’ll cover picking the right project, selecting the right organizational team to manage migration, and developing the right migration path to maximize migration success (from a technical and organizational standpoint).

If you enjoyed this video please check out more videos from Percona here. To see a list of upcoming webinars you can visit our webinar page here to sign up.

Want to get weekly updates from Percona? Subscribe now and we'll send you an update every Friday at 1pm ET.
0
0 Comments
Has Powershell sent you back into the Stone Age?
LVL 8
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Put the Hammer Down
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
0
0 Comments
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
0
0 Comments
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.
0
0 Comments
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
0
0 Comments
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
0
0 Comments
I heard that replication (master slave) can help minimize outages due to heavy schema changes, yet I'm not sure I fully understand that!
1-Do we run changes on the slave then promote that slave to master? If so how is it possible to write to master?
2-what are the cases where replication can help with avoiding or minimizing outage?
0
4 Comments

Percona

2

Solutions

20

Content

i
The collection of articles, videos, and posts on this topic.

19

Contributors

Percona is the only company that delivers enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms that maximize application performance while streamlining database efficiencies. Our global 24x7x365 consulting team has worked with over 3,000 clients worldwide, including the largest companies on the Internet, who use MySQL, Percona Server, Amazon® RDS for MySQL, MariaDB® and MongoDB.

Percona consultants have decades of experience solving complex database and database performance issues and design challenges. We consult on the full LAMP stack, from hardware to operating systems and right up through the database and web tiers. Because we are both broadly and deeply experienced, we can help build complete solutions. Our consultants work both remotely and on site. We can also provide full-time or part-time interim staff to cover employee absences or provide extra help on big projects.

Percona was founded in August 2006 by Peter Zaitsev and Vadim Tkachenko and now employs a global network of experts with a staff of over 125 people. Our customer list is large and diverse and we have one of the highest renewal rates in the business. Our expertise is visible in our widely read Percona Database Performance blog (https://www.percona.com/blog) and our book High Performance MySQL. To put Percona's expertise to work for you, please contact us (https://www.percona.com/about-percona/contact).

Advertise Here
Top Experts In
Percona
<
Monthly
>
Hall of FameAnnual Expert Awards
Advertise Here